How to Build and Use a 13 Week Cash Flow Forecast

About the Author

Gershon Morgulis is the founder and principal of Imperial Advisory and holds an MBA in finance. He has spent years in investment banking and as a college professor, and advises owners on cash flow, forecasting, and financial strategy.

Your profit and loss statement looks fine, but Friday's payroll still feels tight. That gap is a cash timing problem, and a 13-week cash flow forecast is how you see it coming.

A 13-week cash flow forecast is a rolling, week-by-week projection of the cash entering and leaving your bank account over the next quarter. My name is Gershon Morgulis. I founded Imperial Advisory after earning an MBA in finance and spending years in investment banking, and this rolling forecast is the first tool I'd reach for when an owner cannot tell which week gets tight.

Below is how to build one in five steps, how to read what it tells you, and the mistakes that make a forecast lie to you.

TL;DR

  • ●A 13-week cash flow forecast projects cash in and out, week by week, for the next quarter, on a cash basis.
  • ●A shortfall shows up weeks before it hits, while there is still time to act.
  • ●Build it in five steps: starting cash, weekly receipts, weekly disbursements, net flow, and a rolling update.
  • ●Your bank balance today says nothing about the payroll run three weeks out; the forecast does.
  • ●Update it every week, because a stale forecast is worse than none.

What a 13 Week Cash Flow Forecast Is

A 13-week cash flow forecast tracks the actual money moving in and out of your bank account, week by week, for the next quarter. The forecast uses the direct method, which means you project real cash receipts and payments rather than accounting profit.

Thirteen weeks is one quarter, far enough to see a crunch coming and near enough that your estimates stay realistic. Profit is not cash: you can be profitable overall but still miss payroll if a big receivable lands late.

That gap is common. The median small business holds just 27 cash buffer days of reserve, according to the JPMorgan Chase Institute.

The Federal Reserve tells a similar story: in its Small Business Credit Survey, 51 per cent of firms named uneven cash flow a challenge. A forecast will not fix the timing, but it shows you the tight weeks early enough to do something about them.

How to Build a 13 Week Cash Flow Forecast

You can build this in a spreadsheet in an afternoon. Five steps get you there.

1

Start With Your Real Cash Position

Open a spreadsheet with 13 columns, one per week, and start with the cash you actually have across all accounts today. Your bank balance is not your cash position, so net out any checks already written or payments already scheduled.

2

Map Cash Receipts Week by Week

List the cash you expect to collect each week, based on customer payments rather than invoices sent. Money counts in the week it actually lands in the bank.

Base each week on when customers really pay. Getting paid faster pulls cash into earlier weeks, which is why staying ahead of accounts receivable problems shows up directly in the forecast.

3

Map Cash Disbursements Week by Week

Do the same for money going out: payroll, rent, loan payments, taxes, vendor bills, and any one-time costs. Put each in the week the cash actually leaves, including the pay dates that rarely move.

4

Calculate Net Cash Flow and the Ending Balance

For each week, subtract disbursements from receipts to get the net change, then add it to the prior week's ending balance. The result is your projected cash at the end of every week for the next quarter.

Say week six opens at $40,000, brings in $180,000, and pays out $230,000 (illustrative numbers). You end that week at negative $10,000, a red flag you can now see five weeks early.

5

Roll the Forecast Forward Every Week

Each week, drop the week that just passed, add a new week 13, and replace your estimates with what actually happened. A forecast you update every Monday stays honest; one you build once and forget will quietly drift from reality.

Not sure your numbers can be trusted yet?

Schedule a free exploratory call and have an experienced CFO pressure-test your cash forecast.

Schedule a free exploratory call

How to Read and Act on the Forecast

Building the forecast is the easy part. The value is in what you do when it flags a tight week.

When a week dips toward zero, you have levers. You can pull a receivable forward with a quick call, delay a discretionary purchase, time a vendor payment, or draw on a line of credit ahead of the crunch instead of during it.

Seeing the problem early also changes the conversation with your bank. Asking for a line of credit while you are still solvent is a very different meeting than asking once you have missed a payment.

Common Mistakes to Avoid

The most common error is mixing up cash and profit. A profitable quarter can still run you dry if customers pay slowly and bills come due fast, so forecast on a cash basis rather than an accrual basis.

Do not treat EBITDA, a rough proxy for operating profit, as cash: it ignores capital spending, taxes, debt payments, and the timing of your working capital. A forecast built on profit metrics will tell you a comforting story right up until the account is empty.

The last mistake is building it once. A 13-week forecast earns its keep only if you roll it forward and compare last week's estimate to what really happened.

Want a seasoned CFO in your corner?

Meet our CFOs and the finance leadership they bring to growing companies.

Meet our CFOs

Where a Fractional CFO Comes In

Plenty of owners can build the spreadsheet. Fewer have the time to run it every week and the experience to read what it is quietly telling them.

A fractional CFO, a seasoned finance chief engaged part-time, owns that discipline for you. Our CFOs build the forecast, keep it current, and turn a tight week into a decision rather than a surprise.

A familiar story shows up again and again: a growing business that cannot see where its cash is going. Bringing in outsourced CFO support puts that visibility in place without a full-time hire.

Not sure which model fits? A short conversation about the kind of CFO you need is a sensible first step before your next tight quarter.

Frequently Asked Questions

Owners raise a handful of other questions about running a 13-week cash flow forecast.

Why 13 Weeks and Not a Full Year?

Thirteen weeks is one quarter: long enough to spot a cash crunch and short enough that your weekly estimates stay grounded. Annual cash forecasts still matter for planning, but they are too coarse to catch the specific Friday that gets tight.

Is a 13 Week Cash Flow Forecast Only for Companies in Trouble?

No. The tool comes from turnaround work, but a healthy, growing business gets just as much value from seeing its cash clearly. Running one in good times is how you stay out of trouble in the first place. It may also highlight that you have excess cash you can invest in payroll, equipment, and the like, or use to pay down debt or make distributions.

How Accurate Does a 13 Week Forecast Need to Be?

Accurate enough to guide decisions rather than perfect. Early weeks should be fairly tight because you know your near-term bills and collections, while later weeks are rough estimates that sharpen as they approach.

Put the Forecast to Work

A 13-week cash flow forecast will not add a dollar to your bank account. What it adds is time: the weeks of warning that let you act while you still have options.

Build it, update it every week, and let it tell you which Fridays to watch.

Cash flow should not keep you up at night.

Talk with an Imperial Advisory CFO and put a forecast to work in your business.

Talk with an Imperial Advisory CFO
Share the Post: