Work out VAT on a whole list of amounts in one go. Paste your figures, choose add or remove VAT and the rate, and copy the finished table straight back into your spreadsheet.
Paste straight from a spreadsheet or bank export. A label before a tab or semicolon is kept as the item name. Try an example.
Paste or type one amount per line, then press Calculate (or Ctrl+Enter).
Paste a column of figures and get net, VAT and gross for every line plus the totals, rounded to the penny per line the way an invoice or a VAT return expects. Choose whether your figures are net (add VAT) or gross (remove VAT), and the rate: 20%, 5%, 0% or any custom percentage.
Copy the finished table back into Excel or Google Sheets with one click, or download it as a CSV. Nothing you paste leaves your browser; the maths runs on your own device.
HMRC lets you round the VAT on an invoice either per line or on the invoice total, as long as you are consistent. This calculator rounds each line to the nearest penny and adds the rounded lines, which is what most accounting software does. On a long list the total VAT can therefore differ by a few pence from 20% of the total net; that difference is normal, not an error.
To take 20% VAT out of a VAT-inclusive amount, divide by 1.20 rather than subtracting 20%. £120 ÷ 1.20 = £100 net and £20 VAT; £120 minus 20% would wrongly give £96. Switch the calculator to gross, remove VAT and it does this for every line.
Yes. £1,250.00, 1250, 1 250,50 and (12.00) for negatives are all read correctly. Lines with no number are skipped and counted.
Yes. Paste two columns from a spreadsheet, label then amount, and the label is kept as the item name in the results and in the copied table.
No. The calculation runs in your browser and nothing is sent to our server.
Most goods and services are standard rated at 20%. Domestic fuel, children's car seats and some energy-saving work are 5%; most food, books and children's clothes are 0%. Use the custom rate for another country or a historic UK rate.