Add / Remove tax
Move from net to gross or from gross to net without leaving the same working screen.
Tax Inclusive / Exclusive Converter
Convert between tax-inclusive and tax-exclusive prices by entering only the tax rate.
The same workflow works for VAT, GST, and Sales Tax. Paste a table to recalculate many rows at once.
Switch instantly between add tax and remove tax
Batch paste from spreadsheets
Tax rounding and totals in one view
What this page covers
Per-row rates
Use one common tax rate as the default, then override the rate per row when needed.
Tax-amount rounding
Apply round half up, round up, or round down to the tax amount while keeping net + tax = gross.
Reuse
Copy the result as TSV, download CSV, share a reproducible URL, and restore the last state locally.
How to use
- Choose the mode. Add tax converts net to gross, and remove tax converts gross to net.
- Set the common tax rate, rounding rule, and decimal places.
- Enter values manually or paste rows from Excel or Google Sheets.
- Review net, tax, and gross, then export the result as TSV or CSV if needed.
Paste rules
Batch paste is designed first for tab-separated rows copied from spreadsheet software.
Two columns
The first column is treated as the amount and the second column as the tax rate.
1000 10
One column
If you paste only the amount column, the common tax rate is applied.
1100
Three or more columns
Only the first two columns are used. Later columns are ignored.
1000 10 SKU-01
Quick terminology
Tax inclusive
A displayed price that already includes tax.
Tax exclusive
A price before tax is added.
VAT / GST / Sales Tax
Different regions use different names, but this page treats them as user-entered percentage-based indirect taxes with the same workflow.
Formulas
Tax exclusive → Tax inclusive (Add tax)
tax = round_rule(net × rate, unit), gross = net + tax
Tax inclusive → Tax exclusive (Remove tax)
tax = round_rule(gross - gross ÷ (1 + rate), unit), net = gross - tax
Current calculation rule
Rounding is applied per row to the tax amount only. Totals are not re-rounded afterward.
FAQ
Are there country-based tax presets?
No. This page stays globally usable by requiring the user to enter the tax rate instead of choosing from country presets.
Can I calculate multiple products at once?
Yes. You can paste multiple spreadsheet rows at once and recalculate the whole list in one pass.
What if different rows use different tax rates?
Each row can override the tax rate. That works for reduced rates or category-based lists as well.
What is the difference between tax inclusive and tax exclusive?
Tax inclusive means the displayed price already contains tax. Tax exclusive means tax is added on top of the base price. This page converts both directions.
Where is rounding applied?
Rounding is applied to the tax amount. After rounding, the page recalculates the other figure so that net + tax = gross stays true.
Important notes
- This tool is a general calculation aid and does not guarantee tax, filing, or accounting accuracy.
- Tax rates, taxable categories, calculation units, rounding rules, and invoice requirements vary by country, region, and transaction type.
- For final decisions, consult a qualified tax professional or the relevant authority in your jurisdiction.
- Inputs stay inside the browser and are not sent to the server.