Tax Exclusive vs Tax Inclusive: The Mistake Everyone Makes

The most expensive piece of arithmetic in small-business bookkeeping is subtracting a tax rate from a gross figure. Take 20% off 1,200 and you get 960 — which is wrong. The 1,200 already contains the tax, so the net figure is 1,200 ÷ 1.20 = 1,000 and the tax is 200, not 240. The error is 4% of the invoice, it points the wrong way for you, and it repeats on every receipt you process by hand.

Last updated 2026-09-17.

The two modes, defined

+Tax Exclusive (Net → Gross)

You have a net price (the amount you keep). Tax is added on top. This is the standard for B2B quotes because the client reclaims the tax and compares net figures.

Tax = Net × Rate ÷ 100
Gross = Net × (1 + Rate ÷ 100)

÷Tax Inclusive (Gross → Net)

You have a gross total (the amount the client pays). Tax is already inside and must be extracted by division. This is the standard for B2C prices, expense receipts, and marketplace payouts.

Net = Gross ÷ (1 + Rate ÷ 100)
Tax = Gross − Net
Tax = Gross × Rate ÷ (100 + Rate)

The classic error: subtracting instead of dividing

You have a gross total of 1,200 at 20% tax.

MethodCalculationResult
Wrong: Subtract1,200 − (1,200 × 20%)Net: 960 | Tax: 240
Correct: Divide1,200 ÷ 1.20Net: 1,000 | Tax: 200
ErrorNet understated by 40 | Tax overstated by 40

Why it happens: The 20% rate was applied to the smaller net figure (1,000), not the gross (1,200). Subtracting 20% of the gross removes 20% of a bigger number. The gross is 120% of the net, so the tax is only 16.67% of the gross — not 20%.

Worked example: 1,000 at 20%, both directions

Worked example: 1,000 at 20% both directions
Exclusive — Net entered1,000.00
Exclusive — Tax at 20%200.00
Exclusive — Gross total1,200.00
Inclusive — Gross entered1,200.00
Inclusive — Net (1,200 ÷ 1.20)1,000.00
Inclusive — Tax200.00
Wrong method (1,200 − 20%)960.00
Error introduced40.00

Takeaway: The two correct directions agree: 1,000 net and 200 tax. Subtracting 20% from the gross understates the net by 40 and the tax by 40 on a single invoice. To go from gross to net, always divide by 1 + rate.

When to use which mode

Preset rates in the Tax Calculator

The Tax Calculator includes preset chips for the rates freelancers meet most often:

5%

Gulf standard VAT, UK reduced rate (energy), lower GST slabs (India, Canada)

10%

Australian GST, Japanese consumption tax

18%

Indian GST middle standard slab

20%

UK standard VAT, French standard VAT

Custom accepts any rate including fractional rates (7.5%, 13.5%, etc.).

Rounding: per line vs per invoice

This calculator rounds the tax amount once against the base you enter (invoice-level rounding). Accounting systems differ — some round per line, some per invoice. Both are accepted in most jurisdictions if applied consistently. A one- or two-penny difference against per-line software is expected, not an error. Pick one method and stay consistent so your ledger and invoices reconcile.

Sense-check formula

If you are ever unsure which number you have (net or gross), run this check:

Tax ÷ Net × 100 = Rate

If this does not return your rate, you subtracted instead of dividing.

Related guides

Try the calculator

Open the Sales Tax, VAT & GST Calculator on the homepage. Switch between Tax exclusive and Tax inclusive modes to see both readings of the same price side by side.

This calculator does arithmetic on the rate you supply. It is not tax advice and does not determine your registration obligations, place of supply, or whether a transaction is exempt or zero-rated.