Export paid invoices as QuickBooks (QBDT) Sales Receipts

[katycomputer]

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