question

jennypansuriya avatar image
jennypansuriya asked Dan answered

VAT tax calculation not working properly in clover tax report

Hey,


When I generate a tax report in clover, it shows the wrong calculation.


For example:

In the Payment section,

Vat or fee = 20%

Taxable Amount = £554

Then the VAT amount should be:

£554 * 20% = £110.8 (Use https://vat-calc.net/ to remove VAT from amount)

But it shows £109.3


Please help me to figure out this issue. I have lost so much time to fix it and I didn't find any proper solution on the guide section.


Best Regards,

Jenny

Taxes
7 comments
10 |2000

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

David Marginian avatar image David Marginian ♦♦ commented ·

Are you a Clover merchant or a developer?

0 Likes 0 ·
jennypansuriya avatar image jennypansuriya David Marginian ♦♦ commented ·

I am a developer working for client project.

0 Likes 0 ·
kirby avatar image kirby commented ·

Hi jennypansuriya,

Can you please share all the details of the order? Were all the items taxed? Was there only one tax rate? What was the price as sold of each item?


Thank you

0 Likes 0 ·
jennypansuriya avatar image jennypansuriya kirby commented ·

I have already mentioned in my post.
For now it's just one product and its price is £554. When user checkout then 20% VAT will be added in virtual price.

0 Likes 0 ·
David Marginian avatar image David Marginian ♦♦ jennypansuriya commented ·

Can you include the Clover merchant and order id?

0 Likes 0 ·
Show more comments
Dan avatar image
Dan answered

I found a sandbox merchant with an order for a single item with an amount of 55400 and a tax amount of 9233.
The tax rate is_vat = 1 with a rate of 2000000, which corresponds to 20%
In the tax report, I see:

This correspond with the https://vat-calc.net/ Remove VAT calculation for a Initial Amount of 554 and a Rate of VAT(%) of 20
Am I missing something here?
Please provide the merchant uuid and order or payment uuid of the order you are concerned with, along with the timeframe for the report if this does not match what you are seeing.


10 |2000

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

jennypansuriya avatar image
jennypansuriya answered

Thanks Dan,

It was my mistake to do the calculation. I am clear now.

10 |2000

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