Quarter-End Payroll Review: Reports to Check Before Filing Form 941 and State Returns

Quarter-End Payroll Reconciliation Framework

Quarter-end filing is not merely a data entry task; it is a forensic audit of your ledger against your tax liabilities. Failure to reconcile before filing leads to costly amended returns (Form 941-X) and mismatch notices from the SSA. Follow this technical checklist to ensure accuracy.

Stop manual reconciliation errors: Automate your Form 941 filings and state tax compliance with our integrated payroll platform.

1. The Payroll Summary vs. General Ledger Audit

Before touching tax forms, you must verify that your internal records match your bank activity. Run a Payroll Summary Report for the specific quarter and compare it to your General Ledger (GL).

• Gross Pay Reconciliation: Ensure total gross pay matches the sum of all individual paychecks issued during the quarter.
• Tax Liability Check: Verify that the total federal income tax (FIT), Social Security, and Medicare withheld matches the total deposits made via EFTPS.
• Net Pay Validation: Confirm that the total cash outflow from your payroll bank account aligns with the net pay reported.

2. Form 941 Internal Audit Points

When reviewing your draft Form 941, pay specific attention to these high-error zones:

• Line 2 (Total Wages): This should include all taxable wages, tips, and other compensation. It must align with your state unemployment insurance (SUI) total gross wages.
• Line 5a-5d (Taxable Social Security & Medicare): Ensure you are using the correct wage bases. For 2024, the Social Security wage base is $168,600. Any wages above this should only be taxed for Medicare.
• Schedule B (Report of Tax Liability): If you are a semi-weekly depositor, the total on Schedule B must exactly equal the total taxes reported on Line 12 of Form 941. A discrepancy of even one cent will trigger an automated notice.

3. State-Specific Compliance Checks

State returns often require more granular data than federal filings. Review these reports before submission:

• SUI Wage Reports: Verify that employees are assigned to the correct work-site state. Cross-reference the state unemployment tax rate against your most recent rate notice from the state agency.
• State Income Tax (SIT) Withholding: Ensure SIT withheld matches the aggregate of your periodic state tax deposits.
• Local Taxes: In jurisdictions with local earned income taxes (e.g., PA, OH, KY), verify that the residency and workplace codes are updated for any employees who moved during the quarter.

4. Employee Data Integrity

Quarter-end is the final opportunity to catch errors before they propagate into year-end W-2s. Review your Employee Detail Report for:

• Social Security Numbers: Ensure no placeholder numbers (e.g., 000-00-0000) remain in the system.
• Fringe Benefits: Ensure taxable fringe benefits, such as personal use of a company car or group-term life insurance over $50,000, are recorded as imputed income.
• Terminated Employees: Confirm that final payouts and unused PTO liquidations were processed according to state-specific labor laws.

5. Final Filing Verification

Once reports are reconciled, ensure the filing method is secure. Always obtain a Submission ID or Confirmation Receipt for both federal and state filings. Archive these alongside your payroll register and tax liability reports for a minimum of four years to satisfy IRS record-keeping requirements.