📥 Free Download
Nonprofit Cash Flow Projection Template
A working Excel model, not a blank grid. Twelve months of formulas that chain month to month, a 13-week view for when things get tight, and an automatic flag whenever you drop below three months of expenses on hand.
Download Excel Template →
+ How-To Guide PDF
Format: Excel + PDF
Excel Tabs: 4
Formulas: Built in
Updated: September 2026
XLS+PDF
Cash Flow Projection Pack
4 tabs + 2 pages · ~160 KB · 100% free · No signup required
What’s Inside the Template
A nonprofit can be solvent on paper and still miss payroll. Your statement of activities answers whether the year worked. A cash flow projection answers whether next month does. Only one of those questions wakes people up at night, and it is not the first one.
Excel · Tab 1
12-Month Projection
- Nine revenue lines, twelve expense lines
- Each month’s opening pulls the prior close
- Net change and closing calculate themselves
- Months of expenses on hand, per month
- WATCH flag below three months
- You fill only the blue cells
Excel · Tab 2
13-Week Cash
- Weekly detail for tight stretches
- Confirmed receipts kept separate from expected
- Payroll on its own line
- Chained week to week like the monthly view
- Catches the three-payroll month
- Use it only when you need it
Excel · Tabs 3–4
Assumptions & Sources
- Grant timing: signed versus applied for
- Reimbursement lag in weeks
- Seasonality of individual giving
- Pledge collection rate and timing
- How much closing cash is restricted
- Every benchmark cited to its source
Four Things That Make Nonprofit Cash Flow Different
Generic small-business cash flow templates miss all four of these, which is why they tend to be optimistic in exactly the wrong months.
Difference 1
Pay first
Reimbursement runs backwards
Government grants generally pay after you spend. You front the money and wait for the draw. A fully funded program can still open a cash hole for the weeks between spending and reimbursement — and the more successful the program, the bigger the hole.
Difference 2
Not yours
Restricted cash is not available cash
Under FASB ASU 2016-14, net assets with donor restrictions are reported separately. Money sitting in your account for a restricted purpose still shows in the bank balance — and still cannot pay the electric bill. Subtract it before you project.
Difference 3
Q4 heavy
Giving is seasonal, spending is not
A large share of individual giving arrives in the final weeks of the calendar year, while payroll and rent are flat. The result is that most organizations run their thinnest months in late summer and early fall — exactly when nobody is thinking about cash.
Difference 4
≠ cash
A pledge is revenue, not money
An unconditional pledge is recorded as revenue when it is promised. It becomes cash when it arrives. The gap between those two dates is invisible on the income statement and is where organizations get surprised.
How Much Cushion Is Enough
The most cited benchmark comes from the Nonprofit Operating Reserves Initiative (NORI) Workgroup: a minimum operating reserve ratio of 25%, or roughly three months of the annual expense budget — measured at the lowest point in the year, not at year end. The template flags any month that falls below it.
But read the caveat with the number. The same workgroup concluded there is no one-size-fits-all benchmark, and recommended that every organization adopt a written reserve policy defining its own adequate level. An organization living on one government contract that pays in arrears needs a very different cushion than one funded by monthly recurring donors. Three months is where the conversation starts, not where it ends.
Who This Template Is For
ED
Executive Directors
You want to know the answer to “can we make payroll in March” before March, not during it.
TR
Board Treasurers
The board asks how much runway there is. This produces a number you can defend rather than estimate.
BK
Bookkeepers
You see the reimbursement lag coming. This makes it visible to the people who decide about hiring.
GR
Grant Managers
You are about to accept a reimbursement-based award and need to know whether the organization can float it.
How to Use This Template
1
Start from the bank, not the books
Enter your actual bank balance after outstanding checks — then subtract restricted cash. A projection that starts from an inflated opening balance is wrong for all twelve months.
2
Keep confirmed and expected apart
Signed grant agreements are confirmed. Applications are not. Mixing them is exactly how a projection quietly turns into a wish.
3
Write the assumptions down
A projection nobody can question is one nobody trusts. When it turns out wrong — and it will — the assumptions tab tells you which one to fix.
4
Compare to actuals every month
Built once and never revisited, it is a document. Checked against reality monthly, it becomes a system — and your estimates get measurably better within a quarter.
Frequently Asked Questions
Is this really free?
Yes. No email address, no signup, no gate. Download either file directly.
Does the spreadsheet actually calculate, or do I have to build the formulas?
It calculates. Each month’s opening cash pulls from the previous month’s closing balance, totals and net change are formula-driven, and months of expenses on hand updates automatically. You fill in the blue input cells only.
How is a cash flow projection different from a budget?
A budget answers whether the year works overall. A cash flow projection answers whether you can pay people in a specific month. An organization can be fully on budget for the year and still run out of money in month seven, which is why the two documents are not interchangeable.
Should restricted funds be included in the projection?
Not in available cash. Under FASB ASU 2016-14, net assets with donor restrictions are reported separately, and restricted money in the bank cannot be used for general operating costs. Subtract it from your opening balance, or you will project a cushion you do not have.
How many months of cash should a nonprofit hold?
The Nonprofit Operating Reserves Initiative Workgroup suggests a minimum operating reserve ratio of 25 percent, or about three months of the annual expense budget, measured at the lowest point in the year. The same workgroup concluded there is no one-size-fits-all benchmark and recommends each organization adopt a written reserve policy setting its own adequate level.
When should I use the 13-week view instead?
Whenever a month looks thin. The monthly view smooths over timing, so a payroll that lands three days before a grant arrives is invisible. Weekly detail exposes it while there is still time to act.
What if a month projects negative?
Act early, because options shrink as the date approaches. Ask funders about accelerating a scheduled payment, arrange a line of credit while the numbers still look good rather than during the shortfall, and tell the board in writing with the projection attached.
Related Resources
Want someone watching the runway with you?
A projection is only as good as the books behind it. We keep the books, build the monthly projection, and tell you about the thin month while there is still time to do something about it.
Schedule Free Consultation →
