Skip to content
TextArray1.41.0
100% local

VAT calculator

Calculate the net, VAT and gross amount for a whole list of prices at once.

Input
Output
Related tools
Percent calculatorNumbers
Thousands separatorText formatting
Locale number formatternewNumbers
Birth number validatorNumbers
Inline math evaluatorNumbers
Duration calculatorNumbers
VAT calculator
Paste a list of prices and this tool works out the net amount, the VAT and the gross total for every line at once — for pricing a batch of items or checking a stack of invoice lines copied from a spreadsheet or an accounting export.
Choose the direction first: "Add VAT to net amount" treats each number as a price before tax and adds VAT on top, while "Extract VAT from gross amount" treats it as a final price and works out how much is tax. The rate field has presets for common European rates (19%, 20%, 21%, 23%, 25%, 27%), or pick "Custom rate" for any percentage. Rounding defaults to the nearest cent; switch to "Round up" or "Round down" for a fixed accounting rule, or turn rounding off for exact figures. Pick a currency for formatting, and set the CSV column option above 0 when the input is a full CSV row rather than one amount per line.
Lines that are not a number — a header row, a product name, a stray note — are left as they were and skipped, so a real CSV export with a header line just works. Blank lines and CRLF/LF line endings are handled the same way. The live tally shows how many amounts were read, processed and skipped, and the total VAT across the list. Turn on "Add totals row" for a summary line with the totals for base, VAT and gross.
Everything runs locally in your browser — amounts are never uploaded, which matters for an unpublished invoice. Choose "Table" for a readable breakdown or "CSV" to paste back into a spreadsheet, then copy, download as .txt, or send the output back into the input.
FAQ
How do I know whether to add or extract VAT?
Use "Add VAT to net amount" when your list is prices before tax. Use "Extract VAT from gross amount" when your list is final prices that already include VAT and you need to see the tax portion.
What happens to a line that is not a number?
It is left unchanged in the output and counted as skipped, so a CSV header row or a stray note does not break the rest of the list.
Can I calculate VAT for a specific column in a CSV export?
Yes. Set "CSV column" to the 1-based position of the amount in each comma, semicolon or tab-separated row; leave it at 0 to treat each whole line as a single amount.
Does the rounding option affect the totals row?
Yes. Each line is rounded first according to the chosen rounding option, and the totals row sums those rounded amounts — the same way most invoicing software rounds line by line.
Is my price list uploaded anywhere?
No. The VAT calculator runs entirely in your browser — your amounts are never sent to a server.