This looks like a bug. I will elevate it for attention. The India (Karnataka) - VAT 5.5% built-in tax code is actually calculating tax at 15.5.%. This is probably a typographical error in the tax code definition.
I also wonder, though, how you produced a purchase invoice without boundary lines on columns and cells. What version of the software are you using?
I seem to have the same problem now
I have version 16.12.56 and for the amount of 614.36€ it gives for 19% VAT 116.71€ but if you do the calculation the VAT should be 116.7284€ → rounded to 2 decimals → 116.73€
you are right - this is how is done in the manager however in my country they calculate the VAT on the total of the invoice
is there a way around to this?
after all the vat is not shown in every line of the invoice…
Not that I am aware of, except individual invoices per item which probably isn’t practical.
The majority of countries do it as Manager does it for the following reason:
If you invoice 10 items on individual invoices - their VAT adds up to xx.xx
Therefore if you invoice the 10 items on a single invoice - the VAT should still add up to xx.xx
If you use the Invoice total then the VAT could calculate to xx.xy
Another reason taxes are calculated on individual line items is that the same invoice could include items taxable at different rates or excluded from tax entirely. A calculation based on the total could not accommodate this.
Likewise, if a single line item on a sales invoice with many line items is returned, only the tax from the returned item is calculated and rebated.
In most tax jurisdictions, there are explicit regulations permitting line by line calculation, and sometimes requiring it. This is the way virtually all modern accounting software works.
@compuit, you just happen—on your example invoice—to have 3 of 4 line items for which the tax rounds up and 1 on which it rounds down. Would the customer have insisted on your matching their antiquated calculation method (calculating tax on the subtotal instead of each line item) if your invoice happened to round 3 of 4 down and charged one less cent than their calculation? Probably so, because many companies habitually look for any excuse to delay paying their obligations.
But you cannot just insert an arbitrary tax adjustment. If the program allowed that, users could put in any bogus number they wanted.
Total invoice rule – under this rule, the unrounded amounts of GST for each taxable sale should be totalled and then rounded to the nearest cent (rounding 0.5 cents upwards).
Taxable supply rule – under this rule, you need to work out the amount of GST for each individual taxable sale. Where the unrounded amount of GST has more decimal places than your accounting system can record, the amount should be rounded up or down as appropriate. You then need to add the individual amounts and round this total to the nearest cent (rounding 0.5 cents upwards).
You and your customers don’t need to use the same rounding rules.
Managers compliance requires interpreting “more decimal places than your accounting system can record” as Managers ability to record line item GST only to the minimum legal tender, and as a result the final rounding at the invoice level always produces no change.
Importantly for your negotiations with your supplier is the last paragraph “You and your customers don’t need to use the same rounding rules.” providing both comply with the tax offices rules.
Guys just so I understand what is going on here. I understand that GST in Manager is calculated on a line by line basis and then summed, correct?
So using the example above I manually calculated the GST on Total and Line by and then summed to give the GST inclusive total.
Am I totally messed up here because processing both ways I get the same result but Manager calculates slightly different? How does Manager sneak in the extra cent to give $809.98? Look at the rounding it is already rounding up.
OK here is a bit more… rounding at each line then summing