Free tools

Personal cash flow forecast template

A personal cash flow forecast lists the money coming in and going out by date and shows what your balance will be each day. Enter your balance, paychecks and bills below to get the lowest point of each month, so you can see an overdraft coming and move a bill or a transfer before it happens.

Everything runs in your browser. Nothing you type is uploaded or saved.

Income and bills

Heads up: your balance drops to -$410.00 on Dec 5, below zero. The lowest point in the next 90 days is -$550.00 on Dec 8.

Income in this window
$12,600.00
Bills in this window
$9,031.00
Balance at the end
$4,969.00
Dec 1dashed line = $0Feb 28
Lowest balance by month
MonthLowest balanceOnIncomeBillsMonth end
Dec 2026-$550.00 (at risk)Dec 8$4,200.00$2,957.00$2,643.00
Jan 2027$833.00Jan 5$4,200.00$3,117.00$3,726.00
Feb 2027$3,589.00Feb 15$4,200.00$2,957.00$4,969.00

How to use it

  1. Type your current checking balance and pick the date the forecast starts.
  2. Add each paycheck and bill with its amount, how often it repeats and its next date. Load the example first to see how rows look.
  3. Read the warning line and the monthly table. A month marked at risk shows the day the balance bottoms out.
  4. Move a due date, add a cushion in the warning box, or add a one-time expense, and the numbers update immediately.
  5. Download the daily forecast as a CSV to keep it as a spreadsheet template you update each payday.

How the forecast works

Questions

What is a personal cash flow forecast?

It is a day-by-day projection of your checking balance built from the money you expect to arrive (paychecks, refunds, side income) and the money you expect to leave (rent, loan payments, subscriptions, groceries). The useful part is the lowest point in each month, because that is where an overdraft happens.

Why does it show the lowest balance instead of the month-end balance?

A month can end with $2,000 in the account and still dip to minus $300 on the 3rd, when rent clears before the paycheck lands. Month-end numbers hide that. The table shows the lowest balance and the day it happens, so you know which bill to move or which transfer to make before that date.

What happens when a bill and a paycheck land on the same day?

The bill is counted first. Banks do not always post deposits before withdrawals, so the forecast takes the cautious order. If the dip only appears on a day with both, check whether your deposit posts early and adjust the dates.

How are monthly bills handled on the 29th, 30th or 31st?

A bill set to the 31st lands on the last day of shorter months (the 28th or 29th in February, the 30th in April) and goes back to the 31st afterward. Paychecks every two weeks keep their 14-day rhythm, which is why some months have three of them.

Does this save my numbers or connect to my bank?

No. Everything you type stays in this browser tab, nothing is stored, and closing the tab clears it. You enter your expected income and bills by hand, so the forecast is only as good as those inputs. Download the daily forecast as a CSV if you want to keep a copy.

How do I make the forecast use my real transactions?

Typing guesses works for a quick check. For a forecast built from what posted to your accounts over the last year, connect your banks to BankBridge (read-only, $5 a month per connected bank) and ask Claude or ChatGPT to forecast from your transaction history. It reads the recurring charges and deposits from every account for you.

Forecast from your real transaction history

A hand-typed forecast is only as good as your memory of what you pay. Connect your banks to BankBridge and your agent can build the forecast from the real transaction history: the deposits that arrive, the recurring charges that post on schedule, and the bills you forgot to list.

“Forecast my checking balance for the next 90 days from my recurring charges and deposits, and tell me which days it gets lowest.”

Read-only access for Claude, ChatGPT, Cursor and other MCP apps. Nothing stored. $5 a month per connected bank.

More free tools

All free tools