The gross to net report is available from the 'Reports' home page under the 'Payroll Reports' section. It allows you to view a breakdown of total earnings, deductions and CPF for each employee over a given period of time.
Note: Only data from finalised pay runs will be included in the report.
The gross to net report allows you to filter for a range of different date periods including:
If you want to select a specific pay run instead of a date range, you can change to that filter by clicking the toggle button:
The other filters available are:
- Pay schedule: This will show all pay schedules that exist within the business
- Default location: This refers to the location set as the employees default on their Employee file > Pay run defaults page (as at the date the pay run is created).
- Employee: You are able to select a singular employee to filter for. You cannot select multiple employees.
- Pay categories: This will show all pay categories within the business.
- Group by: The options are to have no grouping, or to group by the employee default location
- Employing entity: If you have multiple employing entities in your business you are able to filter using all of them, or specific ones.
The report will then list each employee along a singular line and will show the total hours before breaking it down further to show the pay categories that the employee has gross earnings attributed to, and will show the value for each of these.
It will also provide the following totals:
- Total gross earnings
- CPF contributions. These include:
- Mandatory Employer CPF
- Mandatory Employee CPF
- Voluntary Employer CPF Contributions
- Voluntary Employer MediSave Contributions
- Withheld Amounts (including clearance and withholding tax)
- Total Gross plus Contributions. This includes the gross earnings’ for employees as well as the total value of ‘voluntary CPF Contributions’.
You can easily access the report filter and download button whilst scrolling through the report via a sticky filter, without having to scroll back to the top of the page. The sticky filter buttons will appear on the top right-hand side of the report when you scroll down the report:
Using this sticky filter, you can choose to change the filter parameters by clicking on the 'Filter' button and making the changes then clicking the 'Update' button. You also have the option to clear the filter completely to default by clicking the 'Clear filters' option at the bottom right-hand side of the sticky filter.
If you have any questions or feedback, please let us know via email@example.com