question

brokenoval avatar image
brokenoval asked kirby answered

Why does the Clover Tax report not add up correctly?

See my attachment which contains a snip of the tax report from a certain day in the past, there are a number of different tax rates for that day and attached was calculated by the Clover system.

Just to take the first line item as an example. The calculated VAT is €71.51, however when you do the calculations manually i.e. 599.79 / 113.5 * 13.5 = €71.34. So the actual VAT should be 71.34 vs what Clover is showing 71.51.

Can you explain what is causing the difference?

VAT or Fee

Taxable amountVAT or FeeVAT or Fee Collected13.5%€599.7913.50000%€71.5113.5% Bakery€42.4213.50000%€4.9523%€43.6023.00000%€8.26No Tax€22.940.00000%0



Update:
I have followed up the theory that this is a rounding issue related to each individual order item. I've gone through the day in question, and other days too using the "Export individual line items" report from the Orders section in the Dashboard.

Even with this data I cannot re-calculate the summaries in the report above. If for example I go through every single line item on the day sold at 23% the sum of the "Tax Amount" column in the export is €8.28 rather than the dashboard report (€8.26) or the unrounded amount (€8.156585).

I've attached the line items report with my calculations. lineitemsexport-20190724-1103-ist.zip

@jacobabrams - this might be a question for you as I've seen some of your responses on similar topics
Taxes
10 |2000

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
kirby avatar image
kirby answered

there is
one thing with this merchant that is leading to more rounding:
they have 2 different 13.5% tax rates

So the code is collating the items for each rate.

For example

Suppose an order has
a €4 bottle of water at a 13.5% rate #1 and
a €4 espresso at a 13.5% rate #2

Then the tax code has to assume that these rates are for separate entities
so it calculates the tax paid separately for the water and the espresso
whereas if there was only one 13.5% rate
then it would combine them as €8 before calculating the tax.

That is
it would use a larger total which leads to less rounding

that is
twice it calculates
€4 at 13.5% as base price of €3.52 and €0.48 tax
for a total of €0.96 tax

rather than
€8 at 13.5% as base price of €7.05 and €0.95 tax

That is, with 2 separate tax rates there has to be more rounding, in this case one more rounding up by one cent whereas there would be only one rounding with one tax rate

10 |2000

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Welcome to the
Clover Developer Community