Most nonprofit leaders we work with have built a cash flow forecast the hard way. The treasurer asks how the organization 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 Medicaid reimbursement from two weeks ago has landed, and starts stacking payroll and program costs against it. The hard part isn’t the math. It’s that the bank balance includes restricted funds the organization 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. Nonprofit cash flow is unpredictable in ways a standard finance tool wasn’t built for, because money arrives as grant tranches, government contract reimbursements, donations, and program 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 nonprofit 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 nonprofit cash flow forecasts usually fail

When we dig into what went wrong with an organization’s last cash flow attempt, it almost always comes down to the same three mismatches. They’re structural features of how a nonprofit 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 foundation grant that has to be spent on the youth program, the government contract money tied to delivered services, and the unrestricted donations that can actually pay this period’s wages. On paper the organization looks comfortable. In practice, spending restricted money on payroll is a breach of the grant agreement and a finding waiting to happen at the next report or audit. The most common cash shock we see in nonprofits isn’t running out of money. It’s running out of unrestricted money while the bank balance still looks healthy.

Grant tranche and reimbursement lag. Funding rarely arrives when the work happens. Foundation grants pay in milestone tranches, sometimes partly up front and sometimes only after a report is accepted. Government contracts (Medicaid, state and county human-services agreements, workforce contracts) often pay on a cost-reimbursement basis, and the lag between delivering the service and the money landing is routinely weeks, longer when a claim is questioned. You paid the program staff two weeks ago. The reimbursement for their work clears next month. Multiply that across every program and the gap is real cash the organization has to carry.

Donation and seasonality swings. Recurring giving is the most predictable income a nonprofit has, right up until the year-end appeal, a giving day, or a single major gift distorts the month. If the organization leans on donations to cover the unrestricted side, the lumpiness of giving lands directly on the part of the balance that pays wages. Strong organizations 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 year-end statements and enough cash to make payroll next period 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 nonprofit

A 13-week cash flow forecast for a nonprofit 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 activities works, which recognizes revenue when you earn it (or when a grant is committed), not when you get paid. The cash forecast doesn’t care about what was recognized; it cares about what hit the bank, and which part of it you’re allowed to spend. The math 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 accounts. If it isn’t, the forecast will produce confident answers to the wrong questions.

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

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 report), the expected payment date, and whether the money lands restricted or unrestricted. When a report slips, the tranche slips with it, so the forecast moves that cash event later.

Government contract reimbursements. One row per contract (Medicaid, state and county human-services, workforce programs). Forecast reimbursements by the cadence you actually bill 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 recurring giving. Forecast conservatively off the trailing average. Flag appeals and year-end spikes as their own events. Treat a major gift as a reserve event, not a payroll line.

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

Payroll. One row per pay run. If you pay biweekly, that’s roughly six pay dates across 13 weeks. Include employer payroll taxes and benefits. Payroll is the line that goes out regardless of when a reimbursement clears, which is exactly why the forecast exists.

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

Subcontractor and partner costs. A separate row. Partner organizations and subcontractors 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 human-services organization: roughly 60% government contracts, 25% foundation grants, 10% donations and recurring giving, 5% program fees. Opening unrestricted cash of $320K. Contract reimbursements totaling $210K across the next four weeks. A $90K grant tranche expected in Week 5 once the mid-year report is accepted. Recurring giving steady at about $18K a month. Biweekly payroll of $215K including employer taxes. 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 organizations 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.

Nonprofit cash flow benchmarks we see in healthy organizations

Numbers without context are just numbers. Once you have a forecast running, the next question is how yours compares to organizations that don’t feel cash stress. Below are the benchmarks we consistently see across healthy nonprofits, grouped by total revenue 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. There’s no mandated reserve level, and the right number depends on how lumpy your funding is, but three to six months of operating costs in unrestricted cash is the range we see healthy organizations 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 reimbursement into a payroll emergency.

Debtor days (in plain terms, how many days on average between billing and the money landing) tell you how hard your cash is working. Heavily government-funded organizations run longer because contract reimbursement cycles are slower and questioned claims 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 revenue 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 organizations we work with, but yours may look different depending on your funding mix, subsector, and contract structure. A grants-heavy arts organization looks nothing like a Medicaid-funded human-services provider running on reimbursements, 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 organizations 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 organization is performing.

The weekly rhythm that turns the forecast into decisions

A forecast nobody runs is just a document. The difference between organizations that feel calm about cash and organizations 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 organization pulls the prior week’s actuals into the forecast, reconciles the variances (a claim was questioned, a tranche slipped because a report 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 revenue.” The forecast tells you exactly which claims or invoices, if they landed two weeks early, would keep Week 7 comfortable. That’s a more useful starting point than a general push on receivables. You’ll chase two Medicaid claims and one overdue grant report, 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 revenue, 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 organizations 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 grant reports 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 organization, 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 organizations that have cash stress every quarter and organizations 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 nonprofit 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 organization 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.