Verify End of Year P60

At the end of each tax year, a P60 is generated with the employee's total earnings, tax paid, national insurance paid, and any statutory payments they have received for the tax year.

You can reconcile the figures using the P60 Audit Report, and the Run Year to Date Reconciliation Report. You can follow these steps:

1. Run the End of Year P60 Report.

   This will generate a P60 Audit Report XLS file. You will find this on the Run End of Year P60 Archive task. You can then compare this with the Run Year to Date Reconciliation Report.

2. Run the Year to Date Reconciliation Report.

   You need to ensure that a value is entered for the Tax Reporting Unit field. Else, the P60 values will not appear in the report.

3. Compare the P60 Audit Report and the Run Year End to Date Reconciliation Report.
   To ensure the values are accurate, compare the results in the P60 Audit Report, and the values in the Run Year End to Date Reconciliation Report. The values should match as shown here:

   P60 Audit Report	Year to Date Reconciliation Report
   In this employment - Pay	Taxable Pay - Payroll
   In this employment - Tax	Tax Paid - Payroll
   National Insurance contributions in this employment: NI Category Earnings at the Lower Earnings Limit (LEL) Earnings above the LEL, up to and including the Primary Threshold (PT) Earnings above the PT, up to and including the Upper Accrual Point (UAP) Earnings above the UAP, up to and including the Upper Earnings Limit (UEL) Employee's contributions due on all earnings above the PT	NI Category 1 LEL: Payroll NI Category 1 PT: Payroll NI Category 1 UAP: Payroll NI Category 1 PT: Payroll NI Category 1 Employee Contributions
   Statutory Payments: Statutory Maternity Pay Ordinary Statutory Paternity Pay Additional Statutory Paternity Pay Statutory Adoption Pay	SMP: Payroll OSPP: Payroll ASPP: Payroll SAP: Payroll
   Other Details: Student Loan	Student Loan: Payroll

4. Validate values in the Run Year to Date Reconciliation Report:

   The Run Year to Date Reconciliation Report is populated with a P60 column, which shows the P60 value and a column which will show the value of any discrepancy. The discrepancy value should be zero.