Sales Tax Reports?

[kstew923]

Is there a way to run a report that will show the total amount of sales tax collect over a specific time frame.

I need to know how to do this for accounting purposes.

Also is there a way to run a report for total sales (not just the list of sales that appears in the report section, but something that you can print or export out of the zen cart system)

Any help is appreciated.

Kristi

[dbltoe]

SELECT
Sum(orders.order_tax)
FROM
orders
WHERE
orders.order_tax > 0 AND
orders.date_purchased >= '2010-01-01 00:00:00' AND
orders.date_purchased < '2011-01-01 00:00:00'


NOTE: This assumes that you have no table prefixes. If you have a prefix like zen_, then all instances of orders.**** would become zen_orders.****

Yes, the orders.order_tax > 0 is a little bit of overkill, but..........

[kstew923]

This may be a dumb question but is this script that I run against the site or is there some way to access this information through the admin?

Sorry but I am more design orientied other than the scripting side of things.

Thank You for your response.

[dbltoe]

This is a query that needs to be run against your database and it won't work in the admin. That's for other than queries.

If you have phpMyAdmin (usually in the database section of cpanel), open it, click on your database, click on the Query tab, paste the query in the "SQL query on database #######" box, click on Submit Query in the bottom-right corner of that box.

Your result will be in between the two Show buttons under "Sum(orders.order_tax)

Again, be sure to check if you use a prefix.

[alivewjesus]

Check out this add on

[kstew923]

Check out this add on

This is awesome! Exactly what I was in need of... it is nice to just click on monthly report and there it is.

Do you know of any add-on that allows a daily export of orders to a CSV file?