Is anyone aware of a report I could pull to view our headcount on a certain date in the past?
e.g. I would like to view who was on our payroll on a snapshot date of last April 4 2020 and would need the names, contracted hours and salary.
Alternatively if there is a way I could custom create this report and what values you would suggest adding to it?
The best way to view the required information is to create a custom report. In order to do this you will need to go to HR > Reports > Customised Reports > Create Template. Under Employee Details report group you would choose Forename and Surname as fields. Under Employee Work Details report group you would choose as fields: Start date, Is Payroll Employee, Salary, Pay Type, Hourly/shift amount, Contracted hours. Under Termination Details report group you would choose the Termination Date field. Select Run Report.
Once the report is ran, you would need to filter on the Start Date and Termination Date columns to display all employees that were attached to payroll on the specific date you need.
Please note that the Contracted Hours and Salary/Hourly/Shift rate will be the values available in the solution at the time you are running the report. If these values were updated since the past date required that information will not be available.
Hope this helps.
Please sign in to leave a comment.
Download Our App