Create a Data Export Module for Blesta

I use Blesta as my management console.

Check it here : blesta(dot)com

Please NOTE : Blesta comes with a 30 day FREE Trial so you can surely test it on your server.

No credit card is required for it.

We use Blesta to bill clients quarterly to maintain their computers. I a need a simple way to get these transactions in QuickBooks. Transaction Pro Importer will pull in a csv file if I get it in a suitable format.

Blesta generates the invoice, submits it to Stripe for payment, nothing special.

When a new customer comes in, we invoice them for the entire year in advance, but want them to receive quarterly zero dollar invoices, then at the end of the year, we want to start charging their credit card. So, new customer comes in, we put invoice in for 12 months - nothing special. We then Record Payment equal to 4 quarterly bills and assign it a payment type "In House Credit", the customer gets 4 zero dollar invoices. I don't want these transactions included in the report described below.

We process credit cards through Stripe, Stripe deducts 2.9% + $0.30, the csv file should insert a line item for every invoice to account for Stripe's fee. This line item is calculated as follows:

-1 x (Invoice total*0.029 + 0.30)

I am running Blesta on a cPanel server, I want cron to execute a program that creates an export file named /home/$account/public_html/billing/reports/[login to view URL]

if run today, the file name would be /home/$account/public_html/billing/reports/sr171109csv

The export file should contain invoices generated & paid during the previous 7 days, I don't want any "In House Credit" transactions included.

I have attached a sample file.

It is likely that I will publish the source code on the Blesta forum so that others may benefit from our system, if this is an issue, let me know.

MySQL PHP Software Architecture

Project ID: #15604172

About the project