How to Build a 13-Week Cash Flow Forecast in Excel

A 13-week cash flow forecast is a rolling, weekly, cash-based model that shows how much cash a business is likely to have over roughly the next 90 days. Unlike an accrual forecast, it focuses on when money actually enters and leaves the bank account.

For CFOs, finance managers, treasury teams, lenders, and business owners, that makes it one of the most practical tools for spotting a liquidity gap early enough to do something about it.

---

TL;DR:

• A 13-week cash flow forecast tracks expected cash receipts and payments week by week using the direct cash method.
• The model should start with cash that is actually available to fund operations, supported by realistic AR, AP, payroll, tax, debt, and other timing assumptions.
• Each closed week should be replaced with actual results and a new Week 13 added so the forecast remains rolling.
• Variance analysis matters as much as the forecast itself because it reveals which assumptions are consistently wrong.
• Base, downside, and severe scenarios turn the forecast from a reporting file into a decision-making tool.

---

Table of Contents

• Why the 13-week horizon matters
• Core components every 13-week model needs
• How to build a 13-week cash flow forecast in Excel
• Worked 13-week cash flow example
• Weekly cadence and variance review
• Scenario planning and mitigation
• Common 13-week cash flow mistakes
• Recommended Excel workbook structure
• Get a model built around your business
• FAQ
• Sources

Why the 13-week horizon matters

Most accounting reports are accrual based. Revenue and expenses are recognized when they are earned or incurred, not necessarily when cash moves. A 13-week forecast is different. It generally uses the direct cash forecasting method, mapping expected receipts and payments into the week in which they are expected to hit the bank.

That distinction matters because a profitable company can still run out of cash when customer collections lag behind payroll, taxes, supplier payments, or debt service.

Thirteen weeks is long enough to see meaningful funding problems approaching, but short enough for weekly assumptions to remain operationally useful. A four-week view can be too short for financing or cost actions. A 12-month view is useful for strategic planning, but monthly granularity can hide a one- or two-week liquidity squeeze.

That is why many finance teams use both: a 13-week model for near-term cash decisions and a longer monthly model for annual planning.

Core components every 13-week model needs

The core model is simple. The quality comes from the timing assumptions behind it.

• Opening available cash: begin with cash that is actually available to fund operations. Restricted, ring-fenced, or otherwise unavailable balances should be separated where relevant.
• Cash inflows: customer collections, refunds, grants, asset-sale proceeds, financing draws, and other expected receipts.
• Cash outflows: payroll, suppliers, taxes, debt service, rent, capital expenditure, and other disbursements.
• Net weekly cash flow: total inflows less total outflows, plus or minus financing activity.
• Closing cash: the amount rolled forward as the next week’s opening cash.
• Supporting schedules: AR aging, AP aging, payroll calendars, tax schedules, debt schedules, inventory commitments, and other source data used to determine realistic cash timing.

At entity level, show intercompany transfers explicitly. In a consolidated forecast, eliminate transfers between entities already inside the forecast perimeter so the same cash is not counted twice.

How to build a 13-week cash flow forecast in Excel

1. Define the perimeter. Decide which legal entities and bank accounts belong in the forecast.
2. Reconcile opening cash. Tie the starting balance to actual bank balances and separate unavailable cash where necessary.
3. Collect source data. Pull AR aging, AP schedules, payroll dates, tax due dates, debt schedules, recurring payments, capex plans, and financing availability.
4. Translate accrual data into cash timing. Put each receipt or payment into the week in which cash is realistically expected to move.
5. Build the weekly roll-forward. Each week’s closing cash becomes the next week’s opening cash.
6. Add integrity checks. Week 13 closing cash should equal opening cash plus cumulative inflows, less cumulative outflows, plus or minus financing.
7. Document assumptions. Record why a customer is expected to pay in Week 4, why a tax payment lands in Week 7, or why a facility draw is available in Week 9.
8. Protect formulas and separate inputs. Keep hardcoded assumptions away from calculation cells.

Important: completed weeks can be reconciled to actual bank activity. Future forecast weeks cannot be reconciled to a future bank balance; instead, use roll-forward integrity checks to make sure the model is internally consistent.

Pro Tip: Add a confidence flag beside major assumptions. High-confidence items may include payroll or scheduled debt service. Lower-confidence items may include a disputed customer collection or uncertain financing draw.

Worked 13-week cash flow example

Below is a simplified two-week slice of the same logic you would extend across 13 weekly columns in Excel.

Core formula:

Closing Cash = Opening Cash + Total Inflows - Total Outflows +/- Financing

Next Week Opening Cash = Prior Week Closing Cash

In a real workbook, each inflow and outflow category can be broken into more detail. The goal is not to create the longest spreadsheet. The goal is to make the timing assumptions visible enough that management can challenge and update them.

Weekly cadence and variance review

A 13-week forecast is not a one-time report. It is a rolling operating process.

• Confirm the actual closing bank balance for the completed week.
• Replace that week’s forecast with actual receipts and disbursements.
• Compare forecast versus actual by major cash flow category.
• Investigate material timing or amount variances.
• Update assumptions for the remaining 12 weeks.
• Add a new Week 13 so the horizon remains constant.

Consistency matters more than unnecessary sophistication. Ripple Treasury also emphasizes the importance of a consistent weekly forecasting process and regular variance review.

A useful variance log should distinguish between:

• Timing variance: the cash movement happened, but in a different week.
• Amount variance: the cash movement happened in the expected week, but the amount differed.
• Missed item: the transaction was not forecast at all.
• Assumption change: new information changed the expected outcome.

Scenario planning and mitigation

A single forecast tells you what management currently expects. Scenarios show what happens when those assumptions fail.

1. Base case: use the best current assumptions for collections, payments, and financing.
2. Downside case: slow customer collections, pull forward selected payments, or delay expected receipts.
3. Severe case: combine several adverse assumptions, such as a major customer delay plus tighter supplier terms.
4. Test mitigation levers: accelerate collections, defer discretionary spending, delay capex, renegotiate payment timing, or draw available financing.
5. Check timing: a mitigation only works if it can be executed before the projected cash shortfall occurs.
6. Present a decision: identify the amount, action, owner, and week by which management must act.

When financing alternatives are part of the decision, the Cash & Financing Optimizer can be used alongside the forecast to compare funding choices and timing constraints.

Common 13-week cash flow mistakes

• Using invoice dates instead of cash dates. Revenue recognition and invoicing do not tell you when cash will arrive.
• Assuming AR aging equals collection timing. Old receivables may require customer-specific assumptions rather than a generic DSO rule.
• Forgetting restricted cash. Not every bank balance is necessarily available to fund operations.
• Double-counting intercompany transfers. This often happens when separate entity forecasts are consolidated.
• Hardcoding formulas. One accidental overwrite can quietly break the weekly roll-forward.
• Ignoring forecast accuracy. A forecast without variance analysis does not learn from its own mistakes.
• Keeping the same 13 columns forever. A rolling forecast must add a new Week 13 after each completed week.
• Overbuilding. More tabs and categories do not automatically make the forecast more useful.

Recommended Excel workbook structure

A practical workbook can remain simple:

• Guide / assumptions: scope, ownership, definitions, and forecast rules.
• Inputs: AR, AP, payroll, debt, tax, recurring payments, and other raw schedules.
• 13-week forecast: weekly receipts, disbursements, financing, and cash balances.
• Scenarios: base, downside, and severe-case assumptions.
• Variance analysis: forecast versus actual by week and cash-flow category.
• Dashboard: minimum cash, liquidity headroom, funding requirement, and major drivers.

Automation should come after the manual model works reliably. Bank imports, consistent transaction mapping, Power Query, formulas, or lightweight macros can reduce weekly maintenance, but automation should not hide assumptions that management needs to review.

Get a 13-week cash flow model built around your business

Frac CFO offers a custom 13-Week Cash Flow Forecast service for businesses that want the workbook built around their actual cash structure rather than a generic file.

The model can incorporate bank accounts, AR and AP timing, payroll, taxes, debt service, financing facilities, scenario testing, and management reporting needs.

Get a Custom 13-Week Forecast Browse Excel Templates

FAQ

What is a 13-week cash flow forecast?

It is a rolling weekly forecast of expected cash receipts, cash payments, financing activity, and closing cash over the next 13 weeks.

Why 13 weeks?

Thirteen weeks is roughly one quarter. It gives management enough time to react to a projected funding problem while preserving weekly detail that can disappear in a monthly forecast.

What does rolling 13 weeks mean?

When one week closes, that forecast week is replaced with actual results and a new Week 13 is added. The forecast therefore always looks 13 weeks ahead.

Is a 13-week cash flow the same as a 13-week cash budget?

The terms are often used interchangeably. Both normally refer to a short-term weekly cash forecast focused on expected receipts, disbursements, and liquidity.

Should a 13-week forecast use the direct or indirect method?

The direct method is generally more useful for a 13-week liquidity model because it forecasts specific cash receipts and payments rather than starting from accounting profit and adjusting back to cash.

Should I use weekly or monthly cash flow forecasting?

Use weekly forecasting when short-term liquidity and payment timing matter. Use a monthly forecast for longer-range planning. Many finance teams maintain both.

About the author

Jonas — MSc Quantitative Finance, FMVA®
Fractional CFO and financial-modeling specialist focused on Excel-based forecasting, decision models, dashboards, and finance automation.

Sources

• Cherry Bekaert — What Is a 13-Week Cash Flow Model?
• Deloitte — 13 Week Cash Flow Forecasting
• Ripple Treasury — What Is 13-Week Cash Flow Forecasting?
• AICPA & CIMA — How a 13-Week Cash Flow Cycle Can Help Your Business

Recommended

• Custom 13-Week Cash Flow Forecast
• Cash & Financing Optimizer
• Excel Templates