Sales Tax Reconciliation Calculator

Enter your gross tax-inclusive sales and the rate you charged to split the total into net revenue and the sales tax liability you owe — built for month-end close and bookkeeping.

✓ Gross → Net + Tax Split✓ Any Rate✓ Free — No Signup

Total receipts (tax-inclusive)

Tax rate

Combined state + average local rate, 2026 data.

Reporting period

Number of transactions (optional)

Worked example. $32,100 in monthly receipts at 7% tax → $30,000 revenue, $2,100 tax collected, $25,200 annualized tax liability.

For informational purposes only. Tax rates change frequently — verify with your state's Department of Revenue before filing. This tool is not a substitute for professional tax advice.

Last updated: September 11, 2026 · Rate source metadata is tracked in the TaxesLedger tax data registry.

Data methodology reviewed by M. Imtinan Farooq — Data Engineer who builds and maintains TaxesLedger.

Imtinan Farooq is a data engineer who builds and maintains TaxesLedger's calculators and rate database. He is not a CPA, tax attorney, or enrolled agent, so the site doesn't rely on his opinion. Every rate is linked to an official source, such as a state department of revenue, the Canada Revenue Agency, or a national VAT authority. Each record stores that source and its verification status, so the rate can be checked against it. If you spot an error, contact us and we'll correct it. This is an educational calculator, not tax, accounting, or legal advice. LinkedIn

Data Sources: State DORs · Canada Revenue Agency · EU VAT authorities · Tax Foundation references

What This Calculator Does

Enter the gross, tax-inclusive receipts for a period and the sales tax rate you charged. The calculator divides the total by one plus the rate to find the revenue that is actually yours, and the difference is the sales tax you collected and owe the state. If you add a transaction count, it also shows the average ticket net of tax.

The annualized figure is simply the period's tax multiplied out to twelve months. It is a planning number for cash flow, not a filing figure, and it assumes every month looks like this one.

Combined rates vary by state and by locality within a state. If you charged more than one rate in the period, run the calculator once per rate; the sales tax map lists every state's combined rate.

When You Would Use It

Marketplace and platform payouts. Shopify, Amazon and similar payouts are often net of fees but gross of the sales tax you collected. Backing the tax out at the end of each payout cycle keeps the revenue you book in the general ledger free of the tax you owe.
Point-of-sale totals. Older registers and simple POS exports give a single tax-inclusive total for the day. Splitting it here gives you the revenue and tax lines for the daily close.
Sales made before you registered. If you discover you had nexus in a state before you started collecting, the tax owed on past sales is embedded in your totals. This gives a first estimate; a voluntary disclosure filing will need transaction-level records behind it.
All-in quotes. When a customer agrees an "all-in" price, the tax portion still has to be remitted. Splitting the quote shows the revenue you will actually keep.

Using It With Excel and Your Accounting Software

Spreadsheets. The formula is Net = Gross / (1 + Rate). Check it against this calculator on a few rows, then apply it down the column.
QuickBooks and Xero. Before posting month-end figures, compare the Sales Tax Payable balance in your software with the tax figure here for the same gross and rate. A gap of more than a few cents usually means a tax code is set up wrong or some sales were taxed at a different rate.
Keeping a record. Save or print the result and file it with the journal entry it supports, along with the POS report or payout statement it came from. Those source documents are what an auditor asks for.

Why the Split Matters

Sales tax collected from customers is not revenue; under US GAAP it is excluded from the transaction price and sits on the balance sheet as a liability until you remit it. Booking tax-inclusive totals as revenue overstates income and understates what you owe the state, and both errors carry through to your income tax return and your sales tax filing. Splitting the two every period keeps both figures right. How to book the entries for your business is a question for your accountant.

Frequently asked questions

Quick answers to the most common questions users ask.

What is sales tax reconciliation?

Checking that the sales tax you collected over a period matches what your books say and what you remit on the return. The starting point is splitting gross receipts into revenue and tax, which is what this calculator does.

How often should I reconcile?

Every filing period at a minimum, and monthly if you file quarterly or annually. Small differences are much easier to trace while the payout statements and POS reports are recent.

My POS total and my bank deposits do not match. Which one do I use?

Reconcile against the POS or platform report, because that is what records the tax charged. Bank deposits are net of processing fees, chargebacks and timing differences, so they will not equal gross sales. Explain the gap between the two separately.

I charged different rates in the same month. Can I still use this?

Yes, but run it once per rate with the gross for that rate. Dividing a mixed total by one blended rate gives the wrong tax figure, because the rate applies to each sale's base price, not to the combined total.

What does the annualized liability mean?

It is this period's tax multiplied out to twelve months. It is a cash-flow planning figure and assumes every month looks like this one; it is not a filing amount.

Is this enough to prepare my sales tax return?

No. A return needs sales by jurisdiction, exempt sales, and any local rates you collected. This calculator gives you the revenue and tax split for one rate; your filing software or accountant builds the return from the detail.

🏛️ IRS Official📊 Tax Foundation

Official Sources & Citations

All rates, thresholds, and regulatory guidance cited on this page are sourced from official government publications and non-partisan research institutions.

Federal & National Sources

The official Internal Revenue Service tool for determining deductible state and local sales tax for federal income tax purposes.

irs.gov

Official government repository for quarterly state and local tax revenue statistics and government finance data.

census.gov

The official government opinion for South Dakota v. Wayfair, Inc., establishing modern economic nexus standards for remote sellers.

supremecourt.gov

Official Small Business Administration guidance on understanding federal and state tax obligations for small business owners.

sba.gov

The official inter-governmental organization facilitating the simplification of sales tax administration across 24 member states.

streamlinedsalestax.org

Professional & Industry Organizations

Professional accounting standards and resources for sales tax compliance, risk management, and audit defense.

aicpa.org

Intergovernmental agency facilitating state tax uniformity, nexus guidelines, and model tax statutes.

mtc.gov

TaxesLedger is an independent educational tool. We are not affiliated with any government agency. Rate records include source metadata and verification status; always confirm with the tax authority for your jurisdiction before filing. Last registry update: September 11, 2026.

More free tax tools to help with calculations, compliance, and business tax planning.

Business