How do you check VAT calculations when working backwards from a total?

I’ve been trying to get more comfortable with checking VAT figures when I only have the VAT-inclusive amount.

For example, if an invoice or receipt shows £120 including 20% VAT, I understand that the net amount is £100 and the VAT is £20. What I used to find confusing was whether you should simply take 20% off the £120, which obviously gives a different answer.

I’m also curious how other small businesses handle this when there are different VAT rates involved. Do you normally calculate these manually, use the VAT fraction, or use a calculator/accounting software to check the figures?

I’d be interested to hear what method people find quickest and least likely to cause mistakes, particularly when checking lots of invoices or receipts.

Why knocking 20% off the gross gives the wrong answer

The 20% is charged on the net figure, not the gross. So £120 is actually 120% of the net amount. If you take 20% off £120 you get £96 net and £24 VAT, which is the same mistake that catches a lot of people out on expense claims and till receipts.

The correct approach for 20% VAT is to divide the gross by 1.2:


£120 / 1.2 = £100 net, leaving £20 VAT.

The VAT fraction method

HMRC publishes what it calls the VAT fraction, and it is the quickest way to pull the VAT straight out of a gross figure without working out the net first:

• 20% standard rate: VAT = Gross x 1/6 (or divide by 6)
• 5% reduced rate: VAT = Gross x 1/21 (or divide by 21)
• 0% zero rate: no VAT to extract, the gross is the net

So £120 / 6 = £20. Done. For a reduced rate item at £52.50 gross, £52.50 / 21 = £2.50 VAT and £50 net.

Both methods give identical results, so pick whichever sticks in your head. Dividing by 1.2 tends to be easier to explain to staff. The fraction is faster when you only care about the VAT figure.

Handling mixed rates on one receipt

This is where most errors creep in. A supermarket or cash-and-carry receipt often mixes standard rated, zero rated and occasionally reduced rated items. You cannot apply one fraction to the total.

Things to look for:

• Most till receipts print a code letter or symbol next to each line (often A, B, C or an asterisk) and a key at the bottom showing which code is which rate. Total each group separately, then apply the right fraction to each.
• Many retailers print a VAT summary block at the foot of the receipt showing net, VAT and gross per rate. If that block is there, use it and just sanity check one or two figures.
• Simplified VAT invoices (allowed for sales under £250) only need to show the gross and the rate applied. If a receipt shows nothing about VAT at all and the supplier is not obviously VAT registered, you should not be reclaiming anything from it.
• Exempt items (insurance, some postage, certain financial charges) sit outside the calculation entirely. Do not apply a fraction to those lines.

Rounding

When checking someone else's invoice, expect small differences of a penny here and there. HMRC allows VAT on an invoice to be rounded down to the nearest 0.1p or to the nearest penny, and it can be calculated line by line or on the invoice total, so two suppliers can arrive at figures a penny apart on identical goods and both be correct. A one penny variance is not a reason to bounce an invoice. A variance of pounds is.

Quickest method for checking volume

For a stack of receipts, a spreadsheet beats a calculator every time. Three columns are enough:


Add a fourth column for the rate and use =A2/(1+D2) if you want it to cope with 5% items too. Set the cells to two decimal places and let ROUND handle the pennies if the totals need to tie to a bank figure.

Accounting software (Xero, QuickBooks, Sage, FreeAgent and the like) all have a "tax inclusive" or "amounts are inclusive of tax" toggle when you enter a bill. Type the gross, select the rate, and it backs out the VAT for you. The one thing to watch is the default tax rate on a supplier or nominal code. If a supplier is set to 20% by default and the receipt has zero rated items on it, the software will happily claim VAT that was never charged.

Three quick sanity checks

Whatever method you use, these catch most slips:

• Net plus VAT must equal the gross exactly (give or take a rounding penny).
• VAT divided by net should come out at 0.20 for standard rated items.
• VAT should be roughly one sixth of the gross. If it looks closer to one fifth, someone has taken 20% off the gross instead of dividing by 1.2.

One habit worth building

Whoever is entering receipts, get them into the routine of checking the supplier's VAT number appears on anything over the simplified invoice limit and that the rate shown matches what was actually supplied. Backing out the VAT correctly from £120 is no help if the item was zero rated in the first place, or if the supplier turns out not to be registered. HMRC will disallow the input tax on inspection and the penalty falls on your business, not the supplier.

If you are dealing with a high volume of small receipts, a scanning app (Dext, AutoEntry, Hubdoc and similar) reads the printed VAT block and posts it to your software with the rates already split. They are not perfect, so spot check a sample each month, but they remove most of the manual arithmetic and the temptation to apply one fraction to a mixed receipt.

Short version: divide by 1.2 or use one sixth for 20%, one twenty-first for 5%, never apply either to a total that mixes rates, and let a spreadsheet or your software do the repetition.