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

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

There is a specific moment in a growing business when the founder stops being able to hold the cash picture in their head.

It usually happens around $2M to $5M in revenue. The business has more vendors than the founder can track. Retailer payments come in on different schedules. Inventory arrives in waves. Payroll is a meaningful number. Tax payments hit quarterly. Commissions, reimbursements, subscription fees, and insurance premiums all land at different times.

Up to that point, the bank balance plus a general sense of what is coming in and going out is enough. After that point, it is not. Founders who rely on gut for cash management past this stage start making specific, expensive mistakes: paying a vendor early when they did not have to, missing a short-term opportunity because they thought cash was tight when it was not, running up a credit line unnecessarily, or getting blindsided by a tax payment that was on the calendar all along.

The 13-week cash flow forecast is the tool that fixes this. It is not complicated. It is just disciplined.

What it is

A 13-week cash flow forecast is a week-by-week projection of every dollar entering and leaving the business over the next 13 weeks — about one quarter.

Each week has a starting cash balance, projected cash inflows, projected cash outflows, and an ending cash balance that rolls into the next week's starting point. The whole thing fits on a single spreadsheet, updated weekly.

Thirteen weeks is the right horizon for a reason. It is long enough to see the next quarter clearly — including any seasonal patterns, upcoming tax payments, or expected retailer settlements. It is short enough that the numbers can be reasonably accurate. Longer forecasts become speculation. Shorter forecasts miss things you need to see coming.

Why it beats a P&L forecast

A P&L tells you whether you are profitable. A cash flow forecast tells you whether you can pay your bills next month.

Those are different questions, and a business can be profitable and still run out of cash. This is especially true in CPG, construction, and any business with meaningful working capital needs. Revenue recognized in April might not hit the bank until July. A big inventory buy in March is a cash outflow this quarter, even though it flows through the P&L as COGS spread over future sales.

A good cash forecast captures what the bank account is actually going to do, separate from what the P&L says.

The inflow side

Cash inflows come from three main sources: collections on outstanding receivables, new sales collected immediately, and non-operating inflows like loans, capital raises, or asset sales.

**Collections on AR.** Open your AR aging report. For each customer with a balance, project when that balance will actually collect. Not when it is due — when it will actually come in. Retailer A always pays on day 45. Retailer B is net 30 but drags to 60. Retailer C deducts 8% in chargebacks before paying. All of that should land in the weekly forecast at the likely collection date, net of expected deductions.

**New sales.** For the next 13 weeks, project new revenue by channel. Convert that to cash based on the payment terms of each channel. DTC revenue hits Stripe with a 2-day lag. Wholesale invoices go on terms. Amazon pays on a 14-day schedule. Each channel has its own cash conversion pattern.

**Non-operating inflows.** A loan draw, a capital call, a grant, an insurance settlement, a tax refund. These are often the difference between a tight quarter and a manageable one. Schedule them by the week they realistically land.

The outflow side

Outflows are where most founders underestimate. The P&L shows expenses smoothed across months. Cash flow shows them hitting when they actually hit.

**Payroll.** Bi-weekly or semi-monthly, depending on your schedule. Do not forget contractor payments, commissions, and bonuses. Payroll tax deposits are often a separate line item with their own timing.

**Inventory and COGS.** Purchase orders you have already issued hit on the vendor's payment terms. Upcoming POs hit when you schedule them. Co-packer runs often require deposits ahead of production and final payment on delivery. Freight bills show up separately. 3PL fees hit monthly.

**Rent and occupancy.** First of the month for most leases.

**Insurance, software, and subscriptions.** Some monthly, some annual. Annual subscriptions are the ones founders forget — the $24K insurance premium that hits in April, the $18K ERP annual renewal in September.

**Taxes.** Quarterly estimated payments for federal and state income tax. Monthly or quarterly sales tax remittances. Annual franchise taxes. Payroll tax liabilities on their own schedule.

**Trade spend.** For CPG specifically, trade deductions reduce collections weeks after the sale. If you are not modeling this, your cash forecast will overstate inflows meaningfully.

**Loan payments.** Principal and interest on any financing.

**Distributions and owner draws.** If the business makes regular distributions, schedule them.

**Discretionary categories.** Marketing spend, professional services, travel, office supplies, one-off purchases. These tend to be the most flexible — and the most likely to drift over budget if not tracked.

The mechanics of the build

A usable 13-week cash forecast is one spreadsheet with about 30 rows and 14 columns. Columns are labeled with the Monday date of each week. Rows are grouped into sections: starting balance, inflows, outflows, ending balance.

Build it in Excel or Google Sheets. There are finance tools that do this, but the spreadsheet is faster to adapt and more transparent to whoever is reading it. A founder should be able to look at the forecast and trace any number back to its assumption.

The initial build takes a few hours. Updating it weekly takes 30 to 60 minutes once the rhythm is established.

The weekly rhythm

Once the forecast exists, the value comes from updating it every week, not every month.

At the end of each week, three things happen. First, the actual inflows and outflows for the past week get recorded against the forecast, and variances get explained. Did Retailer A pay when expected? Did the inventory shipment payment actually go out? Did a surprise cost hit?

Second, the forecast for the next 12 weeks gets updated. New information changes assumptions. A late AR payment pushes a collection into next week. A new PO gets scheduled. An unexpected expense needs to land somewhere.

Third, a new 13th week gets added on the end. The forecast always rolls forward so you always have a 13-week view.

The weekly rhythm is what turns a forecast into a management tool. A forecast built once and never updated is a snapshot. A forecast updated every week is a live picture of where the cash is going.

What the forecast enables

Businesses that run a disciplined 13-week cash forecast make different decisions than businesses that do not.

They know whether to take a PO or hold off. They know whether to draw on the credit line before a tight week or ride it out. They know when to negotiate terms with a key vendor. They know when they have surplus cash to deploy into inventory, hiring, or marketing.

They also avoid the specific failure mode of realizing on a Tuesday that payroll on Friday is going to bounce. That moment is preventable. A 13-week forecast prevents it.

When to start

The honest answer: before you need one.

Most founders build their first cash forecast in the middle of a cash crunch. That is better than never, but worse than building it while cash is comfortable. When the business is healthy, the forecast documents what normal looks like. When the business gets tight, you have a baseline to compare against.

For businesses between $1M and $10M in revenue, the 13-week cash flow forecast is non-negotiable. Above $10M, it remains essential but usually gets integrated into a broader FP&A function. Below $1M, the rhythm is still useful, though sometimes a simpler 8-week view is enough.

The harder truth

Running the forecast is not the hard part. The hard part is acting on what it shows you.

If the forecast says you are going to be short in week seven, you have to make decisions in week one or two. Accelerate collections. Stretch a payment. Negotiate a term. Pause a hire. The forecast gives you time — how you use it is up to you.

Businesses that fail to act on their own cash forecast are in some ways worse off than businesses that never built one. They knew and did nothing. That tends to be a leadership issue that no spreadsheet can fix.

---

*Thryve builds and runs 13-week cash flow forecasts as part of our fractional CFO engagements. If your cash picture is getting foggy, a Quick Review can tell you what building one would reveal about your business.*