Skip to main content
All CollectionsPayroll (SG)
Payroll Reports (SG)
Payroll Reports (SG)

How to download monthly and year-to-date payroll reports?

StaffAny avatar
Written by StaffAny
Updated over a week ago

Contents of this article are applicable to the following users

Tier: N/A

Product: PayrollAny

Platform: Web

Monthly payroll reports help you track your company's payroll for each pay period, while year-to-date (YTD) payroll reports show totals for the entire year. YTD payroll reports also help you fill out IR8A (annual employee tax summaries) and IR21 (monthly tax withholding reports) forms. Both are useful for budgeting, tax filing, and monitoring employee costs.

This guide will cover the following:


How to Download

Monthly Payroll Report

  1. Navigate to the Reports menu

  2. Select Payroll Reports on the left side menu.

  3. Click on the Monthly Payroll Report tab.

  4. Continue to select the month and year period

  5. Select the staff you want to include in the report
    Note: Staff listed in the Monthly Payroll Report page are those who have been included in the selected period payroll.

  6. Click on the Download button at the bottom right corner

  7. The file will be downloaded immediately

Year-to-date (YTD) Payroll Report

  1. Navigate to the Reports menu

  2. Select Payroll Reports on the left side menu.

  3. Click on the Year-to-date Payroll Report tab.

  4. Continue to select the year period

  5. Select the staff you want to include in the report

  6. Click on the Download button at the bottom right corner

  7. The file will be downloaded immediately


Definition of Column Headers (Monthly Payroll Report)

The monthly payroll report will be divided among each business entity, so there will be separate tables for each entity.

Column Name

Definition

Employee ID

Employee unique identifier

Name

Staff name used in the app

Employee Legal Name

Staff’s legal name

Bank

Bank used by staff to receive their payment. If staff is paid with another payment method, it will be shown as none.

Bank Account Holders Name

Staff’s bank account name

Account Number

Staff’s bank account number

Payment Remarks

Staff’s payment remarks set in employee profile (e.g. PayNow account number). If no payment remarks are set, it will be shown as none.

Citizenship

Staff’s citizenship setting

Join Date

Staff’s join date

Contract End Date

Staff’s resign date

Home Section

Default or main section that staff’s tagged to

Basic Pay (Salaried), Basic Pay (Hourly), Overtime Pay, Event Pay, Weekend Pay, EngageAny Cash Incentive

Additional pay item

Additional pay items come after the default pay item and are set as “Ordinary Wage (OW)” or “Additional Wage (AW)”.

Total Ordinary Wage

Total amount of Ordinary Wage (OW) pay items

Total Additional Wage

Total amount of Additional Wage (AW) pay items

Total Gross (OW + AW)

Total gross salary which is the sum of OW and AW

Additional Non-CPF Pay Item

Additional pay items that are set as “No CPF”

Total Net Additions/Deductions

All net (no-CPF) addition / deduction payable items

Employee CPF

SHG (CDAC, ECF, MBMF, SINDA)

Total Employee Statutory

The sum of Employee CPF and SHG

Employer CPF

SDL

Total Employer Statutory

The sum of Employer CPF and SDL

Take Home Pay

Total amount to transfer to the employees in the bank file.

Formula used: Gross Salary - Employee CPF - SHG + Net Addition/Deduction Items


Definition of Row & Column Headers (YTD Payroll Report)

Row Headers

Row Name

Definition

Employee ID

Staff unique identifier

Employee Name

Staff legal name

Business Entity

Business entity staff tagged to

Join Date

Staff’s join date

Contract End Date

Staff’s resign date

Home Section

Default or main section that staff’s tagged to

Basic Pay (Salaried), Basic Pay (Hourly), Overtime Pay, Event Pay, Weekend Pay, EngageAny Cash Incentive

Additional pay item

Additional pay items come after the default pay item and are set as “Ordinary Wage (OW)” or “Additional Wage (AW)”.

Total Ordinary Wage

Total amount of Ordinary Wage (OW) pay items

Total Additional Wage

Total amount of Additional Wage (AW) pay items

Total Gross (OW + AW)

Total gross salary which is the sum of OW and AW

Additional Non-CPF Pay Item

Additional pay items that are set as “No CPF”

Total Net Additions/Deductions

All net (no-CPF) addition / deduction payable items

Employee CPF

SHG (CDAC, ECF, MBMF, SINDA)

Total Employee Statutory

The sum of Employee CPF and SHG

Employer CPF

SDL

Total Employer Statutory

The sum of Employer CPF and SDL

Take Home Pay

Total amount to transfer to the employees in the bank file.

Formula used: Gross Salary - Employee CPF - SHG + Net Addition/Deduction Items.

Column Headers

Column Name

Definition

Pay Item

List of pay items staff tagged to for the whole year.

IR8A Code

Used to categorize different types of income paid to an employee. This helps with tax filing by pre-sorting income into relevant brackets.

Totals

Total amount for each pay item across the year.

January to December

Total amount for each pay item across the month.


Frequently Asked Questions

Q: How will staff with 2 entities show up in the monthly and YTD payroll report?

A: If staff is tagged to 2 entities, they will be included in multiple tables. Here’s an example of staff with 2 entities:

  • Monthly Payroll Report

  • Year-to-date Payroll Report

Q: Why can't I find some of the staff in the report page?

A: The staff that can be selected in the Monthly and Year-to-date Payroll Report page are those who are already included in the payroll within:

  • The selected period (Monthly report), or

  • At least within 1 month across the year (YTD report).

Did this answer your question?