To generate a payroll statistic report, follow the steps below:
You can apply the active employee query to generate the report for active employees only.
Go to the Payroll module and click on Reports.
Select Analysis Reports, and click Statistic Report.
Select Report by: Employee and select the Year and Period.
Click Preview.
Click Export. (If you wish to generate the report in Excel)
Click Export All and save the file.