How to Build a Simple 13-Week Cash Flow Forecast
A rolling 13-week forecast shows when cash will be tight before it happens. Here is how to set one up in a spreadsheet and keep it current with a weekly routine.
Annual budgets are useful for big-picture planning, but they rarely tell you whether you can cover payroll three weeks from Friday. That is the job of a short-term cash flow forecast. A 13-week forecast, roughly one quarter looking forward, is a common tool among finance teams and turnaround specialists, and it works just as well for a small business with a spreadsheet. This is general guidance. An accountant can help you tailor the approach to your business.
Why thirteen weeks
Thirteen weeks is long enough to spot problems while there is still time to act, and short enough that your estimates stay reasonably accurate. Weekly detail matters because cash problems usually come from timing: a large bill landing the same week a big customer pays late. Monthly totals can hide those collisions.
Set up the spreadsheet
Create a column for each of the next thirteen weeks. Then build rows in this order:
- Beginning cash. The bank balance at the start of the week.
- Cash receipts. Customer payments you expect to collect, other income, and any loan proceeds or owner contributions.
- Cash disbursements. Payroll and payroll taxes, rent, supplier payments, loan payments, insurance, taxes, software and any planned purchases.
- Net cash flow. Receipts minus disbursements.
- Ending cash. Beginning cash plus net cash flow, which becomes next week’s beginning cash.
Add a row for your minimum comfortable balance so any week that dips below it stands out.
Fill in realistic numbers
The forecast is only as good as its assumptions. For receipts, list open invoices by customer and estimate when each will actually be paid based on that customer’s history, not the due date. Add expected new sales conservatively. For disbursements, start with fixed obligations such as payroll dates, rent and loan payments, then add variable costs. Be sure to include items that do not occur every week, such as quarterly tax payments, annual insurance premiums and software renewals.
Make it a weekly habit
A forecast gains value through repetition. Once a week, ideally on the same day:
- Replace last week’s forecast with actual results.
- Note where the forecast was wrong and why.
- Add a new week at the end so you always see thirteen weeks ahead.
- Update expectations for collections and upcoming payments.
Over time, comparing forecast to actual makes your estimates sharper and reveals patterns, such as customers who consistently pay late.
Use it to make decisions
When the forecast shows a tight week ahead, you have options that disappear if you only notice on the day. You might follow up harder on specific invoices, ask a customer for a deposit, adjust the timing of a purchase, talk to a supplier about terms or arrange a line of credit in advance. When the forecast shows extra cash, you can plan investments with confidence. If the forecast shows sustained shortfalls, talk to your accountant or financial advisor early, while you still have room to maneuver.
