Available for the following Payroll Plan: Standard, Premium
The Gross to Net Reporting feature allows you to create a report on your employees' earnings before and after deductions and statutory contributions (e.g. CPF) made in your organisation within a specific date range or pay schedule. You can also narrow the data down by employing entity and location. Lastly, you can also use this feature to download a CSV or Excel file of this data.
Getting started
- Click the Reports menu.
- Click the Gross to Net report button.
- Complete the following fields:
- Date range.
- Employee.
- Pay schedule.
- Pay categories.
- Location.
- Group by.
- Include monthly breakdown.
- Include all employees in one worksheet for export option.
- Include expenses.
- Show pay category units (ticked by default).
-
Click the Run report button.
Helpful Hint
You will now see your Gross to Net report at the bottom of your screen.
Helpful Hint
If you have chosen Include Monthly Breakdown in the report, you can click this arrow to see the breakdown.
Show pay category units
If your organisation has the pay category units feature enabled, a Show pay category units checkbox will appear in the report filters. This option is ticked by default, so units will appear alongside pay category amounts in your report automatically.
To run the report without units:
- Untick the Show pay category units checkbox before clicking Run report.
- The report will display pay category amounts only — no units columns.
To restore units, tick the checkbox again before running the report.
Note
Your choice applies to the current report run only. Navigating away and returning will reset the checkbox to ticked. This setting does not affect other users.
Downloading data
- Click the Reports menu.
- Click the Gross to Net Report button.
- Complete the following fields:
- Date range.
- Employee.
- Pay schedule.
- Pay categories.
- Location.
- Group by.
- Employing entity.
- Include expenses.
- Show pay category units (untick to exclude units columns from the export).
- Click the Download dropdown.
- Click the CSV option.
- Click the Reports menu.
- Click the Gross to Net Report button.
- Complete the following fields:
- Date range.
- Employee.
- Pay schedule.
- Pay categories.
- Location.
- Group by.
- Employing entity.
- Include expenses.
- Show pay category units (untick to exclude units columns from the export).
- Click the Download dropdown.
- Click the Excel option.
Explore related content
- Employee deduction reporting This payroll platform article will walk you through creating a report that you can use to analyse your employee deductions, such as CPF.
- Expense reimbursements reporting This payroll platform article will walk you through creating a report on employee expenses processed in a Pay Run within your business.