2026-11-07 · QuickBooks Desktop

Outside Payroll Showing Up Twice in QuickBooks? Fix It With a Payroll Clearing Account

↓ Get the free Excel + PDF kit for this article

You use an outside payroll service, such as Gusto, ADP or Paychex, and your books are in QuickBooks. Every payday your bank shows three or four withdrawals: net pay, a tax impound, maybe a 401(k) transfer and a service fee. Your payroll register shows something else entirely: gross wages, taxes withheld, employer taxes and deductions. Somewhere between the two, payroll gets counted twice, or your wages never match what you report.

This is one of the most repeated payroll questions in the QuickBooks Community, and the usual replies are partial: exclude the bank lines, or ask your accountant. Below is a complete method you can follow yourself in QuickBooks Desktop or QuickBooks Online. It needs one extra account and one journal entry per pay run.

Who this is for: owners and bookkeepers whose payroll is run outside QuickBooks (by a payroll service or a PEO) and who record payroll in QuickBooks Desktop or Online themselves.

Why payroll gets counted twice

Two things try to record the same payroll. The payroll register (or the journal report your provider gives you) is the full picture: gross wages are an expense, employer taxes are an expense, and the withholdings are money held for someone else. The bank feed only sees cash leaving: the net pay batch, the tax impound and so on.

If you enter the register as a journal entry and let the bank feed add each withdrawal as Wages or Payroll Taxes, the expense is booked twice. If you only add the bank lines, your wages show net pay instead of gross pay, and your taxes are lumped together. Neither matches the payroll tax returns your provider files.

Comparison table: booking both the register and the bank feed as expenses shows 18,189.60 of payroll cost, while sending withdrawals to Payroll Clearing shows the correct 9,319.80
Figure 1. The same pay run booked two ways. Example values.

The method: one clearing account

Create an account called Payroll Clearing (type: Other Current Liability). Then follow one rule: the journal entry from the payroll register credits Payroll Clearing for everything the service pulls from your bank, and every payroll withdrawal in the bank feed is categorized to Payroll Clearing. When all the withdrawals for a pay run have arrived, the account is back to zero.

Flow diagram: the payroll register becomes one journal entry crediting Payroll Clearing 9,382.80, four bank withdrawals debit Payroll Clearing 9,382.80, balance 0.00
Figure 2. Record the register once; every withdrawal goes to the same holding account.

Step 1: Set up the accounts (once)

AccountTypeUsed for
Payroll Expenses:WagesExpenseGross wages
Payroll Expenses:Payroll TaxesExpenseEmployer Social Security, Medicare, FUTA, SUTA
Payroll Expenses:BenefitsExpenseEmployer 401(k) match, employer health share
Payroll Service FeesExpenseProvider fee
Payroll ClearingOther Current LiabilityEverything the provider pulls from your bank
Payroll Liabilities (sub-accounts)Other Current LiabilityAmounts you pay later yourself: taxes, 401(k), garnishments

Table 1. Suggested accounts. Use your existing names if you have them.

Desktop: Lists > Chart of Accounts, then Account > New. Online: open your chart of accounts (in newer layouts it is under Accounting) and select New; pick the account type, then the closest detail type.

Step 2: Pull five numbers from the payroll register

Open the payroll register for the check date and find the totals line. You need gross wages, employee taxes withheld, employee deductions, employer taxes and the fee (if it is pulled with the pay run). Here is an example pay run we will use for the rest of the post.

Item (example values)Amount
Gross wages8,400.00
Employee taxes withheld (federal 812.00, Social Security 520.80, Medicare 121.80, state 286.50)1,741.10
Employee deductions (401(k) 300.00, health 150.00)450.00
Employer taxes (Social Security 520.80, Medicare 121.80, FUTA 50.40, SUTA 226.80)919.80
Employer 401(k) match168.00
Provider fee45.00

Table 2. Example payroll register totals. All values are invented.

Step 3: Build the journal entry

Type the totals into a sheet (Excel or Google Sheets) and let three formulas do the work. If gross wages are in B2, employee taxes in B3, deductions in B4, reimbursements in B5, employer taxes in B6, employer contributions in B7, the fee in B8, and the amount of 401(k) the provider sends in B9:

AccountDebitCredit
Payroll Expenses:Wages8,400.00
Payroll Expenses:Payroll Taxes919.80
Payroll Expenses:Benefits168.00
Payroll Service Fees45.00
Payroll Clearing9,382.80
Payroll Liabilities:Health150.00
Total9,532.809,532.80

Table 3. The journal entry for the example pay run. Example values.

Notice that the 401(k) money the employee and employer put in (300.00 + 168.00) sits inside the clearing credit, because in this example the provider pulls it from the bank. The health deduction is credited to a liability because you pay the insurer yourself.

Post it in QuickBooks Online

Select + New > Journal entry, set the date to the pay date and type the lines. To skip typing, Intuit's help article describes a CSV import at Settings (gear) > Import data > Journal entries, with columns for Journal No., Journal Date, Account Name, Debits, Credits and Description. Accounts must already exist, and if you use account numbers, turn them off before importing.

Post it in QuickBooks Desktop

Use Company > Make General Journal Entries. For an import, Desktop accepts IIF files at File > Utilities > Import > IIF Files (back up first, and switch to single-user mode). IIF does not warn you about duplicates, so import each pay run only once.

Step 4: Match every withdrawal to Payroll Clearing

Now the bank side. In QuickBooks Online, open your bank transactions, find each payroll withdrawal in the For review list (some newer layouts call it Pending) and categorize it to Payroll Clearing. In Desktop, add each withdrawal from the Bank Feeds Center, or enter it in the checking register, with the account Payroll Clearing.

Timeline of one pay run: taxes pulled Nov 12, entry posted and net pay pulled Nov 13, 401(k) pulled Nov 14, fee pulled Nov 30; the clearing balance ends at 0.00
Figure 3. Taxes often leave a day or two before payday. The balance only has to be zero once every withdrawal is in.

After the last withdrawal, run a QuickBooks report on Payroll Clearing. A zero balance means nothing is missing and nothing is doubled. If you already let the bank feed add payroll as Wages, open the Categorized (or Posted) list, undo those lines and recategorize them to Payroll Clearing.

If you pay the taxes yourself

Some services only handle net pay, and you deposit the taxes yourself. Then the taxes are not part of the clearing credit. Credit them to Payroll Liabilities instead, and categorize your later tax payments to the same liability accounts. The same goes for a 401(k) you send yourself, garnishments and health premiums.

Decision tree: if the service pulls the amount from your bank, credit Payroll Clearing; if you pay it later, credit a liability; employee advance repayments credit the advance asset
Figure 4. Where each amount goes.

Check it every quarter

Keep one row per pay run with gross wages, federal income tax, Social Security and Medicare (both shares). At quarter end, compare the totals with your provider's quarterly reports, such as the Form 941 it filed. A difference almost always means a pay run is missing, entered twice or was corrected after you booked it.

Common mistakes

FAQ

Can I just exclude the payroll withdrawals in the bank feed?

You can, but then nothing proves the cash really left your bank, and your reconciliation gets harder. Categorizing them to Payroll Clearing records the cash and tells you when something is missing.

My provider says it syncs with QuickBooks. Do I still need this?

If a sync posts the payroll for you, check what it posts and how it treats the bank withdrawals before adding anything by hand. The clearing method is for payroll you record yourself, and it is also a good way to check a sync.

Why is employee Medicare higher than employer Medicare?

Additional Medicare Tax is withheld from employees with higher wages, and employers do not match it. Social Security is usually equal on both sides.

Should Payroll Clearing be an expense account?

No. It is a temporary holding account, so Other Current Liability (or a bank-type clearing account) keeps it off the Profit and Loss.

Checklist for every pay run

You can download the ready-made Outside Payroll Journal Entry & Bank Match Builder for free in the Free kit download box below: the Excel workbook plus a PDF guide, no sign-up needed.

Disclaimer: This article is for education only and is not tax, legal or payroll advice. Payroll rules depend on your facts and your state; ask a qualified tax professional about your situation. Menu names change between QuickBooks versions. QuickBooks is a registered trademark of Intuit Inc.; not affiliated with or endorsed by Intuit.

Free kit download

Tools to follow this article step by step. No sign-up needed.

Free to use for yourself and your own business; please do not resell or redistribute. General information, not tax, legal or accounting advice; check every figure against your own records. QuickBooks is a trademark of Intuit Inc.; BIZLEX is not affiliated with Intuit.

Sources

← All articles Privacy