nonprofitcfotools ← all tools
Free Excel workbook · liquidity

13-Week & 12-Month Cash Flow Forecast

See the week your annual budget can't — restricted and unrestricted cash tracked separately, with reimbursement lag built into every revenue stream.

Get the workbook

Enter your email and the download appears below. No spam — occasional notes when new tools ship. See our privacy policy.

Excel · .xlsx · formulas only, no macros
Something went wrong — please check your email and try again.
Download the Cash Flow Forecast
Start with the Read Me tab, enter your numbers on the Assumptions, Revenue Streams, and Expenses tabs — the forecasts and Board Summary update from there.
The cash flow forecast: a 13-week trajectory with the lowest-unrestricted-cash point called out, restricted and unrestricted balances tracked on separate lines, and reimbursement lag applied to each revenue stream.
The weekly view — lowest unrestricted point flagged, restricted cash kept separate.
What it shows your board

The number an annual budget can never surface.

01

The 13-week trajectory

Week-by-week cash out to the horizon, with the lowest-unrestricted-cash point called out on its face — the week you'd run tight, named before it arrives instead of after.

02

Restricted vs. unrestricted, always split

Restricted and unrestricted cash tracked on separate lines at every point — never collapsed into one blended balance that hides whether the money you're looking at is actually yours to spend.

03

Reimbursement lag on every stream

Each revenue stream carries its own lag, so grant and contract cash lands in the week it actually arrives — not the week it was earned. The gap most forecasts quietly ignore.

How it's built

One engine, two views, checked cell for cell.

Formula-only · no macros or VBA Single engine feeds weekly & monthly Validated cell-for-cell vs. a hand-built reference Restricted vs. unrestricted throughout Reimbursement lag per stream Ships with near-miss demo data Opens on locked-down org machines

Know the tight week before it's this week.

Get the workbook