A sales tax reconciliation ties three records together for each filing period: the tax shown on the return, the balance in the sales tax payable account, and the sales recorded in the ledger. The tax filed should match the tax collected, and the taxable sales on the return should trace to revenue after exempt sales are removed.
Sales tax returns against the sales tax payable account
The sales tax payable account holds tax collected from customers that has not yet been paid to the state. At the end of each filing period, its balance should equal the tax due on the return for that period, plus any earlier returns filed but not yet paid. Any other balance is a difference to explain.
The cleanest way to see this is a rollforward of the liability account for the period:
- Opening balance, which should be the tax due on the previous return.
- Add tax charged on invoices and sales receipts during the period.
- Less payments made to the state.
- Less any filing discount or credit taken on the payment.
- Closing balance, which should equal the tax on the return now being filed.
Filing discounts
Some states let sellers keep a small share of the tax when they file and pay on time. The Texas Comptroller's sales tax reporting FAQ, for example, describes a 0.5 percent timely filing discount, plus a separate prepayment discount. The discount is a reconciling item: the payment is less than the tax collected, and the remainder has to leave the liability account, usually to other income. If nobody books it, a small balance builds up every period and never clears.
Every state sets its own rules, so check the tax agency's own pages for each state where you file rather than assuming they match.
Tying taxable sales on the return to revenue in the ledger
Taxable sales on the return should trace to the revenue accounts in the ledger, after removing sales that are exempt, sold for resale, shipped out of state or otherwise not taxable. The tie-out starts from total revenue, subtracts each nontaxable category with support, and arrives at the taxable figure on the return.
Here is a worked example for March with example values. The example rate is 8.25 percent.
| Line | Ledger | Return | Difference |
|---|---|---|---|
| Total sales | 100,000.00 | 100,000.00 | 0.00 |
| Less exempt sales, with certificates | (16,000.00) | (16,000.00) | 0.00 |
| Taxable sales | 84,000.00 | 84,000.00 | 0.00 |
| Tax at example rate of 8.25% | 6,930.00 | 6,930.00 | 0.00 |
| Tax charged to customers (liability account credits) | 6,955.00 | 25.00 |
The return and the ledger agree on sales, but customers were charged 25.00 more tax than the return reports. The invoice detail shows one sale of 303.03 that was coded exempt for the return, while the invoice still added tax. The customer paid tax on an exempt sale. That 25.00 cannot be kept as income. Refund it to the customer, or report and pay it to the state, depending on the state's rules.
Reporting periods
Taxable sales must cover the same dates as the return. Filing schedules differ by state and by seller: the Texas Comptroller's sales and use tax page says sellers are told whether they file monthly or quarterly, with reports due on the 20th of the month after the period, and some file yearly. A quarterly filer should reconcile three months of ledger sales to one return.
Exempt sales and missing exemption certificates
An exempt sale is a sale on which no tax is due, usually because the buyer resells the goods, is a qualifying organization, or the item is exempt. In a sales tax reconciliation, each exempt sale needs support, typically an exemption or resale certificate. Without it, the sale is a taxable sale the business failed to tax.
Run the exempt sales list against the certificate file each period:
- Certificate on file and current. Accept the exemption.
- Certificate missing. Request it from the customer now. Until it arrives, treat the sale as an open exposure and note the tax that would be due.
- Certificate expired or for a different entity. Treat it as missing.
- Item-based exemption. Confirm the item code in the sales system maps to the exempt category for that state.
Exempt sales deserve this attention because a missing certificate costs the business directly: the tax was never collected, and it is hard to recover from a customer months later. Keeping the list and the certificates side by side in the workpaper makes the gap visible before an auditor finds it.
Which timing gaps show up in a sales tax reconciliation?
Timing gaps in a sales tax reconciliation come from tax recorded in one period and reported or paid in another. The common ones are payments made after the period ends, refunds and credit memos dated after the original sale, and returns prepared on a cash basis when the ledger is on accrual.
- Payment after period end. The return for March is paid in April, so at March 31 the liability includes the full March tax. That is not a difference; it is the expected balance.
- Credit memos. A refund issued in April for a March sale is often deducted on the April return, depending on the state's rules. The March reconciliation still shows the original tax.
- Cash versus accrual reporting. If the state lets you report on collections and your books record tax when invoiced, unpaid invoices create a gap between the ledger and the return. List unpaid invoices with tax as the reconciling item.
- Bad debts. Some states allow a deduction for tax on invoices written off. Check the state's rules before taking it.
Unexplained differences
Some differences have no obvious cause. Before parking one in a holding account, remember that a parked difference rarely resolves itself. The suspense account reconciliation and clearing old items explains why a suspense balance tends to become permanent and how to age and clear it.
Filed-but-unpaid sales tax left in the liability
Filed-but-unpaid sales tax is tax reported on a return that was submitted while the payment never reached the state. The liability stays on the books, which is correct, but the reconciliation should flag it. A sales tax balance that grows by one full period's tax usually means a payment failed, was rejected or was never initiated.
The liability rollforward shows it plainly: the opening balance from the last return was not reduced by a payment. Check the bank statement for the debit. If there is none, the state is owed the tax plus whatever penalty and interest its rules impose.
A second case runs the other way. A payment leaves the bank, but nobody books it, so the liability looks unpaid when it is not. The bank statement is the deciding evidence. Matching tax payments on the statement to the ledger tells you which of the two cases you face, and the step-by-step bank reconciliation in QuickBooks Online shows where an unrecorded payment appears as an unmatched line.
What if sales tax collected and sales tax filed disagree?
When sales tax collected and sales tax filed disagree, the gap usually has one of four causes: a wrong rate on some invoices, a filing discount not booked, rounding between line-level and invoice-level tax, or tax charged on sales the return treats as exempt. Each needs a different fix, so identify the cause before booking anything.
| Cause | What you see | Fix |
|---|---|---|
| Wrong rate on invoices | Collected tax differs from taxable sales times the rate | Correct the rate in the sales system and assess the affected invoices |
| Filing discount not booked | Small balance left after each payment | Move the discount to income each period |
| Rounding | Differences of a few cents per period | Accept below a written threshold, and keep the method consistent |
| Over-collection | Collected exceeds the return, traced to specific invoices | Refund customers or remit to the state |
Under-collection is the more costly case: the return shows more tax due than customers paid, and the business pays the difference from its own funds. Track it by invoice so the rate or item setting that caused it gets corrected.
Multi-state sellers
A business that files in several states needs one reconciliation per state, because each return covers only the sales sourced to that state. Split the liability account by state, or keep a subledger that does, so each balance can be tied to its own return. A single combined liability account hides an overpayment in one state behind an underpayment in another, and neither shows until a notice arrives.
A difference left from an earlier year belongs to that year's results. Correcting it after the books are closed may affect equity, as described in the retained earnings reconciliation from year to year. The general approach to tying an account to outside evidence, and the difference between that and checking a rollforward, is covered in account reconciliation meaning.
Payments to the state and refunds to customers both pass through the bank. PreciseBankFlow checks that each statement foots and lists the lines that do not match your ledger, so a missing tax payment stands out before the next return is due. It is in early access, and the filing decisions stay with you.