Before You Start

This guide assumes you have access to detailed payroll reports (e.g., Form 941, state filings) and general ledger accounts in your accounting system.

Overview

20 min
Estimated Time
Intermediate
Difficulty
Monthly
Maintenance

What You’ll Learn

  • How to match payroll tax payments to liability accounts
  • Identifying and correcting payroll system setup errors
  • Steps for reconciling 941, SUI, and other payroll liabilities
  • Ensuring compliance and zeroing out liability balances

1. Preparation Steps

Before starting, ensure you have the following accounts and reports readily available:

Required GL Accounts (Liability Type)

  • Federal Withholding Payable
  • FICA Payable (Employee & Employer portions)
  • State Withholding Payable
  • State Unemployment Payable
  • Payroll Bank Account (Bank Type)

Key Payroll Reports

  • Payroll Summary Report (from your payroll provider)
  • Form 941 (Employer’s Quarterly Federal Tax Return)
  • State Unemployment Insurance (SUI) Quarterly Reports
  • General Ledger (GL) for all payroll liability accounts

2. Understanding Payroll Liabilities

Payroll liabilities represent amounts withheld from employees’ pay or accrued by the employer that are owed to government agencies.

Employee Withholdings

These are amounts deducted directly from an employee’s gross pay.

Characteristics:
  • Reduced net pay.
  • Must be remitted on time.
  • Federal & State Income Tax.
Common Issues:
  • Incorrect tax table setup.
  • Mismatch with employee W-4.
  • Late payment penalties.

Employer Tax Contributions

These are additional taxes paid by the employer based on gross payroll.

Expert Tip: Always differentiate between employee withholdings and employer contributions. While both are liabilities, they originate from different sources and reconciling them separately can prevent common errors. Accurate mapping in your accounting software is crucial.

3. Step-by-Step: Reconciliation Workflow

The goal is to ensure that the total liabilities posted from payroll runs equal the total payments made, resulting in zero balances for liability accounts after all obligations for a period are met.

Here is a sample payroll journal entry, showing how debits and credits affect accounts.

{
  "entry_date": "2025-09-30",
  "description": "Bi-weekly Payroll - Pay Date 2025-09-30",
  "debits": [
    {"account": "Wages Expense", "amount": 5000.00},
    {"account": "FICA Expense - ER", "amount": 382.50}
  ],
  "credits": [
    {"account": "Payroll Bank Account", "amount": 4500.00},
    {"account": "Federal WH Payable", "amount": 300.00},
    {"account": "FICA Payable - EE/ER", "amount": 765.00},
    {"account": "State WH Payable", "amount": 217.50}
  ]
}

4. Monthly Reconciliation Process

  1. 1

    Gather All Payroll Reports

    Collect your monthly/quarterly payroll summary reports and any tax filing confirmations (e.g., Form 941 deposit history, state SUI payments).

  2. 2

    Review General Ledger Balances

    Generate a GL report for each payroll liability account for the reconciliation period. Note the beginning and ending balances.

  3. 3

    Match Payments to Liabilities

    Compare the payroll tax payments made (bank debits) to the liability entries in the GL. Each payment should reduce the corresponding liability account.

  4. 4

    Identify and Investigate Discrepancies

    If any liability account does not zero out after all payments for the period, investigate the cause. Common reasons include missed payments, incorrect GL postings, or payroll system errors.

Common Error: Unpaid Balances Accumulating

A common issue is when a payroll liability account never reaches a zero balance. This often indicates a payment was not correctly applied to the liability, or there’s a mismatch between the payroll system and your accounting software’s GL mapping.

5. Final Review and Cleanup

Reconciliation Cleanup Checklist

  • All payroll liability accounts show a zero balance for the reconciled period.
  • Payroll tax forms (e.g., 941) align perfectly with GL entries and payments.
  • No old, unreconciled payroll entries or lingering balances exist.
  • Payroll system setup is verified to align with GL accounts for future periods.

Need Help?

Get Support

Having trouble with your payroll reconciliation? Our team of experts can help troubleshoot your specific challenges and ensure compliance.

Contact Us