VAT Rounding Rules UK: Nearest Penny, Round Down, Ties

How HMRC lets you round VAT: round the invoice total down, round lines to 0.1p or the nearest penny, unit prices, retailers, and where banker's rounding fails.

By · · 10 min read

Illustration for the Rounding Calculator guide

United Kingdom edition. Written for UK invoicing: HMRC's VAT Notice 700 rounding rules for invoice totals, lines, unit prices and retailers, with £ worked examples run through the Rounding Calculator. US edition

If you invoice in the UK, the rounding rule that matters most is not one from a maths textbook but paragraph 17.5 of HMRC's VAT Notice 700. It lets an invoice trader round the total VAT down to a whole penny, ignoring any fraction. If you work out VAT line by line, each line must be rounded down to the nearest 0.1p or to the nearest 1p or 0.5p, consistently. Retailers who calculate VAT per line or per invoice must not round down at all. Pick the wrong combination and the VAT on the same invoice can differ by a few pence, which matters when the VAT you charge must equal the VAT you pay to HMRC.

This edition works through those rules with the Rounding Calculator and the UK VAT Calculator. For the general theory, every rounding rule, floating-point errors and significant figures, see the US guide to rounding rules.

The rules in VAT Notice 700

HMRC's rules, from paragraphs 17.5 and 17.6 of the notice:

SituationWhat you may do
Total VAT on an invoiceRound down to a whole penny; ignore any fraction of a penny
VAT worked out per lineRound each line down to the nearest 0.1p (86.76p becomes 86.7p), or to the nearest 1p or 0.5p (86.76p becomes 87p); be consistent; the final total may then be rounded down to a whole penny
VAT per unit or per article, for example in price listsWork to 4 decimal places of a pound and round to 3 (£0.0024 becomes £0.002), or round to the nearest 1p or 0.5p, but never to nil on a standard or reduced-rated item (£0.0024 becomes £0.005)
Retailers calculating VAT per line or per invoiceMust not round the VAT down, but may round each calculation up or down

Two conditions sit on the round-down concession. It is designed for invoice traders, and it applies only where the VAT charged to customers is the same as the VAT paid to HMRC. Most retailers use a retail scheme instead, and paragraph 17.6 does not affect them.

The standard rate is 20% and the reduced rate 5%, according to GOV.UK's VAT rates page.

Worked example: one invoice, three answers

A supplier invoices four lines, all at 20%:

LineNetVAT at 20% (exact)Nearest 1pDown to 0.1p
Cable glands£6.43£1.286£1.29£1.286
Labels£0.84£0.168£0.17£0.168
Junction box£18.38£3.676£3.68£3.676
Tester hire£14.99£2.998£3.00£2.998
Total£40.64£8.128£8.14£8.128

Now apply each permitted method:

  • Invoice-level, rounded down: £8.128 becomes £8.12.
  • Lines to 0.1p, then the total rounded down: the lines already have three decimal places, so they total £8.128, and the total rounds down to £8.12.
  • Lines to the nearest 1p: the lines total £8.14, 2p more.

To check this in the Rounding Calculator, paste the four exact VAT figures into the list mode, choose 2 decimal places and half away from zero: the rounded sum is 8.14 and the drift is +0.012. Switch the rule to floor with 2 places on 8.128 and you get 8.12, HMRC's round-down.

All three are allowed, but they are not interchangeable. The notice says that whatever you decide at line level you must be consistent, and the round-down only works if your customer is charged the same VAT you pay over. Per-line rounding to the nearest penny pushes VAT up whenever more lines end in 5p to 9p than in 1p to 4p, the same upward drift the US guide describes for half-up rounding of ties, here caused by lines that are not even ties.

At 20% there are no half-penny ties

A useful quirk of the UK standard rate: 20% of a whole number of pence always ends in an even tenth of a penny (0, 0.2, 0.4, 0.6 or 0.8p). So a 20% line never lands exactly on a half penny, and the choice between banker's rounding (half to even) and school rounding (half away from zero) cannot change a 20% line rounded to the penny.

At the 5% reduced rate it can. 5% of 10p is exactly 0.5p:

Exact VATHalf to evenHalf away from zeroNearest 0.5p
£0.005 (5% of 10p)£0.00£0.01£0.005
£0.015 (5% of 30p)£0.02£0.02£0.015
£0.025 (5% of 50p)£0.02£0.03£0.025

Each row is the Rounding Calculator with 2 decimal places under each rule, or the nearest multiple of 0.005. Banker's rounding sends £0.005 to £0.00, which would put nil VAT on a reduced-rated item, exactly what paragraph 17.5.2 forbids for per-unit amounts. If your software uses half to even, as Python's built-in round() does, check it before you use it for VAT.

Per-unit prices: never round to nil

For price lists, HMRC's own example is VAT of £0.0024 on a unit. Rounded to 3 decimal places it becomes £0.002, 0.2p. Rounded to the nearest 0.5p it would be £0.000, which is not allowed, so HMRC gives £0.005. In the calculator, the nearest multiple of 0.005 under half away from zero gives 0.000, and ceiling gives 0.005. The rule is effectively "nearest, but never below half a penny on a taxable unit".

Excel and accounting software

Excel's ROUND sends ties away from zero (Microsoft's own examples give ROUND(2.15, 1) = 2.2 and ROUND(-1.475, 2) = -1.48), and ROUNDDOWN rounds towards zero, which matches HMRC's round-down for positive amounts. So =ROUNDDOWN(SUM(D2:D5),2) gives the invoice-level round-down, and =SUM(ROUND(D2:D5,2)) the nearest-penny line method. On credit notes, where amounts are negative, ROUNDDOWN moves towards zero, so the credit is the same size as the invoice it reverses. Whatever your software does, the requirement in the notice is consistency between what you charge and what you account for.

Choosing a method

  • Invoice traders with several lines: compute VAT on the invoice total and round down. It is the simplest and never over-charges.
  • Line-level VAT (common when lines go to different cost codes): round each line down to 0.1p, then round the total down, to stay closest to the exact figure.
  • Retailers calculating per line or invoice: round each calculation to the nearest penny, up or down, never down by default.
  • Reduced-rate items priced in pence: avoid banker's rounding, because it can produce nil VAT.

This guide covers rounding only. For which rate applies to a supply, or a retail scheme, check the relevant VAT notice or ask an accountant.

Tools for this job

  • Rounding Calculator: round one amount or a list under ten rules, to decimal places or the nearest 0.005, with the total drift.
  • UK VAT Calculator: add or remove VAT at 20%, 5% or a rate you enter.

For VAT on your own invoices, see how to write an invoice in the UK.

Frequently asked questions

Can I round VAT down on an invoice?

Yes, if you are an invoice trader and the VAT you charge customers is the same as the VAT you pay HMRC. VAT Notice 700 lets you round the total VAT on an invoice down to a whole penny. Retailers working out VAT per line or per invoice must not round down.

Should VAT be calculated per line or on the invoice total?

Either is allowed. On the total, round the VAT down to the penny. Per line, round each line down to 0.1p or to the nearest 1p or 0.5p, consistently, then you may round the total down. The methods can differ by a few pence on the same invoice.

Does banker's rounding work for VAT?

At 20% it never matters for penny rounding, because 20% of whole pence never ends in a half penny. At 5% it can send 0.5p to nil, which HMRC does not allow for VAT on a standard or reduced-rated unit, so use another rule there.

What does "round to the nearest 0.5p" mean in practice?

Round to the nearest multiple of £0.005: £0.0024 would go to £0.000 and £0.0026 to £0.005. For per-unit VAT HMRC adds that a taxable unit must never show nil, so £0.0024 becomes £0.005.

Sources and further reading

Open the Rounding Calculator

More Math Calculators

Every tool in the Math Calculators section, free and in your browser.