Overview
A fast-growing enterprise with a complex, multi-department team structure needed real-time visibility into resource allocation, workload distribution, and productivity — but was operating entirely on disconnected, manually-maintained spreadsheets. Leadership was making resourcing decisions on intuition rather than data.
XLURSELF designed and built a 14-module integrated workforce intelligence platform in Excel VBA — a deliberate choice to work within the client's existing toolset, eliminating change management risk while delivering a system more capable than many paid HRMS tools.
Challenge
The organisation had no unified system for workforce planning. Leave records, performance data, workload allocation, project tracking, and management reporting were all maintained in separate spreadsheets by different team leads. Data was stale the moment it was entered.
Month-end management reporting took three days to compile — and by the time insights reached leadership, decisions had already been made without them. Two employees spent a combined 60% of their working week on data collation and report production. The HR and Finance teams had no shared visibility into the same workforce data.
Solution
We replaced the fragmented spreadsheet landscape with a single, integrated 14-module Excel VBA tool that serves as the organisation's unified workforce management platform. The tool handles leave management, workload allocation, performance tracking, resource planning, capacity forecasting, and automated MIS report generation — all from a single file with role-based data entry and a live executive dashboard.
The choice of Excel was deliberate. No software procurement, no implementation risk, no user retraining. The entire organisation was already proficient in Excel — we simply made it capable of doing far more than they thought possible.
How We Approached It
Cross-Functional Requirements Workshop
Structured sessions with HR, Finance, and Operations leads to map every reporting need, data source, and workflow pain point. Translated requirements into a module specification with prioritised delivery order.
Integrated Data Architecture Design
Designed the underlying data model to support 14 interconnected modules — master data tables, lookup architecture, and validation rules — ensuring consistency across all modules without duplication.
VBA Module Development (Sprints)
Built and delivered modules in three sprints: core workforce data first, then scheduling and tracking modules, then reporting and dashboard layers. Each sprint included user testing before the next began.
Executive Dashboard & Automated Reporting
Designed a live executive dashboard with visual KPIs and drill-down capability. Built one-click automated report generation that compiles the full monthly management pack in under 60 seconds.
Documentation, Training & Handover
Delivered comprehensive user documentation for all 14 modules, conducted training sessions for each user group, and provided a 30-day post-handover support period.
Impact
14
Integrated modules
One unified tool replacing 14+ disconnected spreadsheets — leave, workload, performance, planning, and reporting all connected.
2 FTEs
Freed for strategic work
The two employees previously spending 60% of their week on data collation now focus entirely on analysis and business partnering.
Same day
Management reporting
Month-end management packs that previously took 3 days to compile now generate in under 60 seconds with a single click.
Zero
Software cost
Entire platform built on existing Excel licences — no HRMS software purchased, no ongoing subscription costs.
Key Outcomes
- Single source of truth for all workforce data across HR, Finance, and Operations
- Real-time leave, workload, and capacity visibility for all team leads
- Automated monthly MIS pack generation — from 3 days to 60 seconds
- Standardised performance review process with consistent scoring methodology
- Capacity forecasting module enabling proactive hiring decisions
Facing a similar challenge?
Let's talk about what's broken in your finance operations. The first conversation is free, focused, and no-pitch.