Beginning Payroll Payable
$5,000.00
Carried forward from prior year
Current-Year Liability
$40,000.00
Generated from payroll
Total Payments
$40,000.00
IRS + State + Employees
Ending Payroll Payable
$5,000.00
Carry forward to next year
Reconciliation Difference
$0.00
Reconciled ✓
Payroll Liability Roll-Forward
Beginning Payable → Payments → Current Year Liability → Ending Payable → Next Year
Step 1
2025 Ending Payable
$5,000
→
Step 2
Prior-Year Payable Paid
$5,000
→
Step 3
2026 Liability Generated
$40,000
→
Step 4
2026 Liability Paid
$35,000
→
Step 5
2026 Ending Payable
$5,000
→
Step 6
2027 Beginning Payable
$5,000
Payroll Payable Roll-Forward
Beginning Payroll Payable
Balance carried forward from prior year
+ Current-Year Payroll Liability
Employee + Employer + Wage liabilities generated
− Total Payments Applied
Employee payments + IRS + State payments
Ending Payroll Payable
$5,000.00
Reconciliation Status
Payroll Reconciled
GL payable agrees with calculated payroll liability.
Calculated Ending Payable
$5,000.00
GL Payroll Payable
Difference
$0.00
Wages Payable
Gross Wages
$120,000.00
Employee Taxes
($24,000.00)
Expected Net Payroll
$96,000.00
Actual Employee Payments
($96,000.00)
Ending Wage Payable
$0.00
Federal Payroll Tax Payable
Federal WH
$12,000.00
Employee Social Security
$7,440.00
Employer Social Security
$7,440.00
Employee Medicare
$1,740.00
Employer Medicare
$1,740.00
FUTA
$600.00
Federal Payable
$3,850.00
California Payroll Tax Payable
CA PIT
$3,200.00
CA SDI
$1,320.00
CA SUI
$950.00
CA ETT
$90.00
State Payable
$1,150.00
Payroll Payment Reconciliation
| LIABILITY TYPE | PERIOD | LIABILITY | PAID | OUTSTANDING | DUE DATE | STATUS |
|---|---|---|---|---|---|---|
| Federal 941 | Q4 2025 | $3,500.00 | $3,500.00 | $0.00 | 01/31/2026 | Reconciled |
| CA EDD | Q4 2025 | $1,500.00 | $1,500.00 | $0.00 | 01/31/2026 | Reconciled |
| Federal 941 | Q4 2026 | $3,850.00 | $0.00 | $3,850.00 | 01/31/2027 | Not Due Yet |
| CA EDD | Dec 2026 | $1,150.00 | $0.00 | $1,150.00 | 01/15/2027 | Not Due Yet |
Reconciliation Formula