Your sales tax liability report doesn’t match what you filed

This is one of the most-asked questions in the QuickBooks community, and one of the worst-answered. Intuit's own help content on it ends by suggesting you contact Customer Care. That is an admission, not an answer.

The gap is almost always explainable. Work through these in order, because the first three are settings and the last three are real.

First rule out the three that aren't really problems

1. Accounting basis mismatch

Sales tax on a cash basis follows the payment. On accrual it follows the invoice. Invoice in March, get paid in April, and the two bases put that tax in different months — legitimately.

The mismatch appears when the report is run on one basis and the return was filed on the other. Set the report to the basis your state actually requires, not the basis your P&L happens to default to. If you don't know which your state requires, that is the question to answer before anything else, because everything downstream depends on it.

2. Date range

The "to" date on the Sales Tax Liability report has to match the "show sales tax due through" date in the pay-sales-tax window. These default independently and are very easily a day or a month apart.

3. Credit memos and refunds

A credit reduces taxable sales in the period the credit is dated, not the period the original sale sat in. A refund issued in April against a March sale moves tax between periods. A March return filed before that refund existed will differ from a report run today, and both were right when they were produced.

If the discrepancy clusters around refund activity, it is timing. Document it and move on.

Now the two things the report silently leaves out

This is the part that isn't in most guides, and it is why people reconcile the same report for hours getting nowhere.

The Sales Tax Liability report does not pull from invoices or sales receipts that contain no taxable line item at all. Not "it shows them as non-taxable" — it does not include them.

So:

• A customer who is entirely exempt, invoiced only for exempt items, can be absent from the report's total sales.
• A wholly non-taxable product line likewise.

Those sales are in your income. They are not in that report's total sales. Comparing the two and expecting them to match will never work, and no amount of re-running the report will change it. Once you know this, the reconciliation becomes: P&L income, minus wholly non-taxable sales, minus timing differences, should approach the report's total sales.

The second omission is subtler. Non-inventory item sales and certain transaction types behave inconsistently between the report and the P&L. If your file uses a mix of item types, expect a residual difference and identify it rather than chase it to zero.

Then the causes that are real

4. Tax charged at a rate that doesn't match the jurisdiction

If sales tax is configured as one blended rate across customers in different jurisdictions, then what you collected and what you owed were never the same number. The report is accurately reporting a collection that was wrong.

This is common in states where local rates vary a lot — and it is not a reporting problem, it is a configuration problem with a real cash consequence, because under-collected tax comes out of your margin rather than the customer's pocket.

5. Adjustments posted straight to the liability account

Somebody made the sales tax payable account agree with something by journal entry. The account now balances and no longer reflects returns filed. Look for entries hitting the liability account that aren't sales tax payments or accruals.

6. Periods filed short, or not filed

The plainest cause and the one people avoid looking at. If the liability account carries a balance that cannot be traced to a specific unfiled or underpaid period, that needs resolving before the next return, not after.

The reconciliation that actually settles it

Rather than comparing two reports and hoping, build the bridge explicitly:

1. Set both reports to the same basis and the same dates.
2. Take total income from the P&L.
3. Subtract sales with no taxable line item at all.
4. Subtract or add credit memos dated in the period.
5. Compare to total sales on the Sales Tax Liability report.
6. Compare tax collected on the report to tax remitted per your returns.

Steps 1–5 explain report-to-report differences. Step 6 is the one that matters, because that is where a real liability lives. A gap at step 6 is money you either owe or over-paid.

When this stops being a DIY job

Settle it yourself when the difference resolves at steps 1–4. Those are settings and timing, and once you have seen them you will recognise them again.

Get help when:

• Step 6 doesn't reconcile — collected and remitted genuinely differ, and you cannot attribute the gap to specific periods.
• You find journal entries posted directly to the sales tax liability account that nobody can explain.
• You have been charging one blended rate across multiple jurisdictions, which means the exposure is in the returns already filed, not just the report.
• You have crossed an economic nexus threshold in another state and were not collecting there.

Those are sales tax compliance engagements: configuring the file correctly, reconciling collected against recorded, and producing figures that can be filed from. Where the liability account has years of unexplained balance behind it, the honest scope is a cleanup first — you cannot reconcile a sub-ledger on top of a file that doesn't tie out.

TechBrot does not file sales tax returns. We configure, reconcile and hand your CPA or filing service numbers they can rely on. Where the answer is "your setup is fine, this is a date range," we will tell you that and there is no engagement.