Removing Excess Payroll Tax for an Employee Exempt in a Prior Location

When an employee moves during the year — relocating from one state, county, or municipality to another — their tax situation rarely carries over cleanly. A common problem surfaces during year-to-date payroll setup in QuickBooks Desktop: the software calculates taxes for a prior location where the employee once lived or worked, even though that person is now exempt from taxes there. Left uncorrected, those excess amounts inflate the company’s payroll tax liabilities and produce inaccurate payroll summaries.

The issue arises most often when a business is entering historical paychecks for the current calendar year. QuickBooks applies its standard tax calculations to each paycheck based on the employee’s work and residence locations, and it does not automatically know that an employee should not have been taxed in a jurisdiction they have since left. The result is that the Payroll Summary report shows tax withholdings that should not exist for that prior location, and those phantom figures flow through into year-to-date tax payment setup unless they are manually removed.

Identifying the Excess on the Payroll Summary

The accepted fix centers on the Payroll Summary report as the starting point. After all year-to-date paychecks have been entered for every employee — but before year-to-date tax payments are entered — the user should leave Payroll Setup and open the Payroll Summary report from the Reports menu under the Employees & Payroll section. Setting the report date range to the current calendar year displays every payroll item and every employee on one screen.

From there, the user locates the tax-exempt employee on the report and finds the excess tax amount — the withholding tied to the prior location that should not be there. Double-clicking that figure drills down into a Transactions by Payroll Item report showing the individual paychecks that contributed to the total. Double-clicking the amount again opens the Historical Paycheck window for that specific check.

Deleting the Tax From the Historical Paycheck

Inside the Historical Paycheck window, the excess tax item is visible on the paycheck detail. The user selects that line item and removes it by pressing Ctrl+Delete on the keyboard. This deletes the specific tax withholding from that paycheck without discarding the rest of the paycheck’s data. If the same excess tax appears on multiple historical paychecks for the same employee — which it typically does, since the employee was taxed that way across several pay periods — the process is repeated for each paycheck and each excess amount.

The same workflow applies to every employee who carries a tax exemption for a prior location. The user works through the Payroll Summary report employee by employee, drilling into each excess figure and deleting the offending tax lines paycheck by paycheck.

Backing Up Before Returning to Payroll Setup

Once every excess tax amount has been stripped out, the next step is a precautionary backup of the company file. This matters because returning to Payroll Setup and continuing with year-to-date entries can trigger a recalculation that silently restores the very amounts just deleted. Having a clean backup gives the user a recovery point without re-doing the manual deletions.

With the backup saved, the user returns to the Employees menu, reopens Payroll Setup, navigates back to the year-to-date payroll step, and proceeds with entering tax payments and non-tax payments as normal.

The Recalculate Trap

The one button to avoid during this process is Recalculate Taxes, which appears in the Enter Payroll Tax Payments window within Payroll Setup. Clicking it forces QuickBooks to recompute tax liabilities from scratch — and in doing so, it can bring back the excess taxes that were manually removed. If that button is pressed, the user has two options: repeat the entire deletion process across all affected employees, or restore the company file from the backup created just before re-entering Payroll Setup. Restoring from backup means losing any data entered after that point, so the trade-off depends on how much new work has been done since the backup was created.

For broader context on when tax recalculation is appropriate and how QuickBooks decides which taxes apply to which employees, the QuickBooks payroll troubleshooting guides at quickbooks.ninja cover related scenarios including marking an employee as exempt from a specific tax item and understanding the triggers that cause QuickBooks to recompute liabilities mid-setup. The key takeaway for prior-location exemptions is that QuickBooks will not catch them on its own — the removal has to be manual, deliberate, and protected by a backup before the setup workflow continues.