Your Q2 Reforecast Is Not Just a Spreadsheet Exercise

By Q2, assumptions need to meet reality.

For many charities and purpose-led organisations, this is the point in the year when the original budget begins to be scrutinised. Some income has landed, some has slipped, some opportunities remain plausible, but are less certain than they appeared at the start of the year.

The temptation is to treat the reforecast as a financial exercise: update the numbers, re-phase income, rebalance the spreadsheet and move on. That misses the point.

A credible reforecast should do something more important. It should establish what is financially true now, what is still genuinely deliverable, and which organisational conditions will determine whether the revised plan succeeds or fails.

A reforecast should test reality, not protect optimism

The purpose of reforecasting is not to make the numbers look more comfortable. It's to give leadership a clearer view of risk. That means asking harder questions:

• Which income assumptions are genuinely supported by evidence?

• Which opportunities have weakened?

• Where are renewals or major gifts exposed?

• Which operational constraints are affecting delivery?

• What decisions are still outstanding?

• What action is realistically possible within the remainder of the year?

If those questions are not addressed, a revised forecast may look more credible while still resting on the same unsupported assumptions.

The four lenses every reforecast should use

At Robson & Mitchell, we would test a reforecast through four connected lenses.

1. Financial Reality

Start with what has actually happened. Look at year-to-date performance, current commitments, cash, restricted and unrestricted income, liabilities and the assumptions sitting behind the remaining forecast. The key question is simple:

What is financially true now?

Not what was expected in January. Not what leadership hopes will happen. What is supported by current evidence.

2. Leadership & Governance

Income performance is often affected by decisions outside the fundraising team. A major opportunity may depend on CEO involvement. A proposal may be waiting for approval. A trustee introduction may have stalled. A proposition may need a decision that has been repeatedly deferred. A reforecast should therefore ask:

• Which decisions are required?

• Who owns them?

• Where is ambiguity slowing progress?

• Where are leadership behaviour or governance dynamics affecting performance?

A financially plausible plan can still fail if the organisation cannot make the decisions required to deliver it.

3. Operational Capacity

A revised target is only meaningful if the organisation has the capacity to achieve it. That means examining staffing, vacancies, portfolio load, delivery dependencies, bottlenecks and the practical ability of teams to execute the plan. There is little value in retaining income in a forecast if the operational conditions required to secure it do not exist. The question is:

Can the organisation realistically deliver the revised plan?

4. Income Performance

Finally, test the income itself. How much is genuinely secure? Which gifts or renewals are confirmed? Which remain exposed? What evidence supports the remaining forecast? Where is confidence based on donor behaviour, and where is it based on assumption? This is where optimism most often needs to be challenged.

Where AI can help

AI can be extremely useful in a reforecasting process, but only if its role is clearly defined. It can help teams:

• interrogate data and assumptions

• identify inconsistencies and anomalies

• structure variance analysis

• classify and summarise risk

• compare scenarios

• test consistency

• expose missing evidence

• draft management and board narratives

Used well, AI can act as an analytical challenger. But it should not become an automated decision-maker. It should not approve a forecast, decide whether income is genuinely secure, infer donor intent, invent explanations for variance or create false precision. The rule is straightforward:

If the evidence is missing, AI should identify the gap, not fill it.

Start with the evidence

The quality of any analysis depends on the quality of the input. A robust Q2 review should draw from more than just the fundraising pipeline alone. It should include financial, income, operational and leadership evidence. That might include:

• approved budget

• year-to-date actuals

• current forecast

• cash position and liabilities

• restricted and unrestricted income

• fundraising pipeline

• confirmed gifts and pledges

• renewal dates

• donor correspondence

• staffing and vacancy information

• delivery constraints

• known bottlenecks

• outstanding decisions

• approval dependencies

• material strategic assumptions

This broader view matters because high-value income rarely underperforms for one reason alone. The cause may sit in the pipeline, but it may just as easily sit in leadership behaviour, operational capacity, decision-making or proposition strength.

The real output is better decision-making

The strongest reforecast is not the one with the most sophisticated spreadsheet. It's the one that gives leadership a clear view of:

• what is secure

• what is exposed

• what has changed

• what is causing the variance

• what can still be influenced

• what decisions need to be made now

That's the difference between financial reporting and active performance management. A reforecast should reduce ambiguity. It should make risk visible. And it should leave the organisation with a plan that is not simply financially possible, but operationally and organisationally deliverable. Because by Q2, the objective is no longer to defend the original plan. It's to understand reality clearly enough to make better decisions.

For the full AI for Major Gifts Fundraisers #6: Reforecasting, Budgeting and Planning toolkit click here to apply the four-lens approach to your own Q2 reforecast.