Sales tax exclusive price:
formula and worked example

Why you need the price before tax

Many prices are shown with tax already included, particularly to consumers. Businesses that need to record sales or purchases, compare quotes from suppliers who show prices differently, or report the tax portion separately need the figure before tax.

The mistake that appears most often is reversing the tax by taking the rate off the total. That gives a plausible number, but it is wrong, and the error grows with the rate. The correct approach uses division.

The formula: divide by one plus the rate

Because the inclusive price is the base price multiplied by one plus the tax rate, you reverse it by dividing.

• Inclusive price: the amount the customer pays, tax included, in currency.
• Tax rate: the rate applied to the base price as a decimal, so 18% is 0.18.

The rate here is illustrative. Use the rate that applies to the specific goods or service and place of supply, which you can confirm from the invoice or from the relevant authority.

The same idea works for any percentage that has been added on top of a base, whether it is a service charge or a delivery surcharge. Divide by one plus the rate. The key is recognising that the percentage was applied to the base, not to the total you see, and so it must be undone by dividing back through the multiplier.

Worked example: 1,180 including 18% tax

1. 1Add one to the rate: 1 + 0.18 = 1.18.
2. 2Divide the inclusive price: 1,180 / 1.18 = 1,000.
3. 3Find the tax portion: 1,180 - 1,000 = 180.
4. 4Verify by going forward: 1,000 x 0.18 = 180, and 1,000 + 180 = 1,180.

The check at the end is worth keeping as a habit. If multiplying your answer by one plus the rate does not return the original price, something went wrong in the division.

Why subtracting the percentage gives the wrong answer

Take 18% off 1,180 and you get 212.40, leaving 967.60. But the tax actually charged was 180, because the 18% applied to the 1,000 base, not to the 1,180 total. Subtraction treats the total as if it were the base, so it removes too much tax and understates the true price.

The gap gets wider as the rate rises or as the amount grows. On large purchases or at higher rates, the error can become a meaningful distortion in your records, which affects margins, input credits and reconciliations.

When goods carry different rates on one bill, reverse each line at its own rate. A combined invoice total cannot be divided by a single factor unless every line shares one rate. Where the invoice shows the base and tax separately, use those figures and verify them with the division as a check.

For purchases, the tax portion may be creditable in some systems, so the base price rather than the tax-inclusive price is what belongs in your cost of goods. Using the inclusive figure overstates cost and understates profit.

How a higher inclusive price changes the base

At 1,298 including tax, the base is 1,100 and the tax 198. Proportionality holds only if the rate does not change. If the rate moves, for example with a change in classification, recompute from the new divisor, because the same shelf price then implies a different base.

Mistakes when removing tax

• Subtracting the percentage from the total instead of dividing.
• Applying the standard rate to goods that carry a different or zero rate.
• Rounding every line item separately and then finding the total does not match the invoice.
• Using a rounded rate such as 0.18 when the actual rate has more decimals or when a compound structure applies.

Also be careful with rates quoted as percentages of the inclusive amount. A few systems describe tax that way, and then the division is different. If in doubt, work from a sample invoice where both the base and the tax are shown.

A routine for reversing tax cleanly

Confirm that the quoted price really includes tax, identify the right rate, divide, then test by multiplying back. Record the base and tax portions separately so they can be traced later.

1. 1Check the invoice or label wording for tax-inclusive pricing.
2. 2Identify the applicable rate for that item.
3. 3Divide by one plus the rate.
4. 4Multiply back to confirm you reach the original price.