A 13-week cash flow forecast shows, week by week for the next quarter, how much cash will come in, how much will go out and what the bank balance will be at the end of each week. Thirteen weeks is long enough to see a problem coming and short enough to forecast with real information rather than guesses.
It's the standard tool in turnarounds and lender conversations, but it's just as useful for a healthy business that's growing fast. Growth uses cash before it produces it.
Why weekly, and why direct?
Monthly forecasts hide timing. Payroll on the 1st and a large customer payment on the 28th look fine in a monthly total, but the business may still run short in week one. A weekly view shows the low points.
The 13-week forecast is also built with the direct method: actual receipts and payments, not profit adjusted for working capital. That makes it easy for a non-accountant to read and easy to check against the bank statement.
Step 1: Start from today's actual cash
Week 0 is the real, reconciled bank balance across all operating accounts. If the books aren't reconciled, fix that first; a forecast that starts from a wrong number is wrong every week after.
Step 2: Forecast receipts
- Customer collections: start with the open receivables list. For each large invoice, estimate the week it will actually be paid based on that customer's history, not the due date.
- New sales: add expected invoicing and apply your typical collection delay.
- Other receipts: loan drawdowns, tax refunds, asset sales. Include them only if they're certain.
Step 3: Forecast payments
- Payroll on its actual pay dates, including taxes and benefits.
- Rent, loan repayments and subscriptions on their due dates.
- Suppliers: start from open payables, then add expected new purchases.
- Tax payments such as sales tax, GST, advance tax or estimated payments.
- One-off items: equipment, deposits, annual insurance.
Step 4: Calculate the weekly balance and set a floor
Opening balance plus receipts minus payments gives the closing balance, which becomes next week's opening balance. Then add a minimum cash line: the balance below which you'd be uncomfortable. Any week that dips below it needs a decision now.
Step 5: Roll it every week
Each week, replace the oldest week's forecast with what actually happened, add a new week 13 and note the biggest differences. This variance check is what keeps the forecast honest. If collections keep arriving later than forecast, change the assumption instead of repeating the same optimism.
Common mistakes
- Using invoice due dates instead of actual payment behaviour.
- Forgetting quarterly or annual payments that fall inside the 13 weeks.
- Mixing profit with cash, for example by including depreciation or non-cash accruals.
- Building it once for the bank and never updating it.
What the forecast is for
The point isn't the spreadsheet. It's the decisions it brings forward: chasing a slow-paying customer, moving a purchase by two weeks, drawing on a credit line before you need it rather than after. A forecast that changes nothing is just reporting.
Author bio: Ashwin Kasliwal is a Chartered Accountant and co-founder of Treasure Trail Capital, where his team builds forecasts, budgets and management reporting for growing businesses and accounting firms in the US and India.