Tax-inclusive or tax-exclusive prices: how to show tax on invoices and quotes
Whether your prices include tax changes every total on the invoice, and getting it wrong costs you the tax or confuses the customer. This guide explains both ways, gives the formula for backing tax out and works through the rounding and mixed-rate cases.
A tax-exclusive price is the price before tax, and the tax is added on top: $100 plus 10% GST is $110. A tax-inclusive price already contains the tax: $110 including GST means $100 is yours and $10 is the tax office's. Pick one way for each invoice or quote, say which it is next to the total, and show the tax as its own figure either way.
As a rough guide, show consumers tax-inclusive prices wherever the law expects the full price up front, which is the case in the UK, the EU and Australia. Business customers, and customers in most US states, usually see prices before tax with the tax added at the end. The rest of this guide is the arithmetic, the rules that drive the choice and the mistakes that cost money. It's general information, not legal or tax advice.
The two ways, side by side
| Tax-exclusive | Tax-inclusive | |
|---|---|---|
| What the line price means | Your price before tax | What the customer pays, tax included |
| How tax is worked out | Net price times the rate | Backed out of the gross price |
| Who it suits | Business customers who reclaim tax; US sales tax | Consumers in the UK, EU and Australia; shops and menus |
| What changes if the rate changes | The customer pays more | You keep less, unless you reprice |
That last row matters more than it looks. With inclusive prices, the tax comes out of your margin. If the rate goes up and your price list stays the same, every sale earns you a little less.
How to back tax out of an inclusive price
The common mistake is to multiply the inclusive price by the rate. On a £120 price at 20% VAT, that gives £24, which is wrong. The £120 is already 120% of the net price, so the tax is a share of 120, not of 100.
The formula is:
Tax = gross price × rate ÷ (100 + rate)
So £120 at 20% is 120 × 20 ÷ 120 = £20 of VAT, leaving £100 net. At 10% GST, the tax is one eleventh of the gross price. At 20% VAT, it's one sixth.
| Gross price | Rate | Tax backed out | Net price |
|---|---|---|---|
| £120.00 | 20% | £20.00 | £100.00 |
| £50.00 | 20% | £8.33 | £41.67 |
| A$110.00 | 10% | A$10.00 | A$100.00 |
| A$99.00 | 10% | A$9.00 | A$90.00 |
| €121.00 | 21% | €21.00 | €100.00 |
| €60.00 | 5% | €2.86 | €57.14 |
Work out the tax first, round it to the cent, then take it away from the gross to get the net. Done that way, the net and the tax always add back to exactly the price the customer saw.
Rounding: per line or per invoice
Rounding is where two correct-looking invoices disagree by a penny. Take three items at £9.99 each, VAT inclusive at 20%.
- Per line: 9.99 × 20 ÷ 120 = 1.665, which rounds to £1.67. Three lines give £5.01 of VAT.
- On the total: the three lines come to £29.97, and 29.97 × 20 ÷ 120 = 4.995, which rounds to £5.00.
Neither is a scandal, but your books, your accounting software and your customer's books should all agree. Choose one method and use it on every invoice. HMRC's VAT guide (Notice 700) has a section on rounding, and if you use accounting software, set it to the same method your invoices use, or every reconciliation will show small differences.
Mixed rates on one invoice
Many invoices carry more than one rate: a standard-rated service next to a reduced-rate or zero-rated item, or taxable goods next to tax-free ones. Work out the tax separately for each rate, then add the results. Never apply one rate to the whole total.
Say an Australian caterer bills A$500, made up of A$440 of prepared food, which carries GST, and A$60 of basic groceries, which in this example are GST-free. The GST is one eleventh of A$440, so A$40. If she takes one eleventh of the whole A$500, she gets A$45.45 and overstates the tax by A$5.45. Which goods carry which rate depends on the country, so check the tax office's own list. In the UK that's HMRC's rates of VAT on different goods and services.
On the invoice, show a tax line for each rate, with the rate and the amount. A customer reclaiming the tax needs to see both.
When consumers must see inclusive prices
In several places the price you show a consumer has to be the full price, tax included. Some examples:
- UK. The Price Marking Order 2004 requires traders selling goods to consumers to show the selling price, and defines it to include VAT and other taxes. Prices shown to business customers can be quoted before VAT, as long as that's clear.
- Australia. The ACCC's guidance on displaying prices says businesses must show a single total price, including GST and other unavoidable charges, when they show part of a price.
- US. Sales tax is set by states and local areas and is normally added at the till or on the invoice. Shown prices are usually before tax, so say "plus sales tax" when you quote.
If you sell to both businesses and consumers, the simple route is to quote consumers inclusive and businesses exclusive, and to say which in words next to the total.
What a tax invoice needs
When a customer will reclaim the tax, the invoice has to carry specific details. They differ by country, so here are two common ones.
- UK VAT invoices. HMRC's record keeping notice lists what a full VAT invoice must show, including your VAT registration number, the unit price, the rate of VAT for each item and the total VAT. A simplified VAT invoice is allowed for supplies of £250 or less including VAT.
- Australian tax invoices. The ATO's page on tax invoices says a buyer needs one to claim a GST credit on a sale over A$82.50 including GST. It must say it is a tax invoice and show your ABN, among other things, and for sales of A$1,000 or more, the buyer's identity or ABN too.
Put your tax number in the same place on every document, under your name and address, and label it with its type: VAT number, ABN, GST number or EIN. A bare string of digits makes a bookkeeper guess.
A worked example
A VAT-registered decorator in the UK paints a living room for a homeowner. She quotes £1,800 including VAT: £1,440 for labour and £360 for paint, both at 20%.
- VAT on the labour is 1,440 × 20 ÷ 120 = £240, so the net labour is £1,200.
- VAT on the paint is 360 × 20 ÷ 120 = £60, so the net paint is £300.
- The invoice shows a net total of £1,500, VAT at 20% of £300, and a total of £1,800.
The following week she quotes a letting agent for the same job. The agent is VAT registered and thinks in net figures, so she writes it exclusive: £1,500 plus VAT of £300, total £1,800. Same job, same money, and each customer sees the number they care about first.
The homeowner later decides the paint wasn't needed for one wall, and they agree a £120 reduction. She sends a credit note for £120 including VAT, which reverses £20 of VAT and £100 of net sales. The VAT she owes for the quarter is now £280 on this job, not £300.
Refunds and credit notes
A refund or a credit note reverses tax in the same proportion as the original sale. Back the tax out of the amount refunded using the original rate, not today's rate if it has changed since. If the original invoice had mixed rates, split the refund across the rates the same way, or refund specific lines.
Keep the link between the two documents: quote the original invoice number on the credit note. When you prepare a tax return, take refunds and credit notes off the tax collected for the period they're issued in, as your tax office's rules require.
Common mistakes
- Multiplying an inclusive price by the rate. That overstates the tax. Use gross × rate ÷ (100 + rate).
- Not saying which it is. "£1,500" on a quote can mean either. Write "including VAT" or "plus VAT" next to every total.
- One rate on a mixed invoice. Work out each rate separately and show each on its own line.
- Switching rounding methods. Pick per line or per invoice and stay with it, in your invoices and your software.
- Charging tax before you're registered. In many countries you may not charge VAT or GST until you're registered, and you must start once you pass the threshold.
- A tax number with no label. Say what kind of number it is.
In Programmable Page, invoices, quotes, receipts and credit notes can be set to treat their prices as including tax. The page then backs the tax out at each rate, rounded to the currency's smallest unit, and the Pay amount, any deposit and the PDF all use the same figures. Your tax number prints under your address with its type, such as VAT number, GST number, ABN or EIN, and Money, then Reports, shows the tax collected by rate for a quarter or a year, with refunds and credit notes taken off.
Questions
How do I work out the tax in a tax-inclusive price?
Multiply the price by the rate, then divide by 100 plus the rate. For £120 at 20% VAT that's 120 × 20 ÷ 120, so £20 of VAT and £100 net.
Should I quote prices with or without VAT?
Consumers in the UK generally need to see prices with VAT included. Business customers who reclaim VAT usually prefer prices before VAT. Whichever you use, say so next to the total. This is not tax advice.
Do I round tax per line or on the invoice total?
Either can be acceptable, but use the same method every time and set your accounting software to match. Check your tax office's rounding rules, such as the section in HMRC's VAT guide.
How does a credit note affect the tax?
It reverses tax in the same proportion as the original sale, at the original rate. Quote the original invoice number and take it off the tax collected for the period it's issued in.