How to Build a Cash Flow Forecast for Your Not-for-Profit

Most not-for-profit leaders we work with have built a cash flow forecast the hard way. The treasurer asks how the organisation is tracking, so someone opens a spreadsheet on a Sunday night, pulls the bank balance into column A, tries to remember which grant tranche is due, checks whether the NDIS claim from a fortnight ago has landed, and starts stacking payroll and program costs against it. The hard part isn’t the maths. It’s that the bank balance includes restricted funds the organisation isn’t allowed to touch, so the number at the bottom is reassuring and wrong at the same time. The spreadsheet is out of date by Wednesday.

This is a rational response to a genuinely hard problem. Not-for-profit cash flow is unpredictable in ways a standard finance tool wasn’t built for, because money arrives as grant tranches, government contract claims, donations, and service fees on completely different clocks, and a chunk of it is restricted (money a funder requires you to spend only on the program it was granted for, not on anything else). The version of a cash flow forecast for a not-for-profit that actually works isn’t a one-off spreadsheet. It’s a weekly rhythm with a handful of rows that map how your funding actually arrives against how your costs go out, and that separates the cash you can use from the cash you’re only holding. This post walks through how to build it, what benchmarks to use, and what the weekly review looks like once it’s running.

Why not-for-profit cash flow forecasts usually fail

When we dig into what went wrong with an organisation’s last cash flow attempt, it almost always comes down to the same three mismatches. They’re structural features of how a not-for-profit is funded, not signs that anyone is doing their job badly. That framing matters, because the fix is structural too.

The restricted-fund trap. A standard bank balance lumps every dollar together: the philanthropic grant that has to be spent on the youth program, the government contract money tied to delivered hours, and the unrestricted donations that can actually pay this fortnight’s wages. On paper the organisation looks comfortable. In practice, spending restricted money on payroll is a breach of the funding agreement and a finding waiting to happen at acquittal (the report you give a funder at the end showing the grant was spent as intended). The most common cash shock we see in not-for-profits isn’t running out of money. It’s running out of unrestricted money while the bank balance still looks healthy.

Grant tranche and claim lag. Funding rarely arrives when the work happens. Philanthropic grants pay in milestone tranches, sometimes partly in advance and sometimes only after an acquittal. Government contracts (NDIS, state community-services agreements, employment-services contracts) pay on a claim cycle, and the lag between delivering the service and the money landing is routinely five to fifteen business days at best, longer when a claim is queried. You paid the support workers a fortnight ago. The claim for their work clears next month. Multiply that across every program and the gap is real cash the organisation has to carry.

Donation and seasonality swings. Regular giving is the most predictable income a not-for-profit has, right up until tax time, a year-end appeal, or a single major gift distorts the month. If the organisation leans on donations to cover the unrestricted side, the lumpiness of giving lands directly on the part of the balance that pays wages. Strong organisations forecast giving conservatively and treat any major gift as a bonus to the reserve, not a line they’ve already committed.

If any of these patterns sound familiar, it’s worth sitting with the deeper reframe: a surplus on the annual report and enough cash to make payroll next fortnight are two different questions that need two different instruments, and the second one is almost always the one missing.

How to build a 13-week cash flow forecast for a not-for-profit

A 13-week cash flow forecast for a not-for-profit is a weekly grid. Each column is a week. Each row is a category of cash in or cash out. The model uses what finance people call the direct method, a simple rule: only count money when it actually moves in or out of the bank. That’s different from how your statement of comprehensive income works, which recognises income when you earn it (or when a grant is committed), not when you get paid. The cash forecast doesn’t care about what was recognised; it cares about what hit the bank, and which part of it you’re allowed to spend. The maths is simple: opening unrestricted balance, plus inflows, minus outflows, equals closing balance, which becomes next week’s opening. The AICPA & CIMA treat the 13-week rolling forecast as the gold standard for short-term cash planning, because 13 weeks is long enough to see problems coming and short enough that the assumptions stay reasonable.

The skill is in which rows you use, how you forecast each one, and how you keep the whole thing fresh enough to trust. The rows below assume your bookkeeping foundation is structured correctly, with restricted and unrestricted funds tracked in separate cost codes. If it isn’t, the forecast will produce confident answers to the wrong questions.

Here’s the row structure that works for most not-for-profits across our typical range of $500K to $20M in total income.

Opening unrestricted cash balance. Total cash, less the restricted-fund balance you’re holding but not allowed to spend, as of the first day of Week 1. This is the number that matters. Pull it from the bank and the restricted-fund ledger, not from the headline balance.

Grant tranche receipts. One row per active grant. Each row forecasts the next tranche’s trigger (a date, a milestone, or an accepted acquittal), the expected payment date, and whether the money lands restricted or unrestricted. When an acquittal slips, the tranche slips with it, so the forecast moves that cash event later.

Government contract claims. One row per contract (NDIS, state community services, employment services). Forecast claims by the cadence you actually claim on and the lag you actually experience, not the contract’s stated terms. This is usually the largest and most timing-sensitive inflow.

Donations and regular giving. Forecast conservatively off the trailing average. Flag appeals and tax-time spikes as their own events. Treat a major gift as a reserve event, not a payroll line.

Service fee income. Where you charge for a service (program fees, training, social-enterprise trading), one row, forecast off the invoicing cadence and collection lag.

Payroll. One row per pay run. In Australia most organisations pay fortnightly, so that’s roughly six to seven pay dates across 13 weeks. Include superannuation and on-costs. Payroll is the line that goes out regardless of when a claim clears, which is exactly why the forecast exists.

Program delivery costs. Direct costs of running programs: materials, venue, travel, participant costs. Load them on the weeks they actually hit. Tag whether each is funded from a restricted grant or from unrestricted funds.

Sub-contracted and partner costs. A separate row. Partner organisations and sub-contractors usually invoice in arrears and get paid faster than your funders pay you. That timing mismatch is its own cash drain if you don’t model it.

Overhead. Rent, insurance, software, audit, utilities. Load the actual dates. Annual items like the audit fee or insurance renewal will skew a 13-week window if you miss them.

Closing unrestricted cash balance. Sum it up. The final row of each week, and the number the treasurer actually wants.

A worked example. A $4M community-services organisation: roughly 60% government contracts, 25% philanthropic grants, 10% donations and regular giving, 5% service fees. Opening unrestricted cash of $320K. Contract claims totalling $210K across the next four weeks. A $90K grant tranche expected in Week 5 once the half-year acquittal is accepted. Regular giving steady at about $18K a month. Fortnightly payroll of $215K including super. Program costs of $40K a month, most of it restricted-funded. A $25K partner invoice in Week 2 that a grant reimburses in Week 7. Overhead of $22K a month plus the annual audit fee landing in Week 9.

Built right, this forecast tells you by Week 2 whether Week 9 is going to be tight, and whether the tightness is a real shortfall or just restricted money you’re not allowed to use. That’s the instrument the Sunday-night spreadsheet never gave you.

You can build this whole thing in Excel. We’ve found with the organisations we work with that once the bookkeeping foundation is structured correctly underneath, with restricted funds properly segregated, most of the forecast populates itself from the existing ledger, and the weekly review becomes a short, focused conversation rather than a manual rebuild. Either way, it’s the weekly review where the value compounds, which brings us to benchmarks.

Not-for-profit cash flow benchmarks we see in healthy organisations

Numbers without context are just numbers. Once you have a forecast running, the next question is how yours compares to organisations that don’t feel cash stress. Below are the benchmarks we consistently see across healthy not-for-profits, grouped by total income tier. Treat them as directional, not as targets handed down by a regulator.

A few reading notes.

The unrestricted reserve is the single clearest signal of resilience. The Australian Charities and Not-for-profits Commission (ACNC) doesn’t set a mandatory reserve, and the right level depends on how lumpy your funding is, but three to six months of operating costs in unrestricted cash is the range we see healthy organisations hold. Running at break-even with no reserve every year isn’t prudence, it’s fragility, and it’s the thing that turns a single late claim into a payroll emergency.

Debtor days (in plain terms, how many days on average between sending a claim or invoice and the money landing) tell you how hard your cash is working. Heavily government-funded organisations run longer because contract claim cycles are slower and queries add weeks. If your debtor days sit well above the top of your tier, the cash gap is almost certainly what’s causing the payroll anxiety, not your funding level.

Restricted funds as a share of income climbs with size, and a high share isn’t bad in itself. It just means more of the headline balance is untouchable, which makes the unrestricted reserve matter more, not less.

These numbers reflect patterns across the organisations we work with, but yours may look different depending on your funding mix, sub-sector, and contract structure. A grants-heavy arts organisation looks nothing like an NDIS provider running on contract claims, and both can be well run. One caveat that matters: these benchmarks assume the books are structured correctly, with restricted and unrestricted funds properly segregated and overhead separated from program costs. Most organisations we meet don’t have this right at first. If your numbers look unusually high or low, the issue may be how the books are structured, not how the organisation is performing.

The weekly rhythm that turns the forecast into decisions

A forecast nobody runs is just a document. The difference between organisations that feel calm about cash and organisations that don’t is a weekly rhythm with someone who actually looks at it.

The rhythm is simple. Once a week, someone who knows the organisation pulls the prior week’s actuals into the forecast, reconciles the variances (a claim was queried, a tranche slipped because an acquittal is still in review, an appeal came in light), and re-rolls the forecast forward by one week. The whole thing takes 30 to 45 minutes. What comes out of it isn’t a board paper. It’s three decisions.

Decision one: commit or hold. If the Week 9 closing unrestricted balance is comfortably above your floor, you can confirm the new program hire or the contractor for the funded project. If Week 9 is tight, you wait, or you fund the commitment from a confirmed tranche rather than hope. Every executive director has committed to a cost because the grant looked locked in and the cash didn’t arrive on time. The forecast is the backstop.

Decision two: chase specific claims, not “chase income.” The forecast tells you exactly which claims or invoices, if they landed a fortnight early, would keep Week 7 comfortable. That’s a more useful starting point than a general push on receivables. You’ll chase two NDIS claims and one overdue grant acquittal, not the whole ledger. That’s a 30-minute task, supported by proper accounts receivable management that flags problem claims before the ED has to.

Decision three: diversify or restructure specific funding. When a single grant is more than 40% of income, or a contract consistently pays slower than it costs you to deliver, the forecast makes the risk visible in cash terms. That’s what funding-diversification and contract-renegotiation conversations need to be anchored in, rather than a vague sense that things feel tight.

We’ve seen this rhythm play out across organisations that arrived with the same dysfunctional relationship to cash: a healthy-looking balance, a treasurer who couldn’t get a straight answer on whether payroll was safe, and an ED spending Sunday nights in a spreadsheet. What changes isn’t the funding. It’s that the unrestricted picture becomes visible a quarter ahead, the acquittals get prepared as a running state instead of a deadline scramble, and the reserve starts to build because nobody is accidentally spending it. The same discipline applied on the reporting side compounds the gain across the whole back office.

The forecast itself doesn’t do those things. A weekly rhythm, a partner who knows the organisation, and clean restricted-fund accounting underneath do. The forecast is the instrument that makes each decision visible in time.

If your forecast is still a Sunday-night spreadsheet

The difference between organisations that have cash stress every quarter and organisations that don’t is almost never the size of their funding. It’s whether there’s a weekly rhythm that surfaces the unrestricted cash picture before it becomes a crisis. A cash flow forecast for a not-for-profit doesn’t have to be complicated. It has to be specific to how your funding actually arrives, honest about which money you can spend, built once, and run every week by someone who knows the organisation well enough to read what the numbers mean before the treasurer asks.

If you’re still building the forecast in a spreadsheet late on Sunday night, it’s not because you’re doing it wrong. It’s because you haven’t had a financial partner who builds this with you and runs it alongside you. That’s what Visory Insights is built for. If you want to see what your own numbers look like through this lens, book a Financial Performance Check and we’ll walk through your unrestricted cash position together.