Short answer
A not-for-profit cash flow forecast is a rolling 13-week projection of cash in (grant tranches, contract claims, donations, service fees) against cash out (mostly payroll, programs and overhead). Track restricted and unrestricted funds separately, because only unrestricted cash covers ineligible costs and timing gaps, and update the forecast every week.
Most not-for-profit leaders we meet 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 can spend only on eligible funded costs, 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 to measure it against, 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 unrestricted donations. Grants can also pay this fortnight’s wages where the agreement allows those costs. On paper the organisation looks comfortable.
In practice, spending restricted money on wages outside the funded program 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-funded work pays on a claim or reporting cycle. State community-services agreements and employment-services contracts pay against reports and milestones, and NDIS supports are paid only after the service is delivered and a payment request is made.
For NDIA-managed participants, the NDIA says valid claims from a participant’s recorded “my provider” are usually paid within 2 to 3 business days, and in about 10 business days otherwise or when a claim is checked; plan-managed claims add the plan manager’s own processing time. Before any of that, claims wait on rostering, timesheets and your own claim run. 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 under the accounting standards (for a grant, depending on its terms, when it is received or receivable or as you meet its obligations), 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: for each fund, opening cash plus its receipts minus its eligible payments equals closing cash, which becomes next week’s opening. Maintain restricted and unrestricted balances separately, then reconcile their sum to total cash. Do not add restricted receipts to the unrestricted closing balance. AICPA & CIMA recommend a rolling 13-week cash flow forecast for short-term cash planning. Thirteen 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.
The 13-Week Forecast Skeleton
A $4M community-services example: separate restricted and unrestricted cash
Here’s the row structure that works for most not-for-profits with a mix of grant, government and donated income.
Opening unrestricted cash balance. Total cash, less the restricted-fund balance you’re holding for eligible funded costs, 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 funding and NDIS claims. One row per funding source (state community-services agreements, employment-services contracts and, if you are a registered NDIS provider, NDIS claims). 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. If you pay fortnightly, that’s six or seven pay dates across 13 weeks. Include on-costs and superannuation: from 1 July 2026, under Payday Super, the super guarantee (12% of qualifying earnings) must reach each employee’s fund within 7 business days of each payday, so super now leaves the bank with each pay run rather than once a quarter. 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.
Tax and BAS. One row for the ATO, split across funds the same way as the payroll it relates to. If the $105K payroll figure is gross, net pay leaves on payday and the PAYG withholding (about $40K a month on roughly $2.4M of wages a year) is remitted monthly by the 21st as a medium withholder.
If the organisation is registered for GST, load the net GST payable or refundable on the BAS due date; most government grants paid under a binding agreement are taxable supplies, so the GST on them is collected and remitted, while an organisation making mostly GST-free supplies may be in a refund position. Add FBT instalments where staff salary package. Charitable work is generally exempt from payroll tax, but the rules vary by state, so check with your state revenue office.
Closing balances. Calculate unrestricted closing cash using only unrestricted receipts and payments. Calculate each restricted fund separately, including its eligible payroll, rent and other costs. Add those balances to reconcile total cash. Record any permitted transfer between funds in both columns without double-counting a bank movement.
A worked example. A $4M community-services organisation: roughly 60% government funding, 30% philanthropic grants, 5% donations and regular giving, 5% service fees. Opening unrestricted cash of $320K. Government funding and claims totalling $185K 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 $17K a month.
Fortnightly payroll of $105K including super, with PAYG withholding of about $40K going out by the 21st of each month and the BAS loaded on its due date. 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. Once the bookkeeping foundation is structured correctly underneath, with restricted funds properly segregated, much of the forecast can be drawn 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 what to measure.
Not-for-profit cash flow measures to track
Once you have a forecast running, the next question is what to measure it against. No regulator sets cash benchmarks for not-for-profits, so the useful comparison is your own trend, month on month, against targets your board sets. Four measures do most of the work.
- Unrestricted reserve, expressed as months of operating costs.
- Debtor days on contract, claim and service income.
- Restricted funds as a share of income, and of the cash you hold.
- Operating surplus margin on unrestricted activity.
A few reading notes.
The unrestricted reserve is the single clearest signal of resilience. The Australian Charities and Not-for-profits Commission (ACNC) says in its guide to charity reserves that no single level of reserves suits every charity: the board should assess its own risks, decide on an appropriate level, and be able to explain it. The level depends on how lumpy your funding is and what you would need to cover if a major funder paid late. 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 are rising, or sit well above your funders’ payment terms, the cash gap is almost certainly what’s causing the payroll anxiety, not your funding level.
A high share of restricted funds isn’t bad in itself. It just means more of the headline balance is committed to specified eligible uses, which makes the unrestricted reserve matter more, not less.
What good looks like depends 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 measures only mean something when the books are structured correctly, with restricted and unrestricted funds properly segregated and overhead separated from program costs. 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 Weekly Rhythm
30 to 45 minutes that turns a spreadsheet into three decisions
Step 1
Forecast update
Pull last week’s actuals in and re-roll the forecast forward by one week.
Step 2
Variance review
A claim was queried, a tranche slipped because an acquittal is still in review, an appeal came in light. Reconcile each.
Three decisions
Commit or hold
Is the Week 9 closing unrestricted balance comfortably above your floor? If yes, confirm the program hire. If tight, wait or fund it from a confirmed tranche.
Chase specific claims
Which two NDIS claims and one grant acquittal, if they landed early, keep Week 7 comfortable? A 30-minute task, not the whole ledger.
Diversify or restructure funding
When a single grant is a large enough share of income that losing it would break the budget (set a trigger your board agrees, for example 40%), or a contract pays slower than it costs to deliver, the forecast makes the risk visible in cash terms.
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 a large enough share of income that losing it would break the budget (set a trigger your board agrees, for example 40%), 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.
Many organisations start from the same place: a healthy-looking balance, a treasurer who can’t get a straight answer on whether payroll is safe, and an ED spending Sunday nights in a spreadsheet. What the rhythm 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.
FAQ: Cash flow forecasting for not-for-profits
What is a 13-week cash flow forecast for a not-for-profit?
A 13-week cash flow forecast for a not-for-profit is a rolling weekly projection of cash in and cash out, built around how funding actually arrives: grant tranches, government contract claims, donations and regular giving, and service fees. It tracks actual cash movements, not accrual entries, and it separates restricted and unrestricted cash, allocating wages and rent according to funding eligibility. Most organisations update it weekly on a rolling basis.
Why does a not-for-profit with a healthy bank balance still run short on cash?
Because the headline balance usually includes restricted funds the organisation isn’t allowed to spend on anything except the program they were granted for. Restricted funds can pay eligible payroll and overhead; unrestricted cash covers costs outside those conditions and bridges receipt delays. An organisation can hold a comfortable total balance and still be unable to make a fortnightly pay run if too much of that balance is restricted and the next unrestricted inflow is weeks away. The forecast surfaces that gap before it becomes a crisis.
What’s a healthy cash reserve for a not-for-profit?
There is no single right number. The ACNC does not set a figure; it says each charity’s board should assess its own risks, decide on an appropriate level of reserves and be able to explain why. Organisations with lumpier, more grant-dependent income generally need more. Measure the reserve against genuinely unrestricted funds, which means the books must separate restricted and unrestricted money correctly.
How is an NFP cash flow forecast different from a profit-and-loss or statement of comprehensive income?
A statement of comprehensive income recognises income under the accounting standards, regardless of when the cash arrives, and it doesn’t tell you which cash is restricted. A cash flow forecast records money when it actually moves and tracks the unrestricted balance specifically. An organisation can report an annual surplus while being unable to make next fortnight’s payroll, because the surplus is real and the spendable cash isn’t there yet. The forecast is the instrument that surfaces that timing and restriction gap.
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 reading the numbers with you. That’s what Visory Insights and a Business Performance Partner are for: a plain-English read of the numbers each month, turned into decisions. If you want to see what your own numbers look like through this lens, get your free financial health check and we’ll walk through your unrestricted cash position together.
Sources
About this article
Written by Jack Bickersteth. Published . General information for Australian businesses, not advice for your situation.
