The 13-Week Cash Flow Forecast: The One Spreadsheet Every Growing Business Needs

A profitable business can still run out of cash. It happens more often than most owners expect, and it tends to happen to growing companies: you land a big contract, hire ahead of it, buy materials, and then wait 60 days to get paid while payroll goes out every two weeks.

Once a business passes $1 million in revenue, the dollars moving in and out each week are large enough that a timing gap can become a real problem. Your monthly P&L will not warn you in time. A 13-week cash flow forecast will.

Why 13 weeks?

Thirteen weeks is one quarter, tracked week by week. It is long enough to see a crunch coming and short enough to forecast with real accuracy, because most of the inflows and outflows in that window are already known: invoices you have sent, payroll dates, rent, loan payments and vendor terms.

Lenders, turnaround advisors and CFOs use this tool for a reason. It answers the question every owner should be able to answer at any moment: how much cash will we have, and when?

How to build one

You can build this in a spreadsheet in an afternoon. Set up 13 columns, one for each week, and these rows:

1. Beginning cash

Your actual bank balance at the start of week one. Each following week starts with the prior week’s ending cash.

2. Cash receipts

Forecast when cash actually arrives, not when you invoice. Start with your accounts receivable aging and apply each customer’s real payment habits. If a customer pays on day 50 regardless of your terms, forecast day 50. Then add expected new sales, discounted for how long they usually take to collect.

3. Cash disbursements

  • Payroll and payroll taxes, on their actual pay dates
  • Rent, insurance, utilities and other fixed costs
  • Vendor and supplier payments, based on your accounts payable and their terms
  • Loan and line-of-credit payments
  • Estimated tax payments and sales tax remittances
  • Planned purchases: equipment, inventory buys, software renewals

4. Ending cash, and a minimum cash line

Ending cash equals beginning cash plus receipts minus disbursements. Then set a minimum cash balance you never want to go below, often enough to cover at least one or two payrolls. Any week that dips under that line is your early warning.

Keep it alive: the weekly routine

A forecast is only useful if it stays current. Once a week, take 30 minutes to:

  1. Roll it forward. Drop the week that just ended and add a new week 13.
  2. Compare forecast to actual. Where were you wrong? Usually it is collections running slower than expected.
  3. Adjust your assumptions. Each week your forecast gets more accurate because you are learning your real patterns.

What the forecast tells you

  • When you will need your line of credit, and how much, weeks before you need it.
  • Whether you can take on that big order without straining payroll.
  • Which customers are really financing your business by paying slowly, and where tighter terms or deposits would help.
  • When it is safe to make a large purchase, distribute profits or make a key hire.

It also changes your conversations with lenders. Walking into a bank with a 13-week forecast that you have kept accurate for months tells them you manage cash with discipline, and that makes you a better credit.

A real example: the big contract that could have broken the bank

I was advising the owner of an industrial company who was about to land a multimillion-dollar project. It was the kind of win every business owner wants. But she had not yet projected what the project would do to her cash flow.

Winning the work meant spending before getting paid. She would need a new truck and two highly skilled engineers, and those costs would hit weeks or months before the first project payments came in. On a profit-and-loss forecast the project looked great. On a week-by-week cash forecast, it showed a gap.

Updating her projection to include the truck, the new salaries and the realistic timing of customer payments showed exactly when cash would run short and by how much. With that warning well in advance, she could plan for it instead of reacting to it. She avoided the shortfall and kept the business running smoothly through the ramp-up, rather than risking missed payroll or a stalled project.

The lesson: growth uses cash before it produces cash. Before you sign a large contract, run it through your 13-week forecast and see what happens to your balance between the first dollar spent and the first dollar collected.

Common mistakes

  • Forecasting revenue instead of cash. A sale is not cash until it is collected.
  • Using monthly totals. Weekly detail is what reveals the timing gaps.
  • Being optimistic. Forecast collections conservatively and expenses fully.
  • Building it once and forgetting it. A stale forecast is worse than none, because it creates false confidence.

Want help building yours? We can set up a 13-week cash flow forecast around your business and walk you through keeping it current week to week. Book a strategy call or call 770-826-7263.

Want help setting one up?

Jeannie Bell Capital works with established businesses to build the financial tools that support growth and strengthen lender relationships. Call 770-826-7263 or email sales [at] jbc-atl [dot] com to book a strategy call.

Raymond Cobb III

About the author

Raymond Cobb III

Managing Partner, Jeannie Bell Capital

Raymond founded Jeannie Bell Capital after years with top-tier financial firms, including GE Capital, Bank of America and Truist. He helps established businesses and higher education institutions with capital raising, debt financing and financial strategy.

Follow us on LinkedIn

Work with us

Talk it through with a former lender

Get a clear read on your financing, cash flow and next steps in a focused strategy call.

Raymond Cobb III

Raymond Cobb III

Managing Partner

Talk it through with a former lender

Get a clear read on your financing, cash flow and next steps.

Book a strategy callor call 770-826-7263