Nonprofit Cash Flow Template

Start with the 13-Week Cash Flow sheet. Download the file and open it in Excel or Google Sheets — no macros or plugins required. Enter your current operating cash balance in the starting balance cell, then fill in expected inflows for the next 13 weeks: scheduled grant disbursements, any pledge payments due, upcoming event proceeds, and routine program fee income. Most finance staff can complete this in 20–30 minutes using their grant award letters, pledge schedules, and bank statements from the prior two months.

Next, set up the Grant & Revenue Tracker. Enter every active grant, pledge, and major gift commitment — the funder name, total amount, payment schedule, and expected receipt dates. This is often the most revealing step: seeing all expected cash inflows on one sheet shows you exactly which months are healthy and which months depend on a single grant arriving on time. Update the tracker each time a payment arrives or a disbursement date shifts, and the 13-week projection will reflect the change automatically.

Use the Monthly Cash Flow and Dashboard together for board reporting. At the start of each month, enter last month's actuals — cash received by category and cash paid out by category — in the Monthly Cash Flow sheet. The Dashboard will update your operating reserve months, cash runway, and the fiscal year cash flow chart. Board treasurers and finance committee members typically review the Dashboard summary at monthly meetings, then drill into the Grant Tracker or 13-week view when they want detail on a specific funding gap or upcoming payment.

Nonprofits face a cash management challenge that most for-profit businesses don't: the gap between when expenses are due and when revenue arrives is built into the funding model. Payroll runs biweekly. Rent is due on the first. But grant disbursements arrive on foundation payment cycles — quarterly, semi-annually, or at grant milestones — and year-end donations concentrate in December. A well-run nonprofit with $800K in annual revenue can be eight weeks from an empty bank account in March simply because three grants are scheduled to disburse in April. Without a cash flow projection, that gap is invisible until it becomes a crisis.

The metrics that matter most to nonprofit financial health are different from for-profit businesses. Operating reserve months — how many months of operating expenses you could fund from unrestricted cash alone — is the primary liquidity indicator. Most financial advisors recommend three to six months of reserves; many smaller nonprofits operate with less than two. Program expense ratio measures what percentage of total spending goes directly to programs vs. overhead and fundraising — funders and rating agencies like Charity Navigator look for 75–85%. Fundraising efficiency tracks how much was raised per dollar spent on fundraising. This template calculates all three automatically and displays them on the Dashboard.

The most effective way to use this template is as a planning tool that runs ahead of your bank balance. Load the Grant Tracker with all anticipated disbursements for the next six months. Run the 13-week projection to see exactly when your ending balance dips below your target reserve threshold. Then you can act before the gap arrives: draw on a line of credit, accelerate a grant request, move up an event date, or reduce discretionary spending in a specific month. Finance staff who run this projection monthly consistently report that they stopped making reactive decisions and started managing liquidity on their own terms — which lets them focus on programs instead of cash emergencies.