Weekly cash flow planner
Start with available cash. Enter receipts in the week you expect to collect them and payments in the week money will leave your account.
| Week | Receipts | Payments |
|---|---|---|
| Week 1 | ||
| Week 2 | ||
| Week 3 | ||
| Week 4 |
Your results
- Cash at the end of week 4
- —
- Lowest closing balance
- —
- First week below your reserve
- —
Weekly balances
| Week starting | Opening cash | Closing cash |
|---|
Reopen a saved CSV to continue next week. Moving forward carries the first week’s closing cash into the opening balance. Update it to your actual balance.
What if a customer pays a week late?
Choose when the payment was due and how much arrives one week later. Your saved forecast keeps its original figures.
Enter the amount you expect to arrive late.
| Week starting | Your forecast | If paid late |
|---|
The starting figures are fictional. Your entries stay in this browser tab.
How does cash carry from week to week?
Add receipts to opening cash and subtract payments. Each closing balance becomes the following week’s opening cash. Compare each week-end balance with the reserve you want to keep.
The reserve is a reference amount. The planner leaves that money in your balance. Check individual due dates whenever a bill could fall before a receipt in the same week.
FDIC Money Smart guide to managing cash flow (PDF, opens in a new tab)
Worked example
Start with $4,800. The first week brings in $2,400 and sends out $3,100, leaving $4,100. Week two brings in $1,800 and sends out $4,200, leaving $1,700. If a $1,500 receipt slips from week two into week three, week two closes at $200.