Quick answer
A QuickBooks payroll liability balance is wrong when the Payroll Liability Balances report does not match what you still owe the IRS or your state. The usual causes are a payroll item pointed at the wrong account, a payment recorded as a regular check, a voided paycheck or liability check, or a payment made on an agency website that was never entered in QuickBooks. Reconcile first, then correct.
What a wrong payroll liability balance means
The Payroll Liability Balances report shows what QuickBooks Desktop still owes for each payroll item assigned to a liability account, plus most deductions and company contributions, for the date range you select. When that number is larger or smaller than the amount the IRS or your state says is due, one of the two records is incomplete — and usually it is QuickBooks.
QuickBooks records only the transactions entered in your company file and has no live connection to EFTPS or your state tax portal. If a liability payment was never created as a liability check, QuickBooks keeps showing the amount owed even after the agency received your money.
What QuickBooks reports vs. what the agency shows
These two records answer different questions, which is why they disagree even when nothing is broken:
| Record | What it is built from | Why it can differ |
|---|---|---|
| Payroll Liability Balances report | Paychecks and liability checks saved in your company file | Missing checks, regular checks, voided paychecks, wrong liability accounts |
| Agency transcript (EFTPS or state portal) | Payments and filings the agency actually received under your EIN and account number | Timing, misapplied payments, penalties and interest, amended filings |
| Payroll Summary by employee | Payroll items and year-to-date amounts in QuickBooks | Wrong tax tracking type or liability account, prior-period adjustments |
| Form 941 and state returns | What was filed, prepared from QuickBooks or by your payroll service | Corrections made after filing, underpayments, overpayments |
Three rules explain most mismatches:
- QuickBooks only knows what was entered. A payment made on EFTPS or a state website does not reduce the liability report until you record it as a liability check or enter it as a prior payment during payroll setup.
- The agency only knows what it received. A liability check saved in your file does not reduce your agency balance until the payment clears and is applied under the correct EIN and account number.
- Timing moves both numbers. A payment dated after the report period or a check still in transit can create a real difference for a few days.
Penalties and interest shown on an agency transcript never appear in QuickBooks on their own. Record them as a separate expense with your accountant instead of editing payroll items to absorb them.
Symptoms that come with a drifting liability balance
- The Payroll Liability Balances report shows an amount owed after you already paid the agency.
- The Payroll Center still shows an overdue liability in red even though the money left your bank account.
- The liability account shows a negative balance after an employee paycheck was voided.
- QuickBooks shows nothing owed for a period when the agency says a payment is missing.
- Payroll Summary totals do not match the liability report because an item posted to an expense account.
Common causes, ranked by how often they occur
- The payment was recorded as a regular check or bill payment. QuickBooks only applies a payment to a liability when it is created as a liability check. A regular check reduces the bank account but leaves the liability untouched.
- A paycheck or liability check was voided after the liability was paid. Voiding a paycheck creates a negative liability; voiding a liability check makes the liability look owed again.
- The liability was paid outside QuickBooks. Payments made through EFTPS or a state portal are invisible to QuickBooks until someone records them.
- The payroll item points at the wrong account. A tax or deduction item assigned to an expense account instead of a liability account cannot be tracked correctly. This is the payroll setup mistake that causes the most long-term drift.
- Prior-period paychecks or adjustments were never entered. A company that switched to QuickBooks Desktop Payroll mid-year and skipped the pay history step starts from an incomplete baseline.
- Duplicate or missed liability checks. Two checks for one period, or none, is common after an employee leaves or a payment schedule changes.
- Data damage. Rare, but a damaged company file can move balances in more places than payroll. Run Verify Data if balances change without transactions to explain it.
Before you begin
Back up first. The corrections below delete and recreate checks and can post new entries to liability and expense accounts. Back up the company file and keep that backup until your accountant has reviewed the affected quarter.
- Time: 30–60 minutes to reconcile one quarter; longer when several periods are wrong.
- Access: QuickBooks admin rights plus your IRS EFTPS and state tax portal logins.
- Paperwork: agency transcripts or payment confirmations for the periods you are checking, the last filed Form 941, and state returns.
- People: bring in your accountant before changing any period that has already been filed or paid.
How to reconcile and correct payroll liabilities
Filed quarters need accountant review. Adjust Payroll Liabilities can change year-to-date amounts that feed 941s, W-2s and state returns. Fix current-quarter entry errors first, and amend prior periods only with guidance.
Run the Payroll Liability Balances report one period at a time
Go to Reports → Employees and Payroll → Payroll Liability Balances. Set the date range to a single quarter or deposit period rather than the whole year. Write down the amount owed for each tax and deduction item.
A single period matches the deposit schedule the agency uses and is easier to trace.
Pull the agency's record of the same period
Sign in to EFTPS or your state tax portal and open the account transcript, payment history, or filing history for the same period and EIN. Note what the agency received, the date it was applied, and any penalties or interest.
QuickBooks measures what you owe; the transcript measures what was paid and applied. Put both on paper before deciding which one is wrong.
Trace every payment inside QuickBooks
Go to Vendors → Vendor Center, right-click QuickBooks Desktop Payroll Service (or Intuit) and select Quick Report. Review the liability checks listed there against the agency record.
Then open Banking → Use Register, select the payroll bank account, and look for checks or bill payments that reduced the bank balance but were never linked to a liability. Those are the payments QuickBooks cannot see.
Re-record payments entered as regular checks or bill payments
Open the original check in the register, copy the payment date, amount and memo, then delete it. Recreate the payment through Employees → Payroll Taxes and Liabilities → Create Custom Liability Payments or Pay Scheduled Liabilities so QuickBooks applies it to the liability account.
If the original payment was a bill payment, delete it and the bill it paid, then record the liability check.
Fix payroll items assigned to the wrong account
Run Reports → Employees and Payroll → Payroll Item Listing. Double-click the item that is off, step through the wizard, and set the Liability Account dropdown to your Payroll Liabilities account.
When the Update transactions with new account window appears, choose Update all existing transactions to use this new account, then select OK. Skipping this prompt leaves old transactions on the wrong account.
Repair voided, missing or prior-quarter transactions
If a paycheck was voided in the current quarter, recreate it so the liability report matches again. If a liability check is missing, recreate it through Create Custom Liability Payments. Check the vendor Quick Report first so you do not create a duplicate.
For a prior-quarter void, the fix is an amended return, not a new paycheck. Contact Intuit if you use Payroll Assisted; otherwise work with your accountant on the amendment.
Adjust year-to-date amounts only when the underlying data is correct
Go to Employees → Payroll Taxes and Liabilities → Adjust Payroll Liabilities. Use the last paycheck date of the affected period, choose Employee Adjustment, select the item, then enter a positive amount to increase or a negative amount to decrease.
At Accounts Affected, choose Do not affect accounts to change year-to-date report amounts only, or Affect liability and expense accounts to also post the entry to those accounts. Your bank account is not touched by either choice. This step needs an accountant's review when a period was filed.
Verify the fix
- Re-run Payroll Liability Balances for the same period and confirm the amount owed now matches the agency transcript after timing differences settle.
- Run the Payroll Summary report for the quarter and confirm wages and taxes agree with the last filed Form 941.
- Run the payroll checkup in the Payroll Center and clear anything it flags.
- Process the next payroll and confirm liabilities increase by the expected tax totals.
- Pay that liability with a liability check and confirm the report balance returns to zero for the period.
If the balance still does not match
Penalties and interest on the transcript need their own expense entry, not a payroll adjustment. A payment the agency applied to the wrong period or EIN must be fixed with the agency first. A prior-quarter error that has already been filed needs an amended return from your accountant or payroll service; e-file rejections and filing errors follow the same rule — fix the filing, not just the report.
If you use QuickBooks Desktop Payroll Assisted, contact Intuit rather than recreating filed payments yourself. If liability balances move without any transactions to explain them, run File → Utilities → Verify Data to rule out company file damage before you make more entries.
Prevention
- Pay every liability with a liability check — Create Custom Liability Payments or Pay Scheduled Liabilities — never a regular check or bill payment.
- Record agency-portal payments the same day you schedule them, dated to the period they belong to.
- Reconcile the liability report to the agency transcript every pay cycle, or at least before each 941.
- Never void a paycheck after its liabilities were paid; create a correcting paycheck instead and ask your accountant about that quarter.
- Review the Payroll Item Listing after any setup change so every item still points at the right liability account.
- Back up the company file before every correction session.
Frequently asked questions
Why does QuickBooks still show a liability I paid on the state website?
Because that payment was never recorded as a liability check. QuickBooks cannot read agency portals, so record the payment through Create Custom Liability Payments or enter it as a prior payment in payroll setup. Once the check reduces the liability account, the report matches the agency.
Does Adjust Payroll Liabilities change my bank or liability account?
It depends on the Accounts Affected choice. Do not affect accounts updates year-to-date payroll report amounts only. Affect liability and expense accounts posts the change to those accounts. Neither option touches your bank account.
Why is my payroll liability balance negative?
Usually a paycheck was voided after its liabilities were paid, or a liability check was entered twice. Recreate the voided paycheck if the period is in the current quarter, or remove the duplicate check. Prior-quarter fixes need amended returns.
Can I fix prior-quarter liability errors myself?
Current-quarter entry errors are safe to fix on your own with a backup in place. Anything already filed or paid requires amended returns. Handle those with your accountant, or contact Intuit if you use QuickBooks Desktop Payroll Assisted.