Service Total Including VAT Is Sometimes Incorrect
We have noticed that on occasion the price of a service + VAT sums to a 1p more or less than the total.
This has meant we have had to manually reconcile accounts.
Andrew Cockburn
shared this idea
-
Just Riding Along commented
yes this is super annoying, I have to make a correction each VAT period to get it to match up. I guess someone in RM accounts is having to do the same since they must have thousands of customers with incorrectly rounded invoices.
-
Paul
commented
Agreed, RM should be able to add up to the amount paid. e.g. in June I paid £4.15 for 1 Tracked 24. The invoice showed £3.45 + £0.69 VAT, total £4.14. There were many more Tracked 48 and the average difference was less than 1p, but it does mean that I can't balance my accounts.
The calculation should start with the amount paid and work backwards for net and the VAT is the difference between gross (exactly as paid) and calculated net, or the net is gross (as paid) less calculated VAT.