How to Find the Tax Rate From a Total and Subtotal

You can calculate a tax rate backwards when you know both:

The subtotal before tax
The final total after tax

The difference between these amounts is the tax charged. Divide that tax amount by the taxable subtotal, then convert the result into a percentage.

However, a final total by itself is not enough to identify the tax rate. Many combinations of original prices and tax rates can produce the same final amount.

For additional examples, troubleshooting tables, and guidance on interpreting unusual results, read the complete guide to finding the tax rate from a total.

Formula to Find the Tax Rate

Use this formula:

Tax rate = ((Total - Subtotal) ÷ Subtotal) × 100

The formula has three steps:

Subtract the subtotal from the total to find the tax amount.
Divide the tax amount by the subtotal.
Multiply the result by 100 to convert it into a percentage.

The subtotal must represent the taxable price before tax.

Example: Subtotal of 100 and Total of 108

Suppose an invoice shows:

Subtotal before tax: 100.00
Final total: 108.00

Step 1: Find the tax amount

108.00 - 100.00 = 8.00

The tax amount is 8.00.

Step 2: Divide the tax by the subtotal

8.00 ÷ 100.00 = 0.08

The decimal tax rate is 0.08.

Step 3: Convert the decimal into a percentage

0.08 × 100 = 8%

The implied tax rate is 8%.

Why You Divide by the Subtotal

Tax is normally calculated as a percentage of the taxable price before tax.

In the example above, the tax was calculated from 100.00:

100.00 × 8% = 8.00

The total was then created by adding the tax:

100.00 + 8.00 = 108.00

That is why the tax amount must be divided by 100.00, not by 108.00.

What Happens If You Divide by the Total?

Using the same example:

8.00 ÷ 108.00 × 100 = 7.41%

This does not calculate the tax rate applied to the subtotal.

It calculates the percentage of the final tax-inclusive total that consists of tax.

These are different measurements:

Tax rate applied to subtotal: 8%
Tax share of final total: approximately 7.41%

To find the applied tax rate, divide by the taxable subtotal.

Example With a Larger Invoice

Suppose a business invoice shows:

Subtotal: 1,000.00
Final total: 1,130.00

Find the tax amount:

1,130.00 - 1,000.00 = 130.00

Divide by the subtotal:

130.00 ÷ 1,000.00 = 0.13

Convert to a percentage:

0.13 × 100 = 13%

The implied tax rate is 13%.

You can verify the result by applying the rate forward:

1,000.00 × 13% = 130.00

1,000.00 + 130.00 = 1,130.00

The reconstructed total matches the invoice.

Can You Find the Tax Rate From the Final Total Alone?

No.

Suppose the only number available is a final total of 108.00.

That amount could have been created by:

100.00 plus 8% tax
102.86 plus 5% tax
98.18 plus 10% tax
A taxable amount plus an exempt fee
Several products using different tax rates

Without another value, such as the subtotal or tax amount, there is no unique rate to calculate.

You need at least two related values, such as:

Information available	Can you calculate the rate?
Total only	No
Subtotal and total	Yes
Subtotal and tax amount	Yes
Total and tax amount	Sometimes, after finding the subtotal
Total and known rate	Rate calculation is unnecessary
Payment amount after credits	Not reliably

Finding the Rate When the Tax Amount Is Known

Suppose you know:

Subtotal: 200.00
Tax amount: 16.00

Use:

Tax rate = Tax amount ÷ Subtotal × 100

Calculation:

16.00 ÷ 200.00 × 100 = 8%

You do not need the final total, although it can be calculated:

200.00 + 16.00 = 216.00

Finding the Rate When Total and Tax Are Known

Suppose a receipt shows:

Final total: 216.00
Tax amount: 16.00

First calculate the subtotal:

216.00 - 16.00 = 200.00

Then calculate the rate:

16.00 ÷ 200.00 × 100 = 8%

The implied rate is 8%.

This method assumes the difference between the final total and tax amount is the taxable subtotal.

Example With a Rounded Receipt

Suppose a receipt shows:

Subtotal: 93.46
Total: 100.00

Find the tax amount:

100.00 - 93.46 = 6.54

Calculate the rate:

6.54 ÷ 93.46 × 100 = 6.9976%

The result is not exactly 7%, but it is close.

The likely explanation is that tax was calculated using more decimal places and then rounded to the nearest cent.

In a practical report, you might record:

Implied rate: 6.9976%
Likely listed rate: 7%
Difference likely caused by rounding

Do not automatically treat a slightly unusual decimal as evidence that the seller used an unusual official rate.

Implied Tax Rate Versus Official Tax Rate

The formula calculates an implied rate.

An implied rate is the percentage suggested by the numbers entered.

An official tax rate comes from a tax authority or another verified legal source.

These rates may match, but they are not the same type of evidence.

Rate type	Source	What it tells you
Implied rate	Subtotal and total	What rate the numbers suggest
Official rate	Tax authority	What rate legally applies
Combined rate	Several tax components	Total effect of multiple taxes
Effective rate	Tax divided by a broader amount	Overall percentage burden

Use the implied rate to check or investigate a transaction. Do not treat it as proof of the legally applicable rate.

Why the Calculated Rate May Look Wrong

An unusual rate does not always mean the formula failed.

It may indicate that the subtotal or total contains additional components.

Rounding

Tax may have been calculated on individual items and rounded separately.

A one-cent difference can noticeably affect the rate on a small purchase.

Discounts

A discount may reduce the taxable base before tax is calculated.

If you use the original subtotal instead of the discounted taxable subtotal, the implied rate may appear too low.

Exempt items

The subtotal may include both taxable and exempt products.

Dividing the tax by the complete subtotal can produce a rate below the actual rate applied to the taxable items.

Multiple tax rates

A receipt may contain products taxed at different rates.

The calculated result may be a blended rate rather than one official rate.

Multiple tax components

The total may include several separate taxes, such as state and local sales tax or GST and PST.

The formula may reveal their combined effect.

Shipping and fees

Delivery fees, service charges, tips, handling fees, or deposits may be included in the total.

If these amounts have different tax treatment, the implied rate may become distorted.

Credits and payments

An amount due after applying a gift card, credit, deposit, or partial payment is not necessarily the transaction total.

Use the original subtotal and transaction total, not the remaining balance.

Example With an Exempt Item

Suppose a receipt contains:

Taxable products: 100.00
Exempt product: 50.00
Tax: 8.00
Final total: 158.00

If you use the full subtotal of 150.00, you get:

8.00 ÷ 150.00 × 100 = 5.33%

That result is misleading.

The tax was applied only to the taxable 100.00:

8.00 ÷ 100.00 × 100 = 8%

The correct implied rate for the taxable group is 8%.

This is why the denominator must be the taxable subtotal, not simply every amount listed before the final total.

Example With Two Tax Rates

Suppose a receipt contains:

100.00 taxed at 5%
100.00 taxed at 20%

Tax amounts:

100.00 × 5% = 5.00

100.00 × 20% = 20.00

Combined subtotal:

200.00

Combined tax:

25.00

Final total:

225.00

The implied combined rate is:

25.00 ÷ 200.00 × 100 = 12.5%

However, no item was actually taxed at 12.5%.

The receipt contains two rates: 5% and 20%.

The 12.5% result is a blended rate created by combining the tax groups.

For accurate analysis, separate the groups instead of reporting the blended result as the official rate.

How One Cent Affects Small Subtotals

A one-cent rounding difference has a larger percentage effect on a small subtotal.

Subtotal	Effect of a one-cent difference
1.00	1.00 percentage point
10.00	0.10 percentage point
100.00	0.01 percentage point
1,000.00	0.001 percentage point

This is why a small receipt may produce an implied rate such as 6.91% or 7.08% even when the intended rate was 7%.

The same one-cent difference has much less effect on a large invoice.

How to Check the Calculated Rate

After calculating the implied rate, apply it forward.

Suppose:

Subtotal: 250.00
Calculated rate: 8%
Expected total: 270.00

Calculate the tax:

250.00 × 8% = 20.00

Rebuild the total:

250.00 + 20.00 = 270.00

If the result matches the original total, the implied rate is mathematically consistent.

If it does not match, check:

Whether the rate was rounded too early
Whether the subtotal is taxable
Whether fees are included
Whether discounts changed the base
Whether several taxes apply
Whether the input fields were reversed

Troubleshooting Unexpected Results

Result	Likely explanation	What to check
Rate is close to a normal rate	Rounding	Line-level and receipt-level tax
Rate is much higher than expected	Fees or multiple taxes	Additional charges and tax lines
Rate is lower than expected	Exempt items or discounts	Taxable subtotal
Rate is 0%	Total equals subtotal	Tax status or missing tax
Rate is negative	Values reversed or credit involved	Total, subtotal, and refunds
Rate is extremely high	Wrong subtotal or decimal format	Imported data and taxable base
Rate changes between items	Mixed tax rates	Individual receipt lines

Formula for Excel and Google Sheets

Suppose:

A2 contains the subtotal
B2 contains the final total

Use:

=((B2-A2)/A2)*100

If the result cell is formatted as a percentage, use:

=(B2-A2)/A2

Do not multiply by 100 when the cell already uses percentage formatting.

Suggested worksheet columns

Column	Heading
A	Taxable Subtotal
B	Final Total
C	Tax Amount
D	Implied Tax Rate
E	Expected Official Rate
F	Rate Difference
G	Review Note

Formulas:

Tax amount in C2

=B2-A2

Implied rate in D2

=C2/A2

Rate difference in F2

=D2-E2

Format D2, E2, and F2 as percentages.

Common Spreadsheet Errors

Dividing by the total

Incorrect:

=(B2-A2)/B2

This calculates the tax share of the final total.

Correct:

=(B2-A2)/A2

This calculates the rate applied to the subtotal.

Multiplying by 100 twice

If the formula multiplies by 100 and the cell is also formatted as a percentage, an 8% rate may display as 800%.

Choose one method:

Formula returns 0.08, cell displays 8%
Formula returns 8, cell displays a regular number

Using the amount due

A balance after credits or payments may not equal the transaction total.

Use the original final total before payment adjustments.

Using a tax-inclusive subtotal

The subtotal must be before tax.

If it already includes tax, the calculation will not produce the applied rate correctly.

Ignoring zero or negative subtotals

A subtotal of zero causes division by zero.

Negative totals may represent refunds, credits, or reversed transactions and require separate interpretation.

Can You Use This Formula for VAT, GST, or Sales Tax?

Yes, the same arithmetic can be used when:

The subtotal is the taxable amount before VAT, GST, or sales tax
The final total includes the tax
One rate applies to the amount
Additional fees or tax components have been identified

The formula reveals the percentage implied by the values.

It does not determine which rate should legally apply.

When You Should Not Infer the Rate

Do not rely on an implied-rate calculation when:

You need the legally correct rate
You know only the final total
The subtotal includes exempt products
Several tax rates apply
The receipt includes unexplained fees
The amount due includes payments or credits
Product taxability is uncertain
The transaction location or date is unknown

Use an official tax source when legal or filing accuracy is required.

Use the Calculator for Known Rates

Finding an implied rate is useful when you have both the subtotal and final total.

When you already know the applicable rate and need to separate a tax-inclusive amount, use the free Reverse Tax Calculator.

Enter the final total and rate to calculate:

The price before tax
The included tax amount
The tax multiplier
The reconstructed total

Final Takeaway

To find a tax rate backwards:

Subtract the subtotal from the final total.
Divide the tax amount by the taxable subtotal.
Multiply by 100, unless your spreadsheet cell is already percentage-formatted.
Apply the rate forward to verify the result.
Treat the answer as an implied rate, not automatic proof of the official rate.

Most importantly, do not divide by the final total, and do not attempt to identify a rate from the final total alone.

For more examples and help interpreting unusual percentages, read the complete Find Tax Rate From Total guide.