Skip to content

QuickBooks Incorrect Payroll Items: How to Find the Bad Item and Fix It Safely

quickbooks incorrect payroll

A paycheck comes out wrong. The 401(k) is taken from the wrong amount, a deduction keeps running after it should have stopped, or a tax line shows twice. The cause is often an incorrect payroll item: a setting inside QuickBooks that tells it how to calculate and report one line of pay. Fix the item and the problem stops. Fix it the wrong way and you can make past paychecks and year-end forms worse.

This guide shows you how to tell which item is wrong and what’s wrong with it, how to fix it for future paychecks, and how to clean up the paychecks you’ve already issued.

Quick Answer: What to Do First

  • Find the item. Run Payroll Summary and Payroll Detail Review to see which line is off and which employees it affects.
  • Check the item’s setup. Open Lists > Payroll Item List, double-click the item, and review its type, tax tracking and limit.
  • Check the employee. Open the employee’s Payroll Info to look for duplicates or the wrong rate.
  • For past pay, don’t just edit and hope. Use the retire-and-replace method below.

What Is a Payroll Item in QuickBooks?

A payroll item is one line on a paycheck, and each one has a type that controls how it behaves.

  • Wages (earnings): regular pay, overtime, bonuses.
  • Additions: extra amounts added to pay, such as a reimbursement.
  • Deductions: amounts taken from pay, such as a 401(k) or health premium.
  • Company contributions: amounts you pay on top, such as an employer match.
  • Taxes: federal, state, Social Security, Medicare and unemployment, which QuickBooks sets up and updates.

If an item’s type, tax tracking, rate or limit is wrong, every paycheck that uses it comes out wrong in the same way.

Which Problem Do You Have?

  • The amount is wrong on every paycheck: the rate or calculation basis on the item is wrong. Go to Fix 3.
  • A deduction doesn’t stop, or stops too soon: the limit on the item is wrong. Go to Fix 4.
  • A taxable item isn’t taxed (or the reverse): the tax tracking type is wrong. Go to Fix 5.
  • A line appears twice: you have a duplicate item or paycheck. Go to Fix 6.
  • Year-to-date totals are wrong: go to Fix 7.
  • A tax line (state unemployment, income tax) is off: the rate or tax table is the issue. Go to Fix 1 and Fix 2.
  • The wrong employee is affected: their setup, not the item. Go to Fix 2.

Why Do Payroll Items Go Wrong?

  • The tax table is out of date, so rates and limits are old.
  • A wrong rate or percentage was entered when the item was created.
  • The tax tracking type is wrong, so QuickBooks reports the item in the wrong box on year-end forms.
  • The limit or limit type is wrong, or the annual limit reset at the wrong time.
  • The item order is wrong, so a deduction is calculated before the wage it depends on.
  • The item is linked to the wrong expense or liability account.
  • Duplicates were created, often after a file conversion or when someone built an item that already existed.
  • An item was edited after paychecks were already issued, so old and new paychecks don’t match.
  • A damaged company file or an old update left items in a bad state.

Before You Start

  • Back up your company file. Payroll changes are hard to undo.
  • Sign in as an admin with payroll access.
  • Don’t change items in the middle of a payroll run. Finish or save the run first.
  • Don’t delete paychecks that were already paid. Use an adjustment instead. See the notes below.
  • Know your tax year. Corrections for a past year can affect forms already filed. Ask your accountant first.

How to Find the Incorrect Payroll Item

  1. Go to Reports > Employees & Payroll > Payroll Summary and set the date range to the current year.
  2. Look for amounts that don’t match what you expect, in each employee’s row and in the totals.
  3. Go to Reports > Employees & Payroll > Payroll Detail Review to see each item per paycheck and spot where it changed.
  4. Compare one correct paycheck with one wrong one. Note which line differs.
  5. Open Lists > Payroll Item List and double-click that item.

How to Fix QuickBooks Incorrect Payroll Items in Desktop

Work through these in order, and review a test paycheck after each change.

Fix 1: Update QuickBooks and the Payroll Tax Table

  1. Go to Help > Update QuickBooks Desktop and install the latest release. See how to update QuickBooks Desktop, or QuickBooks update stuck if it hangs.
  2. Go to Employees > Get Payroll Updates, tick Download Entire Update, and click Update.
  3. Check whether the item now calculates correctly.

If the update fails, see error PS038. If payroll is locked, see QuickBooks payroll subscription inactive.

Fix 2: Check the Employee’s Own Settings

Sometimes the item is fine and the employee’s setup is not.

  1. Go to Employees > Employee Center and double-click the employee.
  2. Open the Payroll Info tab. Check the items listed, the rates and the limits.
  3. Click Taxes and check the Federal and State tabs, including filing status and exemptions.
  4. Remove anything duplicated or no longer needed, then click OK.

For state unemployment, see QuickBooks not calculating unemployment correctly.

Fix 3: Correct the Rate and Calculation Basis

  1. Go to Lists > Payroll Item List and double-click the item.
  2. Click Next through the screens until you reach the Calculate based on quantity or rate setting.
  3. Confirm the amount, the percentage and whether it’s based on gross pay, net pay or hours.
  4. Check the item’s order in the list. Wages should come first, then additions, then deductions.
  5. Click Finish and review a new paycheck.

Fix 4: Fix the Limit and Limit Type

  1. Open the item from the Payroll Item List.
  2. Go to the Limit screen.
  3. Check that the amount and the limit type (annual, per-paycheck or one-time) match the plan.
  4. Save, then check the next paycheck for that employee.

If the deduction stopped early, check whether the employee already reached the limit, and whether a past paycheck used the wrong amount.

Fix 5: Fix the Tax Tracking Type

This is the most serious type of error, because it also affects your W-2 and year-end reports.

  1. Open the item and look at the Tax tracking type.
  2. QuickBooks can’t change the tracking type on an item that’s already used on paychecks. Don’t edit your way around this. Use the retire-and-replace method in Fix 7.
  3. Create a new item with the right tracking type and taxability. Ask your accountant if you’re unsure how it should be taxed.

Fix 6: Remove Duplicate Payroll Items and Paychecks

  1. Open the employee’s Payroll Info and check for the same item listed twice, including under Taxes > Other.
  2. Remove the duplicate from the employee’s profile. Deleting it only from a paycheck isn’t enough, because it can come back.
  3. If duplicate paychecks were created and not paid, void or delete them and re-enter.
  4. If they were already paid or sent by direct deposit, don’t delete them. Use an employee liability adjustment to correct the tax amounts. See how to reverse a direct deposit if a deposit needs to be pulled back.
  5. If duplicates keep appearing, back up, update, and run File > Utilities > Verify Data and Rebuild Data.

Fix 7: Correct a Bad Item and Its Past Paychecks (Retire and Replace)

When the type or tracking is wrong, or past totals are off, retire the old item and bring the amounts across to a new one.

  1. Retire the old item. Go to Lists > Payroll Item List, double-click the item, add Do Not Use to the end of the name, and click Finish.
  2. Create the right item. Click the Payroll Item button, choose New, and set it up with the correct type, tax tracking and rate.
  3. Find the year-to-date amounts. Run Payroll Summary for the year and note each affected employee’s amount for the old item.
  4. Move the amounts. Go to Employees > Payroll Center, start a payroll, select the employee and click Open Paycheck Detail. Enter wages, clear Other Payroll Items, then enter two lines: the old item (reversing its amount) and the new item (with the same amount).
  5. Use the right signs. For wages, additions and company contributions, the old item is negative and the new one positive. For deductions, reverse the signs. Reversed signs give wrong totals.
  6. Check the wages cover it. The correction paycheck needs enough pay to cover the added tax. Spread large amounts over several paychecks.
  7. Make the old item inactive. Right-click it in the Payroll Item List and choose Make Payroll Item Inactive. You can’t delete an item that’s been used.

This method is for wage, addition, deduction and company contribution items. For taxes such as federal income tax, Social Security, Medicare, FUTA, state income tax or SUI, use an Adjust Payroll Liabilities entry instead (Employees > Payroll Taxes and Liabilities).

Fix 8: Repair Damaged Payroll Data

If items behave oddly or change by themselves, the file may be damaged.

  1. Run File > Utilities > Verify Data, then Rebuild Data if it reports problems.
  2. Use QuickBooks File Doctor from the Tool Hub.
  3. Check the paychecks again after the repair.

How to Fix Incorrect Payroll Items in QuickBooks Online

Step 1: Find the Wrong Paycheck

  1. Go to Payroll > Employees and open the employee.
  2. Compare their pay, deductions and contributions with what they should be.
  3. Run the Payroll Summary report to see totals.

Step 2: Correct the Employee’s Pay Setup

  1. Open the employee’s Pay and Withholdings settings.
  2. Fix the deduction, contribution or tax settings.
  3. Save so that future paychecks use the right amounts.

Step 3: Fix a Paycheck You’ve Already Created

  1. Open the paycheck from Banking or the payroll history.
  2. Edit the amount and save, or void it and create a new one if it hasn’t been paid.
  3. If it was already paid, ask your accountant or payroll support how to correct it without creating a double payment.

Online can’t edit year-to-date amounts directly on a paycheck. Run a payroll details report to confirm what the totals should be.

After You Fix It

  • Run Payroll Summary and compare with last time.
  • Review the next paycheck for each affected employee before you approve it.
  • Check Payroll Liability Balances so what you owe matches what you expect.
  • Compare the items on a W-2. See how to print a W-2 in QuickBooks.
  • Keep a note of what you changed, the date and why.
  • Check tax deadlines. See QuickBooks Form 941.

We’re not tax advisors. Ask your accountant before you amend any filed return.

How to Prevent Incorrect Payroll Items

  • Set up each item correctly the first time, with your accountant’s help on tax treatment.
  • Update QuickBooks and the tax table regularly.
  • Check for an existing item before you create a new one.
  • Don’t edit items mid-year unless you have to. Retire and replace them.
  • Name items clearly, such as “401(k) Employee,” not “Deduction 2.”
  • Review Payroll Summary every quarter.
  • Keep your payroll subscription active. See QuickBooks payroll subscription renewal.

Still Wrong? Get Help From Our QuickBooks Payroll Team

If payroll items still calculate wrongly after these steps, the history may need a careful clean-up so your W-2s and filings stay correct. Our payroll experts can review your items and fix them safely. Contact Data Service Solutions, visit our QuickBooks payroll support page, or call +1-(855)-955-1942. For other payroll problems, see QuickBooks payroll not working and payroll not deducting taxes.

Frequently Asked Questions

What is an incorrect payroll item in QuickBooks?

It’s a payroll line, such as a deduction, addition or tax, that’s set up with the wrong type, rate, limit or tax tracking. Every paycheck using it comes out wrong in the same way.

How do I find which payroll item is wrong?

Run Payroll Summary and Payroll Detail Review, compare a correct paycheck with a wrong one, and open that item in the Payroll Item List.

Can I edit a payroll item that’s already used on paychecks?

You can change some settings, but you can’t change everything, such as the tax tracking type, and an edit doesn’t fix past paychecks. Retire the old item, create a new one and move the year-to-date amounts.

Can I delete a payroll item?

Not once it’s been used on a paycheck. Make it inactive instead.

How do I fix wrong year-to-date amounts?

Use the retire-and-replace method. Enter the old item as a reversing amount and the new item with the same amount on a paycheck, using the correct signs. Taxes are fixed with liability adjustments instead.

Why does the same deduction or tax show twice on a paycheck?

A duplicate item is on the employee’s profile, often under Taxes > Other, or a duplicate paycheck was created. Remove it from the profile, not just from the paycheck.

How do I fix payroll items in QuickBooks Online?

Correct the employee’s pay and withholding settings, then edit or void the affected paychecks. Online can’t change year-to-date amounts directly, so check reports for the correct totals.

Will fixing a payroll item change my W-2?

It can. Totals and tax tracking feed your W-2 and year-end forms, so ask your accountant before you correct anything from a past year.

Robert Downe SEO Editor
Robert is an accounting professional, well versed in many accounting software. He has established himself as a QuickBooks expert over the past ten years. Robert finds great joy in assisting businesses and accountants all over the country so that they can manage their finances seamlessly. He does so individually and through his blogs.
follow me

© Dataservicesolutions - All Rights Reserved

Disclaimer

"Data Service Solutions" is a Accounting and Bookkeeping service provider. We are distinguished by the virtue of our expertise in various products developed by a wide range of third-party companies. Read More