How to reconcile Payroll Liability payments that hit the checking account with the component amounts generated from the Payroll Module.

Illinois_Farmer · ‎January 09, 2026

I do not have QuickBooks make direct payroll liability payments to my company's state department of revenue account, nor to my IRS EFTPS account. Thus, within QuickBooks, there is no link between the payroll liability payments and the individual amounts that comprise those payments. I read in another QB Help that I should delete the payment transaction that hits the checking account, and use the amounts in the payroll liability sub-accounts in the bank reconciliations.

I file IRS and state Dept of Revenue reports quarterly, so I have monthly amounts and monthly sub-account amounts in the large quarterly payment amounts.

I have a hard time matching these small amounts to the payment amounts -- quickly -- so I can reconcile my business's bank statements quickly and efficiently each month. If someone has an SOP and a spreadsheet that they use to execute this process, I would be very interested in learning how you do it. This should be easy for me, but it's not. Thank you!

oliviacarter · ‎January 10, 2026

This is a common issue when payroll liability payments are made as lump sums outside of QuickBooks.
The cleaner approach is to reconcile using the payroll liability accounts, not the single bank transaction itself. In practice, you keep the bank payment as-is, then match it against the combined balances of the payroll liability sub-accounts for that period.
What helps is running a Payroll Liability Balance Report for the same date range and using that as your reference during reconciliation. That way, you’re validating totals instead of trying to match each small component individually, which saves a lot of time.

Topics

Training

Community

Resources

How to reconcile Payroll Liability payments that hit the checking account with the component amounts generated from the Payroll Module.

How to reconcile Payroll Liability payments that hit the checking account with the component amounts generated from the Payroll Module.

Need to get in touch?