The 13-Week Cash Flow Forecast: The Only Report That Matters When Cash Is Tight

A 13-week cash flow forecast is a week-by-week projection of cash in and cash out for the next quarter. It is the single most important report when cash is tight because it tells you exactly when you will run out of money, and gives you the runway to do something about it. Every lender, every turnaround advisor, and every board asks for the same document when the stakes are high.

The forecast is not a budget and it is not a P&L. It is a cash document. It starts with the bank balance this week, adds expected receipts, subtracts expected payments, and lands on the projected bank balance for each of the next thirteen weeks. The mistakes that make it useless are the ones that turn it into a wish list instead of a warning system.

What Is a 13-Week Cash Flow Forecast?

It is a rolling, week-by-week projection of your cash position. The top line is the opening bank balance. Below it, every source of cash in: customer payments, loan draws, owner contributions, tax refunds. Then every cash out: payroll, rent, vendors, loan payments, taxes, owner draws. The bottom line is the closing bank balance for the week, which becomes the opening balance for the next week.

The 13-week horizon is not arbitrary. It is one quarter. It is long enough to see a covenant test or a seasonal dip coming, and short enough that the numbers are still credible. Beyond thirteen weeks, the forecast becomes a guess. Inside thirteen weeks, it is a management tool.

How Do You Build a 13-Week Cash Flow Forecast?

Start with the actual bank balance on day one. Do not round. Do not estimate. Pull the real number from the bank.

List every expected receipt by week. Use your AR aging, not your revenue forecast. A sale is not cash. A collected invoice is cash. If your average collection time is 45 days, a sale today is cash in six weeks, not this week.

List every expected payment by week. Payroll is the largest and the most predictable. Rent, loan payments, and tax deadlines are next. Vendor payments come from your AP aging, ranked by due date and by which vendors are calling.

Subtract payments from receipts, add to the opening balance, and carry the closing balance forward. Do this for all thirteen weeks. The line you are watching is the closing balance. If it goes negative in week seven, you have a problem you can see seven weeks before it happens.

What Mistakes Make a Cash Flow Forecast Useless?

Using the P&L instead of the bank. Accrual profit is not cash. A forecast built on the income statement will tell you you are profitable while you go broke. Always start from the bank balance.

Assuming customers pay on time. They do not. Use your actual days sales outstanding, not your terms. If you bill net 30 and collect in 52 days, use 52.

Forgetting the lumpy payments. Quarterly taxes, annual insurance, the balloon loan payment, the owner draw in December. These are the payments that break a business, and they are the ones owners forget to put in the forecast.

Not updating it weekly. A 13-week forecast is a living document. If you build it once and file it, it is worthless by week three. Update it every Monday with the actuals from the prior week.

Optimism. The forecast is not a sales pitch. If you need it to look good to show the bank, you are using it wrong. The bank will find out the truth. The forecast is for you, to find the gap before the bank does.

How Do Lenders Read a 13-Week Cash Flow Forecast?

Lenders read it from right to left. They look at the ending balance in week thirteen first. If it is positive and trending up, they relax. If it is negative or trending down, they start asking questions.

They look for three things: the minimum cash balance in the period (the trough), the timing of any covenant test, and the assumptions behind the receipts. If the receipts line is aggressive and the payments line is complete, they will discount the forecast. If the receipts are conservative and the payments are complete, they trust it.

The forecast you show a lender should be the same one you run the business on. If you build two versions, a real one and a bank one, the bank will figure it out and you will lose credibility at the moment you need it most.

Can I Get a Template?

Yes. C2 Group Inc. provides a 13-week cash flow forecast template to owners who request it. It is a working spreadsheet, not a PDF. You drop in your bank balance, your AR aging, your AP aging, and your payroll schedule, and it produces the thirteen-week projection with the minimum balance flagged.

If you want the template, or if you want us to build the forecast with you and review it, call (914) 210-1008 or send a message through the contact page. The first consultation is free.