Hi there,
I have a problem with VAT calculations today.
When I use 10% VAT, the calculation is wrong and I don’t get 10% of the whole amount.
You can find an example here :
Before today, the VAT amount would have been 1.42$ as the correct 10% amount of 14.25$.
Since this morning, the VAT is calculated with around 9.09% and I don’t know why.
I think I didn’t change any setting about VAT.
Anyone has an idea about how can I get a real 10% again on my invoices ?
Thanks in advance.
It appears that the calculation is Tax Inclusive instead of Tax Exclusive - 12.95 + 10% = 14.25.
Furthermore your screenshot layout is for a Tax Inclusive invoice, Tax Exclusive layout looks like this:
Check that the Tax Inclusive tick box hasn’t been ticked or set as default
Thanks for your answer.
I want the calculation to be Tax Inclusive and not Tax exclusive.
The amount I’ve paid is 14.25$ including 10% VAT.
The amount of VAT that I’ll get back will be 1.43$
So I want the invoice to be like this :
Total 14.25$
Including VAT 10% 1.43$
It always has been like this before on my invoices and I dont get why it’s like this from today.
Its the same for my sales invoice :
Then the actual tax amount will ALWAYS be less than 10% of the total, NOT 10% of the total.
No, VAT is a Value Added Tax, That means the tax is added to the items value, the tax is not deducted from the total price.
No, it should be 62.68. The sale value is 628.64 and the VAT of 10% (62.86) is added to total 691.50
Your balance sheet is not distorted as the VAT amounts are correct.
If what you say is correct then EVERY Manager user would be having incorrect tax calculations - but they aren’t having incorrect calculations.
If an items value is 100, then the 10% (1/10) VAT is added to total 110.00 - tax exclusive
If an items total is 110, then deduct 1/11 (110/11) or 10 to get the items value 100 - tax inclusive
Can you show a screenshot example of - It always has been like this before on my invoices.
That is - a “tax inclusive invoice” format with the tax equalling 10% of total
Thanks for your answer and for your very clear explanations.
I got it, I didn’t know that the Inclusive VAT was not exactly 10% of the amount.
Now I get well the difference between Inclusive and Exclusive.
I was pretty sure that before the tax equalled 10% of total but maybe I was wrong and didn’t noticed that before.
I based my thoughts on invoices with Exclusive VAT so I thought the VAT always should be equalling exactly 10%.
Thanks a lot for your explanations, everything is pretty clear for me now !
That is the selling price decided by the seller, how they arrive at that sale value depends on their pricing policy.
Say you are a retailer and you mark-up the products you buy by 20%, therefore for the above item you would buy it for 523.87 add 20% (104.77) to arrive at your sale value of 628.64 - which then has VAT added
