// blog
Why a VAT-Inclusive Amount Can Come Out a Penny Out
When software splits a VAT-inclusive amount into net and VAT and rounds each part on its own, the two can add up to a penny more or less than the amount typed. At 20% this happens for about one amount in six: £12.15 becomes £10.13 net and £2.03 VAT, £12.16 in all. At 5% and 15% it never happens. The fix is to round only one part, the VAT, and make the net whatever is left, so the two always add up. Changing it can move individual figures by a penny, so agree it with whoever does your books.

Bookkeepers in the UK will know a version of this: a receipt for £12.15 including VAT, entered as VAT-inclusive, and the figures on the screen don’t quite add back to £12.15. Sometimes the program won’t post it at all.
We saw how it can happen while moving TurboCASH 4, open-source Windows accounting software, to the web.
Splitting £12.15
At 20%, a VAT-inclusive amount is 120% of the net. So:
- The net is £12.15 ÷ 1.2 = £10.125, which rounds to £10.13.
- The VAT is £10.125 × 0.2 = £2.025, which also rounds to £2.03.
- Together: £12.16, a penny more than was typed.
Both halves landed exactly on a half penny, and both were rounded up. Nothing is wrong with either calculation on its own. The trouble is rounding two parts separately when they have to add up to a fixed total.
How often
We ran that arithmetic, the way TurboCASH 4’s source does it, on every amount from £0.01 to £1,000.00:
- At 20%: 16,667 of the 100,000 amounts come out a penny over. That’s one in six.
- At 5% and at 15%: none.
The rate decides it. At 20%, the net is the amount divided by 1.2, and one amount in six gives a net and a VAT that both end in exactly half a penny.
In TurboCASH 4’s code, the check that a batch balances allows no difference at all, so a batch with such a line wouldn’t post. We found that by reading the code and running its arithmetic, not by watching the program, so treat it as what the code says.
The rule that avoids it
Round one part, and make the other whatever is left. Work out the VAT, round it to the penny, and take it away from the amount:
- VAT: £12.15 × 20 ÷ 120 = £2.025, rounded to £2.03
- Net: £12.15 − £2.03 = £10.12
Now the net and the VAT always add up to exactly what was typed, at any rate, for any amount. It’s what the web version does: type £12.15 with 20% VAT in its sales journal and press F5 to see the split.
Before you change it
Fixing the rounding changes some figures by a penny: on £12.15, the net becomes £10.12 instead of £10.13. Over a quarter, that can move the net figures on a VAT return by a few pence. That’s why we list every change like this for the business owner and their accountant to agree before switching programs, not after.
If you’re moving off an old accounting or invoicing program and want its rules written down before anything changes, tell us about it. The case study has the rest of what we found.
































































































































