HR Headcount Reporting Automated
Leading auctioneer, Christies, came to xlteq to help streamline and automate their global headcount reporting. This included real-time clarification of total headcount coupled with detailed location status functionality.
The Problem - FTE (headcount) reporting
This task was typically an 8 day process conducted on a monthly basis. It often contained significant errors due to the heavy manual intervention required to create the report.
- Templates manually created and populated with data from HR system (Workday),
- Checked centrally
- Distributed to 40 departments for validation – typically updating leavers and joiners
- Collated centrally
- Consolidated data from templates manually imported (copied and pasted) into new excel listing
- Analysts manually filter excel list and create final reports for board