In QuickBooks, sales tax collected and sales tax payable start at the same number and drift apart from there. Collected is the gross tax you charged customers during a period. Payable is the current liability balance still sitting on your books after you subtract payments already remitted, credit memos, adjustments, and any collection allowance your state grants. Payable is what you owe right now; collected is what came in the door.
What Each Figure Represents
Sales tax collected is a description of activity. If you sold $50,000 of taxable goods at 7%, you collected $3,500. That money hit your bank account but was never yours: you held it as an agent of the taxing jurisdiction, and it never touches your profit and loss statement.
Sales tax payable is an account, specifically the current liability on your balance sheet that tracks your running obligation. It opens each period at the same figure as collected, then moves as you remit payments, issue refunds, book adjustments, or claim a timely-filing discount. QuickBooks uses a single liability account for both purposes, which is why the Sales Tax Liability Report can display both figures and they sometimes look identical. They only match in a period with no payments, no returns, no adjustments, and no vendor discount. That period is rare.
Why the Two Numbers Diverge
Four things move payable away from collected. Understanding which one is at work in your file usually solves the mystery.
Payments Already Remitted
Every time you use the Pay Sales Tax function, QuickBooks debits Sales Tax Payable and credits your checking account. The liability goes down; the record of what you collected does not. If you remitted last month’s tax on the 20th and pull a report on the 25th, collected still reflects the full month while payable reflects the balance after that payment cleared. Same account, two different questions being answered.
Collection Allowances
About half the states offer a collection allowance, sometimes called a vendor discount, as compensation for collecting and remitting on the state’s behalf. Rates typically run from 0.25% to 5% of tax collected, with caps and tiered structures varying by state. When an allowance applies, you owe less than you collected and keep the difference as income.
On $3,500 collected with a 2% allowance, your liability drops to $3,430 and $70 becomes business income. In QuickBooks this posts as a sales tax adjustment that reduces the payable balance, with the offset going to an income account. This is the single most common reason the two figures separate at filing time.
Refunds, Credit Memos, and Other Adjustments
When a customer returns a taxable item, the tax on that original sale has to come back out. A credit memo in QuickBooks automatically reduces Sales Tax Payable, debiting the liability and crediting Accounts Receivable.1QuickBooks. Process Sales Tax Adjustment Rounding corrections, audit adjustments, and exemption certificates received after a sale was initially taxed do the same thing. Each opens a gap between the gross figure you collected and the net figure you owe. If the Sales Tax Liability Report surprises you, check the adjustment column first.
Journal Entries and Manual Overrides
The fourth cause is bookkeeping that bypassed the proper workflow. A journal entry posted directly to the liability account, a regular check written to a tax agency instead of using Pay Sales Tax, or an invoice where the tax was manually overridden will all push payable away from collected without a clean trail. These are errors, not features, but they show up regularly in files that don’t reconcile.
Cash Basis vs. Accrual Basis Can Also Move the Numbers
Timing choice is a second reason a report may look off even when nothing is wrong. Under accrual accounting, QuickBooks records the full sales tax liability the moment you create the invoice, regardless of when the customer pays. Under the accrual method, you report income in the year it’s earned and expenses when incurred, not when cash changes hands.2Internal Revenue Service. Publication 538 – Accounting Periods and Methods
Cash basis works differently. The payable balance only rises when the customer actually pays. Invoice $1,060 in August, collect it in September, and accrual shows the full $60 liability in August while cash basis puts nothing there until the money arrives.3QuickBooks. How Cash and Accrual Accounting Affect Tax Split the payment $424 in August and $636 in September and cash-basis liability is $24 the first month and $36 the second.
QuickBooks Desktop sets the basis in Sales Tax Preferences under “When do you owe sales tax?” — “As of invoice date” is accrual, “Upon receipt of payment” is cash.4QuickBooks. Reconciling Sales Tax Payable If your report basis doesn’t match how you actually file with the state, the collected and payable figures will disagree in ways that have nothing to do with any real error in your data.
Reconciling the Two Figures
Before you file, run the Sales Tax Liability Report and confirm two settings. First, the report’s “through” date has to match the date in the Pay Sales Tax window. Second, the report basis has to match your Sales Tax Preference. A mismatch on either point is the usual reason the report total and the payment window disagree.4QuickBooks. Reconciling Sales Tax Payable
Next, compare the report to your balance sheet. The Sales Tax Payable line on the balance sheet should equal the total from the liability report for the same period. If it doesn’t, hunt for transactions that skipped the proper sales tax workflow: journal entries posted directly to the liability account, checks written to a tax agency without using Pay Sales Tax, or invoices with manually overridden tax. Each one is a discrepancy that will not resolve on its own.
When you do remit, use the Pay Sales Tax function rather than writing an ordinary check. A regular check reduces your bank balance but doesn’t properly clear the liability for that filing period, and the report will keep showing the amount as still owed. If you’re claiming a collection allowance, book the adjustment before you cut the payment so the remittance amount reflects what you actually owe. After the payment posts, the payable balance for that filing period should be zero.
Why the Distinction Matters Beyond Bookkeeping
Sales tax collected from customers is legally held in trust for the taxing authority. It is not business revenue, and treating it that way creates exposure that can reach past the business entity. Most states treat unremitted sales tax as a trust fund obligation, meaning the liability can attach personally to owners, officers, or managers.
Late filing penalties vary by state, commonly running from 5% to 25% of the tax due and increasing the longer you wait. Some states impose a flat minimum penalty regardless of the amount owed, and interest accrues from the original due date on top of penalties. Repeated failure to remit can result in revocation of your sales tax permit in states with aggressive enforcement.
Honest QuickBooks mistakes cause their own problems. Record a sales tax payment as a regular check instead of through Pay Sales Tax and the liability report will keep showing the amount as owed even though the money already left your account. That phantom balance carries into future periods, inflates your apparent obligation, and makes every subsequent reconciliation harder. Fixing it usually takes adjusting journal entries and occasionally a rebuild of the sales tax data. Using the correct workflow the first time is far less work.