13-Week Cash Flow Forecasting:
A Practical Guide for Operators

Running out of cash is almost never a surprise in hindsight. The signals were there — in the AR aging, the payables schedule, the seasonality pattern. What was missing was a system that surfaced those signals before they became a crisis.

That's what a 13-week cash flow forecast does. It's not a budget. It's not a P&L. It's a rolling, weekly-level view of every dollar coming in and going out over the next 90 days — specific enough to act on, far enough out to course-correct.

Why 13 Weeks Specifically?

The number isn't arbitrary. Thirteen weeks — one quarter — is the sweet spot between precision and planning horizon. Go shorter (4 weeks) and you're just tracking cash, not forecasting it. Go longer (52 weeks) and the numbers become too speculative to be useful for operational decisions.

At 13 weeks, you can see:

• When your next payroll cycle will hit relative to your expected AR collections
• Whether a large vendor payment will create a short-term squeeze
• How a slow sales week ripples forward into a cash crunch 6 weeks later
• Whether you have enough runway to make a planned hire or equipment purchase

What a 13-Week Forecast Actually Looks Like

The interactive chart below shows a sample 13-week cash flow forecast. The first 4 weeks are actuals; weeks 5–13 are forecast. Toggle between views to see cash position vs. weekly net flow.

How to Build One: 6 Steps

1. 1

   Start with your opening cash balance

   Pull your actual bank balance as of the start of the forecast period. This is your anchor. Everything else flows from here.

2. 2

   Map your cash inflows by week

   List every expected cash receipt: customer payments (based on your AR aging and payment terms), recurring revenue, any expected financing or asset sales. Be conservative — use your actual collection history, not invoice dates.

3. 3

   Map your cash outflows by week

   Payroll (exact dates), rent, vendor payments (based on AP aging), loan payments, taxes, and any known one-time expenses. This is where most businesses underestimate — don't forget quarterly or annual items.

4. 4

   Calculate weekly net cash flow

   Inflows minus outflows for each week. A negative week doesn't mean crisis — it means you need to know about it in advance so you can plan around it.

5. 5

   Build the rolling balance

   Add each week's net flow to the prior week's ending balance. This gives you your projected cash position at the end of each week — the number that tells you whether you'll have enough.

6. 6

   Update it every week, without fail

   A 13-week forecast is only useful if it's current. Every Monday, replace the oldest week's forecast with actuals, add a new week 13, and review the variances. The variance review is where the real learning happens.

Run Your Numbers

Use the calculator below to estimate your cash runway and identify your risk window based on your current business metrics.

The 3 Most Common Mistakes

After building hundreds of these models, we see the same errors repeatedly:

1. Using invoice dates instead of expected payment dates. Your AR aging tells you when customers actually pay, not when you bill them. A 30-day invoice from a customer who pays in 45 days creates a 15-day blind spot that compounds quickly.
2. Forgetting lumpy outflows. Quarterly insurance premiums, annual software renewals, semi-annual tax deposits — these are predictable but easy to miss in a weekly model. Build a "known future payments" list and map every item to a specific week.
3. Not reviewing variances. The forecast is only half the value. The other half is the weekly variance review: why did cash come in $18K less than expected this week? That conversation surfaces operational problems before they compound.

"We thought we had 3 months of runway. The 13-week model showed us we had 6 weeks — because our largest customer was running 45 days past due and we hadn't tracked it. We collected $140K in the next two weeks that we didn't know was at risk." — CEO, $5.8M B2B services firm

Getting Started

The fastest way to build your first 13-week forecast is to start with a simple spreadsheet: 13 columns (weeks), rows for each inflow and outflow category, and a running balance at the bottom. It doesn't need to be sophisticated to be useful.

If you want a more robust model — one that integrates with your accounting system, flags variances automatically, and produces a weekly management summary — that's where a controller adds real value. We build and maintain these models for clients across every industry we serve.

About TMA Finance: We build and maintain 13-week cash flow models as part of our Cash Flow Planning add-on. Learn more about Cash Flow Planning or book a free call to discuss your situation.