Monthly Sales and Tax Summary Report [support thread]

[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