English Boards > Support

Difference in Tax

(1/2) > >>

evail:
Emre,

I have noticed some difference in Tax.

Please find attached the screenshot of the Work Period Report

Tax rate is 6%

When I take Total Sales and multiply with 6% Tax Amount comes as 4,954.25

There is a difference of 2.10

Please let me know why this is happening.

Thanks
Evail

spanky:
Hello evail, try to check if all products have set the vat. Test with SqlCe40Toolbox will be easier.

evail:
Checked the DB, all products are correctly set with VATID as 1.

Then I checked the Tickets List and it seems that there is a major difference in Total Sales.

I took the total of the TotalAmount from the Tickets list from DB. And I took the Work Period Report from SambaPOS. There is a 21,837.10 difference in the Totals from both.

How can there be any difference?

emre:
Hello evail. Of course tax total won't be exactly %6 of the total sales. For example if you sell something for 11,75 exact tax amount should be 0,705 but we shold round it to make the ticket total payable. Tax amount becomes 0,71 and that makes tax rate %6,042. This is the reason of the difference.

I couldn't understand the thing you calculated from database. Work period reports calculated from db but there are lots of additonal calculations such as gifts, discounts, etc. I don't think getting a direct sum from db gives any idea about correctness of reports. We never encountered such problem but if you have any doubt best way will be storing physical bills for a while and comparing rerport values with your calculation based on printed numbers.

evail:
Thanks Emre,

I understand about the Tax Difference. Since I have so many individual receipts there is bound to have a minor difference.

But regarding the total of Tickets in DB, I never sell on discount or give any gifts. there has being no cancellations.

I have attached the report of the very first work period.

It says 808 tickets. From DB i took the total of the first 808 tickets and it comes as 19,798.55 which is same as the TOTAL INCOME in the work period report.

However the GRAND TOTAL of Sales is different.

Navigation

[0] Message Index

[#] Next page