13 Week Cash Flow Forecast: How to Build One That Works
Runway expressed in months is a comfort. Runway expressed in weeks is a decision-making tool.
Most businesses know roughly how much cash they hold and roughly how long it lasts. Neither number survives contact with a delayed customer payment or an unexpected tax bill. A weekly view is what turns an abstract figure into something a founder can actually plan against.
A 13 week cash flow forecast covers one quarter, updated weekly. It runs on a cash basis only, because accrued revenue does not pay salaries. Roll it forward each week by dropping week one and adding week fourteen. Variance against actuals is where the model earns its value.
Thirteen weeks is one quarter, which is why it works.
"The moment a founder builds their first weekly forecast is usually the moment they realise the problem is not how much cash they have. It is when it arrives relative to when it leaves."
JOHN ORTELLE
Key Takeaways
Here is how the model is structured, why it runs on a cash basis only, and the weekly rhythm that keeps it useful. Building it takes an afternoon. Maintaining it takes twenty minutes a week.
A 13 week cash flow forecast is a rolling weekly projection of every cash inflow and outflow over the next quarter. It is refreshed each week with actuals so the horizon always extends thirteen weeks forward, giving week-by-week visibility rather than a monthly average.
Why Thirteen Weeks and Not Twelve Months
Thirteen weeks is one quarter. That matters because a quarter is the shortest period over which most business decisions can meaningfully be influenced.
An annual forecast is a planning document. It sets direction and it is largely fiction by month four. A 13 week cash flow model is an operating document, and the difference is that you can act on it.
Weekly granularity is the second reason. Monthly forecasts average away the timing problem, and the timing problem is the one that actually causes trouble. A business can be profitable across a month and still be unable to make payroll in week two of it.
Cash Basis Only: The Rule People Get Wrong
Every line in a 13 week cash flow forecast records money moving. Not money earned, not money invoiced. Money landing in or leaving the bank account. Getting this wrong is what makes a 13 week cash flow forecast misleading rather than useful.
This is where accrual thinking causes real damage. Revenue recognised in March that will be collected in June belongs in the June week, not the March one. Treating it otherwise produces a forecast that looks healthy right up until the moment it is not.
The same applies in the other direction. A vendor invoice received today but payable in forty-five days sits in the week it will actually be paid. This is why the forecast is built separately from GAAP financial reporting rather than derived from it.
Building the Rolling Cash Flow Forecast
A rolling cash flow forecast is built in four blocks: opening balance, inflows, outflows, closing balance. The closing balance of each week becomes the opening balance of the next.
Inflows are customer receipts, and they should be modelled by expected collection date rather than invoice date. If a customer historically pays at day fifty-two despite thirty-day terms, model day fifty-two. Optimism here is the most common source of forecast error.
Outflows split into fixed and variable. Payroll, rent, loan payments and subscriptions land on predictable dates. Vendor payments, taxes and one-offs need individual scheduling.
The rolling mechanic is what keeps it alive: each Monday, replace week one with actuals, shift everything forward, and add a new week fourteen. A rolling cash flow forecast that is not rolled becomes a static spreadsheet within a month.
Weekly Cash Flow Forecasting for Small Business
Weekly cash flow forecasting for small business works best as a fixed rhythm rather than an occasional exercise.
Twenty minutes each Monday covers it: update last week’s actuals, review the variance, adjust the forward weeks where something has changed, and note anything that needs a decision.
The variance review is the part most people skip and the part that makes the model useful. If receipts came in $18,000 under forecast, the question is whether that is timing or whether the customer is not going to pay. Those are different problems with different responses.
Weekly cash flow forecasting for small business also changes the conversation with the team. A specific week where the balance dips is actionable. A general sense that cash is tight is not.
Using a 13 Week Cash Flow Forecast Template Excel
A 13 week cash flow forecast template excel file is the most common starting point, and for most US small businesses it remains adequate well past the point people expect.
The structure below is the one we build for clients. Rows are line items, columns are the thirteen weeks, and the only formulas required are running totals.
| Block | Line items | Modelled by | Common error |
|---|---|---|---|
| Opening balance | Bank balance at week start | Actual, from bank | Using ledger instead of bank |
| Inflows | Customer receipts, refunds, funding | Expected collection date | Modelling by invoice date |
| Fixed outflows | Payroll, rent, loans, subscriptions | Known payment dates | Missing quarterly items |
| Variable outflows | Vendors, taxes, contractors, one-offs | Scheduled individually | Omitting tax payments |
| Closing balance | Opening plus inflows less outflows | Calculated | Not carrying forward |
The Common error column is worth reading before building. Quarterly tax payments and annual insurance renewals are the two items most frequently missing from a first attempt, and both are large enough to change the answer.
Weekly Forecast vs Monthly Forecast
13 week weekly | 12 month monthly | |
|---|---|---|
Primary use | Operating decisions | Planning and budgeting |
Timing visibility | Week by week | Averaged, timing hidden |
Update frequency | Weekly, 20 minutes | Monthly or quarterly |
Catches payroll risk | Yes | Usually not |
The verdict: these are complementary, not alternatives. The annual model answers whether the plan works. The weekly model answers whether you can execute it between now and the end of the quarter.
EXPERT INSIGHT
Pankaj Gohel, Finance Operations Lead at Finkeepers
“The forecast that gets used is the one somebody owns on a fixed day. We set it for Monday morning and we do not move it. The businesses that update whenever they remember have a spreadsheet. The ones that update on schedule have a tool.”
A 13 week cash flow forecast is only as valuable as the rhythm around it. The model takes an afternoon to build and a habit to make useful.
PUT THIS INTO PRACTICE
If cash decisions are currently made by checking the bank balance, a 13 week cash flow forecast will change how the next quarter runs. Most businesses find at least one week in the first thirteen they had not seen coming.
FREQUENTLY ASKED QUESTIONS
Everything US Founders Ask,About Cash Flow Forecasting
What is a 13 week cash flow forecast?
A rolling weekly projection of every cash inflow and outflow across the next quarter, refreshed each week with actuals so the horizon always extends thirteen weeks forward. It shows week-by-week cash position rather than the monthly average a standard forecast provides.
How do you build a 13 week cash flow forecast?
Start with the current bank balance, add expected customer receipts by collection date, subtract fixed outflows like payroll and rent, then subtract variable outflows including vendor payments and taxes. Each week’s closing balance becomes the next week’s opening balance.
Why do companies use a 13 week cash flow model?
Thirteen weeks equals one quarter, the shortest period over which most business decisions can still be influenced. Weekly granularity exposes timing problems that monthly forecasts average away, such as a payroll date falling before a large customer receipt.
How often should a cash flow forecast be updated?
Weekly, on a fixed day. Update the prior week with actuals, review the variance, adjust forward weeks where circumstances changed, and add a new week fourteen. Twenty minutes is usually sufficient once the model exists.
Should a cash flow forecast use cash or accrual basis?
Cash basis only. Revenue recognised but not yet collected does not pay salaries, and a vendor invoice received today but payable in forty-five days belongs in the week it will actually leave the account. Accrual thinking produces forecasts that look healthy until they are not.
What is usually missing from a first cash flow forecast?
Quarterly tax payments and annual insurance renewals, most commonly. Both are large enough to change the answer materially, and both are easy to omit because they fall outside the monthly rhythm most people model from.
A 13 week cash flow forecast is the cheapest financial control a US small business can put in place. An afternoon to build, twenty minutes a week to maintain, and it converts an abstract runway number into something you can plan a quarter around. Finkeepers builds and maintains these as part of cash flow management, working from clean bookkeeping with fractional CFO oversight where the model needs to inform bigger decisions. Talk to a Finkeepers advisor about getting one running.
See what US businesses say about working with Finkeepers on Clutch.
Written by the Finkeepers Team
Getting the 1099 threshold 2026 right comes down to one thing: knowing what you paid each vendor before January arrives. If contractor payments are spread across cards, bank transfers and platforms, that visibility is worth building now. Finkeepers handles contractor and 1099 management for US businesses as part of ongoing payroll support - talk to a Finkeepers accountant if January filing is already looking complicated.
Disclaimer: This article is provided for general informational purposes only and does not constitute financial, tax or accounting advice. Cash flow modelling approaches vary by business model and sector. Consult a qualified professional before making financing or operating decisions based on forecast outputs. Finkeepers accepts no liability for decisions made on the basis of this content. Current as of August 2026.
Get Your Free Cash Flow Consultation Today
*No obligations. Just fast, expert cash flow insights tailored for your US business needs.
Built by experienced professionals, Finkeepers delivers reliable accounting services for startups and SMBs, powered by proven processes and modern software.
Contact Info:
-
Address: 30 N Gould ST STE R, Sheridan, Wyoming, 82801 United States
-
Email: hi@finkeepers.us
-
Phone: +1-408-370-2711