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 tax planning 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.
Swipe horizontally to compare
| 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 next planning step
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.
Authoritative Sources
- IRS Publication 583, Starting a Business and Keeping Records
- IRS Publication 334, Tax Guide for Small Business
Citations reflect U.S. federal tax law as of the article's last reviewed date.
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.
Limited Availability
Book a free initial consultation to pressure-test this number with a CPA
Book a free 30-minute call to walk through your situation. We'll tell you exactly how our CPA-led team can help, and whether we're the right fit.
Learn how our CPA-led team can help
30 minutes, no fluff, just answers
Zero obligation, zero pressure
0+
Clients Nationwide
0+
Years Experience
0%
CPA-Led Service
0min
Free Consultation
What to Expect on the Call
1
We learn about your business and tax situation2
We explain which services fit your needs3
You get honest answers, no hard sellMake the weekly update reproducible
Give each forecast line a named data source: bank balance, receivable aging, payroll calendar, vendor schedule, loan statement, or owner-approved commitment. Mark uncertain receipts separately rather than hiding them inside a precise total.
For illustration, opening cash is $40,000, expected receipts are $25,000, payroll is $18,000, vendor payments are $12,000, and debt service is $5,000. Ending cash is $30,000. If a $10,000 customer payment slips one week, ending cash becomes $20,000 before any response.
| Weekly task | Required action |
|---|---|
| Replace forecast with actual | Preserve the difference and explanation |
| Roll forward | Add a new thirteenth week |
| Recheck collections | Use customer evidence and promised dates |
| Update commitments | Include approved hires, equipment and taxes |
| Review the low point | Discuss actions before cash reaches it |
Keep actuals and assumptions separate
A formula should not overwrite last week's forecast. Retaining it shows whether misses come from collection timing, unplanned spending, or optimistic assumptions. Add an action column beside material variances.
This is a cash model, so include loan principal, asset purchases, and owner distributions even when they do not appear as operating expenses. Avoid counting the same payment in both a vendor schedule and an automatic monthly allowance.
Recordkeeping reference: IRS business records guidance. The management schedules above are illustrative; they do not prescribe a tax accounting method.
Apply this to your records
Use the printable worksheet to compare the example with your records, identify missing support, and assign follow-up questions.
Open this guide’s worksheetOpens in a new tab · Print or save as PDF · No email required
Discuss the next decision with Taxstra
Identify the decision you need to make, the reports available today, and the forecast or management support you need. We can discuss reporting cadence, analysis, and implementation responsibilities.
A free 30-minute conversation with our onboarding team about your situation, service fit, and next steps. Fees depend on complexity, records, entities, states, and ongoing support.
Free Consultation
Discuss your next decision with Taxstra
A free 30-minute conversation with our onboarding team about your situation, service fit, and next steps.
Takes 30 seconds to book
Educational, not individualized tax advice. Examples are hypothetical. Content updated September 5, 2026; confirm the rules applicable to your year and circumstances.
Turn the forecast into a business decision.
Discuss the records, cash constraints, and hiring or investment decision that financial leadership needs to support.
Explore fractional CFO services →Related Taxstra resources
Continue with the services, planning tools, and explainers most relevant to this topic.