Payroll and sales tax liabilities that never clear in QuickBooks
When tax liabilities just sit there and never go away
You open a new QBO file, pull a Balance Sheet, and your eye goes straight to it: Sales Tax Payable sitting at $18,432… for as far back as the columns go.
The client swears, "But we pay our sales tax every month. My bank is reconciled."
Same story with payroll: Payroll Liabilities or Payroll Tax Payable has a chunky credit balance that never really moves. Meanwhile, you see regular payments to the IRS and state agencies… but the liability accounts don’t clear.
This is one of those cleanup problems that looks small at first and then turns into a compliance mess. The business might be:
- Accruing tax correctly but paying it out of random expense accounts, or
- Paying tax correctly but never accruing it, or
- Doing both, but with the wrong vendors and wrong GL accounts.
Your job in a cleanup is to figure out: Is tax actually unpaid, or just misposted? And can you prove it from the books, not just from "we think it’s fine"?
Where this problem hides inside QuickBooks Online
Start with a Balance Sheet in QBO for the last 12–24 months, columns by month. Focus on:
- Payroll tax liability accounts (Payroll Liabilities, Payroll Tax Payable, Federal/State Withholding Payable, etc.)
- Sales tax liability accounts (Sales Tax Payable, VAT Payable, state-specific sales tax accounts)
You’re looking for balances that don’t return to (or near) zero after each filing cycle.
Example:
- Each month, QBO records $1,000 of sales tax to Sales Tax Payable.
- The client pays $1,000 to the state every month.
- But those payments are coded to Miscellaneous Expense, not Sales Tax Payable.
- After six months, Sales Tax Payable shows a $6,000 credit balance that has persisted for six periods.
On the flip side, a clean file looks like this:
- $1,000 accrued to Sales Tax Payable.
- $1,000 payment coded directly against Sales Tax Payable.
- The account returns to zero after each filing cycle.
Beyond the Balance Sheet, you’ll usually see:
- Checks/expenses to IRS, state DOR, or sales tax agencies coded to generic expense or "Taxes & Licenses" instead of liability accounts.
- Payments posted to tax liability accounts with random vendors (payroll provider, landlord, office supplies) as the payee.
- QBO Payroll or Sales Tax center balances that don’t match the GL liability account at period end.
Key red flags:
- Liability accounts that never (or rarely) clear to zero over multiple filing cycles.
- Large, same-direction balances (always credit, never dipping near zero).
- Tax authority vendors used on non-liability accounts (e.g., IRS paid from "Misc Expense").
- Non-tax vendors used on tax liability accounts.
- QBO Payroll or Sales Tax reports that don’t tie to the Balance Sheet.
Run a Balance Sheet with monthly columns and quickly scan just the payroll and sales tax liability rows. Any line that doesn’t regularly dip back to zero deserves a deeper look.
What happens if you just live with it
Persistent tax liabilities and misposted payments are more than cosmetic. They distort the Balance Sheet and can hide real underpayments or overpayments.
The damage inside your numbers
When payroll and sales tax liabilities don’t clear properly:
- The Balance Sheet overstates liabilities, sometimes by years of accruals.
- The P&L may show tax expense twice: once when accrued, again when payments are coded to expense instead of the liability.
- Or the P&L may understate tax expense if the client only books payments and never accrues.
- You can’t reconcile QBO Payroll or the Sales Tax center to the GL, so you lose a key control.
This becomes a problem at:
- Tax prep time: You can’t easily support payroll tax or sales tax expense.
- Due diligence or lending: Persistent, unexplained tax balances look like unpaid obligations.
- Future cleanups: Another firm inherits the file and has to unwind years of confusion.
The damage in client conversations
If you ignore this, you end up in awkward territory:
- You can’t confidently answer, "Do I owe this $18k, or is it just bad coding?"
- You’re forced into "we think" instead of "here’s the reconciliation".
- If a notice shows up, you have no clean trail of what was actually paid vs. recorded.
Clients assume that if their books are "reconciled" and taxes are "paid", the Balance Sheet is telling the truth. When it’s not, trust erodes fast.
How to untangle sticky payroll and sales tax balances
In a cleanup, you don’t need to reconstruct every filing from day one. You do need a systematic way to decide: unpaid vs. misposted vs. immaterial.
Here’s a practical workflow:
-
Identify the tax liability accounts. From the Chart of Accounts, list every payroll and sales tax liability account. Include any custom "Other Current Liability" accounts that clearly hold tax.
-
Scan for persistent balances. Run a 12–24 month Balance Sheet with monthly columns. For each tax liability account, note:
- Current ending balance
- How many consecutive periods it’s stayed on the same side (credit/debit)
- Whether it ever returns near zero after a filing cycle
-
Pull tax authority payments. Run a Transaction Detail report for the same period. Filter to payees that are tax authorities (IRS, state DOR, sales tax agencies, etc.). Review:
- Payments coded to non-tax accounts (e.g., Misc Expense, Taxes & Licenses)
- Whether those amounts line up with expected filing amounts
-
Review transactions hitting tax liability accounts. Using the same report, filter by the tax liability accounts. Look for:
- Payments with non-tax vendors as payees
- Journal entries that move balances around without clearing them
-
Reconcile to modules where possible. If the client uses QBO Payroll or Sales Tax:
- Run Payroll Liability and Sales Tax Liability reports as of a specific date.
- Compare each module total to the corresponding GL liability account.
- Note any differences above your materiality threshold.
-
Decide on adjustments vs. reclassifications. Based on what you find:
- Reclass tax payments from expense to the liability account where appropriate.
- If the liability is clearly overstated and books are closed, consider a current-period adjustment with workpaper support.
- Document any true underpayments that need to be addressed outside QBO.
-
Document your logic. For each liability account, keep a short workpaper: opening balance, what you found, how you tied (or didn’t tie) to payroll/sales tax reports, and the entries you made.
Tools like CleanupOwl can run these checks up front: scanning liability accounts for balances that don’t clear, and flagging payments to tax authorities that never touch a tax liability account. That lets you start the engagement with a clear list of problem accounts and suspect transactions instead of hunting them down manually.
Turning this into a repeatable firm standard
This shouldn’t be a one-off hero move; it should be part of your standard diagnostic.
- Add a checklist item: "Review payroll and sales tax liabilities for persistent balances and misposted payments."
- Standardize your lookback (e.g., last 12–24 months or since prior CPA took over).
- Define firm thresholds: how many periods a balance can persist and what dollar amount is worth chasing.
- Decide when to adjust in the current year vs. reopening prior periods.
A diagnostic tool like CleanupOwl can hand you the list it used to take an hour to build by hand: which liability accounts have sticky balances, how long they’ve persisted, and which payments to or from tax authorities look misclassified.
Be explicit in your firm SOP about thresholds: e.g., investigate any tax liability that doesn’t clear for more than two filing cycles and has a balance over $500, but allow small carryforwards where the jurisdiction routinely rolls minor differences into the next period.
The patterns you’ll keep seeing in client files
| Situation | What you see in QBO | Risk if you shrug it off |
|---|---|---|
| Sales tax accrued, payments to expense | Sales Tax Payable grows every month; payments to state coded to Misc Expense or Taxes & Licenses | Overstated liabilities, double-counted tax expense, confusing Balance Sheet for lenders and buyers |
| Payroll tax payments coded to expense | Payroll Tax Payable has a large credit balance; IRS/state payments hit Payroll Tax Expense or generic expense accounts | Balance Sheet shows apparent unpaid payroll tax; hard to reconcile to payroll reports; potential overstatement of expense |
| Liability account used with non-tax vendors | Payments or JEs hitting Sales Tax Payable or Payroll Liabilities with random vendors (suppliers, landlords) | True tax balances are obscured; risk of using tax accounts as a "parking lot" for unrelated items |
| Module vs. GL out of sync | QBO Payroll or Sales Tax center shows one liability; GL account shows a very different number | You can’t rely on either number without a reconciliation; notices or audits become harder to defend |
| Old tax balances from closed years | Large, persistent tax liability that predates your engagement; no clear history | May represent real unpaid tax or just legacy misposting; needs a documented position and possibly a one-time adjustment |
Not every situation deserves the same level of effort. Some balances are clearly immaterial or intentionally carried forward (a few dollars of sales tax rounding, for example). Others are big enough that you can’t, in good conscience, sign off without a plan.
For smaller, stable balances that the jurisdiction routinely rolls forward, you might just document and monitor. For larger or growing balances, you’ll want to trace at least a sample of payments, reconcile to payroll or sales tax reports, and either cleanly adjust or clearly flag the issue for the client.
Be careful with prior-year balances that tie to filed tax returns. Don’t casually reclass or wipe them out. Coordinate with whoever prepared the returns, and if you adjust in the current year instead of reopening history, document your rationale and keep a clear audit trail.
Making this part of your cleanup playbook
Payroll and sales tax liabilities that never clear are one of those quiet problems that separate a surface-level cleanup from a professional one. When your firm has a standard way to spot persistent balances, misposted tax payments, and module-to-GL mismatches, you protect both the client and your own reputation.
This deserves its own line item on every diagnostic review. Whether you run the checks manually or let a tool like CleanupOwl flag the suspect accounts and transactions first, the key is consistency: same reports, same thresholds, same documentation every time.
If you’re a business owner reading this, this is a good question for your accountant: "Can you show me how my payroll and sales tax liabilities clear out each filing cycle in QuickBooks?" If they can’t walk you through that on-screen, it’s worth a deeper look.
Ready to run deeper QuickBooks diagnostics?
Use CleanupOwl to automatically flag issues like this before you quote or start your next cleanup project.
Start Free Trial