Jump to content
katycomputer

Export paid invoices as QuickBooks (QBDT) Sales Receipts

Recommended Posts

I needed my transactions in QuickBooks, I am using Stripe, so I wanted each transaction reduced by the cost of Stripe to make everything easy to reconcile.

I worked a developer to put together the attached files which are placed in /exportcsv

I am thrilled with the results, let me know if you have any questions.

This is running on a cpanel host, I see no reason it wouldn't run on any host with rights to access the Blesta database.

A couple modifications I have planned:
- We use Transaction Pro Importer to pull the csv file into QuickBooks. I am thinking about using qodbc or CData's remoteconnector to make things a bit more seamless.

- It should be possible to get the database connection parameters from /config/blesta.php

config.php

index.php

Output.xlsx

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×