Accountants · problem and fix
QuickBooks payroll liabilities not matching: a state checklist for accountants, 2026
If your QuickBooks payroll liabilities do not match a state balance, one number is wrong, or the two numbers measure different things. Common causes are wrong rates, wage bases, deposit dates and amended returns. This page shows how to find which one, what it costs, and the fixes that need no paid tool.
The short answer
- Compare three things: the QuickBooks liability, the deposits you paid and the state account balance.
- Stale SUI rates and wage bases that differ by state are common sources of state gaps.
- Form 941 Line 16 summarizes liability, not deposits. Do not use it as a deposit check.
- Fix the books with Adjust Payroll Liabilities. Fix a filed return with Form 941-X.
- Mac users should confirm their QuickBooks edition first, because the menu paths here come from Intuit's Desktop Payroll articles.
$339
Average cost to correct one payroll error, excluding compliance costs (EY survey, inflation-adjusted)
EY Survey: Cost Per Payroll Error Climbs to $339 Average1 in 5
Payrolls where survey respondents reported a payroll error, about 1 of every 5
EY Survey: Cost Per Payroll Error Climbs to $339 Average$20,400
Iowa's 2026 taxable wage base for unemployment tax, down from $39,500 in 2025
EY Tax News: 2026 state unemployment insurance taxable wage bases48.1%
Tax and audit staff in a 110-person survey who worked 51 to 60 hours a week in busy season. Not representative.
Distinct Recruitment: Busy season 2025 snapshotWhat payroll tax liabilities that differ from state balances costs you
Money you spend on each error
EY, in a release published by Paycom, puts the average cost to correct one payroll error at $339. The figure is an inflation-adjusted update of 2022 survey data from more than 500 US payroll managers. It excludes compliance costs and other financial effects, so your real cost can be higher.
How often payroll errors happen
The same release says respondents reported payroll errors in about 1 of every 5 payrolls. Treat that as directional. It comes from a vendor-sponsored survey, not a count of mismatches in your own files, and your own frequency is what matters for your clients.
Time you give back
One Distinct Recruitment survey of 110 tax and audit professionals found that 48.1% worked 51 to 60 hours a week in busy season. The sample is small and not representative. A payroll gap that eats a Friday afternoon is still a real cost to your week.
Why it happens
State wage bases differ from the federal base
A state sets its own taxable wage base, and that base can differ from the federal base. EY Tax News reports Iowa's 2026 base at $20,400, down from $39,500 in 2025. If your payroll settings still use the old base, the software and the state will disagree. EY also counts 28 jurisdictions with a flexible wage base.
Software still uses an old SUI rate
Payroll software stores a state unemployment rate for each employer. When the state issues a new rate, that stored number goes stale until someone updates it. Intuit's guidance for Desktop Payroll Enhanced starts with updating the rate if it increased. Check the state notice, not last quarter's number.
Deposit dates and pay dates do not line up
A deposit can be dated when you send it, not when the wages were paid. Compare the payment date with the pay date for each run before you call a gap an error. Payments that cross a quarter boundary are a common trap.
A filed return and the books disagree
If a Form 941 went in with a wrong number, the books and the return will never match until the return is corrected. Adjusting the books alone does not fix a filed return. The IRS route for a filed return is Form 941-X.
Line 16 gets read as a deposit total
Line 16 summarizes your monthly tax liability. It does not summarize deposits. Anyone who compares Line 16 with the bank statement will see a gap whenever the two numbers differ, even when the filing is right.
How to fix it
These work with or without any app.
Tie Form 941 to the W-3 and W-2 totals
The IRS matches the four quarterly Forms 941 against the annual W-3 and W-2 totals for wages, withholding and tips. Add the four quarters, then compare the total with the annual totals. This tie-out catches errors that a single-quarter check misses.
Correct the SUI rate and base first
For a state SUI shortfall in Desktop Payroll Enhanced, Intuit's steps start with updating the rate if it increased. Then run a payroll checkup, review the payroll summary, pay the state and record the payment. Only one SUI payment per quarter can be made in QuickBooks.
Use Adjust Payroll Liabilities with the right sign
Go to Employees > Payroll Taxes and Liabilities > Adjust Payroll Liabilities. Enter a positive amount for under-withheld items and a negative amount for over-withheld items. Set the effective date to the last paycheck date of the affected month or quarter.
Pay the agency directly, then record it
For federal and state income and FICA shortfalls, Intuit says you can pay through QuickBooks if you e-pay there. Otherwise, pay the agency directly and record that payment in QuickBooks. Desktop Payroll Assisted customers must contact Intuit.
Amend a filed return with Form 941-X
Use Form 941-X to correct errors on a Form 941 you already filed. File it separately from the books entry. Some amended employment tax returns can be e-filed, so check the current instructions before you file.
Start with the state account, not with QuickBooks. Pull the balance the state shows for one quarter. Then pull the QuickBooks liability for the same dates. Most of the work is deciding which number is wrong, and why.
Find which number is wrong first
A liability and a balance are different things. QuickBooks shows what it thinks you owe for each pay date. The state shows the payments it received and the amount it has on your account. A gap can mean the books are wrong, the payment landed on a different date, or both.
| Symptom | Likely source | First check |
|---|---|---|
| QuickBooks is higher than the state | A deposit was not recorded, or you paid the state outside QuickBooks | Match each payment to a state confirmation or bank debit |
| State is higher than QuickBooks | A stale or wrong SUI rate, or a wage base mismatch | Compare the state rate notice and taxable wage base for the quarter |
| Gap shows in one quarter only | A payment dated by deposit date instead of pay date | Compare the payment date with the pay date for each run in that quarter |
| Gap appeared after a new year or a software update | An old rate or base still active in payroll settings | Open the payroll settings and check each state tab |
| Gap matches an earlier correction | An adjustment or amended return entered twice | Check the adjustments list and any filed Form 941-X |
Read Form 941 before you touch the books
Form 941 has two checks that people mix up. For deposit-required filers, Line 12 should match the total liability on Line 16 or on Schedule B. Line 13 reports the total deposits for the quarter. Compare each line with its own partner, not one line with the bank.
Your deposit schedule depends on your lookback period. A monthly depositor reports $50,000 or less in taxes in the lookback period. Above $50,000 makes you a semiweekly depositor. Semiweekly depositors must complete Schedule B, or the IRS may assess penalties based on the information it has.
The IRS instructions give no step-by-step method for tying liabilities to deposits. The tie-out on this page is a practical approach, not an IRS procedure. Write that down in your file so a reviewer knows where the method came from.
A worked example with Iowa's wage base
Say your QuickBooks file still uses last year's taxable wage base for Iowa unemployment tax. EY Tax News reports Iowa's 2026 base at $20,400, down from $39,500 in 2025. Under the 2026 base, only the first $20,400 of each employee's pay is taxed for state unemployment. Software that still taxes up to $39,500 will show more liability than the state expects.
The gap can run the other way too, if the rate is stale. Check both the base and the rate for each quarter. Verify the figures on Iowa's own wage base table first. A search result I saw listed a different number, so do not rely on one source.
| 2025 base | 39500 USD |
|---|---|
| 2026 base | 20400 USD |
EY reports these figures. Confirm against Iowa's official table before you enter them. Source: EY Tax News: 2026 state unemployment insurance taxable wage bases
Repeat that check for every state where you have employees. State bases can differ from the federal base. The federal FUTA wage limit has been $7,000 since 1983, so do not assume the bases match. EY counts 28 jurisdictions with a flexible wage base, so last year's number is not a safe default.
Five checks before you adjust anything
- Pull the state account balance and the payment history for the quarter.
- Pull the QuickBooks liability report for the same dates, with pay dates and deposit dates side by side.
- Compare Form 941 Line 12 with Line 16, then Line 13 with the deposits you made.
- Check the SUI rate and taxable wage base for each state against the state's own rate notice.
- Compare your quarterly totals with the annual W-3 and W-2 totals for wages and withholding.
Adjust the books or amend the return
Fix the books and the return as two separate jobs. In QuickBooks Desktop Payroll, Employees > Payroll Taxes and Liabilities > Adjust Payroll Liabilities changes the liability record in your books. That fixes the books. It does not file a corrected return.
A filed Form 941 with a wrong number needs Form 941-X, filed separately. Some amended employment tax returns can be e-filed. Check the current 941-X instructions before you file, and keep a copy of what you filed and why.
Mistakes people make with adjustments
- Entering a positive number for an over-withheld item. Over-withheld items take a negative amount.
- Using the wrong effective date. Use the last paycheck date of the affected month or quarter.
- Picking a random employee for a company-paid item. The screen requires an employee even for company-paid items, so pick the right one and note why.
- Making a second SUI payment in the same quarter. QuickBooks allows only one SUI payment per quarter.
- Paying the state directly and never recording it. The liability stays open, and the gap stays on the report.
Mac users: confirm your edition first
The Intuit articles I checked cover Desktop Payroll in general. They do not say which Mac editions show the same menus. One Intuit community reply from January 20, 2024 says QuickBooks Desktop for Mac has its own cloud-based payroll. That reply is not an official article, and third-party sources I found disagree on Mac payroll support.
Before you follow a menu path, open your edition's own help and search for Payroll Taxes and Liabilities. If the menu is not there, the adjustment may live somewhere else, or your edition may not support it. Ask your firm's software admin before you guess.
Browser tools work differently. Xero's US payroll guide says its software schedules and submits tax deposits to the IRS and state agencies on your behalf. The same guide does not explain how to reconcile liability balances with agency records, so the tie-out on this page still applies.
Where Lazur helps, and where it stops
Lazur is a voice assistant for the Mac. Hold ⌥ ⌘ to ask about anything on screen, and Lazur answers out loud. It points at things, and it guides you one click at a time, waiting for each click.
For this problem, Lazur is most useful as a second pair of eyes. Ask it where Adjust Payroll Liabilities sits in the menu. Ask it what Line 13 measures on a Form 941 you have open. Use Research for state rate notices, which runs in Lazur's own Chrome tabs and returns a summary and a report.
Lazur does not reconcile your accounts, click buttons or edit files for you. It only sees the screen while you hold the shortcut. Audio and the screenshot go to AI providers to answer, and they are not stored. Content is never used to train AI models.
Keep the fix from coming back
After the balances match, change one habit. Compare each state balance with QuickBooks once per quarter, before the deposit is due. Keep the reconciliation sheet with the payroll file. Re-check the rate and base each time a state publishes a new notice.
Also ask who owns the state rate settings in your software. A state tab with no owner is where stale rates come from. Give that tab a name in your checklist, and review it on the same day you review the balances.
Faster with Lazur
Where Lazur helps with payroll tax liabilities that differ from state balances
Hold ⌥ ⌘ and say what you want. Lazur sees your Excel window. Lazur draws a circle and a label around the button or menu you need.
- 1
Hold ⌥⌘ and talk
- 2
Lazur draws a circle and a label around the button or menu you need.
- 3
You stay in Excel. Nothing to copy into a chat window.
More things to say in Excel
- “Where is Adjust Payroll Liabilities in this menu?”
- “Walk me through the adjustment screen one click at a time.”
- “What does Line 13 on this Form 941 measure?”
- “Find the current SUI rate notice for Iowa and summarize it.”
- “Hold fn and dictate your reconciliation note.”
- “Draft a note to the client explaining the variance.”
Free for 3 days, then $18/month. Download for Mac
You say“Where is Adjust Payroll Liabilities in this menu?”
Lazur · points at itYou see the path on screen. You still open the menu and enter the adjustment yourself.
What accountants say to Lazur for this
Each one is a single hold of ⌥ ⌘.
“Where is Adjust Payroll Liabilities in this menu?”
Lazur draws a circle and a label around the menu item on your screen. You open it and click it yourself.
Points at it
“Walk me through the adjustment screen one click at a time.”
Lazur guides you one click at a time and waits for each click before it names the next one.
Walks you through it
“What does Line 13 on this Form 941 measure?”
Lazur answers out loud, using what is on screen. It does not replace the IRS instructions.
Explains what's on screen
“Find the current SUI rate notice for Iowa and summarize it.”
Research runs in Lazur's own Chrome tabs and returns a summary and report. Check the agency source before you enter any rate.
Researches in the background
“Hold fn and dictate your reconciliation note.”
Dictated text appears at the cursor in any app. Review it before it goes into a client file.
Types what you say
“Draft a note to the client explaining the variance.”
Lazur drafts and types the text. Check every figure against your own report before you send it.
Drafts it
“Remind me to check the state balance next Monday.”
Lazur adds an Apple Reminders item by voice, so the check stays on your list.
Handles the small stuff
A plan you can start this week
- Day 1
Pull both sides for one quarter
Get the state account balance and payment history for one quarter. Export the QuickBooks liability report for the same dates. One quarter shows the pattern faster than a full year.
- Day 2
Tie Form 941 to the books
Compare Line 12, Line 13 and Line 16 with your QuickBooks totals. Mark each difference as timing, rate, base or missing entry. Do not adjust anything yet.
- Day 3
Check rates and wage bases
Open the state rate notice for each state with a gap. Compare the SUI rate and taxable wage base with what your payroll settings use. Write the source address next to each figure.
- Day 4
Adjust and pay
Enter adjustments in QuickBooks with the right sign and effective date. Pay the state directly if needed, then record the payment. Remember that only one SUI payment per quarter can be made in QuickBooks.
- Day 5
Amend and document
If a filed Form 941 was wrong, prepare Form 941-X. Write a short reconciliation note with the reason for each adjustment. Store it where your firm keeps client files.
Questions people ask
Why do my QuickBooks payroll liabilities not match the state balance?
The usual reasons are a wrong SUI rate or wage base, a payment dated by deposit date instead of pay date, a payment made outside QuickBooks, or an adjustment entered twice. Start with the symptom table on this page and work down the causes.
Does Line 16 on Form 941 show what I deposited?
No. Line 16 summarizes your monthly tax liability. Line 13 reports the total deposits for the quarter. Compare Line 12 with Line 16, and compare Line 13 with your payment records.
Should I adjust QuickBooks or file a Form 941-X?
Adjust QuickBooks when the books are wrong and the return was right. File Form 941-X when a Form 941 you already filed was wrong. The two steps are separate, and one does not fix the other.
Can Lazur fix the mismatch for me?
No. Lazur points at menus, guides you one click at a time, reads what is on screen and drafts text. It does not click buttons, edit files or reconcile accounts for you.
Is the Mac menu path the same as Windows?
Not confirmed. The Intuit articles I checked describe Desktop Payroll in general. Check your edition's own help before you follow a menu path.
Do I need a paid tool to do this tie-out?
No. The tie-out needs your payroll reports, the state rate notices and the IRS instructions. Those sources are free. A paid tool can save time, but it does not decide which number is right.
Can a mismatch create penalty exposure for my client?
It can, so do not guess. The IRS may assess penalties based on the information it has if a semiweekly depositor does not complete Schedule B. Ask your firm's tax lead before you file a correction for a client.
Sources
- EY Survey: Cost Per Payroll Error Climbs to $339 Average for Companies · Paycom (vendor; EY study) · checked 2026-11-09
- Instructions for Form 941 (Rev. 03/2026) · IRS · checked 2026-11-09
- About Form 941-X, Amended Employer's QUARTERLY Federal Tax Return · IRS · checked 2026-11-09
- Fix underpaid payroll taxes - QuickBooks · Intuit · checked 2026-11-09
- Adjust payroll liabilities in QuickBooks Desktop Payroll · Intuit · checked 2026-11-09
- Desktop Payroll for Mac · Intuit Community · checked 2026-11-09
- Understanding online payroll · Xero · checked 2026-11-09
- 2026 state unemployment insurance taxable wage bases · EY Tax News · checked 2026-11-09
- Busy season 2025: A snapshot of workload, stress & support in public accounting · Distinct Recruitment · checked 2026-11-09
Fix payroll tax liabilities that differ from state balances with Lazur, free for 3 days
Hold a key and ask. Lazur sees your screen, points at the button and talks you through it, in any Mac app. No credit card.