Forecast model and formula errors
Operational Before 16 After 6Formulas are broken, overwritten or linked to the wrong ranges in budget and forecast models, so totals and projections mislead the people who make spending decisions.
Who or what is affected: Budget owners, board members and lenders
Causes
Manual links, copied sheets and large models built and extended over several years.
Consequences
Overspending against approved budgets, poor hiring decisions and loss of trust in forecasts.
Existing controls
- Model totals are checked against the ledger each month.
- Each model is built by an analyst from a standard template.
Control gaps
Model changes are not logged, and no second person checks structural edits.
Additional controls
- Prevent: Lock formula cells and protect the template so only the planning lead can change its structure.
- Detect: Run a formula audit and compare key totals with an independent calculation each quarter.