How to Build a 13-Week Cash Flow Forecast (+ Template)

By Billy Forney · · 5 min read

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.

What you'll need before you start

  1. Accurate books through last month. A forecast built on bad numbers is a guess. (If you're behind, start with catching up on bookkeeping.)
  2. Current bank balance(s).
  3. A/R list: who owes you, how much, and when they usually pay.
  4. A/P list: bills due, with due dates.
  5. Payroll calendar: pay dates and approximate amounts.
  6. Recurring fixed costs: rent, loan payments, subscriptions, insurance.
  7. 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.

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:

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:

Step 6: Decide what to do

A forecast only matters if you act on it. Common moves:

The weekly routine (15–30 minutes)

  1. Compare last week's forecast to what actually happened.
  2. Note why any big line was off (a late payment, an unexpected bill).
  3. Drop the finished week and add a new week 13.
  4. Update anything that's changed.
  5. 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

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.

← All articles