Receipts by source
Separate recurring collections, project or milestone receipts, financing, owner contributions, and one-time cash. Assign customer receipts when concentration or timing matters.
Free business finance tool
Cash Flow Forecast Template: A 13-Week Operating Model
Preview the structure, download the CSV starter, and use the implementation notes to turn a static spreadsheet into a weekly management process.
No account required Educational, not individualized advice
Template preview
13-week receipts and disbursements
This starter keeps categories broad. Expand customer or vendor detail only when timing, concentration, or responsibility changes a decision.
| Cash-flow line | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Opening cash | $100,000 | Prior ending | Prior ending | Prior ending | Prior ending | Prior ending | Prior ending | Prior ending | Prior ending | Prior ending | Prior ending | Prior ending | Prior ending |
| Customer collections | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 |
| Other receipts | — | — | — | — | — | — | — | — | — | — | — | — | — |
| Payroll and benefits | $22,000 out | $22,000 out | $22,000 out | $22,000 out | $22,000 out | $22,000 out | $22,000 out | $22,000 out | $22,000 out | $22,000 out | $22,000 out | $22,000 out | $22,000 out |
| Vendors and operating expenses | $18,000 out | $18,000 out | $18,000 out | $18,000 out | $18,000 out | $18,000 out | $18,000 out | $18,000 out | $18,000 out | $18,000 out | $18,000 out | $18,000 out | $18,000 out |
| Debt payments | $3,000 out | $3,000 out | $3,000 out | $3,000 out | $3,000 out | $3,000 out | $3,000 out | $3,000 out | $3,000 out | $3,000 out | $3,000 out | $3,000 out | $3,000 out |
| Taxes | — | — | — | — | — | — | — | — | — | — | — | — | — |
| Capital purchases | — | — | — | — | — | — | — | — | — | — | — | — | — |
| Owner payments | — | — | — | — | — | — | — | — | — | — | — | — | — |
How to use the result
The structure behind a useful weekly model
Keep the first version simple enough to update. Add detail only when it changes a decision, explains a variance, or assigns responsibility for a receipt or payment.
Disbursements by behavior
Separate payroll, recurring operations, vendors, debt, taxes, capital purchases, and discretionary decisions. This makes protective actions visible.
Actual-versus-forecast loop
Copy the prior forecast before updating it. Record actual results and explain the variance so future assumptions improve.
What belongs in each forecast layer
Avoid a single undifferentiated revenue and expense line once timing or responsibility becomes material.
| Layer | Examples | Update source | Management question |
|---|---|---|---|
| Opening liquidity | Bank cash and available facility | Bank and lender portals | What is available now? |
| Customer receipts | Invoices, retainers, subscriptions, projects | AR aging, contracts, billing system | When will cash arrive? |
| Committed disbursements | Payroll, debt, rent, taxes, signed vendors | Payroll, AP, debt schedules | What must be paid? |
| Discretionary actions | Hiring, equipment, owner payments, growth spend | Management plan | What can be changed? |
| Scenario adjustments | Collection delay, margin pressure, growth case | Management assumptions | What could happen and what would we do? |
Take the working file with you
Get the expanded working model
The emailed pack adds an assumptions tab, actual-versus-forecast review, scenario prompts, and a meeting agenda to the starter structure.
Frequently asked questions
Why use 13 weeks instead of a monthly annual budget?
Weekly detail makes collection and payment timing visible over a practical operating horizon. The annual budget still matters for strategy, but it can hide a short cash squeeze inside a seemingly healthy month or quarter.
Should every customer appear separately?
List customers separately when concentration, payment behavior, or large invoices can materially change the forecast. Smaller or predictable receipts can be grouped if the assumption remains understandable.
How should payroll be shown?
Use actual pay dates and expected cash amounts, including employer costs and benefits where relevant. Add separate lines for bonuses, commissions, contractor runs, or planned hires when timing differs.
How do I model uncertainty?
Keep the base forecast grounded in the most likely timing, then copy it into downside and action scenarios. Change a few important assumptions rather than making every line uncertain.
Who should maintain the forecast?
One person should own the file and update schedule. AR, AP, payroll, sales, and management may own inputs. A CFO or finance leader should own assumptions, scenarios, and the decisions that follow.
Does this replace accounting software?
No. Accounting provides actual historical records. The forecast uses those records plus forward assumptions. The two should reconcile through opening cash and actual-versus-forecast review.