Monthly Sales and Tax Summary Report [support thread]

[medmonds]

Super, thank you! That worked perfectly.

[medmonds]

Hi Skip,
Thank you for the quick reply. That worked!

I have one more question for you, if I may take one more minute of your time.

We do not charge tax on shipping and have two main shipping options: FedEx shipping and Store Pickup (free). On the FedEx side, the Tax Class is set to "none".
However, our Monthly Sales report seems to show tax being collected for shipping. The amount is usually very small - a total shipping tax collected of .01 to .05 in any given month. I cannot seem to figure out where this amount is coming from and wondered if you might have a suggestion about how to troubleshoot this issue and eliminate shipping tax.

I really appreciate your insight!

Best wishes,
Marta

[skipwater]

Hi Skip,

We do not charge tax on shipping and have two main shipping options: FedEx shipping and Store Pickup (free). On the FedEx side, the Tax Class is set to "none".
However, our Monthly Sales report seems to show tax being collected for shipping. The amount is usually very small - a total shipping tax collected of .01 to .05 in any given month. I cannot seem to figure out where this amount is coming from and wondered if you might have a suggestion about how to troubleshoot this issue and eliminate shipping tax.

I really appreciate your insight!

Best wishes,
Marta

The best thing I can suggest is to look at the raw data in orders_total table and see how the fedex shipping mod is placing the data into the records. in the class field you will see ot_tax and ot_shipping. I don't run the fedex ship mod so I have no data to look at.

Skip

[medmonds]

Skip,
Thank you for your quick response. Thank you for the suggestions. I will post back when I find something.

Best wishes,
Marta

[medmonds]

Ok, so I checked the table as you suggested and notice that the FedEx shipping rate has a class of ot_shipping. What does this mean? Can I modify the class so that no tax is charged?

Thanks again,
Marta

[mooomers]

Has anyone noticed strange things in their report where the day's shipping is $0, but the tax on shipping was a positive value?

Gross Income  Product sales  Nontaxed sales  Taxed sales  Taxes collected  Shipping & Handling  Tax on shipping
112.62        107.25 	      0.00            107.25       5.36             0.00                 0.01

[skipwater]

Has anyone noticed strange things in their report where the day's shipping is $0, but the tax on shipping was a positive value?

Gross Income  Product sales  Nontaxed sales  Taxed sales  Taxes collected  Shipping & Handling  Tax on shipping
112.62        107.25 	      0.00            107.25       5.36             0.00                 0.01

Tax values are stored with 4 decmial places $0.0000.
If value is = to or greater then 0.0050 it will add 0.01 to tax but if the value is < less then 0.0050 it will not add any value to tax.

Which is the correct way in calculating taxes for each transaction.

In your example product sales are $107.25 and your sales tax was $5.36.

So it looks like you have a 5% sales tax?
5% of $107.25 = $5.3625

But wait your Gross Income is $112.62
$112.62 - 107.25 = $5.37 that leaves $0.01 that showed up in ship tax.

My best guess is that you had more the one order on that day and each order had a tax value of 0.0049 or less, that when summed the 0.0049's became 0.01.

I hope that helped to explain very low out of place values.

Skip

[goldiegao]

HI, I've upload the folder to my server, however, there is always a Internal server problem 500 shows up when I click the" monthly sales report" in ZenCart admin site. Please HELP ME!!!

[skipwater]

HI, I've upload the folder to my server, however, there is always a Internal server problem 500 shows up when I click the" monthly sales report" in ZenCart admin site. Please HELP ME!!!

After unzipping the mods zip file to a temp area on your local computer and then renaming the admin folder to match the name of the admin folder that you are using on your web server.

That is when you then uploaded the files?

Skip

[Renz]

Hi,

I have duplicated my core files into another site and this mod is amongst them, I would like to know If I can zero the figures for the new business.

Can it be done in anyway or is it an overwrite of the mod with.

Cheers

RR