Productivity
Forecast cash
Thirteen weeks of in and out, with the week it gets tight.
Fill it in
Cash on hand, what is owed to you and by when, and what goes out.
How far out.
Model what happens if the big invoice slips a month.
Your prompt
Build a 13-week cash forecast. [your where you are] Weekly, not monthly. A month that ends fine can contain a Tuesday where payroll does not clear, and a monthly view cannot see it. The running balance by week is the entire output. Date the receipts by when money ACTUALLY arrives, not by the invoice date. Net 30 means day 45 for most clients, and a forecast built on terms rather than behaviour is optimistic in exactly the weeks that matter. Model the big invoice slipping a month, and say which week breaks. Call out the tightest week in a sentence at the top, with the number. That is the only line most readers need. Deliver an .xlsx with live formulas so a changed assumption redraws the balance.
Use Forecast cashOpens with everything above already filled in.
Why this works
A month that ends fine can contain a Tuesday where payroll does not clear, which a monthly view cannot see. This is weekly, dates receipts by when money actually arrives rather than by terms, and names the tightest week in one line at the top.
Questions
- Do I get a spreadsheet?
- An .xlsx with live formulas, so changing an assumption redraws the balance.