The 13-week cash flow forecast, and why most owners have never seen one

Ask most owners how cash looks and they will tell you the bank balance. Ask how it will look in ten weeks and they will guess. The guess is usually optimistic, because the big receivable feels real and the payroll in week nine does not.

A 13-week cash flow forecast replaces the guess. It is the single most useful report a growing business can have, and almost nobody outside of turnaround work has seen one. Here is what it is, why it works, and how to build one.

What it is

A 13-week cash flow forecast is a simple grid. Thirteen columns, one per week. Rows for cash in, cash out, and the ending balance. Nothing accrual, nothing about profit. Just money arriving and money leaving, week by week, for the next quarter.

Cash in is what you actually expect to collect each week: customer payments, deposits, a loan draw if one is planned. Cash out is what will actually leave: payroll, rent, materials, loan payments, the insurance renewal, the truck lease, owner draws.

The last row is the one that matters. Ending cash, each week, for thirteen weeks. That row is either comfortable, tight, or negative. Now you know which, and when.

Why thirteen weeks

Thirteen weeks is a quarter. It is long enough to see the next pinch coming and short enough to forecast honestly. Past thirteen weeks, nobody knows which jobs will close or which customers will pay late, and the forecast turns into fiction. Inside thirteen weeks, most of the numbers are already committed: the jobs are sold, the payroll is scheduled, the rent is due.

Weekly, not monthly, is the other half of the answer. Cash does not fail on a monthly average. It fails on a Thursday. A monthly view can show a healthy month that hides a week where payroll lands two days before the big check does.

What goes in it

Receipts, by week and by source. Do not put in the invoice date. Put in the week you honestly expect the money. If a customer pays in 45 days, that is where it goes. Deposits on new jobs go in the week the contract is signed, not the week you hope it is.

Disbursements, by week and by category. Payroll and employer payroll costs on the actual pay dates. Rent on the first. Vendor bills by their real due dates. Loan payments. Credit card payments. Owner draws, written down, not assumed.

The known lumps. Insurance renewals, equipment purchases, annual software, the quarterly payments. These are what surprise people, and they are the easiest things to see coming if you write them in.

The opening balance. Real bank cash, today, minus any checks that have not cleared.

How to build one

1. Open a spreadsheet. Thirteen columns, dated by week ending. Rows as above.
2. Fill in the committed outflows first. Payroll, rent, debt, leases. These are known.
3. Add the vendor bills you already have, by due date.
4. Add the receipts you can defend. Sold jobs, signed contracts, invoices out, with realistic pay timing.
5. Add the lumps from the calendar.
6. Subtract, week by week. Look at the ending cash row.
7. Save it. Next week, replace week one with actuals, add week fourteen, and repeat.

The first version takes an afternoon. Every version after that takes about an hour, because you are only updating the front of the grid and adding one week to the back.

The weekly rhythm

The forecast is only useful if it is updated. Every week, actual cash replaces the forecast for the week just finished. That comparison, forecast versus actual, is where you learn how your business really behaves. Customers who always pay late. Vendors who bill early. The seasonal dip that shows up every August.

After a few months, the forecast gets accurate because it is trained on your own history. That is when owners stop checking the bank balance every morning.

What it changes

The hire. You can see whether the new technician's payroll clears in week six or sinks you in week eight, and what has to be true for it to work.

The truck, the warehouse, the second location. Run the purchase through the grid before you sign. The cash impact is visible in the ending row, not in a feeling.

The lender. A bank that sees a maintained 13-week forecast sees a business that knows itself. It is the single document most likely to move a line of credit conversation forward.

The slow month. You saw it in week two. You called the three slow-paying customers in week three. It never became a crisis.

Common mistakes

Forecasting invoices instead of collections. The invoice is not cash. The payment is.

Skipping owner draws. If the family takes money out, it goes in the grid.

Forgetting the lumps. The renewal you forgot is the one that hurts.

Building it once and never updating it. A stale forecast is worse than none, because it is wrong with confidence.

Making it complicated. Thirteen columns, a handful of rows. If it takes a consultant to read, it is too much.

How we use it

Every Clarity engagement at Lucent CFO starts with this forecast. It goes live inside the first sixty days, gets updated every week, and sits on the first page of the monthly package next to the one-page KPI report. When a decision comes up, the forecast is where we run it.

If you want to build your own first, the template is coming to our resources page. If you would rather have it built and kept for you, start with a conversation.