krnseeCFO
All Finance Tools

12-Week Cash Flow Tracker

Plan 12 weeks of cash coming in and going out, see rolling balances and spot a negative week.

How It Works

Enter opening cash and each week's expected receipts and payments. Each closing balance becomes the next week's opening balance. The chart shows balances above and below zero.

Assumptions And Limits

The dates and amounts are your assumptions, not confirmed bank receipts. Blank weekly amounts contribute no movement, so fill all expected receipts and payments before relying on the view.

Worked Example

Start with $500 and enter $100 coming in and $200 going out each week. Cash reaches $0 in week five and becomes negative in week six. Example figures only.

Week 1

Net
-
Ending cash
-

Week 2

Net
-
Ending cash
-

Week 3

Net
-
Ending cash
-

Week 4

Net
-
Ending cash
-

Week 5

Net
-
Ending cash
-

Week 6

Net
-
Ending cash
-

Week 7

Net
-
Ending cash
-

Week 8

Net
-
Ending cash
-

Week 9

Net
-
Ending cash
-

Week 10

Net
-
Ending cash
-

Week 11

Net
-
Ending cash
-

Week 12

Net
-
Ending cash
-

Enter your starting cash and weekly numbers to build the 12-week view.

Built from the numbers you entered - an estimate to plan with, not a forecast or a promise. General rules of thumb for small subscription businesses, not financial advice.

Enter your starting cash and weekly numbers to build the 12-week view.

Save and export

Your numbers save automatically in this browser, on this device only. No account needed. They aren't encrypted or sent anywhere - use your own device, not a shared one. Export to keep a copy or move devices - clearing browser data erases the saved numbers.

Blank templates: Excel · Fillable PDF

Nothing saved yet - saving starts when you enter your numbers.