Au Payroll - Overtime report
Overtime Report by employee in one easy to read report
Managerment required a report to analyse overtime per employee over the course of a year - in one report. Only option in Xero is to run report employee by employee. (which would be incredibly time consuming)
A simple report would be -
- Rows would be list of employees
- Columns would be all the overtime categories,
- values would be sum of hours worked (or dollar value or both)
- parametres would be between two given dates.
I could find no such useful report in Xero - instead I had to download the activity report into XL which was over ten thousand rows, then spend over half an hour deleting non overtime rows and format it in order to run a pivot table to get said report.
It seems to ridiculous that all this info is in Xero and should be reportable within seconds, instead it took me an hour. Furthermore - having to repeat all this every time I want an update.
thanks
Kristen
