Free template

The 13-week
cash flow forecast.

Profit and cash are not the same thing, and the gap is where good companies get into trouble. Thirteen weeks is long enough to see a squeeze coming and short enough to stay accurate. This is the template we build for clients, ready to open in Excel or Google Sheets.

What's inside

  • A working Excel model, not a blank grid. Formulas built in: subtotals, ending cash, and revolver draw and repay against your minimum cash target
  • Weeks that fall below your cash floor highlight automatically, so a week-9 problem is visible today
  • Separate Actuals and Variance tabs. Enter what happened each Monday and the misses beyond your threshold flag themselves
  • The disbursement lines operators forget until they hurt (taxes, insurance, debt service, capex)
  • No macros, no lock-in. Opens in Excel and imports cleanly into Google Sheets

Get the template

We only use this to send the template and occasional operator notes. Unsubscribe anytime.

How to use it

  1. Set the Assumptions tab: start date, bank balance, minimum cash target, revolver. Five inputs, two minutes.
  2. Fill the yellow cells on the Forecast tab from your AR aging, payroll calendar, and AP due dates. Rough is fine for weeks 6 to 13.
  3. Every Monday, enter last week's real numbers on the Actuals tab and read the Variance tab. Misses beyond your threshold flag themselves.
  4. If a week turns amber or red, act now, while you have weeks of warning instead of days.

The background reading: what a 13-week forecast actually catches. If you want it built and running against your numbers, start a conversation.