Charity Cash Flow Forecast: How to Build a 12-Month Forecast and Spot Funding Gaps

A charity can have enough income on paper and still struggle to pay the next salary run. A cash flow forecast answers the question a balanced budget cannot: will the right money be available when each payment actually falls due?

You do not need a complicated financial model to start. You need a reliable opening balance, realistic receipt and payment dates, and a habit of updating the forecast before a problem becomes urgent. This guide explains how to build a rolling 12-month charity cash flow forecast, test delays and turn low balances into clear decisions.

Our grant-budget guide covers what a project will cost, while our full cost recovery guide explains allocating shared support costs. Here, the focus is timing, liquidity and the cash you can actually use—not recalculating overheads.

What is a charity cash flow forecast?

A cash flow forecast estimates the money entering and leaving your bank accounts over a future period. It carries the balance forward so you can see when receipts may not cover payments. NCVO distinguishes budgets from cash flow forecasts: a budget considers income and spending overall, while the cash forecast considers when money reaches or leaves the bank.

Cash timing is not the same as accounting income

Where you prepare accruals accounts, recognising income is not the same event as receiving cash. An invoice might relate to work completed in one month but be paid later. A grant may arrive in instalments, subject to conditions or reporting. Follow your accounting framework for recognition, but use the expected payment date in the cash forecast.

Similarly, depreciation is not itself a bank payment. Buying equipment is a cash outflow when you pay for it, even if the accounting cost is spread over its useful life. Loan proceeds and repayments also affect cash differently from income and expenditure. Reconcile these differences with your finance lead rather than copying budget totals straight into monthly cash columns.

1. Establish the opening cash balance

Choose a clear start date and reconcile the relevant bank balances against your records. Check outstanding payments and receipts so the opening figure and future movements do not count the same transaction twice. If you consolidate several accounts, transfers between them are not new income or external spending.

Start with cash, not the value of buildings, equipment, unpaid invoices or all the reserves in the accounts. A useful forecast can show both total bank cash and the part available for each purpose.

Separate restricted and unrestricted cash

Money held for a restricted purpose is not automatically available for general bills. In its cash flow forecasting guidance, reviewed in January 2026, NCVO recommends tracking restricted funding separately because it cannot be spent on unrestricted purposes.

For example, £30,000 in the bank including £22,000 restricted to a particular project leaves £8,000 of unrestricted cash before other commitments. Those figures are illustrative. The restricted £22,000 can fund eligible costs under its terms, including any agreed support costs, but is not a general emergency pot.

Use separate forecast lines or schedules for material restricted funds, then reconcile them to the total. Do not treat every restricted receipt as unusable for everything, or combine restrictions so that one project's shortage is hidden by another's balance. Check your reserves policy alongside the forecast: accounting reserves and immediately available cash answer different questions.

2. Put receipts in the month they are likely to arrive

Build a receipt schedule from evidence. For each material receipt, record the amount, expected bank date, restrictions, conditions, confidence level and person responsible for following it up.

• Grants: use the instalment schedule and allow for acceptance, reporting or other payment conditions. An award letter does not always mean immediate cash.
• Contracts and fees: consider invoice dates, payment terms and the customer's actual payment pattern. Do not assume every invoice clears on its due date.
• Donations and events: reflect seasonality, settlement delays and the date money becomes available, not only the event date.
• Unconfirmed applications: label them clearly. Do not present hoped-for awards as secured receipts; show how the forecast changes if they do not arrive.

Record uncertain timing rather than disguising it. NCVO advises cautious assumptions, testing them with colleagues and keeping a written record. A sensible base case is useful; an optimistic spreadsheet labelled “confirmed” is not.

3. Schedule payments when cash will leave

Map payroll, employer costs, rent, supplier invoices, insurance, project spending and other commitments to their actual payment dates. Do not divide every annual cost by twelve: annual insurance, quarterly bills and equipment purchases can create sharp low points.

Include tax, pension, VAT and loan movements where relevant to your charity, taking advice on the correct treatment. Record bank receipts and payments on a consistent basis. For example, do not net card processing fees from receipts and also deduct them as separate payments. Where VAT applies, avoid mixing VAT-exclusive costs with cash payments that include VAT without accounting for the difference.

A payment's forecast date is not permission to defer it. If you propose a later date, get the necessary agreement and consider the consequences for staff, suppliers and beneficiaries.

4. Calculate opening and closing balances: a 12-month example

For each month: closing cash = opening cash + receipts − payments. The closing balance becomes the next month's opening balance. In November, £15,000 + £4,000 − £9,000 = £10,000.

Over twelve months, receipts total £128,000 and payments total £118,000. The net cash increase is £10,000, so £15,000 opening cash becomes £25,000 at the end. Yet December closes at only £3,000. The positive annual movement does not remove that low point.

Month-end balances can hide an earlier shortage

Suppose a grant arrives on the last working day of a month but payroll leaves a week earlier. A healthy month-end figure does not prove payroll was affordable. For tight periods, add weekly or dated movements and inspect the lowest balance before each critical payment.

5. Test a delayed receipt before it happens

Keep the base forecast and create a clearly labelled downside case. In the example, delay the entire £24,000 January receipt until February, with all payments unchanged. January then closes at £3,000 + £0 − £10,000 = −£7,000. February receipts become £30,000 (£6,000 plus the delayed £24,000), bringing its forecast closing balance back to £13,500.

That negative January figure is an unfunded cash requirement, not an available overdraft or permission to keep spending. Without an agreed, usable funding solution or changed timing, the forecast cannot be delivered as shown. Recovery in February does not pay January's bills retrospectively.

• Delay a major grant or contract receipt by one month, or remove an uncertain award entirely.
• Test lower unrestricted donations while keeping essential payments unchanged.
• Bring forward a major unavoidable payment or add a credible cost increase.
• Combine plausible adverse events; record the lowest usable cash balance and when it occurs.

Give each scenario an action and owner. Options may include discussing payment timing with a funder, securing genuinely available unrestricted support, agreeing a revised delivery schedule or seeking appropriate finance advice. Do not count an unapproved funding facility as a confirmed solution.

6. Agree warning triggers and decision dates

Choose triggers that reflect your obligations, not a universal “safe” bank balance. A useful trigger gives trustees time to act before a payment is missed.

• Low usable cash: an agreed minimum unrestricted balance is breached in the forecast. A hypothetical £6,000 threshold would flag December's £3,000 in our example; it is not a recommended minimum for other charities.
• Receipt uncertainty: a material instalment is overdue, a reporting condition is unmet or a forecast award remains unconfirmed close to a commitment date.
• Payment pressure: supplier balances increase, statutory payments risk being late or payroll funding is unclear.
• Restricted-fund pressure: the total bank balance is positive but cash available for the required purpose is insufficient.

NCVO's guidance on financial difficulty and cash flow highlights falling balances, increasing amounts owed to suppliers and late statutory payments as warning signs. If you may be unable to pay debts when due, alert trustees and seek qualified professional advice promptly; do not wait for the next monthly update.

7. Update monthly and keep a rolling horizon

NCVO considers monthly updates and a rolling 12-month outlook reasonable for small to medium organisations not in immediate financial difficulty. Review more often when liquidity is tight, receipts are uncertain or circumstances change materially.

• Replace the completed month’s estimates with reconciled actual bank movements.
• Compare actual receipts and payments with the saved forecast; distinguish timing differences from permanent shortfalls.
• Update the remaining assumptions and carry the actual closing balance into the next month.
• Add a new final month so the forecast continues to look twelve months ahead.
• Re-run the downside case and report low points, restrictions, proposed actions, owners and decision dates.

Save the previous version before updating it. If receipts repeatedly arrive later than forecast, change the timing assumption rather than carrying the same optimism into every new month. Connect recurring gaps to your funding strategy: a timing problem and an ongoing income shortfall need different responses.

Charity cash flow forecast: common questions

Can we use our annual budget as the forecast?

Use it as an input, not a substitute. Adjust for when grants, invoices, annual bills, capital payments and relevant tax or loan movements actually affect the bank. Keep both documents consistent with the same plans.

Does a positive bank balance mean we can afford a new project?

No. Check restrictions, existing commitments and the lowest forecast balance throughout delivery. Also confirm the project's full cost is funded: a cash receipt can temporarily hide an underlying funding gap.

Should we include grant applications awaiting a decision?

Keep their status visible. Show a prudent case without uncertain receipts and, if useful, a separate scenario with them. Do not make irreversible commitments on the assumption that an application will succeed.

What if the forecast goes below zero?

Identify the amount, timing and purpose of the shortage, escalate it and obtain appropriate advice. A spreadsheet is not a borrowing facility. Any proposed remedy must be agreed, lawful, available in time and consistent with funding restrictions.

Your next step: find the lowest usable balance

Start with reconciled cash, map the next twelve months and identify the lowest unrestricted and relevant restricted-fund balances. Then delay your largest expected receipt and ask what decisions would need to happen earlier. Record those decisions now, not when the account is already short.

This is general planning guidance, not individual accounting, insolvency or legal advice. Your finance lead or adviser should help with complex fund restrictions and urgent liquidity concerns. For a broader review of how clearly your project is positioned for funding, start with the site's free scorecard.