13-week cash flow: the forecast that flags trouble a quarter early

The average small business discovers a cash problem about ten days before it becomes a payroll problem. A 13-week cash flow forecast moves that warning to thirteen weeks out — enough time to fix it with a line of credit, a collections push, or a spending pause instead of panic.

Why 13 weeks and not 12 months

Annual budgets hide the timing of cash. 13 weeks (one quarter) is long enough to see a problem coming and short enough that every number is a real expectation, not a hope. And because it rolls — every week you drop the oldest week and add a new one — it never goes stale like an annual budget does in March.

The four rows that matter

You do not need 40 rows. You need:

1. Opening cash — actual bank balance, all accounts, each Monday.
2. Cash in — only collections you can name. Not "sales"; invoices you expect to be paid, by week, from your AR aging.
3. Cash out — payroll (biggest, most fixed), rent, taxes, loan payments, then everything else as weekly averages.
4. Closing cash — opening + in − out. This row is the forecast.

The two lines that tell you everything

Draw your minimum safe cash line (we recommend two payroll cycles) across the chart. Then look for:

• Dips below the line — your financing conversation starts now, while banks still like you.
• Persistent climbs — idle cash you can prepay against a loan or move to a high-yield account.

Build it in an afternoon

Start with our 13-week template — the formulas and a worked example for a $2M/year business are pre-built. Fill week 1 with actuals, estimate weeks 2–4 from your AR aging and bill calendar, and rough weeks 5–13 with weekly averages. Accuracy improves every week you roll it forward; the first version only has to be honest, not perfect.

What we see across client books

When we build this for a new client, the median finding is a mid-quarter dip of 9–14% below their comfort line that annual numbers completely hid. Fixing it usually takes one of three moves: moving a quarterly tax payment onto a weekly reserve, shortening two slow customers' terms, or rescheduling a large inventory buy.

One prerequisite the forecast assumes: books you can trust. If the inputs are guesses, catch-up bookkeeping clears the backlog first, and accrual-level accounting keeps the forecast's inputs clean going forward.

Want a second pair of eyes on your forecast? Book a free consultation — bring the spreadsheet, we will pressure-test the assumptions.