A 13 week cash flow forecast is a rolling, week-by-week projection of cash receipts, disbursements, and bank balances over the next quarter, built to give leadership a clear view of short-term liquidity. Its primary purpose is early warning: spotting a cash shortfall weeks before it hits so you can arrange financing, delay a payment, or accelerate collections. The immediate step is simple: set this week's actual opening bank balance and run your first 13-week projection today.
TL;DR:
- Build the baseline from one week of actuals and 12 forward weeks, timing receipts and payments by when cash reaches or leaves the bank.
- Assign one owner to refresh actuals weekly, reconcile last week's projections with results, and revise assumptions when collections or vendor payments repeatedly miss expectations.
- Flag any week when closing cash falls below the minimum operating balance, then separate a late receivable from a persistent deficit.
- Stress test delayed collections, sustained revenue declines, and unexpected payroll costs, then report the base case and at least one downside scenario weekly.
- Start with Excel to keep assumptions transparent; add bank, receivables, payables, and payroll integrations when manual updates become burdensome for the finance team.
Table of Contents
- Why leadership treats the 13-week cash flow as an operational discipline
- Step-by-step: building a 13-week cash flow from inputs to weekly baseline
- Model structure and the cash summary that drives decisions
- Working capital roll-forwards: turning balance sheet items into weekly cash timing
- Interpreting shortfalls, running scenarios, and connecting to runway
- Choosing Excel templates versus automated forecasting tools
- How a fractional CFO keeps the 13-week model accurate week after week
- The 13-week forecast works only when it stops being a crisis tool
- How we help you build and maintain a 13-week cash flow forecast
- FAQ
- Sources
Why leadership treats the 13-week cash flow as an operational discipline
A 13-week cash flow model is rolling, not fixed. Each week you drop the oldest week, add a new week 13 periods out, and refresh every input with actuals. That rolling structure is what separates it from an annual budget or a quarterly forecast: it stays current with what is actually happening in the bank account, not what was assumed three months ago.
Ownership usually sits with the CFO, a controller, an FP&A lead, or a fractional CFO brought in specifically for this kind of forecasting work. The model earns its place on the leadership agenda because it does several jobs at once: it gives real-time visibility into cash position, it surfaces working capital problems before they become liquidity crises, it gives lenders a credible basis for covenant and borrowing conversations, and it lets you stress-test decisions like a hire, a capital purchase, or a slow-paying customer before committing cash.
The model breaks down in predictable ways. Common mistakes include:
- Letting the forecast go stale because no one owns the weekly update
- Mixing income statement accruals with actual cash timing, which distorts the weekly numbers
- Skipping the back-solve on accounts payable, so disbursements never reconcile to real vendor terms
- Building a one-time model instead of a living rolling tool
Step-by-step: building a 13-week cash flow from inputs to weekly baseline
Building a dependable model starts with data, not a spreadsheet template. According to Wall Street Prep's breakdown of the 13-week cash flow model, timing conversion from monthly to weekly figures and consistent general ledger mapping are among the most time-consuming parts of building the model correctly, which is exactly where most first attempts go wrong.
- Gather your inputs. Pull the current bank balance, the accounts receivable aging ledger, the accounts payable aging, the payroll calendar, and any recurring disbursements such as rent, insurance, or loan payments.
- Set the baseline. Build one week of actuals followed by 12 forward weeks, and convert every monthly line item, rent, subscriptions, loan payments, into the specific week it actually clears the bank.
- Add financing and one-off rows. Include draws or paydowns on a line of credit, planned capital expenditures, tax payments, or any other non-recurring cash event on the week it is expected to hit.
- Back-solve accounts payable where needed. When vendor terms are inconsistent or informally extended, work backward from the cash you actually have available to determine a realistic payment week rather than assuming net-30 is always honored.
- Assign weekly ownership. Name one person responsible for refreshing the model every week from a single-source inputs sheet, so actuals replace projections cleanly instead of being re-keyed from memory.
For a deeper walkthrough of gathering and organizing these inputs, our guide to building a cash flow projection covers the data-collection step in more detail.
Pro Tip: Lock your inputs sheet with data validation so a dropped formula or an overwritten cell does not silently break next week's numbers.
Model structure and the cash summary that drives decisions
Every working 13-week model needs a cash summary worksheet, the single page leadership and lenders actually look at. The underlying detail sheets (receipts, disbursements, AR, AP) feed into it, but the summary is where decisions get made.
The standard layout runs in this order:
- Opening cash balance for the week
- Total cash receipts expected that week
- Total cash disbursements expected that week
- Net cash flow (receipts minus disbursements)
- Closing cash balance, which becomes next week's opening balance
Layered onto that structure is a minimum cash target, the balance below which you cannot comfortably operate, and a row showing available borrowing capacity on any revolver or line of credit. When projected closing cash dips below the minimum target in a given week, that is your trigger. Build a simple conditional flag or highlight rule on the summary tab so a shortfall week is visually obvious the moment the model updates, not something you discover by scrolling through formulas.
Working capital roll-forwards: turning balance sheet items into weekly cash timing
The accuracy of a 13-week forecast lives or dies on how well you convert balance sheet drivers into weekly cash timing. Four roll-forwards do most of the work.
- Accounts receivable: apply a collections curve or a days sales outstanding assumption to your open invoices, then map expected receipts to the specific week each invoice is likely to be paid rather than spreading collections evenly.
- Inventory: forecast purchases from cost of goods sold and your target days of inventory on hand, then schedule the resulting accounts payable impact in the week those purchases are actually invoiced.
- Accounts payable: map each vendor's payment terms to an expected pay date, and back-solve the timing when terms are informal or inconsistently honored.
- Accrued wages: align actual payroll dates, not the pay period they cover, to cash outflows, since payroll accrues on the income statement differently than it hits the bank.
The payroll distinction trips up more models than any other line item. A pay period ending on a Friday but funded the following Wednesday needs to sit in the week the cash actually leaves, not the week the labor was incurred.
Pro Tip: When AR collections run consistently behind your assumed curve, tighten the curve rather than the forecast; a model built on optimistic collections will miss every shortfall it was designed to catch.
Interpreting shortfalls, running scenarios, and connecting to runway
A projected shortfall needs a diagnosis before it needs a fix. A timing mismatch, cash is tight for a week or two because a large receivable lands late, resolves itself once that invoice clears. A structural shortfall, where disbursements consistently outpace receipts over a full 13-week horizon, signals a deeper problem that financing alone will not solve.
That structural read is where the forecast connects to runway and burn rate. Cash runway is calculated as current cash divided by net burn rate, and a 13-week model is the operational detail that validates or corrects that higher-level number week by week. JPMorgan's guidance on startup runway similarly ties short-term cash forecasts directly to financing timing decisions, since a rolling view catches a tightening runway long before an annual budget would.
Useful scenarios to run every week include:
- A two-week delay in customer collections across your largest accounts
- A top-line decline of a defined percentage sustained over the full 13-week window
- An unplanned payroll spike from overtime, bonuses, or a new hire
For businesses carrying working capital-intensive operations, resources like Emory Lending's guide to protecting contractor working capital with a 13-week forecast walk through specific levers, like adjusting payment terms or drawing on a credit line, that pair well with scenario testing. Report the base case and at least one downside scenario to leadership weekly, and reserve the full detail for lenders only when a covenant conversation requires it.
Choosing Excel templates versus automated forecasting tools
A well-built Excel template is the right starting point for most businesses, especially early on, because it forces you to understand every input and every formula driving the output. Wall Street Prep's template framework for the 13-week model includes an inputs sheet, working capital roll-forwards, a weekly summary, and a minimum cash line, the same structure outlined above.
As the business grows or the manual update burden becomes heavy, automation becomes worth the cost. Integration priorities, in order of impact, are:
- Bank feed connections, so the opening balance updates without manual entry
- Accounts receivable ledger sync, to automate collections timing
- Accounts payable aging feed, for real vendor payment timing
- Payroll system integration, since payroll is often the single largest recurring disbursement
The trade-off is real: Excel gives you full transparency and an audit trail you can walk a lender through line by line, while automated platforms save update time but can obscure the underlying assumptions if you are not careful about documentation. Many finance teams run both, an automated feed for speed, with periodic manual reconciliation for accuracy.
How a fractional CFO keeps the 13-week model accurate week after week
Sustaining a weekly cadence is harder than building the first version. Our approach assigns a single forecast owner, maps every line item to its general ledger account, and runs a weekly inputs checklist covering bank balance, AR aging, AP aging, and payroll so nothing gets missed between updates.
Much of the groundwork happens before the forecast is even built. We support QuickBooks cleanup so the underlying data is reliable, set up the template structure, and manage the weekly reporting cycle itself. The goal across engagements is consistent: a lender-ready model, less time spent each week rebuilding instead of analyzing, and reporting that looks the same from one week to the next so leadership can spot trends instead of relearning the format.
The 13-week forecast works only when it stops being a crisis tool
The biggest misconception about the 13-week cash flow forecast is that it belongs to a crisis. Most businesses first encounter the model during a restructuring or a liquidity scare, build it under pressure, and then quietly let it lapse once the emergency passes. That is backwards. The model's value comes from being boring: a weekly habit that catches a problem in week 4 instead of week 11.
Conventional advice spends too much time on template mechanics and not enough on governance. A perfectly structured spreadsheet maintained by no one is worse than a rough one updated religiously every Monday morning. The formulas matter far less than the discipline of refreshing actuals, reconciling last week's projection against what actually happened, and adjusting assumptions when they are consistently wrong.
If you take one thing from building this model, prioritize the weekly update ritual before you perfect the spreadsheet design. A forecast that is 90% accurate and updated every week beats a 99% accurate one that gets touched once a quarter. Accuracy compounds with cadence, not with formula complexity.
— Angelica
How we help you build and maintain a 13-week cash flow forecast
Building the first model is manageable. Keeping it accurate every single week, through payroll runs, slow-paying customers, and a growing transaction volume, is where most internal teams lose steam. Our fractional CFO services take that weekly burden off your plate: we build the model, maintain the weekly cadence, run scenario tests against collections delays or revenue swings, and produce lender-ready deliverables whenever you need them for a financing conversation.
Our forecasting work pairs naturally with QuickBooks cleanup and ongoing bookkeeping, so the data feeding your forecast is accurate from the start. If your business needs a reliable weekly view of cash without hiring a full-time finance team, reach out through our fractional CFO services page to talk about what a managed forecast could look like for you.
FAQ
What is a 13-week cash flow chart?
A 13-week cash flow chart is the visual or tabular output of the forecast, typically a weekly summary showing opening balance, receipts, disbursements, net cash flow, and closing balance across 13 consecutive weeks. It is the single page most leadership teams and lenders review, since it condenses the full model into one scannable view.
What does rolling 13 weeks mean?
Rolling 13 weeks means the forecast window always extends 13 weeks forward from the current week: each time a week closes and becomes an actual, a new 13th week is added at the far end. This keeps the forecast perpetually current, which is why Wall Street Prep's template framework treats weekly updating as a core part of the model rather than an optional refresh.
What is the 13-week cash budget?
The 13-week cash budget is another name for the same rolling forecast: a weekly plan of expected cash receipts and disbursements over a 90-day horizon, used to manage short-term liquidity rather than long-term profitability. It differs from an annual budget in that it tracks actual cash timing, not accrual-based income statement figures.
What is a 12-month rolling cash flow?
A 12-month rolling cash flow applies the same rolling logic at a monthly level instead of weekly, extending the projection forward by one month as each month closes. It gives a longer-range liquidity view but misses the week-to-week detail needed to catch a short-term shortfall, which is why many finance teams run both a 13-week model for near-term accuracy and a 12-month rolling view for longer-range planning.
Sources
- 13-Week Cash Flow Model (TWCF) | Template Example — Wall Street Prep
- Startup runway: reducing cash burn & extending your runway — JPMorgan
- Cash runway explained: formula, examples & uses — CFI