report - breaking down taxes collected

[DryDiapersPlus]

Hi,

Just wondering - SquirrelCart automatically adds on the sales tax (when instructed). For our reporting purposes at the end of the year - because the Government wants to collect those taxes from us that we collected - how do we print off a report detailing how much tax has been collected?

Or do we have to open up each order - and write it down on a scrap piece of paper?

Thanks

[Jamie]

You would need a custom query for this. Click Tools > Database > Query in the control panel, paste the query in the field, and click the submit button.

SELECT SUM(Tax_Total) FROM Orders WHERE Order_Date BETWEEN '2011-01-01' AND '2011-12-31 23:59:59';

This is going to include every order in your database for 2011, regardless of the order status.

[DryDiapersPlus]

Yea! Thank you - now I will just go back through my orders, and for any cancelled or refunded orders, will subtract the tax from the total amount that query gives me.

Tammy