Your P&L tells you how last month went. It can't tell you whether you'll make payroll in week seven.
A 13-week cash flow forecast can. It's a week-by-week view of the cash you expect to come in and go out over the next quarter, updated every week as real numbers arrive. It's the single most useful financial tool for a small business, and you can build one in a spreadsheet in an afternoon.
Why 13 weeks?
Thirteen weeks is one quarter, which is long enough to see trouble coming and short enough to forecast with reasonable accuracy.
- Weekly detail catches the timing problems that monthly views hide, like payroll landing two days before your biggest deposit.
- One quarter out covers most of the decisions owners face: a hire, a big purchase, a quarterly tax payment, a slow season.
- Rolling means that every week you drop the week that just ended and add a new week 13, so you always see a full quarter ahead.
What you'll need before you start
- Accurate books through last month. A forecast built on bad numbers is a guess. (If you're behind, start with catching up on bookkeeping.)
- Current bank balance(s).
- A/R list: who owes you, how much, and when they usually pay.
- A/P list: bills due, with due dates.
- Payroll calendar: pay dates and approximate amounts.
- Recurring fixed costs: rent, loan payments, subscriptions, insurance.
- Known one-offs: quarterly tax estimates, equipment purchases, annual renewals.
The template layout
Set up a spreadsheet with weeks across the top and categories down the side:
| Wk 1 | Wk 2 | Wk 3 | … | Wk 13 | |
|---|---|---|---|---|---|
| Opening cash | |||||
| Cash in | |||||
| Customer payments / sales deposits | |||||
| Collections on outstanding invoices | |||||
| Other income | |||||
| Total cash in | |||||
| Cash out | |||||
| Payroll (incl. taxes) | |||||
| Rent | |||||
| Suppliers / inventory | |||||
| Loan payments (principal + interest) | |||||
| Tax set-asides / estimates | |||||
| Owner draws | |||||
| Other operating costs | |||||
| Total cash out | |||||
| Net cash flow | |||||
| Closing cash | |||||
| Minimum cash buffer | |||||
| Above / below buffer |
The key formula: each week's closing cash becomes the next week's opening cash.
Step-by-step: building your forecast
Step 1: Enter opening cash
Use your actual bank balance on the first day of week 1. Include every operating account, but leave out money that's already committed, such as a tax savings account.
Step 2: Forecast cash in, by when it actually arrives
This is where most forecasts go wrong. Enter cash in the week it hits the bank, not the week you invoice.
- Restaurants and retail: use recent weekly deposit averages from your POS, adjusted for seasonality. (If you use Toast or a similar system, reconcile deposits to the bank first. Processor fees and timing differences add up.)
- Service businesses: use your A/R list and each customer's real payment habits. If a client always pays at day 45, put it at day 45.
Step 3: Forecast cash out
Start with the big, predictable items: payroll, rent, loan payments. Then add suppliers, subscriptions and one-offs.
Don't forget:
- Loan principal. It doesn't appear on your P&L, but it leaves your bank account.
- Owner draws.
- Quarterly estimated taxes. Put them in the weeks they're due.
- Payroll extras like tips and off-cycle checks for hospitality businesses.
Step 4: Set a minimum cash buffer
Decide the lowest balance you're comfortable holding, often enough to cover one payroll plus rent. Add a row that flags any week where closing cash dips below it.
Step 5: Read the forecast
Look for:
- Red weeks: closing cash below your buffer.
- The low point: the week with the least cash, and why.
- Trend: is closing cash rising or falling across the quarter?
Step 6: Decide what to do
A forecast only matters if you act on it. Common moves:
- Chase a slow-paying customer before the tight week.
- Move a purchase from week 5 to week 9.
- Talk to a supplier about terms before you're late.
- Hold off on a hire until the low point passes.
The weekly routine (15–30 minutes)
- Compare last week's forecast to what actually happened.
- Note why any big line was off (a late payment, an unexpected bill).
- Drop the finished week and add a new week 13.
- Update anything that's changed.
- Check for new red weeks.
Over time, the variance notes are where the real value lies. You learn how your business actually behaves.
Common mistakes
- Forecasting revenue instead of cash. Invoices aren't deposits.
- Forgetting irregular costs. Annual insurance and quarterly taxes catch owners off guard.
- Building it once and never updating it. A forecast you don't update is out of date within a month.
- Starting from unreliable books. Clean the books first.
Example: what this looks like in a restaurant
Picture a restaurant with steady weekend traffic, payroll every two weeks, and a monthly SBA loan payment. The P&L looks healthy. The 13-week forecast shows that in week 6, a payroll run, the loan payment and a quarterly tax estimate all land in the same five days, during a historically slow stretch.
Seeing that in week 1 means there's time to prepare: hold a little back from draws, time a supplier order, or set aside the tax money earlier.
(Illustrative example. For restaurant-specific guidance, see Fractional CFO for Restaurants.)
Want help building yours?
A 13-week rolling forecast is one of the core things we build for clients at Forney Consulting Group. We work from the tools you already use (QuickBooks, Xero or spreadsheets) and review it with you on a regular rhythm.
Book a free 30-minute call with Billy and we'll look at where a forecast would help most in your business.