Admin > Reports > Sales Tax Report

[batteryman]

Hello,

I have an idea if anyone can make it which shouldn't be very hard. I believe it would be just a MySQL query and a couple of small php files to show the output in the admin.

The idea:

It would be nice if there was a report that could generate all sales that had sales taxes on them based on your tax zones. I have to pay taxes each month to the state of nevada for my company and I had to go through the sales one by one to find all nevada orders.

Your all thinking why dont you go through the actual print out of the orders, but I have hndreds of orders and some get missed placed in the shuffle by me or one of my employees so I have to verify the numbers.

So that is why I think the report should just pull up the person name gross sales and taxes for the order almost like the who online report

I will make an attempt at it but I am no PHPer...

Thank you,

Batteryman

[wk4hm]

Did you ever get a report for this?

[jammin320]

This isn't a report but it may make your life easier until one becomes available. If you go into myPHP admin and run the following query in your ZenCart data base (adjusting the table for any prefix you may have) you will get the information that you are looking for. It should at least be faster then going through the orders one by one in admin .

 
SELECT
orders_id, billing_state, order_total, order_tax
FROM
orders
WHERE
order_tax > 0

[jammin320]

On second thought, this may work better

 
SELECT
orders_id, date_purchased, billing_state, order_total, order_tax
FROM
orders
WHERE
order_tax > 0
AND
date_purchased > '2007-05-01 00:00:00'

Adjusting the date_purchased condition to only show the month that you are interested in.

You could also add the following to it to limit it to only one month. It all depends on your needs.

AND
date_purchased < '2007-06-01 00:00:00'

[batteryman]

Thank you so much. I will definetly use this.

I will try to use the mysql query and add it into a php file to make it an option in my admin.

will give to contributions with you as an contributor if I get it made.


Batteryman (avel)

[apemusic]

Hey Guys,

I really need to see which orders were taxed and how much tax was charged?

Not really sure how to use that mysql query, I have phpmyadmin with godaddy, I guess I log in there and then???

Anyone made a PHP file or module yet ??

[DrByte]

If you have Sales Report installed, you can run a report on all sales, and export it to CSV, and sort on Tax Amount.

[RayDube]

Hello Dr. Byte,

Unfortunately, the Sales Report, groups the taxes.

What I'm looking for now is a report that will break down the taxes, how much on federal, how much on regional, etc...

But the sql idea sounds pretty good.

Ray