Price excluding tax:
stripping tax out of a final amount

Why you divide instead of subtract

A shelf price of ₹1,120 that includes 12% tax was built by multiplying a base by 1.12. To undo that, divide by 1.12. The tax percentage was calculated on the smaller base, so it is not 12% of the larger total.

To prove the answer, rebuild the total: 1000 × 1.12 = 1120. If the check does not return your starting figure, the division was set up incorrectly.

The subtract-the-percentage error

Many people take 12% of ₹1,120, which is ₹134.40, and subtract it, getting ₹985.60. That looks reasonable, but the answer is too low by ₹14.40. The 12% belongs to the base of ₹1,000, so it is ₹120.

The error grows with the rate and the size of the amount. At 18% on ₹11,800, subtracting gives 11800 × 0.82 = ₹9,676, while the correct pre-tax price is 11800 ÷ 1.18 = ₹10,000. That is a ₹324 difference on a single invoice, large enough to cause a return mismatch.

Tax share at different rates

The rates in the table are illustrations of the method. Use the one that applies to your supply, and note that a rate for one product category may not apply to another.

Situations where this comes up

• Reconciling a supplier bill that shows only the total when your books need the base and the tax separately.
• Claiming input tax credit or filing returns that ask for the taxable value.
• Comparing prices from sellers who quote with and without tax.
• Setting a selling price: if the market takes ₹1,120 all-in, your revenue before tax is ₹1,000.
• Splitting a restaurant or service bill into its taxable and tax components.

In each case the sequence is the same: find out the rate, divide the total by 1 plus the rate, and subtract that from the total to get the tax. A dedicated tax-removal tool saves doing this by hand for a long list of invoices.

When a bill contains several rates

If a single total includes items at different rates, you cannot back out the base without knowing how the total splits. Dividing a mixed total by one rate will produce a wrong answer for every line.

Suppose a bill of ₹2,170 is made up of two items: one with 5% tax and one with 18%. Unless the invoice shows the split, there are many pairs of bases that can produce that total. The solution is to ask for the itemised bill, which is what a valid tax invoice should provide anyway.

Taking apart a restaurant-style bill

Suppose a service bill shows a total of ₹2,360 and the only information is that it includes 18% tax. The pre-tax amount is 2360 ÷ 1.18 = ₹2,000 and the tax is ₹360. If the invoice instead says the tax is split in two equal parts, each part is ₹180 on a 9% rate.

This is also how you work out what a business actually earns on a sale. The customer paid ₹2,360, but the business keeps ₹2,000 before its own costs, because the rest belongs to the tax authority.

Doing a whole column at once

In a spreadsheet, put the inclusive totals in one column and the rate in a separate cell. The base is then the total divided by (1 + rate cell), and the tax is the total minus the base. Keep the rate as a decimal or as a percent-formatted cell so that 12% is stored as 0.12.

A column of results that are all slightly larger than expected usually means you divided by the rate instead of by 1 + rate, which is a typing slip rather than a conceptual one. Compare a single row by hand before trusting the whole sheet.

Keeping the base and tax apart in your books

Once you have extracted the base, record it separately from the tax. Expense reports that lump tax into the cost overstate what the item really cost the business, and returns filed on the wrong figure can be rejected. A simple three-column habit, total, base and tax, with the check base × (1 + rate) = total, prevents most of these mix-ups.

It also helps to note which rate you used and why, so that a reviewer can follow your working months later without redoing it.

Rounding and a caution

When dividing, you will often get a long decimal, such as ₹952.380952. Keep the full value in your working and round only the figure you report. If you round the base to ₹952.38 and then recompute tax at 5%, the total may be a paisa off the original ₹1,000.

Treat any figure from a formula as an estimate until it matches the supplier's invoice. If an invoice shows a base and tax that do not follow the division rule, the difference could be rounding, an exempt item or a different rate than you assumed, and the invoice is the document that governs.