Free · A Google Sheet

The 13-week cash forecast

Live in your forecast, not your bank balance. The balance tells you what already happened. This sheet shows where your cash is headed for the next 13 weeks, and the week it gets tight, while there’s still time to act.

Get the sheet

Free, with my weekly newsletter. Your copy is private to you.

13-week cash forecast
WeekWk 7Wk 8Wk 9Wk 10
Sales in$69,000$71,000$68,000$74,000
Supplier payments$9,000$14,000$0$118,000
Everything else$38,800$70,000$44,200$74,400
Cash at week’s end$195,600$182,600$206,400$88,000
Weeks 7 to 10 of 13, from the example tab. Made-up numbers. Week 10 ends below the $100,000 line set at the top, so it turns red.
  1. Put this Monday’s cash in week 1Then what you expect to come in and go out each week. Supplier payments go in the week they’re due, not the week you order.
  2. Pick the number that makes you actDecide it now, while nothing is wrong. Any week that ends below that number turns red.
  3. Check it against the bank weeklyWrite down why anything is off, then roll it forward a week. A forecast nobody checks drifts.

Why 13 weeks

Growth eats cash before it makes cash

The next order is sized for the bigger business, and the cash in the bank is from the smaller one. That’s why the tightest week usually comes right when sales look good. Thirteen weeks is far enough out to see it coming and close enough to plan every line.

Free · Your copy

Get your copy of the sheet

Put in your email and I’ll give you the link. Make a copy and it’s yours. It comes with an example tab filled in, so you can see how it reads.

Free. You’ll also get The Consumer Engine, my weekly newsletter. Unsubscribe any time.