How to Generate Employee Payroll Report (Singapore Payroll)

Audience & Scope

Audience: HR Admin & Payroll Managers

Module: Payroll & Reports

Country: Singapore

Pre-requisites: HR Module Permission for Reports Module and Payroll Manager access for Payroll Centers

Payroll reports provide essential insights into employee compensation and financial management. This article explains how you generate payroll reports for Singapore employee payroll, providing monthly and yearly data efficiently for each individual in an easy-to-export Excel format.

The report has two tabs:

• Individual (one employee at a time)

• Multiple (several employees at once, grouped by payroll centre). 

This step-by-step guide simplifies payroll reporting, ensuring accurate and efficient access to essential payroll data.

Steps to Generate Individual Employee Payroll Report

1. Navigate to Analytics > Report Builder

2. On the Report Builder page, locate Employee Payroll and click Create.

3. By default, you will be under the Individual tab. Select the specific employee and the period you want to generate the report for. You can choose a single month, multiple months, or year.

4. Click Export as Excel to download the individual employee report.

Below is an example of the report in an Excel file.

Steps to Generate a Report for Multiple Employees (Multiple Tab) 

Use the Multiple tab to generate a single report covering several employees at once, grouped by payroll centre.

1. On the Employee Payroll report page, click the Multiple tab.

2. Set the following filters:

• Country — select the payroll country (Singapore).
• Payroll Center — a multi-select list, scoped to the country you selected. Changing the country resets this selection and re-applies the default:
  
  • If only one payroll centre exists, it's auto-selected; if several exist, the first (alphabetically) is preselected; if none exist, the field shows "No payroll center available for Singapore".

• Start Month / End Month — defaults to January of the current year through the current month. The selected range cannot exceed 12 months; a longer range is rejected with "Only a 12-month date range is supported."

3. Use the employee multi-select to narrow the report to specific employees. By default, all employees are selected.

4. Employees are grouped under a payroll centre, with each employee collapsed into a single row.

5. Click the expand arrow next to an employee's name to reveal their full breakdown — pay items, Total Earnings, statutory deductions, PCB, and Net Pay — across the same monthly columns. If an employee has no value for a given pay item in a given month, it shows as 0.00.

6. Click Expand to fullscreen for a larger view while reviewing.

7. Click Export as Excel to download the report.

FAQ

Q: Can I mix payroll centres from different countries in one Multiple-tab report?

A: No. Payroll centres belong to a single country's statutory setup, so the Payroll Center selector only ever shows centres for the country currently selected — you can't mix Malaysia and Singapore centres in one report.

Owner:

Aqilah