How to Build a 13-Week Cash Flow Forecast for a Manufacturing Business

Lenders ask for them during credit reviews. Private equity firms expect them during diligence. And yet most manufacturing operators either don’t have one, or are maintaining something in Excel that’s already a week out of date.

A 13-week cash flow forecast is the most actionable short-term financial tool a manufacturer can use. It doesn’t predict the future — no forecast does. What it does is show you where your cash position is likely to go, week by week, based on what you know today. That visibility is the difference between reacting to a cash crunch and managing around one.

What it is (and what it isn’t)

A 13-week cash flow forecast is a rolling, week-by-week projection of actual cash receipts and disbursements — not revenue and expenses. The distinction matters. Revenue recognized in your P&L doesn’t equal cash until the customer pays. An expense accrued doesn’t hit your bank account until the check clears.

The forecast has two inputs: when cash is coming in, and when it’s going out. Everything else is arithmetic.

Step 1: Build your collections model

The starting point is your accounts receivable aging. For each customer, project when invoices are likely to convert to cash based on their terms and actual payment history.

If a customer is on Net 30 terms but consistently pays in 38 days, your forecast should reflect 38 days — not 30. Be honest here. Optimistic collection assumptions are the most common reason cash forecasts fail.

Group your AR into buckets and apply historical collection rates:

Current (0–30 days): project based on terms and payment history
31–60 days past due: apply your actual historical collection rate for this bucket
60+ days: be conservative — treat as uncertain until collected

Add projected new invoices from your production pipeline for weeks 5–13.

Step 2: Map your disbursements

List every cash outflow, week by week:

Payroll — fixed, usually every one to two weeks
Supplier and vendor payments — use your AP aging schedule, not an average
Loan and lease payments — fixed, known in advance
Tax payments — quarterly estimated, annual true-ups
Capital expenditures — any planned equipment purchases
Insurance, rent, utilities — fixed monthly, map to the week they clear

For variable disbursements, anchor to your AP aging the same way you did for AR. What’s due when? Don’t average across a month — model it by week.

Step 3: Calculate your weekly cash position

Starting cash balance + weekly receipts − weekly disbursements = ending balance. Do this for each of the 13 weeks. The ending balance from week 1 becomes the starting balance for week 2.

Two numbers to watch: the low point in your 13-week window (your minimum cash position) and whether that number ever goes negative. If it does, you have a defined problem with a defined timeline — which is far better than discovering it when the payment bounces.

Step 4: Maintain it weekly

A 13-week forecast that’s never updated is just a document. The value is in the weekly refresh — loading in what actually happened against what you projected, rolling the forecast forward by one week, and reviewing the variances.

Most variances come from one of two places:

Collections — customers paying earlier or later than expected
Production changes — material costs shifting, orders added or lost

Tracking variances is how the forecast gets more accurate over time. After a few months, you’ll know which customers always pay late, which cost categories run over, and where your assumptions need to be tighter.

Common mistakes

Using revenue booked instead of cash actually collected
Building it once and not maintaining it
Forgetting tax payments and annual insurance premiums
Not capturing seasonal inventory builds as disbursements
Failing to reconcile the forecast to actual bank balances weekly

When to bring in help

If you’re building this for the first time, a fractional CFO can set up the model, calibrate assumptions based on your actual AR and AP history, and train your controller to maintain it. For most manufacturing businesses, a working 13-week forecast can be up and running within two to three weeks.

If a lender is asking for one now and you don’t have it, that’s a more urgent situation — but still solvable quickly with the right help.