A 13 week cash flow forecast works best when its simple, cash based, and updated weekly. For <50 employee businesses, I recommend a single rolling sheet with columns for Week 1-13 and rows for opening cash, cash in, cash out, net movement, and closing cash. Each Monday, week 1 is replaced with actuals, the weeks roll forward, and a new week 13 is added. Precision matters most in the first 4 weeks, weeks 5-13 can be directional.
The most important rule is to forecast cash timing, not accruals. Inflows should reflect when money actually hits the bank-customer receipts, subscriptions, and any confirmed payments. If income isnt high confidence, it stays out of the main forecast and is tracked seperatley as upside.
Line item granularity is where many forecasts either fail or succeed. On inflows, the top 5 customers should each have their own line, with all others grouped together. Late payments are customer specific risks, not average. Subscriptions should be seperated from project or one off revenue.
On outflows, certain items must always stand alone: payroll, payroll taxes, rent, cloud/SaaS costs, marketing spend, loan repayments, VAT or tax payments, and any capex. Smaller discrentionary expenses can be grouped. A good rule is: if delaying or accelerating an item would change a decision, it deserves its own line.
Variance tracking is the rela value driver. Each week, I compare forecast vs actual and note why the difference occured. In one case, a week 3 variance showed a major customer slipping payment by 10 day. that pushed projected cash below our minimum buffer in week 5 due to payroll and VAT timing. The decision wasnt drastic cost cutting, we paused discrentionary marketing for 3 weeks, negotiated a supplier payment extension, nad accelerated collections from smaller customers.
For businesses this size, maintaining a minimum cash buffer of 4 to 6 weeks of payroll and acting as soon as a future dip appears is what keeps forecasts useful and companies solvent.