Your 13-Week Cash Forecast Is the Only Report That Sees Trouble Coming

Your 13-Week Cash Forecast Is the Only Report That Sees Trouble Coming

Most cash problems announce themselves weeks before they arrive. Payroll is heavier next month. A big receivable is 60 days late. The quarterly tax payment lands on the same week as an insurance renewal. None of that is a surprise if someone is looking. All of it is a surprise if nobody is.

A 13-week cash forecast is the only report built to see those collisions coming. It is short, it is boring, and it is the single most useful financial document a small business can keep.

Why thirteen weeks

Thirteen weeks is roughly one quarter. It is short enough that most of the numbers are real — actual invoices, actual due dates, actual payroll runs — and long enough to see a problem while you still have room to react.

A monthly forecast is too coarse. A yearly budget is a wish. Thirteen weeks sits in the range where you can still call a customer, delay a purchase, or move a payment date.

What actually goes in it

Only cash. Not revenue, not margin, not accrual. Money arriving and money leaving, week by week.

  • Inflows: expected collections by customer and by week, deposits, draws, refunds, any financing
  • Outflows: payroll and taxes, rent, loan payments, supplier runs, card settlements, insurance, capital purchases
  • Opening and closing balance: every week ends with a real number
  • Minimum cash line: the floor you refuse to go below

If a line cannot be tied to a real due date or a real invoice, it does not belong in the forecast.

The collection assumption is where it breaks

Most forecasts fail for one reason: they assume customers pay on terms instead of on their actual behavior. If your largest account has never paid inside 50 days, do not forecast them at 30.

Build the inflow side from your own history. Take the last twelve months of receipts, calculate days-to-pay by customer, and use that. It is unflattering and it is accurate, which is what you want from a forecast.

How to keep it honest

  • Update it every week, same day, same person
  • Compare last week's forecast to what actually happened and note the gap
  • Keep a light version of actuals next to the forecast, not a separate model
  • Review the four weeks ahead, not the whole quarter, in working sessions

A forecast that is updated monthly is a historical document. The value is in the weekly loop, not the spreadsheet.

Warning signs it is already needed

  • You check the bank balance before making normal payments
  • Payroll timing feels tight more than once a quarter
  • You cannot say what next month's low point will be
  • Every large payment is a surprise
  • Decisions depend on when a single customer pays

None of these mean the business is in trouble. They mean the business has no early warning system.

The bottom line

Profit tells you whether the model works. A 13-week cash forecast tells you whether you can afford to keep proving it. Build one page, update it weekly, and let it drive the conversations you are already having.

If you want help building a cash forecast your team will actually keep up to date, contact Nexera Consulting.

Need a second set of eyes?

Bring the context and we can talk through the next move. If the issue in this article looks familiar in your business, share the situation and we will respond with a practical next step, not a canned pitch.