How do you double-check tax-inclusive prices before recording them?

[AlexCarter]

One thing I’ve been trying to improve in my bookkeeping is checking tax-inclusive prices before entering them into my records.

It sounds straightforward, but I’ve noticed it’s quite easy to make a mistake when working backwards from a total. For example, if something costs £120 including 20% VAT, simply taking 20% off £120 doesn’t give the correct pre-VAT amount.

The calculation would be:

£120 ÷ 1.20 = £100
VAT = £20

I’m interested in how other business owners handle this in practice. Do you normally rely on your accounting software to calculate the VAT, use the VAT fraction, or manually check the figures as well?

And when an invoice contains several VAT rates, do you find it easier to calculate each line separately before entering the totals?

I’d be interested to hear what other people do, especially if you deal with a large number of invoices or receipts.

 

[AI Helper]

Working from the gross figure

Your division method is the right one, and the quickest sanity check is the VAT fraction. At 20% the VAT element is one sixth of the gross, so £120 ÷ 6 = £20. At the 5% reduced rate the fraction is 1/21. Anyone entering a lot of receipts tends to memorise those two fractions because they make spotting a wrong figure almost instant.

Software versus manual checking

Most bookkeeping packages let you enter the gross amount with the VAT code and they back-calculate the net and tax for you. That removes the arithmetic risk, but it doesn't remove the coding risk. The common errors are picking the wrong VAT code, or treating a zero-rated or exempt line as standard rated. A sensible habit is to compare the software's VAT figure against the VAT shown on the supplier's invoice before saving. If they differ by more than a penny or two, something has been coded wrongly.

Rounding is worth a mention. Suppliers are allowed to round VAT per line or per invoice, so a few pence of difference across a long invoice is normal. Match the supplier's figure, not the theoretical one, since that is what you're actually reclaiming.

Mixed-rate invoices

Never split a total across rates by guesswork. Enter each line with its own VAT code, or at minimum group the lines by rate and enter one line per rate. Supermarket and DIY receipts are the classic problem because they mix standard, zero and reduced rated items, and the VAT breakdown is often printed at the bottom in a small summary. Use that summary rather than the item lines.

Simplified receipts

For purchases under £250 a retailer can issue a simplified VAT invoice showing only the gross and the rate. That's where the fraction earns its keep. Just confirm the receipt shows a VAT registration number, otherwise there's nothing to reclaim regardless of how neatly the maths works out.