13-Week Cash Flow
Weekly cash receipts, disbursements, financing activity, ending cash and available liquidity.
← All resources
Free financial resource
13-Week Cash Flow
13-Week Cash Flow
Forecast Template
See where liquidity pressure is developing before it becomes a crisis. A practical, direct-method Excel model for forecasting weekly cash receipts, disbursements and available liquidity over the next 13 weeks.
Download the Free Excel Template →Free · No email required
13-WEEK CASH FLOW FORECAST
WEEK 1WEEK 2WEEK 3…WEEK 13
Beginning Cash
Cash Receipts
Cash Disbursements
Ending Cash
Available Liquidity
13-Week Cash FlowInputsA/RA/PHeadcount
Why 13 weeks
Know what the next 13 weeks look like.
Annual budgets and monthly forecasts answer important questions. But when cash gets tight, timing matters.
A 13-week cash flow forecast creates a more immediate view of liquidity by translating expected collections, vendor payments, payroll, financing activity and other cash movements into a weekly forecast.
The goal isn't simply to predict an ending cash balance. It's to give management enough visibility to make decisions before liquidity becomes the decision.
One model. The supporting detail to make it useful.
Accounts Receivable
Customer-level receivables, expected collection percentages and realistic collection dates.
Accounts Payable
Vendor-level obligations and expected payment timing.
Headcount & Payroll
Compensation, payroll burden, monthly benefits, employment dates and payroll timing.
Other Cash Flows
Taxes, capex, settlements, owner or investor funding and other material cash items.
Debt & Liquidity
Revolver commitments, existing draws, remaining availability and minimum cash assumptions.
How to use it
Build a forecast you can actually manage from.
01
Start with cash, not accounting.
This is a timing model. Focus on when money will actually enter or leave the bank, not merely when revenue was recognized or an invoice became due.
02
Forecast collections realistically.
Start with open receivables and assign expected collection timing based on what you actually know about each customer.
03
Map cash obligations.
Layer in vendor payments, payroll, benefits and other operating requirements based on when cash is expected to clear.
04
Capture the exceptions.
Add taxes, capital expenditures, settlements, financing, owner contributions and other one-time items that can materially change liquidity.
05
Understand available liquidity.
Where relevant, incorporate revolver availability and other committed liquidity so management can see both projected cash and total financial capacity.
06
Update it every week.
Refresh expected dates, roll the forecast forward, reconcile prior expectations to actual cash movement and challenge assumptions that no longer hold.
Operator perspectiveA forecast doesn't solve a liquidity problem.
A forecast doesn't solve a liquidity problem.
It makes the problem visible.
The harder questions usually come next: What can move? What can't? Which assumptions are actually credible?
Is the problem timing, working capital, operating performance, capital structure or some combination of them?
That's where the model becomes a management tool rather than a spreadsheet.
When to use it
When cash timing becomes strategically important.
Rapid growthRevenue disruptionWorking-capital swingsRestructuring or turnaroundLender or investor reportingM&A integrationCovenant or liquidity concernsScenario planning
Frequently asked questions
13-week cash flow forecasting, explained.
What is a 13-week cash flow forecast?+
A 13-week cash flow forecast is a short-term, direct-method view of expected cash receipts and disbursements by week. It is designed to show how operational and financing assumptions translate into actual liquidity.
Why is 13 weeks commonly used for cash forecasting?+
Thirteen weeks covers roughly one quarter while preserving enough weekly detail to manage near-term cash decisions. It creates a practical bridge between immediate cash management and longer-range planning.
How often should a 13-week cash flow forecast be updated?+
Weekly. The value comes from refreshing collection and payment assumptions, rolling the forecast forward and comparing prior expectations with actual cash movement.
What's the difference between a cash flow forecast and a budget?+
A budget is generally built around financial performance over a longer period. A 13-week cash flow forecast focuses specifically on the timing of money entering and leaving the bank.
Should a 13-week cash flow forecast include accounts receivable and accounts payable?+
Yes. A/R and A/P are often among the most important drivers of near-term liquidity. This template includes supporting tabs for both so timing assumptions can roll into the weekly forecast.
Can I use this template in Google Sheets?+
The template is provided as a macro-enabled Excel workbook. Google Sheets may open many workbook elements, but Excel is recommended to preserve the intended functionality and formatting.
Ready to use it?
Start with a clearer view of cash.
Download the complete 13-week model with supporting inputs, A/R, A/P, headcount and payroll schedules.
Download the Free Template →Excel · Free · No email required
When the forecast raises harder questions
A clearer view of cash is often the beginning of the conversation.
Cadence & Compass helps leadership teams navigate financial complexity, performance challenges and critical operating decisions.