[PR] Balancing Reports for Quarterly and Year-End Processing

Created by Crystal Ann Harvey, Modified on Fri, 24 Oct at 2:49 PM by Crystal Ann Harvey

To ensure payroll accuracy throughout the year and at year-end, the following reports within Vista Payroll should be used to verify and reconcile federal, state, and insurance-related balances.

1. Reports to Balance Form 941

PR Employee Accumulations – Verify that eligible deduction amounts align with taxable wages for Federal, Social Security, and Medicare.
PR Federal Tax Liability – Should reconcile with the Schedule B report.
PR 940/941 Information – Uses FICA deduction for taxable wages.
PR 941 Schedule B – Confirm that paid dates align with paid months by comparing against the PR Employee Sequence Detail and PR Check Register reports.

2. Reports to Balance FUTA/SUTA

PR Employee Accumulations – Ensure subject amounts match FUTA/SUTA wages in the PR Unemployment Report.
PR Employee Sequence Detail Report – Check for calculation errors, overrides, or limits being ignored.
PR Unemployment Report – Displays amounts included in the electronic file.
PR Tax Report – Run for any deduction or liability code to confirm accuracy.
Tip: Verify FICA Social Security limits and rates are correct.
PR 940 Schedule A – Review for federal unemployment reconciliation.

3. Reports to Balance Insurance and Workers’ Compensation

PR Employee Accumulations – Review gross and subject wages.
PR Insurance Report by Insurance Code – Gross amount reflects total wages; subject amount includes earnings subject to insurance calculations.
PR Tax Report – Useful for verifying deduction and liability code calculations.

4. Reports to Balance W-2s

PR Employee Accumulations – Confirm Federal, Social Security, and Medicare wage accuracy.
PR W-2 Process/Preview/Print – Use this report to validate W-2 totals prior to filing.