All Collections
Indigo Payroll & Leave
Payroll FAQ
How to Export a Detailed Payroll Report to Excel
How to Export a Detailed Payroll Report to Excel

Learn how to export a detailed payroll report to Excel which include overtime concession taxation; how to show total hours in the report

Jake Ellis avatar
Written by Jake Ellis
Updated over a week ago

Overview

Detailed payroll reports provide in-depth information and calculations on your payrolls, including hourly or salary pay totals, overtime, overtime concessions taxation, adjustments, employee SSC and SSC contributions, maternity leave, employer VOPS, cheque number, and more.


Exporting a detailed payroll report

To export a detailed payroll report, go to the Payroll & Leave tab, then click on Payroll in the Reporting Section.

Tick the Payroll that you would like to issue the report for by using the check boxes on the left.

From the right, change the Report Type to "Detailed." 

To show total hours in your payroll report, select the Show hours box.

You can also choose to include all pay items in your system in the report. By checking the Show all pay items box, Indigo will include all pay items in the report, even if certain pay items have a value of zero for the given payroll periods.

From the bottom right, select Generate Data Only as Excel.

You can then sort and filter data as normal by using Excel features.

If you want Indigo to remember the settings for this report for future uses, check the Remember generated report settings at the bottom of the report setup panel.


Did this answer your question?