Free tools · Profit & cash
13-week cash flow forecast
Map your cash week by week for the next 13 weeks, see when the balance dips lowest, and get warned before it falls below the floor you set.
Your numbers
Example values throughout: replace them with yours.
Cash you expect to collect, not sales you'll invoice. Change any week in the table below.
Include employer taxes and benefits paid with payroll.
Suppliers, software, loan payments, card bills. Change any week below.
Lowest balance
$66,000
Week 2. Never below your floor.
Cash after 13 weeks
$123,000
Up $63,000 from today
Money in vs money out
$286,000 / $223,000
Total over 13 weeks
Week by week
Type over any week’s receipts or other payments (a big invoice due, a tax payment). Edited cells are tinted; clear one to go back to the typical amount.
| Week | Opening | Receipts | Payroll | Rent | Other out | Closing |
|---|---|---|---|---|---|---|
| Week 1 | $60,000 | $0 | $6,000 | $69,000 | ||
| Week 2 | $69,000 | $18,000 | $0 | $66,000 | ||
| Week 3 | $66,000 | $0 | $0 | $81,000 | ||
| Week 4 | $81,000 | $18,000 | $0 | $78,000 | ||
| Week 5 | $78,000 | $0 | $6,000 | $87,000 | ||
| Week 6 | $87,000 | $18,000 | $0 | $84,000 | ||
| Week 7 | $84,000 | $0 | $0 | $99,000 | ||
| Week 8 | $99,000 | $18,000 | $0 | $96,000 | ||
| Week 9 | $96,000 | $0 | $6,000 | $105,000 | ||
| Week 10 | $105,000 | $18,000 | $0 | $102,000 | ||
| Week 11 | $102,000 | $0 | $0 | $117,000 | ||
| Week 12 | $117,000 | $18,000 | $0 | $114,000 | ||
| Week 13 | $114,000 | $0 | $6,000 | $123,000 |
Everything you type stays in your browser: nothing is sent to us or saved.
How this works
Start with what's in the bank today. Each week adds the cash you expect to collect and takes off what you'll pay out: payroll every two weeks, rent roughly once a month, and everything else. The closing balance becomes next week's opening balance.
Use cash you expect to collect, not sales you'll invoice. If customers pay in 45 days, this week's receipts come from invoices you sent six weeks ago. That gap is where most cash surprises come from.
Typical amounts fill every week, then you type over the weeks that are different: a large invoice due in week 4, a quarterly tax payment in week 9, a slow holiday week. The chart and the warning update as you go.
Thirteen weeks is a quarter: far enough ahead to fix a problem, close enough to be reasonably accurate. Update it every week with real bank balances and it gets better each time. Our article on building a 13-week cash flow forecast walks through it in more detail.
Questions people ask
How is this different from my profit and loss?
Your P&L shows profit when it's earned. A cash forecast shows when money actually moves in and out of the bank. A profitable business can still run short of cash when customers pay slowly or a big bill lands.
What cash floor should I set?
Enough to cover your next payroll and any bills that can't wait, plus a cushion for a slow week. Many owners use one full payroll cycle as a starting point and adjust from there.
Should I include loan payments and owner draws?
Yes. Anything that leaves the bank belongs in the forecast, even if it isn't an expense on the P&L. Add them to other payments in the weeks they happen.
Can I keep working on it in Excel?
Yes. Download the CSV and open it in Excel or Google Sheets. Each week has its own row, so you can roll it forward by deleting the first week and adding a new one at the end.
This tool gives estimates for general information, not tax, legal or accounting advice for your situation. Talk to us or your CPA before acting on the results.
Related tools
- Profit margin calculator
Gross, operating and net margin from a few numbers off your P&L.
- Break-even calculator
How many sales you need each month to cover your costs, with a price sensitivity table.
- EBITDA calculator
Earnings before interest, taxes, depreciation and amortization, and EBITDA margin.
Ready for books you can trust?
Book a free 30-minute consultation. We'll review where your finances stand today and show you exactly how we'd help.