The 13-Week Cash Flow Forecast, Explained: Why Smart Founders Stopped Forecasting Monthly
A 13 week cash flow forecast tracks weekly cash in and out over 90 days. Here is why weekly beats monthly, and how to build one.
A 13 week cash flow forecast is a model that tracks the cash coming into and going out of your business, week by week, over the next 90 days. Thirteen weeks. Thirteen weekly numbers, not three monthly ones. That weekly resolution is the entire point, and it is the part most founders get wrong.
Here is the stand this whole piece rests on. Monthly cash forecasting is a soft story you tell yourself. It takes the exact week you go negative and averages it away into a smooth monthly number that looks fine. Your forecast says you are fine on the first of the month. It is wrong on week three, and you find out when payroll does not clear.
What a 13 week cash flow forecast actually is
Cash flow forecasting is the process of estimating a company’s future cash levels and its financial position more broadly. The forecast is built on anticipated payments and receivables: cash receipts from sales and collections on one side, payments to suppliers and employees on the other.
The 13-week version applies the direct method. You schedule the company’s cash receipts and disbursements week by week. Receipts are mostly the collection of accounts receivable from recent sales. Disbursements include payroll, payment of accounts payable, and interest on debt. Add them up each week, carry the balance forward, and you can see your cash position 90 days out.
Why 90 days? Because the direct method is best suited to a short horizon, where you are working with actual data rather than guesses. Push it much further and the errors pile up. Thirteen weeks is short enough to stay accurate and long enough to act before a shortfall arrives.
Why weekly beats monthly
A month is too wide a window to see the thing that ends companies. A business can fail because of a shortage of cash even while it is profitable. Being profitable does not mean being liquid. So the question that matters is not whether this month nets out positive. It is whether there is any single week in the next 90 days when the bank balance goes negative.
Monthly forecasting cannot answer that. It takes thirteen weeks of real movement and folds them into three numbers. The mean looks healthy. But cash does not arrive as a mean. A large customer pays late. Payroll and a quarterly tax payment land in the same week. Your monthly view smooths all of that into one soft line, and the line is hiding the week you run out.
Weekly resolution drops the smoothing. Each week is its own number, so the trough shows up where it actually is. The default habit of forecasting once a month is not good enough, and a CFO will agree. It lets a solvent business drift toward insolvency, because the data that should have raised a warning got folded out of view.
Granular does not mean harder. It means honest. Thirteen weekly numbers are the minimum resolution that tells the truth about when, not just whether.
How to build one
You do not need anything exotic. A common approach is a spreadsheet, typically in Excel, showing cash coming in from all sources out to at least 90 days and all cash going out over the same period.
- List your starting cash. The real bank balance, not the accrual-accounting book number. Those two often differ, and only one of them pays employees.
- Lay out 13 weekly cells across the top. One week per line, left to right.
- Drop in receipts by week. Anticipated collections of accounts receivable, plus any sale of assets or proceeds of financing. Time them when the cash actually arrives, not when you booked the sale.
- Drop in disbursements by week. Payroll, payment of accounts payable, interest on debt, rent, the lot.
- Carry the balance forward. Each week’s closing cash is the next week’s opening cash. Now you can see every dip.
Where you find a shortfall or mismatch, you can act early: a bridge loan, increased collections activity, or stretching a payment. The forecast does not fix the problem. It shows you the problem while you still have time.
One warning. It is rare for cash receipts to match sales forecasts exactly, and rare for customers all to pay on time. Predicting when customers will pay is hard, because payment behaviour is a human thing, not a tidy rule. So treat your receipts as estimates, indicate the uncertainty, and keep the model up to date. A forecast built on stale data is worse than no forecast, because it tells you a precise number with false confidence.
Where CX Cash comes in
The weak point of any 13-week model is the same one the textbooks name: accuracy depends on data that is current. A spreadsheet you refresh once a quarter goes stale fast. CX Cash keeps the receipts and disbursements feeding in so the weekly numbers stay live, and so the trough you need to see shows up before payday, not after. You should know where the money is going. A 13-week forecast is how you know.
Frequently asked questions
How is a 13 week cash flow forecast different from a budget?
A budget is a fixed-term financial plan used for resource allocation and control. A forecast is an estimate of future financial performance that flexes as conditions change. The 13-week forecast is the second kind. It is not about what cash should do. It is about what cash will actually do, week by week, so you can spot a shortfall in advance and act.
Why 13 weeks and not 12 or 26?
Thirteen weeks is one quarter, which lines up cleanly with how businesses already plan. It is also near the limit of the direct method, where you are mostly working with real, near-term data rather than projection. Shorter and you cannot see far enough to act. Much longer and the direct method’s errors compound.
Can I still use monthly forecasting for anything?
Yes. Longer-horizon, monthly or quarterly views are useful for the bigger picture: a full year of planning, fundraising, asset and liability management. Just do not run your short-term survival on a monthly cadence. Use 13 weekly numbers for the next 90 days and a coarser model for the year.
Do I need software, or is a spreadsheet enough?
A spreadsheet is enough to start, and many founders run one for years. The catch is the data going stale. The moment updating it by hand slips, the forecast quietly stops telling the truth. That is the gap automation closes.
The stand, one more time
If you remember one thing, drop the monthly-only habit. Not because monthly is useless, but because a month is the wrong resolution for the one question that decides whether your company survives the next 90 days. The mean is a comfort. The weekly trough is the truth.
Build the 13-week. Grab our free 13-week cash flow model and forecast template, run your numbers through it this week, and share it with the founder who needs it most. Then come see what CX Cash does when the data feeds itself.