Building a Forecasting & Budget Model for a Nonprofit Organisation

The Hidden Problem

Following the migration from Reckon to Xero, the organisation was operating without a reliable forward-looking financial framework. Historical data needed validation, budgeting lacked ownership, and department leaders had very little visibility into how their areas were actually tracking.

• No clear ownership of budgeting across departments
• No visibility into seasonal trends in income and spending
• No tools to support confident operational planning
• Limited clarity around long-term financial sustainability

Without structure or training, budgeting felt like an isolated finance task rather than a practical tool for planning impact and protecting the organisation's future.

The Practical Fix

• Recovered and rebuilt financial history
  Validated 12 months of profit and loss data across Xero and legacy Reckon records, resolved discrepancies, and identified the key income and cost drivers shaping performance.
• Created a rolling forecast model in Excel VBA
  Built a regression-based forecasting tool that projected revenue and expenses by category and updated monthly as new actuals came in.
• Developed departmental budget templates
  Designed planning tools aligned to project pipelines and historical trends so each department could set, monitor, and manage its own budget with more confidence.
• Delivered practical financial training workshops
  Ran tailored sessions to help managers read profit and loss statements, understand variances, and use forecasts to guide operational decisions.

The Result

• Budgeting became part of the culture, not just a finance task
• Leadership gained monthly visibility into financial position and future pressure
• The forecast model updated dynamically as live profit and loss data changed
• Managers began owning their budgets and applying financial insight to daily decisions
• Planning became more proactive, with clearer links between resources and impact

Why It Mattered

In community services, clarity over cash flow and sustainability is everything. The organisation needed more than a spreadsheet — it needed a financial system that linked past performance, future forecasting, and everyday operational choices.

By rebuilding the financial foundation from legacy data through to rolling forecasts, and pairing it with practical training, budgeting became an organisation-wide habit rather than a finance-only process. That gave leadership and managers a clearer way to align resources with mission and make better decisions sooner.

Implementation Snapshot

1. Validated historical financial data across Reckon and Xero after migration.
2. Built a rolling Excel VBA forecast model linked to actual performance.
3. Created departmental budget templates grounded in trends and project pipelines.
4. Trained managers to read P&Ls, track variances, and use forecasts in planning.
5. Embedded a regular budgeting and review rhythm across the organisation.

Key Takeaways

• Forecasting did not meaningfully exist after the migration from Reckon to Xero.
• A rolling forecast model created a clearer view of future financial direction.
• Department managers were trained and empowered to own their budgets.
• Leadership now tracks financial health with more consistency month by month.
• Budgeting became a practical, organisation-wide discipline rather than a siloed task.