How this instrument works
Value-added tax is charged as a fixed percentage of the pre-tax price, and that single fact is why the arithmetic is only two steps: multiply the net amount by the rate to get the VAT charged, then add that figure back onto the net amount to get the gross. What separates VAT from a one-stop retail tax is not the multiplication but how often it repeats — a slice is charged and handed to the tax authority at each link in the supply chain, from the farm or the mine through the factory floor and the distributor's warehouse to the shop counter — yet the sum owed at any single one of those links comes from exactly this net-to-VAT-to-gross conversion, run once per sale.
The three-figure breakdown this instrument produces is mostly a business document rather than a shopping one. Retail law in VAT countries requires the price on the shelf to already include the tax, so a shopper comparing two boxes of cereal sees one number, not net, VAT and gross laid out separately. The breakdown matters on a formal invoice between VAT-registered businesses, where the seller must itemize the net charge, the rate applied, and the VAT amount, because the buyer — if also VAT-registered — reclaims that exact VAT amount as input tax against whatever VAT it charges its own customers. Freelancers, contractors and small companies above their country's VAT-registration threshold produce this breakdown routinely; a shopper at a till almost never sees it.
This sheet runs in one direction only: net amount and rate in, VAT and gross out. It does not recover a net figure from a gross one — that division is a different calculation and needs the gross divided by one plus the rate, not this multiplication. It also assumes a single flat rate on a single line; it will not split an invoice across standard, reduced and zero-rated items, and it does not model the reverse charge that shifts VAT accounting to the buyer on certain cross-border business-to-business services within the EU.
- Enter the price before tax into Net (pre-VAT) amount, $ — a figure you are certain excludes VAT already.
- Set VAT rate, % to whatever figure applies to this sale — 20% is the UK's standard rate and common across much of the EU, but reduced and zero rates apply to specific goods.
- Read VAT amount, $ for the tax that rate adds to this particular sale.
- Read Gross (VAT-inclusive) amount, $ for the total figure that belongs on the invoice or the receipt.
- Change the rate against the same net amount to see how a reduced or zero-rated category would change what the sale actually charges.
Worked example — a $1,000 net price at 20% VAT
A contractor invoices a VAT-registered client for $1,000 of net work, charged at the 20% standard rate that the UK applies and several EU countries share. VAT = 1,000 × 20 ÷ 100 = $200, and gross = 1,000 + 200 = $1,200 — the figure that actually appears at the foot of the invoice, alongside the net and VAT lines shown separately above it.
Only the $1,200 figure would ever reach a retail shopper, and even then folded into a single shelf price rather than split into three lines, because VAT is normally quoted tax-inclusive at the point of sale. The net-VAT-gross breakdown this example shows exists for the client's benefit: a VAT-registered business receiving this invoice reclaims exactly the $200 VAT line as input tax against the VAT it charges its own customers, which is why that figure has to be stated, not just implied.
Questions
What VAT rate should I enter?
Whatever rate applies to the specific goods or service, not a general guess. The UK charges a 20% standard rate with 5% and 0% bands for specific categories; EU member states set their own standard rates, most falling roughly between 17% and 27%. Check the rate for the exact category before typing it in — the field has no default that is correct for every sale.
Why doesn't my shop receipt show net, VAT and gross separately?
Consumer protection rules in VAT countries require the displayed price to already include tax, so a shelf tag or a card receipt normally shows one number. The three-line breakdown this instrument produces is a business-invoice convention, not a retail one — it appears when the buyer is VAT-registered and needs the VAT figure isolated to reclaim it.
I have a VAT-inclusive price — can I use this to find the net figure?
Not directly. This sheet only runs forward, from a net amount to a gross one. To strip VAT out of a price that already includes it, divide by one plus the rate as a decimal — an $1,200 inclusive price at 20% divides back to $1,000 net. Typing an inclusive figure into Net (pre-VAT) amount, $ charges VAT on top of VAT already sitting inside the number.
Who actually needs a net, VAT and gross breakdown?
A VAT-registered business invoicing another VAT-registered business. The seller must state the net charge, the rate, and the VAT amount as separate figures so the buyer can reclaim exactly that VAT amount as input tax. A sale to a final consumer, who has nothing to reclaim, rarely needs the lines separated at all.
Does this handle the reverse charge on cross-border services?
No. Under the reverse charge, certain cross-border business-to-business services shift the VAT accounting to the buyer, who declares both the VAT charged and reclaimed on their own return instead of the seller charging it. This sheet prices a single domestic-style line at a flat rate; treat reverse-charge transactions as a separate bookkeeping step around this number.
Is VAT the same thing as a US sales tax?
No. A US-style sales tax is added only once, when a retailer rings up a final consumer purchase, and appears as its own line on top of the shelf price at the register. VAT instead collects a slice at each handoff along the supply chain and is normally already folded into the price a shopper sees, which is exactly why this net-VAT-gross breakdown surfaces mainly on business invoices rather than till receipts.
References
- GOV.UK — VAT rates on different goods and services
- European Commission — Taxation and Customs Union, VAT
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.