Balancing pre year end Data Check report, Complete Update report and the Cumulative All report

Download the year end cleardown balancing spreadsheet.

Save to the local computer. Enter the figures.

Employee moved companies.

If during the year employees moved to another company their cumulatives will not be included in the employee cumulative report or the complete update report for the old pay group. Their cumulatives will be included in the Pre Year End Data Check report. The Employee Cumulative All report reads employees current pay group.

Pension tax limits.

Some employees may have exceeded the pension tax limit. To identify these employees, follow the steps below in back office.

This returns employees who have exceeded the pension tax limit.

Note: When employees are retrieved via this screen they are displayed one by one, please use the down arrow to scroll down to the next employee, keep going employee by employee until the No further records message is displayed.

The pre year end data check report does not match the employee cumulative all report:

The employee cumulative all report displays employee who have been paid under the current company. Where an employee joined with previous earnings and never has been paid they will not show on this report. Reconcile using employee cumulative current and previous reports instead.

Cancel payment.

If a cancel payment has been carried out after the final payroll run of the year then the complete update report will not match. The complete update report will include this payment.

Manually amending cumulatives.

If amendments have been made to employee cumulative record after the final payroll run then the reports will not match. To see if cumulative have been amended, run employee audit trail listing report. To do this, follow the steps below in back office.

Run payrolls.

Ensure that all payrolls have been completed for current tax year.

USC not matching across reports.

Refer to article USC on complete update report not matching the employee cumulative all report at end of year.

Check the Pre Year End Data Check PAYE521.csv for any negative Taxable / USCable values.

Depending on how an employee is processed a negative value may appear on the CSV but not on any other reports and will cause a reconciliation error.