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.

← All free tools

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

Closing cash each week
$0$33,210$66,420$99,630$132,840Cash floorW1W3W5W7W9W11W13Closing cash, W1: $69,000Closing cash, W2: $66,000Closing cash, W3: $81,000Closing cash, W4: $78,000Closing cash, W5: $87,000Closing cash, W6: $84,000Closing cash, W7: $99,000Closing cash, W8: $96,000Closing cash, W9: $105,000Closing cash, W10: $102,000Closing cash, W11: $117,000Closing cash, W12: $114,000Closing cash, W13: $123,000

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.

WeekOpeningReceiptsPayrollRentOther outClosing
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

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.