The 13-Week Cash Forecast Anatomy: Every Line Item a CFO Builds and Why

The 13-week cash forecast is the single most diagnostic deliverable a CFO produces, and it is also the most frequently butchered. Most versions you will see are a spreadsheet of guesses dressed up in formatting — an opening balance, a smear of "expected" receipts, a lump of payroll, and a closing number nobody trusts by Wednesday. The companies that run on those forecasts do not fail because they lack revenue; they fail because they could not see, in time, the week the cash ran out. A real 13-week cash forecast is something else entirely: a structured operating instrument that tells a founder exactly how many weeks of liquidity runway remain, which week breaks first, and what levers actually move the bottom line. This post walks the model line by line — every row a senior CFO builds, why it earns its place, and the decision rule attached to it.

I am deliberately not writing a "what is a cash forecast" explainer. You can google that. What you cannot google is the discipline behind a forecast that survives contact with a board, a lender, or a near-miss on payroll. That discipline is a method — a repeatable CFO playbook, not ad-hoc advice — and the method is the moat. It is also the thing standing between your company and the most avoidable kind of failure: solvency lost to a timing surprise nobody modeled.

Why 13 Weeks, and Why Direct-Method

Before the first line item, two design decisions govern everything. Get these wrong and the rest is noise.

Thirteen weeks is one fiscal quarter expressed in operating reality. A quarter is the rhythm at which boards, lenders, and management actually make decisions, but a monthly view hides the within-month timing that kills companies. A business can be profitable on a monthly P&L and still miss payroll in week 6 because a large customer pays on net-45 and rent, payroll, and a tax remittance all land in the same five-day window. That scenario is not exotic — it is the single most common way a growing, "healthy" company nearly dies, and a monthly cash view is structurally blind to it. Thirteen weeks is long enough to see the next two payroll cycles, the next quarterly tax payment, and at least one full collection cycle of your receivables — and short enough that the line items are knowable rather than imagined.

The direct method is non-negotiable. A 13-week cash forecast is built from actual cash movements — receipts in, disbursements out — not from an indirect bridge off net income. The indirect method (start with net income, add back depreciation, adjust for working capital) is fine for an annual plan. It is useless for liquidity runway planning because it obscures timing, and timing is the entire point at the 13-week horizon. The decision rule: if a line cannot be tied to a specific bank account on a specific week, it does not belong in the cash forecast. Most "cash forecasts" a founder shows me fail this test on the first line — which is exactly why they break the first time real money is on the table.

With those two anchors set, we build the model from the top down.

Line 1–3: The Opening Cash Position (And Why It's Harder Than It Looks)

The forecast opens with cash, but "cash" is three lines, not one.

• Operating cash by account. List every operating account separately. A single blended number hides the truth that the money is in the wrong place — $400k sitting in a money-market sweep that takes two days to free up is not the same as $400k in the checking account that clears payroll Friday. Founders have bounced payroll while "having the cash" for exactly this reason.
• Restricted or committed cash. Cash collateral for a letter of credit, customer deposits you are contractually holding, payroll-tax trust amounts — these are on the balance sheet but they are not available liquidity. A CFO segregates them on a separate line so the available-cash number is honest. Counting restricted cash as runway is how a company convinces itself it has six weeks when it has three.
• Available revolver capacity. If there is a line of credit, the undrawn availability belongs in the opening block as a memo line. Liquidity is cash plus what you can draw today, and a forecast that ignores the revolver under-states the company's true runway and over-states the crisis.

The opening balance is also the model's integrity check. Every Monday, the prior week's forecast closing balance gets compared to the actual bank balance. That variance is the first thing I look at — more on the variance discipline below. A forecast that cannot reconcile to the bank to the dollar is one nobody on a board should act on, and the moment a lender catches that gap, your credibility in the room is gone.

Line 4–9: Cash Receipts, Built From the AR Aging, Not From Hope

This is where amateur models collapse. They take the monthly revenue plan, divide by 4.33, and call it weekly receipts. That is a revenue forecast, not a cash forecast — and it is the single most expensive mistake in the discipline, because it consistently shows cash arriving weeks before it actually does. A CFO builds receipts from the collections reality.

Customer collections from existing AR. Start with the current accounts-receivable aging and apply your collection pattern week by week. The decision rule here is to use demonstrated payment behavior, not stated terms. If a customer is on net-30 but historically pays in 52 days, you forecast 52. The model should carry a named-account schedule for the largest receivables — typically the accounts that make up the bulk of the balance — and a pooled, percentage-based assumption for the long tail of small invoices.

Collections from new bookings within the window. Sales that will be invoiced and collected inside 13 weeks. This is the most uncertain receipt line, so it gets the most conservative treatment: only include cash you can defend, and lag it realistically from booking to invoice to payment. Optimism on this line is how a forecast lies to you in the exact week you most need the truth.

Recurring / subscription receipts. For SaaS or any recurring model, this line is the most predictable cash you have — billing runs on a calendar, churn is estimable, and dunning recovery follows a pattern. Model it from the billing schedule, not the GAAP revenue schedule.

Other receipts. Tax refunds, financing draws, asset sales, insurance proceeds, interest income. Each gets its own line because each has different certainty and different timing, and lumping them hides risk.

The judgment that separates a CFO-grade receipts section: every receipt line carries a probability and a timing assumption that is documented, so when week 7 comes in light you can immediately see which assumption broke — was it timing slippage or an actual shortfall? That distinction drives completely different responses, and a forecast that cannot tell you which one you are facing leaves you guessing with payroll on the line. This is precisely the judgment a fractional CFO engagement installs that a divide-by-4.33 spreadsheet never will.

Line 10–22: Cash Disbursements, the Section That Earns Its Keep

Disbursements are where the model becomes board-ready, because this is where you demonstrate that you understand the business's obligations at the granularity of a bank statement. I build disbursements in tiers of controllability.

Tier 1 — Non-discretionary, fixed-date obligations. These hit on known dates and cannot slip without consequences:

• Payroll and payroll taxes. Modeled to the actual pay calendar — the specific Fridays — including employer-side taxes and benefit remittances. Payroll-tax deposits often land a few days after the run; model them on their real due dates. This is the line that, if missed, ends the company, so it is forecast first and protected always.
• Debt service. Principal and interest on every facility, on its contractual date. Pull the amortization schedule; do not estimate.
• Rent and lease obligations. Real estate and equipment, on their due dates.
• Taxes — income, sales, payroll. Quarterly estimated payments and sales-tax remittances are the classic "surprise" that the monthly view misses. They belong on the exact week they are due. A six-figure estimated payment that lands unmodeled in week 8 has turned solvent companies upside down overnight.

Tier 2 — Committed but timing-flexible. Accounts payable to vendors. Built from the AP aging plus expected new bills, scheduled by your payment policy. The key insight: AP timing is a lever, not a fact. The forecast should show payments on their current policy, with the flexibility to model stretching terms as a scenario — never bake the stretch into the base case, or you lose visibility into the cushion you actually have.

Tier 3 — Discretionary. Capital expenditures, marketing spend above committed contracts, discretionary bonuses, hiring-related costs. These are the levers a founder can pull in a crunch, so they are isolated on their own lines. The decision rule: if management can decide on Monday not to spend it this week, it is discretionary and must be visibly separable.

This tiering is not cosmetic. When liquidity tightens, the CFO's first move is to walk up the tiers — defer Tier 3, then renegotiate Tier 2 timing — while never touching Tier 1. A forecast that mixes these tiers into one "operating expenses" blob cannot support that decision, which means in a crunch it forces blunt, panicked cuts — usually to the wrong things — instead of a sequenced response. A forecast that separates them turns a panic into a sequence of choices. The difference between those two outcomes is often the difference between a hard quarter and a down round.

Line 23–27: The Net Movement, Closing Balance, and the Runway Math

With receipts and disbursements built, the arithmetic block writes itself — but how you present it is a judgment call.

• Net weekly cash flow. Receipts minus disbursements for the week. The sign and trend of this line tell the story at a glance.
• Closing cash before financing. Opening plus net flow. This is the "what the operating business does to cash" number.
• Financing movements. Revolver draws and paydowns, modeled to keep the closing balance above a minimum. A CFO models the revolver as a managed line — drawing to a target floor, repaying when cash allows — which mirrors how the facility is actually used and reveals interest cost and covenant proximity.
• Closing available cash. The number the founder reads first.
• Weeks of runway. Closing available cash divided by average weekly burn, carried as a rolling figure. This is the headline for liquidity runway planning, and it is the number a board internalizes faster than any other.

The non-negotiable formatting rule: the minimum closing balance across all 13 weeks gets its own highlighted cell. A forecast that ends week 13 at a healthy $2M but dips to negative $150k in week 6 is a forecast of insolvency, not health. The trough week, not the ending week, is the truth — and a model that reports the ending number while burying the trough is not optimistic, it is dangerous. That single hidden cell is the gap most amateur forecasts leave wide open.

The Three Scenarios Every Forecast Carries

A single-column cash forecast model is a guess with false precision. A CFO-grade forecast carries three columns from the day it is built, because liquidity decisions are made against downside, not expectation. A one-column forecast does not just under-inform a board — it actively lulls one, presenting a most-likely path as if it were the only path.

• Base case. Demonstrated collection behavior, current AP policy, committed spend only. This is the most-likely path and the one you report against.
• Downside case. The disciplined stress test: collections slow by a defined number of days, your single largest customer slips a payment by 30 days, a new booking you were counting on does not close. The downside answers the only question that matters in a crunch — how many weeks until we hit zero if things go wrong in the ways they usually go wrong? A company that has never modeled this learns the answer for the first time in the week it can least afford the lesson.
• Management case. The base case plus the levers you would pull — AP stretch, deferred capex, a hiring freeze, a revolver draw. This case quantifies the company's self-rescue capacity before the crisis, so the board can pre-approve the playbook. Walking into a financing conversation able to show this case is the difference between negotiating from strength and raising under duress.

The pattern recognition embedded here is the senior judgment a fractional engagement buys: knowing which assumptions to flex and by how much comes from having watched these stress points break across many companies. The framework is repeatable; the calibration is experience — and it is exactly the experience a growth-stage company cannot afford to hire full-time and cannot afford to be without. You can read more about how we structure these engagements on our Home page.

The Variance Discipline: Where a Model Becomes an Instrument

A forecast you build once and admire is decoration. A forecast you re-true every week is an instrument. This is the part most solo operators skip — not because they don't know better, but because the weekly grind is genuinely hard to sustain alone — and it is the part an AI-assisted pipeline makes sustainable.

Every Monday, three things happen:

1. Actuals replace the prior week's forecast. The oldest week drops off, a new week 13 is added — the model rolls forward continuously.
2. Variance is computed line by line. Forecast versus actual for every receipt and disbursement line, not just the total. The total can be right for the wrong reasons; the line detail is where the signal lives.
3. Variances are classified as timing or permanent. A receipt that came a week late is a timing variance — it self-corrects. A receipt that came in 20% short is a permanent variance — it changes the runway and demands a response. Conflating the two is the most common analytical error in cash forecasting, and it costs companies in both directions: panicking over a timing blip, or ignoring a permanent erosion until it is too large to absorb.

The forecast accuracy improves measurably over the first several weekly cycles as the collection-pattern and AP-timing assumptions get calibrated against reality. Teams often aim for forecast-versus-actual variance on total net cash flow to tighten into a single-digit percentage band within roughly a quarter of disciplined weekly cycles — framed as a target, not a guarantee, because every business's volatility is different. A forecast that gets more trustworthy every week is a compounding asset; one that is rebuilt from scratch each month, by contrast, never earns the board's confidence.

This weekly cadence is also where speed and consistency become a genuine differentiator — and where a solo fractional CFO, however senior, hits a throughput wall. Producing a re-trued, three-scenario, line-classified forecast every single Monday is grinding work for one person, and the weeks it slips are precisely the chaotic weeks you most needed it. An AI-assisted pipeline ingests the bank feed, AR aging, AP aging, and payroll calendar, drafts the variance analysis, and flags the breaks — so the CFO spends time on judgment and the founder conversation, not on data wrangling. The method stays human; the throughput stops being a constraint. That combination — senior judgment delivered with the consistency of a machine — is what a single fractional operator cannot match and what your finance function gets with us.

How the Forecast Talks to the Rest of the Board Pack

The 13-week cash forecast does not live alone. It is the load-bearing wall of a connected set of board-ready deliverables, and a CFO builds it to feed the others:

• The flash report pulls the current-week closing balance and weeks-of-runway figure as its lead liquidity metric.
• The covenant monitor reads the projected closing balances and revolver draws to test minimum-liquidity and fixed-charge-coverage covenants forward, not just at quarter-end — so a covenant breach is forecast weeks before it happens, while there is still time to act. A breach discovered at quarter-end is a renegotiation from weakness; the same breach seen six weeks out is a managed conversation, and that lead time is worth more than any line on the forecast.
• The variance analysis rolls the weekly cash variances into the monthly management narrative.

When these tie together — same numbers, same assumptions, no reconciliation gaps — the board stops auditing the finance function and starts trusting it. That trust is the real deliverable, and it is worth real money: a board that trusts your numbers approves faster, supports raises, and stops second-guessing management. A board that catches the finance function contradicting itself does the opposite. To see how this fits into a full fractional CFO engagement, start at our Home page.

Common Failure Modes (And the Decision Rule That Prevents Each)

A quick field guide to the ways 13-week cash forecasts fail, and the rule that closes each gap. Every one of these is a gap a serious lender or board member will find — better that your CFO finds it first:

• Revenue smeared into receipts. Rule: build receipts from the AR aging and demonstrated payment behavior, never from the revenue plan.
• Stated terms instead of actual behavior. Rule: forecast collections on historical days-to-pay per customer, not contractual terms.
• Discretionary and fixed costs blended. Rule: tier every disbursement by controllability so the crunch playbook is visible.
• Ending balance celebrated, trough ignored. Rule: highlight the minimum closing balance across all 13 weeks as the headline risk metric.
• Single scenario. Rule: always carry base, downside, and management cases.
• Built once, never re-trued. Rule: roll forward and classify variances every week without exception.
• Restricted cash counted as available. Rule: segregate restricted and committed cash from available liquidity in the opening block.

Every one of these failures comes from treating the forecast as a reporting artifact rather than a decision instrument. The anatomy I have walked here exists to make decisions: when to draw the revolver, when to stretch a vendor, when to freeze hiring, and — most importantly — how many weeks you have before any of those choices stop being optional. Get the anatomy wrong and you do not find out until the week the options have already closed.

The Takeaways

If you build only the headline number, you have a guess. If you build the anatomy, you have an instrument. The 13-week cash forecast earns its place in the board pack when:

• It is direct-method, tied to specific accounts and specific weeks.
• Receipts come from the AR aging and real payment behavior, not the revenue plan.
• Disbursements are tiered by controllability, with payroll and debt service protected first.
• The trough week, not the ending week, is the headline risk.
• It carries three scenarios so downside and self-rescue are both quantified.
• It is re-trued weekly with variances classified as timing versus permanent.

This is the difference between a spreadsheet and a cash forecast model a board will act on — and it is a repeatable method, not a one-off heroics. Done weekly, with the right pipeline behind it, liquidity runway planning stops being a fire drill and becomes a standing capability. The cost of not having it is not abstract: it is the missed payroll, the surprise tax bill, the covenant breach found too late, the raise taken at a worse price because nobody could prove how much runway was real.

If you are flying on a forecast you do not fully trust — or building payroll decisions on a number that changes every time someone touches the file — it is time to put a real one in place before the week that punishes the gap. Visit our Home page to see how a fractional CFO engagement installs this exact 13-week discipline in your finance function: the proprietary method, the board-ready deliverables, and the senior judgment, delivered with a consistency a solo operator can't sustain — so the next board meeting opens with a number everyone believes. Let's build the forecast your decisions deserve.