Payroll Clearing Account Reconciliation in QuickBooks Online

October 2, 2026

Bottom line: Reconcile payroll clearing by following one payroll from its approved register to every cash withdrawal and every QuickBooks posting. Gross pay, employee withholdings, employer taxes, direct deposits, tax debits, benefit payments, and provider fees do not always settle on the same day. A good schedule explains those timing differences. It never plugs an unexplained remainder or gives a support assistant authority to approve payroll.

What the clearing account is meant to show

A payroll clearing account provides a temporary bridge between payroll expense and the separate payments created by a payroll run. Depending on the company and provider, the accounting entry may credit a clearing liability for net pay, taxes, deductions, and other components. Later bank withdrawals reduce those amounts. Some systems post detailed transactions automatically; others send a summarized journal entry. The exact design should be documented by the company’s accountant.

The operational problem appears when the debits and entries arrive on different dates. Employees may be paid on Friday, the provider may withdraw direct-deposit funding on Wednesday, and a tax agency debit may settle the following week. A month-end balance can therefore be valid, but only if it is tied to named payroll components with expected settlement dates.

Do not assume every balance is a timing difference. A duplicate imported journal, a provider fee posted into clearing, a voided check, or a tax debit matched to the wrong account can also leave a residue. The purpose of reconciliation is to distinguish supported in-transit items from errors that need authorized review.

Gather a controlled payroll packet

Start with the approved payroll register or equivalent provider report for each pay date in the review window. Obtain the payroll liability or tax report, funding notice, direct-deposit detail, employee check list where applicable, provider invoice, bank statement or activity, and the relevant QuickBooks general-ledger detail. Use only the payroll access granted to the role; do not download employee data that the review does not require.

Record report names, pay period, pay date, entity, bank account, run identifiers, and export times. Limit employee-level details in the working schedule. The reconciliation usually needs aggregate net pay and deduction totals, transaction identifiers, and settlement dates, not Social Security numbers, bank instructions, or other sensitive fields.

QuickBooks’ payroll reports guidance describes available payroll reporting. The IRS employment tax recordkeeping page describes the records employers should retain. Those sources guide report retrieval and retention; they do not replace the company’s accounting design or approval controls.

Build the payroll-to-cash bridge

Give every payroll run its own section. Begin with the amount credited to payroll clearing by the authorized accounting entry. Then list the components expected to reduce clearing: direct-deposit funding, printed or manual checks, employee tax withholding remittances, employer tax payments, benefit or garnishment remittances if the setup routes them through clearing, and any other specifically documented settlement.

For each component, record:

• payroll run ID and pay date;
• source report and line reference;
• expected amount and settlement date;
• actual bank description, date, and amount;
• QuickBooks transaction type and reference;
• matched, outstanding, disputed, or correction-needed status;
• next owner and review date.

Do not net unrelated differences. A $420 missing tax debit and a $420 duplicate funding debit do not cancel each other operationally. They are two exceptions with different evidence, risk, and owners.

Consider a design firm with a September 30 payroll. Its provider reports $48,600 gross pay, $36,940 net pay, $8,760 employee withholdings and deductions, and $4,280 of employer payroll taxes. The provider withdraws $36,940 for direct deposits on September 29, $11,970 for combined taxes on October 2, and a $145 service fee separately. QuickBooks contains a $49,380 clearing credit under the accountant’s documented entry design. At September 30, the $12,440 remaining balance is not automatically wrong: it includes the combined tax funding expected October 2 plus $470 in benefit deductions due later. The $145 provider fee should not reduce payroll clearing unless the approved entry design says it should.

That example depends on the configured journal, so the preparer must show the arithmetic rather than copy a generic formula. If employer taxes are posted directly to a payable instead of clearing, the bridge changes. If benefits use separate liability accounts, they should not be forced into this schedule.

Match withdrawals carefully

Match on more than amount. Compare the bank description, trace or confirmation number, payroll run, settlement date, and funding account. Providers sometimes combine tax amounts across jurisdictions or split withdrawals by entity. Bank feeds may suggest a match to an existing entry, but the preparer should confirm the underlying payroll component before accepting it.

Watch for four common exceptions. First, an off-cycle payroll may produce a valid debit that is absent from the normal register packet. Second, a void or reversal may appear in the provider report before cash returns. Third, an insufficient-funds retry can create multiple bank attempts but only one successful settlement. Fourth, a manual payroll check can remain outstanding after electronic components have cleared. Each exception needs its own dated evidence.

If the bank feed has added a withdrawal as an expense while an approved payroll journal already recorded the liability, flag the possible duplicate accounting path. Do not delete, exclude, or recategorize it without approval. Preserve screenshots or exports of the original state and identify the proposed correction.

Reconcile by cutoff date

For a month-end review, calculate the opening clearing balance, credits from payroll postings, debits from settled payments, other approved activity, and ending general-ledger balance. Separately total the open supported items. The difference between the ledger balance and supported open items should be zero. If it is not, report the variance plainly.

Age open items by when they should have settled, not merely by transaction date. A tax debit scheduled two business days after payroll may be current. A direct-deposit amount that has remained open beyond the provider’s expected funding cycle deserves immediate review. Set an escalation threshold appropriate to the company and name the person authorized to contact the provider or bank.

Never solve a variance by changing a payroll date, editing an employee record, or posting a journal entry from inference. The payroll administrator approves payroll corrections; the accountant approves account mapping and journals; the owner or authorized signatory approves cash actions. A VA’s value is a complete, organized exception that lets those reviewers act quickly.

Deliver a reviewer-ready reconciliation

The cover note should state the cutoff date, payroll runs covered, opening and ending clearing balances, total supported outstanding items, unexplained variance, and number of exceptions. Follow it with the run-by-run bridge and links to the retained reports. Mark sensitive documents and store them only in the approved location.

For the design-firm example, the September 30 note could state: “One payroll run reviewed. QuickBooks clearing balance is $12,440. Supported outstanding items total $12,440: $11,970 combined tax funding scheduled October 2 and $470 benefit remittance due October 5. Direct-deposit funding of $36,940 cleared September 29. A separate $145 provider fee is recorded outside clearing. No unexplained variance.” On October 2, the preparer should match the tax debit and update the item, not rewrite the September 30 evidence.

Archive the final reviewer sign-off and any authorized correction with the original exports. Then maintain an exception log that shows repeated late tax withdrawals, duplicated bank-feed entries, or journals arriving after the review deadline. Those patterns help management fix the workflow instead of repeatedly cleaning the balance.

QBOAssistant’s payroll support services explain where administrative support fits, while the services overview helps owners define a broader handoff. To design a clearing reconciliation with explicit approval boundaries, contact QBOAssistant.

Sources

• QuickBooks: Run payroll reports
• IRS: Employment tax recordkeeping
• IRS Publication 15