Contents of this article are applicable to the following users
Tier: N/A
Product: PayrollAny
Platform: Web
Access Level: Owner
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
How to Download
Monthly Payroll Report
Navigate to the Reports menu
Select Payroll Reports on the left side menu.
Click on the Monthly Payroll Report tab.
Continue to select the month and year period
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.Click on the Download button at the bottom right corner
The file will be downloaded immediately
Year-to-date (YTD) Payroll Report
Navigate to the Reports menu
Select Payroll Reports on the left side menu.
Click on the Year-to-date Payroll Report tab.
Continue to select the year period
Select the staff you want to include in the report
Click on the Download button at the bottom right corner
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: |
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: |
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:
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).