Running CPF Reports and Files

This topic provides an overview of CPF reports and files.

Note: If you elect to use the delivered rules for Global Payroll Singapore, use only the employment instance in HR.

Page Name

Definition Name

Usage

Create CPF Reporting Data SGP Page

CPF PAL-Internet File Creation Page

Create CPF Line Report SGP Page

CPSG_CPF_RPTG_RC

Create the monthly CPF data that can be used for creating reports and files for submission to the CPF Board.

CPF Contribution Report SGP

CPSG_CPF_CONRPT_RC

Create multiple reports.

CPF Mthly Contribute List SGP Page

GPSG_CPF_CONLST_RC

Create a list of the contributions for all of the funds on a single report.

CPF Adjustment Report SGP Page

GPSG_CPF_ADJ_RC

Create a list of the CPF contributions on a single report.

To simplify the CPF reporting process, and the collection of the data needed for CPF reports and files, all the amounts needed from the Global Payroll processing results are stored in the GPSG_CPF_RSLTS table, using the writable array CPF WA RESULTS. The array puts all of the MTD amounts calculated for all of the CPF contributions and other related Global Payroll results into a single record (CPF Monthly reporting table).

Prior to running any of the monthly reports, you need to run the CPF Report Data Creation process. This process carries out all the required processing, such as identifying new hires and terminations, and determining the CPF account numbers. After that, you can produce the following reports and files, using relatively simple processes:

  • CPF/IRAS Line File.

    The CPF/IRAS Line File Creation process enables you to create a flat file in the format required for submitting monthly CPF payments to the CPF Board using the CPF/IRAS Line software.

  • CPF PAL Internet File.

    The CPF PAL-Internet File Creation process enables you to create a flat file in the format required for submitting monthly CPF payments directly to the CPF Board via the internet.

  • CPF Mthly Contributions Report.

  • CPF Contributions List.

    CPF Contributions List process creates a list of the contributions for all of the funds on a single report.

  • CPF Adjustments Report.

    CPF Adjustments Report process creates a list of the CPF contributions on a single report.

The GPSG_CPF_RPTG table is used for producing the CPF reports and files for submission to the CPF Board. It is populated when you run the monthly CPF Data Creation process.