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.
5
votes
-
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.