Free 13-Week Cash Flow Forecast Template and Generator
Updated July 10, 2026 · Reviewed by Max Berger, Co-Founder
A 13-week cash flow forecast projects the money entering and leaving your bank account each week for the next calendar quarter. It uses the direct method, so every figure maps to real receipts and disbursements rather than accounting profit.
Build your forecast below, watch the weekly grid update live, then download it as Excel or have the blank template emailed to you.
Set up your forecast
Your 13-week grid
Starting with $250,000, this forecast ends week 13 at $129,000. The tightest week is week 13 at $129,000.
| Line item | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Beginning cash | $250,000 | $243,000 | $236,000 | $229,000 | $192,000 | $185,000 | $178,000 | $171,000 | $164,000 | $157,000 | $150,000 | $143,000 | $136,000 |
| Customer receipts | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 |
| Total cash inflows | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 |
| Operating disbursements | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 |
| Estimated tax payment | $0 | $0 | $0 | $30,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total cash outflows | $52,000 | $52,000 | $52,000 | $82,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 | $52,000 |
| Net cash flow | -$7,000 | -$7,000 | -$7,000 | -$37,000 | -$7,000 | -$7,000 | -$7,000 | -$7,000 | -$7,000 | -$7,000 | -$7,000 | -$7,000 | -$7,000 |
| Ending cash | $243,000 | $236,000 | $229,000 | $192,000 | $185,000 | $178,000 | $171,000 | $164,000 | $157,000 | $150,000 | $143,000 | $136,000 | $129,000 |
Email me the template
Optional. We will send this breakdown to your inbox, no strings attached.
Sent. Check your inbox shortly.
If you have questions about your numbers, we reply within one business day.
These figures are a planning estimate built on standard assumptions. For numbers based on your actual books and state, book a discovery call.
Everything runs in your browser. Nothing you type is sent anywhere unless you ask us to email the breakdown.
How this calculator works
This generator uses the direct method: it forecasts the actual cash you expect to receive and pay each week, then rolls the balance forward. For each of the 13 weeks the math is the same:
Ending cash = beginning cash + total inflows - total outflows.
The beginning cash for week 1 is the starting balance you enter. Every following week begins with the prior week's ending cash. Recurring inflows and outflows repeat in all 13 weeks. One-off items are added only in the single week you assign them, which is how large events like a quarterly tax payment or an equipment purchase show up as a dip in that week's ending balance.
The forecast is only as good as its inputs. It assumes your weekly amounts hold steady unless you add a one-off, and it does not model the timing risk of a late customer payment or an early vendor draw. Treat the ending-cash row as a planning estimate, revisit it weekly, and replace forecast weeks with actuals as they close. It is not tax or accounting advice.
Worked example
Suppose you open with $250,000 in the bank. You expect $45,000 of customer receipts every week and $52,000 of operating disbursements every week, so in a normal week the account drops by $7,000. In week 4 you also owe a $30,000 estimated tax payment.
Across the quarter the recurring gap removes $91,000 over 13 weeks, and the one-off tax payment removes another $30,000. Starting from $250,000, that leaves an ending cash position of $129,000 at the end of week 13. The grid above shows the balance stepping down week by week, with the extra drop visible in week 4.
Frequently asked questions
Why 13 weeks for a cash flow forecast?
Thirteen weeks is one calendar quarter, which is long enough to see payroll runs, rent, tax payments, and customer collection cycles play out, yet short enough to forecast week by week with real accuracy. It is the standard horizon lenders, turnaround advisors, and CFOs use to manage near-term liquidity. Beyond 13 weeks, weekly estimates get too speculative to be useful.
What is the difference between the direct and indirect method?
The direct method, used in this template, forecasts actual cash receipts and disbursements week by week, so you see the real bank balance on each date. The indirect method starts from projected net income and adjusts for non-cash items and working capital changes. For short-term liquidity planning the direct method is clearer because it maps to money actually moving in and out of the account.
How often should you update a 13-week cash flow forecast?
Most businesses refresh it weekly by rolling the window forward one week and replacing forecasts with actuals for the week that just closed. Companies under real cash pressure often update two or three times a week. The discipline of comparing forecast to actual each week is what makes the tool accurate over time.
Who should own the 13-week cash flow forecast?
Ownership usually sits with the controller, finance manager, or fractional CFO, working from the same inputs the bookkeeper maintains. One person should be accountable for updating it and flagging tight weeks to leadership. In a small company the owner or bookkeeper can run it directly as long as the update happens on a fixed weekly cadence.
When does a business need a 13-week cash flow forecast?
It becomes essential when cash is tight, when revenue is seasonal or lumpy, or when a lender, investor, or board asks for a near-term liquidity view. It is also valuable ahead of a large planned outflow such as a tax payment, equipment purchase, or hiring push. Even healthy companies use it to confirm they can cover obligations without surprises.
We run bookkeeping, controller, and fractional CFO services for US companies, fully remote.
Book a callThese results are estimates for planning purposes only and are not tax or legal advice. Rules, rates, and thresholds change; figures on this page are current as of July 10, 2026. Consult a CPA or attorney about your specific situation before acting.