Add / Remove tax
Move from net to gross or from gross to net without leaving the same working screen.
పన్ను సహిత / పన్ను రహిత మార్పిడి
Tax rateను మాత్రమే నమోదు చేసి, పన్ను సహిత మరియు పన్ను రహిత ధరల మధ్య మార్పిడి చేయండి.
VAT, GST, మరియు Sales Taxకు అదే workflow పనిచేస్తుంది. పట్టికను అతికించి అనేక వరుసలను ఒకేసారి తిరిగి లెక్కించండి.
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.
తరచుగా అడిగే ప్రశ్నలు
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.
ముఖ్య గమనికలు
- Tax rate మరియు rounding విధానం ఫలితాన్ని మార్చుతాయి.
- మీ దేశపు పన్ను నియమాలకు అనుగుణంగా విలువలను తనిఖీ చేయండి.
- పంచుకునే URLలో రహస్య సమాచారాన్ని పెట్టవద్దు.
- Inputs stay inside the browser and are not sent to the server.