CPF ordinary and additional wages reconciliation report

Pippa Bennet

Updated 05 March 2024 08:56

Partner Content Team

This report enables admins to self-serve to identify quickly which month of CPF contribution had AW CPF wages contributed and troubleshoot why the following month had no CPF AW being paid (basically tracing the root cause).

Generate the Report

Log into your payroll account.
Click on the Reports menu.
Select the CPF ordinary and additional wages reconciliation report from the Payroll reports section.
You then need to select how to filter the report then click Run Report.
The filters to choose from are: Basis Period, Employing Entity, Employee, Employee Default Location.
The results are displayed in the following columns:

Employee identity number
Employee ID
Employee name
Employee date of birth
Employee Legal Status
Employing entity
Month
Ordinary wages
Ordinary wages subjected to CPF
CPF contribution (Employer/Employee)
Additional wages
Additional wages subjected to CPF
CPF contribution (Employer/Employee)
Total CPF contribution (Employer/Employee)
Excess/voluntary contribution (Employer CPF/MediSave)

Important

The legal status with this report will referenced from the last known legal status within the pay period end date.

Export the Report

You have the option to export this report to Excel.

Click Download
Select Excel.
The file will automatically download.