Platform: Workday and Workday Adaptive Planning
Scope: review of an existing forecast model built by an earlier team
The business problem
The finance team forecast revenue in the planning model with confidence. The model also had sheets for headcount, direct cost, overheads, shared services and allocations, built by an earlier team. Finance did not know how to forecast those lines with it, or how a number travelled from revenue to the management P&L.
Existing architecture
Revenue is driver-based and split across several sheets, one for each billing method. Below revenue sit headcount inputs, operating metrics, direct costs, shared services and overhead sheets, with allocations to region and line of business, and summary reporting.
Why it happened
The model was broad and not documented. Nobody could say which accounts were loaded from Workday, which finance entered, and which the model calculated. The sheets existed. The path through them was unknown.
Design decision
We avoided an immediate rebuild and began with one representative revenue path. We separated loaded source values, planner-entered drivers, assumptions and calculated accounts, recording each conclusion as confirmed, plausible or still unverified.
Implementation approach
- Pick one programme and its exact intersection: level, region, line of business, line item and revenue category.
- On each sheet in the path, record the intersection, the input accounts, the loaded accounts, the formula accounts, the assumptions used, and where the output goes next.
- Mark each important account as loaded, input, assumption, formula or output.
- Follow revenue drivers into headcount and operating metrics, then direct cost, then allocations, then the P&L.
Controls and validation
We marked each finding with its evidence status. One formula was confirmed directly in the tenant. Others were marked likely or unknown until inspected. We did not describe the integration as confirmed until the data sources and loaders were inventoried.
Outcome
One representative revenue-driver path was mapped and a downstream review approach was agreed. The rest of the path, through payroll, allocations and the management P&L, is the next stage of the review.
Lessons learned
- One traced path teaches more than a review of every sheet.
- Write down what is confirmed and what is assumed. A guess recorded as fact misleads the next reader.
- The first question on any inherited model: what is loaded, what is entered, what is calculated.
Scope of the outcome
Representative revenue calculation path traced; full downstream mapping was outside the documented result.
EPMLogic | Implementation insight based on an anonymized scenario. Exact operational amounts and client details are intentionally omitted.