Nonprofit Cash Flow Template

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.

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.