Nonprofit Cash Flow Forecasting Guide +Template

Does your nonprofit always seem to be one slow month away from a crisis?

You're not alone. Cash flow is the #1 financial threat facing small and mid-sized nonprofits — and most leaders don't see the problem coming until it's already here.

The good news: a simple cash flow forecast changes everything. When you know what's coming in and what's going out, you can make decisions with confidence instead of anxiety.

This bundle gives you both the knowledge and the tools to get it done.

What's Included

📘 The Cash Flow Forecasting Guide (PDF)

A plain-English guide written for nonprofit leaders, bookkeepers, board members, and staff — not accountants. It walks you through:

• Why cash flow is different from profit and loss (and why that matters)
• The difference between a 12-month forecast and a 13-week rolling forecast — and when to use each
• How to build your first forecast, step by step, from scratch
• How to track actuals against your projections and course-correct early
• How to run "what if" scenarios so you're never blindsided by a delayed grant or an unexpected expense
• How to present cash flow information to your board in a way they'll actually understand

Each chapter builds on the last, starting from the basics and working up to the tools experienced financial managers use. Whether you're a first-time executive director or a seasoned nonprofit CFO, you'll find actionable guidance throughout.

📊 The 6-Tab Cash Flow Excel Template

No starting from scratch. Open the template, enter your numbers, and you're forecasting. Includes:

• Tab 1 — 12-Month Forecast: Plan your full fiscal year with 8 revenue categories and 11 expense categories. Monthly columns with annual totals. Opening and ending cash balance auto-calculate.
• Tab 2 — 13-Week Rolling Forecast: Your short-term early-warning system. Update it every Monday with actual results and roll the forecast forward. See cash crunches 3 months out.
• Tab 3 — Actuals Tracker: Record what actually happened each month. Side-by-side with your forecast in the Variance tab.
• Tab 4 — Variance Analysis: Compare projected vs. actual inflows and outflows. Twelve months of variance tracking with a notes section to document what happened and why.
• Tab 5 — Scenario Planning: Model five scenarios — grant delayed, grant falls through, revenue down 20%, expenses up 15%, worst case. Built-in assumption inputs so you can customize each scenario.
• Tab 6 — Board Dashboard: A clean one-page view for board meetings. Key metrics, 12-month balance snapshot, and a narrative summary section for the treasurer or ED.

All blue cells are inputs. All formulas are built and locked in. You just fill in your numbers.

Who This Is For

✅ Executive directors who want to stop worrying about making payroll

✅ Bookkeepers and finance staff who need a structured forecasting tool

✅ Board treasurers preparing for finance committee meetings

✅ Development staff who want to understand how grant timing affects cash

✅ Any nonprofit leader who has ever said "we have money in the bank but I'm still nervous"

What You'll Walk Away With

After working through this guide and template, you'll be able to:

• Build a 12-month cash flow forecast for your organization
• Maintain a 13-week rolling forecast to catch problems early
• Explain your cash position clearly to your board
• Run scenarios so you're prepared when something doesn't go as planned
• Know — not just hope — that you can make it through the tight months

Want to Go Deeper?

Pair this bundle with Nonprofit Financial Mastery — the book behind all three nonprofit guides — for a complete picture of nonprofit financial management. Add it to your order for just $14.99 (regularly $24.99).

This guide and template work for nonprofits of any size. No accounting degree required.