Performing periodic, month-end, quarter-end, or year-end balancing

Use the spreadsheet you created to log Payroll Register (PR141) payroll totals from each run to perform pay period, periodic, month end, quarter end, or year end balancing.

Balance month to date and quarter to date reports each period. If you find a discrepancy, you will be able to identify the discrepancy in that pay period. If you run quarter-to-date reports only once a quarter and find an error, the error will be more difficult to identify than when you balance reports each period.

Before performing periodic, month-end, quarter-end, or year-end balancing, create a log of Payroll Register (PR141) transactions for each run. Balancing a payroll cycle

Perform periodic, month-end, quarter-end, or year-end balancing

For pay period, periodic, month-end, or quarter-end balancing, validate totals you tracked on your spreadsheet of Payroll Register (PR141) transactions against the details from the reports listed below.


Balance your Monthly or Quarterly totals from PR141 against the figures in the following reports.
Report Title	Report #	Dates	Description	Use To
Payment Detail Listing	PR260	User Specified Date Range	A detail listing of payments for a specific quarter.	This report can be used to verify Gross Wages and New Wages for a time period with totals from PR141.
Employee Wage Report	PR270	User Specified Date Range	A Summary of wages for each employee for a date range.	Use to edit specific summary level types of pay data for a range of employees, in a date range by process level or department.
Deduction Report	PR275	User Specified Date Range	A report of deduction amounts, by payment for a specific quarter.	Use to troubleshoot errors This report can be run for employee totals or deduction totals.
Employee Deduction Report	PR276	User Specified Date Range	A report of deduction amounts and totals for a specific quarter.	Used to troubleshoot errors in deductions taken.
Quarterly Report	PR290	Qtr	A report of taxable wages and taxes withheld for a quarter.	Verify Taxable Wages totals from this report with Taxable Wage Totals from PR260. Quarterly and Year-to-Date Gross Wages from this report are Total Wages.
Unemployment Continuation Form	PR291	Qtr	A quarterly unemployment report of Social Security taxable wages, total wages, total taxable wages, excess wages, and weeks worked.	Verify Excess Wages with PR294. Verify Taxable Wages and tax withholdings from this report against output from PR297.
United States Balancing Report	PR294	Qtr	A report of wages and deductions by tax authority and class.	Verify Excess Wages with PR291.
W-2 Forms	PR297	Year	A report of year-to-date totals associated with W-2 reporting (summary or detail).	Verify Taxable Wages and tax withholdings from this report against PR290 totals for all four quarters. You can run this report at any time of the year for balancing.

For year-end balancing, validate totals you tracked on your spreadsheet of Payroll Register (PR141) transactions against the details from the reports listed below.


Balance your Grand Total All Quarters totals from PR141 against the figures in the following reports.
Report Title	Report #	Dates	Description	Use To
Payment Detail Listing	PR260	User Specified Date Range	Detail Payment listing for year dates.	Verify Gross Wages and Net wages for a time period with totals from PR141.
Year To Date Payment Report	PR265	Thru Date	Year-to-Date totals through a specific date.	Produce a report of Month-to-Date, Quarter-to-Date, and Year-to-Date open and closed payments.
Employee Wage Report	PR270	User Specified Date Range	Summary of wages for each employee for the year.	Edit specific summary level types of pay data for a range of employees, in a date range by process level or department.
Deduction Report	PR275	User Specified Date Range	A report of deduction amounts by payment, for a specific year.	Troubleshoot errors in deductions taken. Can be run for employee totals or deduction totals.
Employee Deduction Report	PR276	User Specified Date Range	A report of deduction amounts and totals for a specific year.	Troubleshoot errors in deductions taken.
W-2 Forms	PR297	Year	A report of year to date totals associated with W2 reporting in detail or summary style.	Verify Taxable Wages and tax withholdings from this report against PR290 totals for all four quarters. This report can be run at any time of the year for balancing.

Note: Use Payroll History - Year To Date (PR52.1) to view an employee's wages and deductions by payroll year.