Line-by-line results
| # | Net | VAT | Gross |
|---|---|---|---|
| Paste one amount per line to see a breakdown. | |||
| Totals | — | — | — |
Comma-separated: line, net, VAT, gross.
Round each line, not just the total
VAT is charged on each supply, so the calculator rounds the VAT on every line to the nearest penny and then adds the rounded figures. That matches what an invoice shows when each line carries its own VAT amount.
A single rounding step on the total can differ by a few pence. On ten lines that is immaterial, but on a long invoice run it can make your return disagree with your sales ledger. Use the same method your invoicing software uses, and reconcile any difference rather than mixing the two.
Mixed rates need separate runs
One rate applies to the whole batch. If an order contains standard-rated, reduced-rated and zero-rated lines, run the standard-rated lines first, then the reduced-rated lines, then the zero-rated lines, and add the three totals. Mixing them in one run would apply a single rate to everything.
| Line | Net | VAT | Gross |
|---|---|---|---|
| 1 | £100.00 | £20.00 | £120.00 |
| 2 | £250.50 | £50.10 | £300.60 |
| 3 | £1,200.00 | £240.00 | £1,440.00 |
| Totals | £1,550.50 | £310.10 | £1,860.60 |
The two formulas behind the tool
Add VAT: VAT = net × rate ÷ 100
Remove VAT: net = gross ÷ (1 + rate ÷ 100)
Removing VAT is not the same as subtracting the rate. At 20%, subtracting a fifth of a £120 gross price gives £96, but the correct net is £100 and the VAT is £20. The calculator uses the division method, so the figures stay consistent with the removing VAT guide.
Reconciling a batch with your VAT return
The tool gives you net, VAT and gross totals for the batch. To reconcile, compare those totals with the sales daybook or the VAT account for the same period, not with the bank receipts. Three things commonly explain a difference:
- Timing. A VAT return follows the tax point, which can be the invoice date, the payment date or the delivery date depending on the supply. Cash received in the period is not the same test.
- Credit notes. A credit note reduces output tax. If it was left out of the pasted list, the batch total will be higher than the return.
- Rate mix. Zero-rated, exempt and outside-the-scope lines never belong in a 20% run. Including them overstates the VAT even though the net total looks plausible.
A penny or two of rounding across a long invoice run is normal. A difference that scales with the number of lines points to a rate or rounding method, and a difference that stays the same points to a missing document. Investigate the pattern rather than forcing the total to agree.
When bulk is the wrong tool
Bulk arithmetic assumes each line is an ordinary taxable supply at one rate. That is true for most invoice runs, but not for every business:
- Retail schemes. Output tax is worked out from daily gross takings or a scheme percentage, not by adding VAT to each sale. Line-by-line VAT would not match the scheme return.
- Margin scheme. VAT is due on the margin, not the full selling price. Running the selling prices through a 20% bulk calculation overstates the liability badly.
- Domestic reverse charge. On most construction services between VAT-registered businesses, the supplier does not charge VAT and the customer accounts for it. Adding 20% to the invoice would be wrong.
- Partial exemption. If you cannot recover all input tax, the VAT on a purchase is not the amount you reclaim. The bulk tool does not apportion anything.
- Discounts and surcharges. A trade discount reduces the taxable amount, and a prompt payment discount has its own rules. Paste the amount that actually carries VAT, not the list price before discount.
For those cases, use the specialist calculator that matches the scheme, or work from the scheme return itself. Bulk is a fast check on ordinary invoicing, not a substitute for the VAT accounting method you have agreed with HMRC.
What the tool does not do
- It does not decide the VAT rate for a product. That depends on the supply, not the arithmetic.
- It does not account for retail scheme or margin scheme calculations, which start from different figures.
- It keeps no record: the list lives in your browser tab and is gone when you close it.