Cash flow calculator
Week by week, what happens to the bank balance — and when does it run out?
What you need
- Your current bank balance
- Expected collections by week
- Payroll, suppliers, rent, loan and tax payments
About 10 minutes · saved in this browser only
Step 1 of 3
Saved in this browser as you type
Opening position
Start with the money actually available today — not what is owed to you.
Week by week
What you expect to collect and pay each week for the next quarter.
Fill in week 1, copy it across, then change only the weeks that differ — rent, tax, a large supplier payment.
| Week | Money in | Payroll | Suppliers | Other out | Net | Closing |
|---|---|---|---|---|---|---|
| 1 | $0 | $0 | ||||
| 2 | $0 | $0 | ||||
| 3 | $0 | $0 | ||||
| 4 | $0 | $0 | ||||
| 5 | $0 | $0 | ||||
| 6 | $0 | $0 | ||||
| 7 | $0 | $0 | ||||
| 8 | $0 | $0 | ||||
| 9 | $0 | $0 | ||||
| 10 | $0 | $0 | ||||
| 11 | $0 | $0 | ||||
| 12 | $0 | $0 | ||||
| 13 | $0 | $0 |
0 of 13 weeks filled in
Result
Nothing to read yet
Add the cash you hold today and at least one week of money in and out. The forecast, the low point, and the week it turns negative all appear here.