Quote for Custom report development - Daily Product / Payment method Income

[charlie@cloudaccess.net]

We want to request a report developed inside WHMCS that will show daily income generated by each of the live products.

 

This also needs to be divided into payment methods that we allow: credit card, paypal, mail in payment / wire transfer that can be displayed both daily and with a monthly summary.

 

To give you a graphical idea it would be much in the form of this spreadsheet: https://docs.google.com/a/cloudaccess.net/spreadsheet/ccc?key=0AsvbFwRW8wwVdEVfbFNIcTNCTGtwREVhMmNDbU50QUE#gid=0

Note the different tabs at the bottom of the report

 

We need this to show real income and not only add the tblinvoice.amount fields when paid.

 

Some of our clients operate on various discounts so what we actually need is the sum of transactions coming in.

 

Also if a transaction gets logged on an already paid invoice and generates overpayment we want that transaction to be counted to the daily sum by the report.

 

In short we need a report showing all transactions coming in sorted by the payment gateway they used and the products associated with the transaction.

 

If possible we need this report to be retro-active and show us the data for past months of 2012.

 

Thank you,