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