13-Week Cash Flow Forecast for Small Business: A Practical Guide

Every small business that has ever run out of cash did so with a healthy P&L. Profitability is an accounting story about the past. Cash is a survival story about the next ninety days. The 13-week rolling cash flow forecast — a staple of restructuring practitioners and PE-backed operators for decades — is the single tool that translates the accounting story into a survival story you can act on.

This is a practical guide to building one. Not the theoretical version you read in a textbook, but the version that actually gets updated every Friday and drives decisions on Monday. If you already have QuickBooks, Xero, or Zoho, and you already know what a receivable and a payable are, you have everything you need.

Why 13 Weeks, and Why Weekly

The horizon is a compromise. Anything shorter than 13 weeks and you cannot see the impact of a slow-paying customer, a payroll cycle, or a quarterly tax payment. Anything longer than 13 weeks and the forecast becomes speculation dressed as arithmetic. Thirteen weeks — one calendar quarter — is long enough to spot problems while they are still fixable, and short enough that every line item is defensible.

The cadence matters too. A monthly forecast tells you your bank balance will be uncomfortable in six weeks. A weekly forecast tells you which Friday you cannot make payroll. That specificity is what turns a spreadsheet into a management tool. If your business runs on real cash constraints — as most small businesses do — the weekly rhythm is not optional.

The Structure: Direct Method, Not Indirect

There are two ways to build a cash forecast. The indirect method starts from net income and adjusts for non-cash items and working capital changes. It is the format shown in the audited cash flow statement. Do not use it. It is designed for reporting the past, not managing the future.

The direct method — the one used in the tool — lists every cash inflow and every cash outflow explicitly, week by week. Rows for customer collections, other inflows, payroll, rent, vendor payments, tax payments, loan servicing, and capex. Each cell is a number you can defend, not the residual of an accounting identity. This is what makes the forecast usable.

The Rows That Belong

• Beginning cash (the opening bank balance for the week)
• Customer collections (from AR ageing + expected new sales, cash-received basis)
• Other inflows (loan draws, tax refunds, owner injections)
• Payroll & related (net wages, payroll taxes, benefits — every fortnight or monthly as appropriate)
• Rent & utilities (usually monthly, dropped into the relevant week)
• Vendor payments (from AP ageing + expected new bills, cash-paid basis)
• Debt service (interest + principal, from the amortisation schedule)
• Tax payments (GST, income tax, payroll tax — dropped into the specific weeks they are due)
• Capex and one-offs (equipment, deposits, non-recurring items)
• Ending cash (beginning cash + inflows − outflows)

Every business will add or remove rows. A subscription business will have fewer AR rows because customers pay upfront. A construction business will have progress claims. A retailer will have merchant settlement timing. The point is the same: every material cash movement gets its own row.

Populating the Forecast: Where the Numbers Come From

The first version of the forecast takes a Saturday morning. Subsequent versions take twenty minutes a week.

Customer collections come from your AR ageing report. Sort the ageing by due date, apply a realistic collection assumption to each bucket (0–30 days: 85%, 31–60 days: 60%, 61–90 days: 40%, 90+: 20% or write off), and slot the expected collections into the week they are likely to hit. Add expected new sales — from your pipeline or from a run-rate assumption — collected on their typical DSO.

Vendor payments come from your AP ageing, filtered for payments you intend to make in each week. Payroll comes from the payroll calendar (this is one of the most predictable rows). Tax payments come from the tax calendar for your jurisdiction. Debt service comes from the loan amortisation schedule.

The temptation is to make each row perfect. Do not. A forecast that is 80% accurate and updated weekly is infinitely more useful than a forecast that is 99% accurate and updated once a quarter. Start rough, refine as you use it.

The Weekly Update Ritual

Every Friday afternoon, you spend twenty minutes doing three things. First, roll the forecast forward by one week — delete the past week, add a new week at the end, so you always have 13 weeks ahead. Second, update the beginning cash row with the actual bank balance. Third, update the assumptions in each row where reality has changed (a customer paid early, a big invoice slipped, a new bill came in).

Then you look at the ending cash row across the 13 weeks and ask one question: is there any week where the ending balance goes below my minimum operating cash threshold? If yes, you have a problem you can solve now — accelerate a collection, defer a payment, draw on a facility, delay a hire. If no, you have earned the right to sleep on Sunday.

Common Mistakes That Kill the Forecast

The most common mistake is optimism about receivables. Owners routinely assume customers will pay on their due date. Historical DSO says otherwise. Use your actual historical collection pattern, not the invoice terms.

The second most common mistake is forgetting one-offs. Annual insurance renewals, quarterly tax payments, licence fees, and one-time bonuses do not appear in the run-rate. Build a separate line for known one-offs and drop each one into the specific week it will hit.

The third is treating the forecast as a static document. If you build it once and never update it, it is worse than useless — it gives you false confidence. The weekly ritual is what makes the tool work.

The fourth is confusing the forecast with the budget. The budget is what you hoped would happen at the start of the year. The 13-week forecast is what will happen based on the current reality. They diverge, and that is fine. The forecast is what you manage cash against.

Frequently Asked Questions