In QuickBooks, sales tax collected is the gross tax you charged customers during a period, while sales tax payable is the current liability balance you still owe the taxing authority. The two numbers start identical on every taxable sale and then drift apart as payments, credit memos, vendor discounts, and adjustments work through the account. If your QuickBooks sales tax payable and tax collected figures don’t match, that gap is almost always real and usually explainable in a few minutes.
What Each Number Represents
Sales tax collected describes what happened during transactions. If you sold $50,000 of taxable goods at 7%, you collected $3,500 from customers. That cash sat in your bank account, but it was never revenue. You held it as an agent of the state, and it never touches your profit and loss statement.
Sales tax payable is the current liability account on your balance sheet. It keeps a running score of what you owe right now. It climbs with every taxable sale, drops with every remittance, and moves up or down with any adjustment you post. QuickBooks runs both concepts through the same liability account, which is why the Sales Tax Liability Report can display them side by side and sometimes show the same figure.
They match only in a period where nothing has reduced the balance yet. Once you’ve made a payment, issued a refund, or booked a discount, the payable figure is lower than the collected figure, and the payable number is the one that reflects your actual obligation.
Why the Two Figures Drift Apart
Four things typically open the gap.
Payments already remitted. Every time you use the Pay Sales Tax function, QuickBooks debits Sales Tax Payable and credits your checking account. The collected figure for the period doesn’t change, but the payable balance drops by whatever you sent. If you’re looking at a year-to-date view after making monthly payments, collected will be far larger than payable by design.
Credit memos and refunds. When a customer returns a taxable item, issuing a credit memo automatically reduces the Sales Tax Payable balance. The credit memo debits payable and credits accounts receivable, unwinding the original tax entry. Collected on the gross report may or may not net the refund out depending on how you’re reading it, and that alone can account for a mismatch.
Collection allowances. Roughly half the states let you keep a small percentage of what you collect as compensation for handling the tax. These vendor discounts commonly run from 0.25% to 5%, sometimes with caps or tiered rates. If you collected $3,500 and your state grants a 2% discount, your actual liability is $3,430 and you keep $70 as income. Booked as a sales tax adjustment, the discount reduces payable while leaving collected untouched. This is the single most common reason the two figures disagree at filing time.
Other adjustments. Rounding corrections, audit adjustments, and exemption certificates received after a sale was initially taxed all post as sales tax adjustments.1QuickBooks. Process Sales Tax Adjustment Each one changes payable without changing what you originally collected. When your Sales Tax Liability Report shows a number you didn’t expect, the adjustment column is usually where the difference lives.
How Cash vs. Accrual Shifts the Numbers
Reporting basis can make a matched set of books look mismatched. Under accrual, QuickBooks records the full sales tax liability the moment you create the invoice, whether or not the customer has paid.2Internal Revenue Service. Publication 538 – Accounting Periods and Methods Under cash basis, the payable balance only moves when payment actually arrives. Invoice a customer $1,060 in August and collect in September, and accrual books the $60 of tax in August while cash basis splits it based on when the money lands.3QuickBooks. How Cash and Accrual Accounting Affect Tax
In QuickBooks Desktop, the setting lives under Sales Tax Preferences, in the “When do you owe sales tax?” option. “As of invoice date” is accrual; “Upon receipt of payment” is cash. If your Sales Tax Liability Report is running on a different basis than the one you file on, collected and payable will look wrong even when the underlying data is clean.4QuickBooks. Reconciling Sales Tax Payable Check this setting first when something looks off.
How to Reconcile the Two in QuickBooks
Run the Sales Tax Liability Report for the period you’re filing. Confirm the report’s “through” date matches the date in the Pay Sales Tax window, and that the report basis matches your Sales Tax Preference. A mismatch between those two settings is the most common reason the report total and the payment window disagree.
Then compare the report against 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, look for transactions that bypassed the proper workflow:
- Journal entries posted directly to the liability account.
- Checks written to a tax agency without using the Pay Sales Tax function.
- Invoices where tax was manually overridden.
Each of these creates a discrepancy that won’t resolve itself and will carry forward into every future period until you fix it.
Which Number to Remit
You pay the payable figure, not the collected figure. If a vendor discount applies, record the sales tax adjustment first so the remittance reflects what you actually owe, with the discount posted to an income account. Then use the Pay Sales Tax function to send the money.
Never write a regular check to the tax agency. A standard check reduces your bank balance but leaves Sales Tax Payable untouched, so the liability report keeps showing the amount as owed even after the money is gone. The Pay Sales Tax function debits the liability properly and ties the payment to the right agency and filing period. After it posts, the payable balance for that period should be zero.
What Happens If You Treat Collected as Payable
The money you collected from customers is held in trust for the taxing authority. It is not revenue, and spending it as if it were is one of the fastest ways to create personal legal exposure. Most states treat unremitted sales tax as a trust fund obligation, which means the liability can pierce the business entity and attach to owners, officers, or managers individually.
Late-filing penalties commonly run from 5% to 25% of the tax due, often climbing the longer you wait, with interest accruing on top from the original due date. Repeated failure to remit can cost you your sales tax permit, which ends your ability to make taxable sales at all.
Honest bookkeeping mistakes cause their own version of this problem. 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. That phantom balance inflates your apparent obligation period after period, and cleaning it up usually requires adjusting journal entries and sometimes rebuilding the sales tax data. Using the correct workflow the first time is far less work than unwinding it later.