Cash Flow Forecast Template for Nonprofits

Nonprofits often have healthy annual budgets and still struggle to make payroll in certain months. Grants pay in installments, reimbursement contracts pay in arrears, and most individual giving arrives in the last few weeks of the year. A cash flow forecast shows the months where the timing doesn’t line up, so the board can act before the bank balance forces a decision.

Why nonprofit cash flow is different

• Giving is seasonal. In many countries, a large share of individual donations comes in November and December.
• Grants arrive in installments. A $60,000 grant might pay quarterly, or only after reports are approved.
• Government contracts pay in arrears. You deliver the service, submit a claim and wait 30 to 90 days.
• Restricted funds can’t cover everything. Money given for a specific program can’t be used for rent or general payroll, even if it’s sitting in the bank.
• Events are lumpy. A gala brings in a lot at once but has costs weeks beforehand.

A worked example

An organisation with a $70,000 monthly budget runs mostly on donations, one foundation grant paid quarterly and a state contract paid in arrears.

Summer donations fall short of costs, while December brings in almost a full month of costs as surplus. The forecast lets the board agree in advance how much of December’s income is reserved for next summer, rather than treating it as a windfall.

How to build a nonprofit cash forecast

1. Forecast donations by month using past giving patterns.
2. List each grant with its installment schedule and any conditions.
3. Enter contract income in the month the claim is actually paid.
4. Separate restricted and unrestricted funds for key lines.
5. Add payroll, program costs, rent, fundraising and audit fees.
6. Set a reserve target, often three to six months of operating costs.

Common mistakes

Counting a grant as received when it’s awarded. Spending restricted money on general costs. Budgeting evenly across the year when giving isn’t even. And forgetting that the annual audit is a significant one-off cost.

What the template gives you

The Nonprofit template includes a Grant Schedule tab: list each grant, its amount, first payment month, number of installments and frequency, and it lays out the payments across the forecast automatically. Scenarios show what a weaker year-end appeal or a delayed contract payment would do to your reserves.

Key assumptions built into the Nonprofit template

• The Grant Schedule tab lists large, irregular payments with the month each starts, how many payments there are and how often they repeat. The example includes community foundation grant and state program grant. Each one is routed to the right line of the forecast, and there are spare rows for your own.
• 6 cash in lines and 7 cash out lines are already named for nonprofit businesses, and every one can be renamed or extended.
• The example figures follow a typical nonprofit year, busiest in December and November and quietest in January and February, so the tight months show up where they usually fall.

Every assumption sits in a yellow input cell, so you replace the example with your own numbers in minutes. The same figures flow through a 13-week weekly view, a 12-month monthly view and a 3-year outlook, and a dashboard shows your lowest balance, the weeks that fall below your minimum buffer and your cash runway.

Free or premium?

If you only need the basics, the free 12-month template or the free 13-week template will get you started today. The premium Nonprofit template saves the setup time and adds the tabs above, best and worst case scenarios, and an actual vs forecast tracker that shows where your forecast was wrong, so next month’s is better.

Nonprofit cash flow forecasting: questions

How many months of reserves should a nonprofit have?

Many nonprofits aim for three to six months of operating expenses in unrestricted reserves. Organisations reliant on a few large funders often need more.

How do restricted funds affect a nonprofit cash flow forecast?

Restricted funds can only be spent on their stated purpose. Track them separately so the forecast shows how much unrestricted cash is available for payroll and overheads.

When should grant income appear in a cash flow forecast?

In the month you expect the payment to arrive, not when the grant is awarded or the agreement is signed.