Switch payroll providers to QuickBooks before January: Tie Out Year-to-Date Pay First

If you plan to switch payroll providers to QuickBooks Workforce this quarter, the new import from ADP or Gusto will carry your year-to-date pay history across. Don't trust it blindly. Tie every imported total to the three Forms 941 you already filed and to each employee's last pay stub, or wait and switch on January 1.

Why this matters now

Intuit's October 2026 QuickBooks Online product update, published 2026-10-06, says that clients switching to QuickBooks Workforce from ADP or Gusto can import complete employee records and year-to-date payroll history without starting from scratch. It is available now to QuickBooks Workforce subscribers. Intuit's setup article for the import, updated 2026-08-28, lists what rides along: employee details, work locations, pay schedules, payroll items, and year-to-date gross pay, deductions, contributions, taxes withheld, and net pay. It also states why the history matters. If you have already paid employees this year, the imported pay history goes on their W-2s and other payroll tax forms.

The calendar is what makes this an October question. Three quarters of 2026 payroll are done. The third quarter Form 941 is due November 2, 2026, because October 31 falls on a Saturday and the IRS's Publication 509, updated 2026-04-30, moves a weekend due date to the next business day. Anyone who switches now will have one quarter of QuickBooks payroll and three quarters of imported history feeding a single set of 2026 W-2s. Anyone who waits until January 1 has nothing to import at all. The Instructions for Form 941, revised March 2026, describe the check that will eventually test either choice: the IRS matches the four quarterly Forms 941 against the W-2 amounts totaled on Form W-3 for federal income tax withholding, Social Security wages, Social Security tips, and Medicare wages and tips, and you may hear from the IRS or the Social Security Administration when they don't agree.

Guides on switching payroll providers usually cover the project plan: export reports, gather tax IDs, pick a start date, run a parallel payroll. Intuit's own material covers the mechanics of the import and notes that a QuickBooks payroll expert reviews it before it comes back to you. What is thin is the owner's side. A plain decision rule for October versus January, a tie-out you can do in an hour with small numbers, and a clear statement of what the import does and does not do to your books. That is what this article adds.

Switch now or wait for January 1

January 1 is the cleanest date to switch payroll providers. There is no year-to-date history to import, the old provider files all four 2026 Forms 941 and issues the 2026 W-2s, and QuickBooks starts the year at zero. The cost of waiting is eleven more weeks on a system you have decided to leave, and a setup project that lands in December when you would rather be closing the year.

A fourth quarter switch is reasonable when three things are true. First, you can put your hands on the three filed Forms 941 for 2026 and a final year-to-date pay stub or register for every employee today, not after the old provider's access ends. Second, your payroll is ordinary: hourly and salaried pay, a pre-tax health deduction, maybe a retirement plan, no stock compensation, no third-party sick pay, no employees who moved between states. Third, you have a reason that does not wait, such as a job costing need for the fourth quarter or a contract that is ending. If any of the three fails, set up QuickBooks in December and run the first payroll in January.

Whichever date you choose, cut over on a pay period boundary. The old provider pays every hour worked through the last day of its final period. QuickBooks pays the first full period after that. A period split across two providers produces two partial pay stubs, two sets of tax deposits for one week, and a year-to-date figure that neither system owns.

Write down who files what. The provider that processed the third quarter payrolls should file the third quarter Form 941 and make the deposits behind it. If you switch in October, QuickBooks files the fourth quarter return and the 2026 W-2s, using the imported history for the first three quarters. Confirm this in writing with both providers before the first QuickBooks payroll runs. A missing or duplicated return is the most expensive outcome of a mid-year switch and the easiest to prevent.

The year-to-date tie-out, with a worked example

The import brings numbers across. The tie-out proves they are the right numbers. You need two comparisons, one at the company level and one per employee, and both should finish before the first QuickBooks payroll is approved.

Start at the company level. Add up the same four lines from the three Forms 941 you filed for 2026: line 2 wages, tips, and other compensation; line 3 federal income tax withheld; line 5a Social Security wages; and line 5c Medicare wages and tips. Those four sums are the numbers the IRS will later compare against your W-3, so they are the anchor. Then open the imported year-to-date figures in QuickBooks and build the same four totals from the imported gross pay, pre-tax deductions, and taxes withheld.

Here is an example for a three-person business through September 30. Maya is salaried and has $42,000 of gross pay year to date with a pre-tax health premium of $200 a month, so $1,800 so far. Luis is hourly with $33,000 of gross pay and $2,400 of 401(k) deferrals. Priya works part time and has $21,000 of gross pay with no deductions. Federal income tax withheld across the three is $9,400. The health premium is excluded from all three wage lines. The 401(k) deferral is excluded from line 2 but stays in Social Security and Medicare wages.

Every line ties except one. The federal income tax wage figure is $2,400 too high, and that is exactly Luis's 401(k) deferral. During the import, the 401(k) item from the old provider was matched to a post-tax deduction in QuickBooks, so QuickBooks did not reduce taxable wages for it. Nothing about the dollars is wrong. The mapping is wrong, and if it is not fixed, the 2026 W-2 for Luis will show $2,400 too much in box 1 and his fourth quarter withholding will be calculated on the wrong base. The fix is to re-map the item as a pre-tax retirement deduction and re-check the line. This is why the Intuit article insists that you match every payroll item during setup rather than adding them later.

Now go per employee. For each person, compare the imported year-to-date gross pay, each deduction, each tax withheld, and net pay to the final pay stub or year-to-date register from the old provider. The stubs already carry a year-to-date column, so this is a side-by-side read, not a calculation. Then add up the imported year-to-date net pay for everyone and compare it to the total of net pay debits on your bank statements since January. The bank total is independent of both payroll systems, which makes it the best single check that the import is complete.

Finally, the quarterly FUTA totals. Federal unemployment tax applies only to the first $7,000 each employee earns in the year. In the example, all three employees crossed $7,000 in the first quarter, so the FUTA taxable wages are $21,000 in the first quarter and zero in the second and third. If you skip this screen, QuickBooks has no way to know the wage base is used up and may calculate FUTA on fourth quarter wages, which at the usual net rate of 0.6 percent on roughly $32,000 of fourth quarter pay is about $192 of tax you do not owe, sitting in a liability account and flowing onto Form 940. The same logic applies to the Social Security wage base of $184,500 for 2026 if anyone on the payroll earns near it.

Accounting controls for the payroll switch

Source data: the three filed Forms 941 for 2026 with their filing confirmations, the final year-to-date pay stub or payroll register for each employee from the old provider, the employee summary and payroll history exports that QuickBooks asked for, the old provider's tax deposit history by quarter, the written agreement on which provider files which returns, and the bank statements showing net pay and tax debits since January. Download all of it before the old provider's portal closes, because the import does not replace these records.

Calculation: a one-page worksheet that sums the four Form 941 lines across three quarters, pulls the matching company-wide totals from the import, and shows the difference in a formula cell. A second block lists each employee with stub year-to-date figures beside imported figures and a difference column. A third block lists FUTA taxable wages by quarter and the running total against $7,000 per employee. Formula cells only. Typing a difference from memory defeats the purpose.

Review: someone other than the person who uploaded the files reads the worksheet. If your bookkeeper ran the import, you review it. If you ran it, the bookkeeper does. The reviewer confirms every difference is zero or has a written explanation, checks that each payroll item was matched to a QuickBooks item with the same tax treatment, opens the bank register and the payroll liability accounts to confirm the import did not post any transactions, and checks that the first QuickBooks pay stub shows year-to-date figures that continue from the old provider's last stub. The Intuit article on the import does not address what the import does to your accounts, so test it rather than assume. Wages are a flow. The January through September wage expense is already on your profit and loss from the old provider's entries, and the import exists to make tax forms and wage base limits correct, not to record expense again. Payroll liabilities are a point-in-time balance. Taxes withheld in the old provider's final payroll remain a liability on your balance sheet until that provider deposits them, which happens after your switch date, and you clear the balance when the deposit shows up, not when you cut over. The post on who posts what in QuickBooks covers how to assign that responsibility when more than one person touches the books.

Decision: the owner chooses the switch date, decides in writing which provider files the third and fourth quarter Forms 941 and the 2026 W-2s, decides whether to keep read access to the old provider through the end of January, and signs off the tie-out worksheet with a date. A switch that is approved only in the QuickBooks setup screen is not a documented decision.

Limits and common mistakes

First, treating the import as bookkeeping. The imported history is payroll data for tax forms. If someone also posts a journal entry for January through September wages because they saw the year-to-date figures in QuickBooks, wage expense is doubled. Confirm the register before and after the import.

Second, mapping errors. A pre-tax deduction matched to a post-tax item, a taxable bonus matched to a mileage reimbursement, or a company contribution matched to an employee deduction will each tie at gross pay and fail at the taxable wage lines. The company-level tie-out catches these in minutes, which is why it comes before the per-employee read.

Third, skipping the quarterly FUTA and wage base totals. The overpayment is small per employee, but it lands on Form 940 and in a liability account that will not reconcile to anything.

Fourth, leaving filing responsibility to assumption. Each provider files the quarters it processed. Say so in writing, keep the filed third quarter return, and keep the old provider's deposit history, because its totals are the first column of your tie-out.

Fifth, switching mid period or in the last week of December. The first cut splits a week across two systems. The second gives you the import work of a fourth quarter switch and the setup crunch of a January switch at the same time.

Finally, this article covers federal forms and the books. State withholding, state unemployment rates, local taxes, and any tipped wage credit still have to be set up and checked separately. Once you are on QuickBooks, the fourth quarter is also the first chance to use service items by paycheck for labor job costing, and that post explains how to tie those figures out too. A payroll tie-out worksheet and other small business bookkeeping models are in the FinBoard templates library.

Frequently Asked Questions

Is it better to switch payroll providers on January 1 or during the fourth quarter?

January 1 is the cleanest date because there is no year-to-date history to import and the old provider files every 2026 form. A fourth quarter switch works when you can tie the imported year-to-date totals to your three filed Forms 941 and your last pay stubs before the first QuickBooks payroll runs.

What do I tie the imported year-to-date totals to?

Add up wages, federal income tax withheld, Social Security wages, and Medicare wages from the Forms 941 for the first three quarters, then compare each total to the company-wide year-to-date figures in QuickBooks. Then compare each employee's imported gross, taxes, deductions, and net pay to that employee's last pay stub from the old provider.

Does imported pay history change my profit and loss or balance sheet?

It should not. Wage expense for January through September is already in your books from the old provider's entries, and the import exists to make W-2s and year-to-date tax limits correct. After the import, open the bank register and the payroll liability accounts and confirm that no new transactions appeared.

Who files the third quarter Form 941 if I switch in October?

The provider that processed the third quarter payrolls normally files it, and in 2026 that return is due November 2 because October 31 falls on a Saturday. Confirm the responsibility in writing with both providers, and keep a copy of the filed return because its totals are the first number in your tie-out.

Why does QuickBooks ask for FUTA totals by quarter?

Federal unemployment tax applies only to the first 7,000 dollars each employee earns in the year. Without the quarterly totals, QuickBooks cannot tell that the wage base is already used up and may calculate FUTA again on fourth quarter wages, which overstates the liability on Form 940.

FinBoard connects your QuickBooks file to labor cost and profit and loss reports that show whether October wages agree with the payroll register, with drill-down to the entries behind each number, so the first month on a new payroll system is a report you can check rather than a spreadsheet you have to build. See how FinBoard works for small businesses.