The reconciliation report brings data together in one place, allowing you to see payroll values that would otherwise only be available in a limited format on a P32 report. This facilitates a more efficient end-of-period reconciliation process.
📌Note: This is only available for UK Payroll.
Configuration required
To enable access to the reconciliation report screen, enable the below menu options. To do this, follow the steps below in portal.
From the dashboard menu, select Security Dashboard.
Click Menu Profiles then in the search field, search for the menu profile assigned to the user applying filter e.g COREPORTAL_EMPLOYEE
Click the three-dot icon then select Manage Menu Options.
To filter the systems, click the filter
icon.
From the Filter By System dropdown menu, select CorePortal Pay.
Click Apply.
In the search field, search for the following menu option FINALREPORTS_MENU.RECONCILIATION.
Turn on the toggle for the menu option.
Run the report
After enabling the menu option, run the report. To do this, follow the steps below.
Click Manage Payroll then highlight the relevant pay group.
Click the Outputs tab then click Reports.
Click Reconciliation then fill in the following fields:
Company
Pay Group
Year
Tax Month - Only Payroll Periods in the selected Tax Month and Year will display.
Click Print then go to the Report Centre.
Open the .csv file.
Fields in the report
The fields in the report are as follows:
Section | Box Number | Field |
1/4 Income Tax | 1 | PAYE Income Tax |
2 | Student Loan Deductions |
|
3 | Postgrad Loan Deductions |
|
4 | Net Income Tax Due To HMRC (total of boxes 1 to 3) |
|
5 | Date Paid To HMRC |
|
2a/4 National Insurance Contributions | 6 | Gross National Insurance Contributions |
7 | Statutory Sick Pay (SSP) Recovered |
|
8 | Statutory Maternity Pay (SMP) Recovered |
|
9 | NIC Compensation on SMP |
|
10 | Statutory Paternity Pay (SPP) Recovered |
|
11 | NIC Compensation on SPP |
|
2b/4 National Insurance Contributions | 12 | Shared Parental Pay (ShPP) Recovered |
13 | NIC Compensation on ShPP |
|
14 | Statutory Adoption Pay (SAP) Recovered |
|
15 | NIC Compensation on SAP |
|
16 | Statutory Parental Bereavement Pay (SPBP) Recovered |
|
17 | NIC Compensation on SPBP |
|
18 | Total Deductions from NICs (total of boxes 7 to 17) |
|
19 | Net NICs Due To HMRC (6 minus 18) |
|
20 | Date Paid To HMRC |
|
3a/4 Apprenticeship Levy by Period | 21 | Earnings This Period before BIK |
22 | BIK Value This Period |
|
23 | Leviable Earnings This Period after BIK |
|
24 | Levy Rate % |
|
25 | This Period Levy before Allowance |
|
26 | Levy Allowance This Period |
|
27 | Levy Due This Period |
|
3b/4 Apprenticeship Levy YTD | 28 | Earnings YTD before BIK |
29 | BIK Value YTD |
|
30 | Leviable Earnings YTD after BIK |
|
31 | Levy Rate % |
|
32 | Levy YTD before Allowance |
|
33 | Levy Allowance YTD |
|
34 | Levy Due YTD |
|
4/4 Amount Due to HMRC as per Employer Payment Submission (EPS) | 35 | Net Income Tax (box 4) |
36 | Net NIC (box 19) |
|
37 | Net Levy Due (box 27) |
|
38 | Total Due (total of boxes 35 to 37) |
|
39 | Date Paid To HMRC |
|