13-Week Cash Flow Forecast: The Complete Guide for Small Business

According to classic stats, 50% of small businesses that close are profitable on paper. The reason for closure is cash flow. A 13-week cash forecast (~3 months) is the tool that prevents this.

A 13-week cash forecast is a weekly table showing: opening balance, expected receipts from customers, expected payments, and closing balance. Updated every Sunday. 13 weeks is the reasonable time to spot a problem and react before a crisis.

What is cash flow and how is it different from profit?

Accounting profit is calculated by 'when the revenue was recognized' - not 'when the cash came in.' If you sold $10,000 on the 1st but the customer pays on the 30th - you have profit on the 1st but no cash on the 1st. Cash flow measures what's actually in the bank.

This distinction isn't theoretical - it's what kills businesses. You can have a profitable business that can't make payroll because customers paid late.

Why specifically 13 weeks?

13 weeks is 91 days, ~3 months. That's the reasonable time to spot a problem and react before it becomes critical. Shorter forecast (one month) is too late. Longer (a year) less accurate.

13 weeks is also a horizon you can influence: delay a vendor payment, accelerate collections, defer a non-essential purchase.

What a 13-week forecast looks like

Table: first column - rows (opening balance, receipts, payments, closing balance). Headers - 13 weeks. Update every Sunday.

Each week: opening balance is last week's closing. Receipts: revenue expected to land this week. Payments: everything going out. Closing: opening + receipts - payments.

Where to get the data

Receipts: list of customers who haven't paid yet (receivables) - when each is due, how much. Plus contractual agreements already known.

Payments: fixed costs (rent, insurance), payroll, vendors (invoices with due dates), variable monthlies (utilities, advertising).

We load data from QuickBooks, Xero, or FreshBooks into a simple Google Sheet. No dedicated software needed.

When to update

Once a week, Sunday morning. 30-45 minutes max. Lock it in your calendar as a recurring meeting - otherwise it doesn't happen.

What to do if the forecast shows a crisis

If week 3 or 4 shows a negative balance, you have time. Actions in order: 1) Accelerate collections. 2) Defer non-critical payments. 3) Use line of credit. 4) Talk to the bank about a bridge loan.

Each is solvable with time. Without a forecast, you discover the problem when it's a crisis - and solutions cost 5x more.

Common forecasting mistakes

1) Excessive optimism - forecast of 'how it should be' instead of 'how it will be.' 2) Failure to update - one-time build without ongoing maintenance. 3) Forecast disconnected from reality - not distinguishing between 'revenue recognized' and 'revenue received.'

How to start

Empty Google Sheet. Rows: opening balance, expected receipts, expected payments, closing balance. Columns: 13 sequential weeks. Fill in. Lock 30 minutes every Sunday morning. After 4 weeks you start spotting patterns.