Back-Calculation Guide: Finding Original Price from Final Paid Total and Tax Amount
How Do I Calculate the Original Price Before Tax from a Total Amount?
If you only have a receipt showing $107.50 paid and a 7.5% sales tax rate, how do you figure out what the item actually cost before tax?
This is the exact scenario that lands on my desk every month. I reconcile expenses for a small consulting firm. Vendors hand me crumpled receipts. Some list the pre-tax subtotal clearly. Others—especially from travel, fuel stations, and certain online platforms—only show the final paid total and the tax rate applied. The subtotal line is either missing, smudged, or buried in fine print.
That's when back-calculation becomes essential. You're working backward from the number you have (what was charged to the card) to the number you need (the actual cost of the good or service for bookkeeping). And if you're using a percentage calculator to speed things up, knowing the underlying formula ensures you're entering the right inputs—not just trusting the tool blindly.
Let me walk through the exact workflow I use, end to end, so you can replicate it whether you're reconciling five receipts or five hundred.
What Formula Back-Calculates Pre-Tax Price from Final Paid Total?
The formula is simpler than most people expect. Here it is:
Original Price = Final Paid Total ÷ (1 + Tax Rate)
One division. That's the entire operation.
Breaking Down the Components
Three inputs. Nothing more.
Final Paid Total — The full amount charged. This is what hit your bank account or credit card. On a receipt, it's usually labeled "Total," "Amount Due," or "Charged."
Tax Rate — Expressed as a decimal. A 7.5% tax rate becomes 0.075. An 8.25% rate becomes 0.0825.
(1 + Tax Rate) — This is the multiplier that was applied to the original price to arrive at the final total. Dividing the final total by this multiplier reverses the process.
A Concrete Example
Let's say you have a receipt from a hardware store. The total paid is $107.50. The local sales tax rate is 7.5%. You need the original price for your expense report.
Step 1: Convert the tax rate to a decimal → 0.075
Step 2: Add 1 → 1.075
Step 3: Divide the final total by this number → $107.50 ÷ 1.075 = $100.00
The original price was $100.00. The tax was $7.50. The total was $107.50.
You can verify this by going forward: $100.00 × 1.075 = $107.50. The math checks out.
This is the pattern I run on every receipt where the subtotal is missing. Once you've done it a dozen times, the three steps become automatic.
How Do I Handle Different Tax Rates When Reverse-Calculating?
Not every receipt involves a single, clean tax rate. Real-world receipts get messy fast. Here's how I handle the common variations.
Single Tax Rate (Most Common)
This is the scenario above. One tax rate, one total. Use the standard formula:
Original Price = Total ÷ (1 + Tax Rate)
Most retail receipts, restaurant bills, and online purchases fall here. If the receipt lists the tax amount but not the rate, you can derive the rate first:
Tax Rate = Tax Amount ÷ (Total − Tax Amount)
Then plug that rate into the back-calculation formula. Though honestly, if you already have the tax amount, just subtract it directly:
Original Price = Total − Tax Amount
No percentage math needed. Save yourself the step.
Compound Tax Rates (Canada, Some US Cities)
Some regions stack taxes. Quebec, for example, applies 5% GST and 9.975% QST. British Columbia applies 5% GST and 7% PST. Certain US cities layer a state tax, county tax, and city tax.
When taxes are compounded—meaning each successive tax is calculated on the running total—the back-calculation changes slightly:
Original Price = Total ÷ (1 + Tax Rate 1) ÷ (1 + Tax Rate 2) ÷ (1 + Tax Rate 3)...
Each tax layer gets its own divisor, applied sequentially.
Example: A receipt from Montreal shows $129.90 total paid. Quebec applies 5% GST and 9.975% QST, compounded.
Step 1: Divisor for GST → 1.05
Step 2: Divisor for QST → 1.09975
Step 3: $129.90 ÷ 1.05 ÷ 1.09975 = $112.50
Original price: $112.50. GST: $5.63. QST: $11.77. Total: $129.90.
When the Receipt Lists Multiple Tax Amounts Separately
If the receipt shows the tax amounts broken out (e.g., "State Tax: $4.50, County Tax: $2.25") but not the subtotal, simply subtract all tax amounts from the total:
Original Price = Total − (Tax Amount 1 + Tax Amount 2 + Tax Amount 3)
This is the easiest path. No rate conversion, no compounding concerns. Just subtraction.
What Tools Help Me Verify My Back-Calculation Is Correct?
I never trust a single calculation pass. Receipt reconciliation is too important to get wrong, and errors compound when you're processing dozens of entries.
The Forward-Check Method
After back-calculating the original price, run the math forward:
Calculated Original Price × (1 + Tax Rate) = Should Equal Final Paid Total
If it doesn't match to the cent, something's wrong. Either the tax rate you assumed is incorrect, the total was misread from a smudged receipt, or there's a rounding issue.
This forward-check is built into most percentage calculators. Enter your back-calculated original price, apply the tax rate, and confirm the output matches your receipt total. If the tool gives you $107.51 instead of $107.50, you're dealing with a rounding artifact—close enough, but worth noting.
Cross-Referencing with a Percentage Calculator
A percentage calculator speeds up the workflow when you're batch-processing receipts. Instead of doing manual division for each entry, you can:
1. Enter the final total as the base value 2. Enter the tax rate as the percentage 3. Use the "reverse percentage" or "find original value" function
Most modern percentage calculators have this built in. The key is understanding what the tool is doing under the hood—dividing by (1 + rate)—so you can spot when a tool is configured incorrectly or when you've entered inputs in the wrong order.
I've seen calculators that ask for "percentage to remove" rather than "tax rate." In that case, entering 7.5% as the percentage to remove from $107.50 would give you $99.44, not $100.00. That's wrong. The tool is subtracting 7.5% of the final total, not reversing a 7.5% tax markup. Know the difference.
How Do I Build a Repeatable Workflow for Receipt Reconciliation?
Here's the exact checklist I follow for every batch of receipts. It keeps the process fast, consistent, and auditable.
Step 1: Sort Receipts by Tax Structure
Group them into four buckets:
- Receipts with clear subtotals (no back-calculation needed) - Receipts with tax amount shown but no subtotal (simple subtraction) - Receipts with only total and tax rate (full back-calculation) - Receipts with compound taxes (sequential division)
This sorting pass takes roughly 30 seconds per receipt and saves significant time downstream because you apply the right method immediately.
Step 2: Extract and Record Key Data Points
For each receipt, capture:
- Vendor name - Date - Final paid total (the number that hit your card) - Tax rate(s) or tax amount(s) - Payment method
Enter these into a spreadsheet. One row per receipt. This becomes your working document for the entire batch.
Step 3: Apply the Correct Back-Calculation Method
Based on your sorting from Step 1:
- No subtotal needed? Skip to Step 4. - Tax amount shown? Subtract directly. - Only total and rate? Use Original Price = Total ÷ (1 + Rate). - Compound taxes? Divide sequentially by each (1 + Rate).
Step 4: Forward-Check Every Entry
Take your calculated original price. Multiply by (1 + Tax Rate). Confirm it matches the final paid total. If it doesn't, flag the entry for manual review. Don't let a mismatched entry pass through—track it down before it corrupts your expense report.
Step 5: Log and Categorize
Record the original price, tax amount, and total in your accounting system. Categorize by expense type. Attach the receipt image. Move to the next entry.
This five-step workflow processes roughly 20-30 receipts per hour once you're fluent with the formulas. The back-calculation itself—the part that seems intimidating at first—becomes a 10-second operation per receipt.
The key insight is this: back-calculation isn't about complex math. It's about knowing which of three methods to apply (subtraction, single-rate division, or compound division) and then verifying the result with a forward-check. Master those three paths, and no receipt will stump you—regardless of how the vendor chose to print it.