How to see your month before it's over: forecast your balance
A plain method for forecasting your bank balance through the month: what to list, how to find the lowest point, and how it differs from a budget.
· 5 min read · By the GroFunds team
Most people find out how their month went when it’s already over. The statement arrives, the balance is lower than you hoped, and the only thing left to do is promise that next month will be different.
A forecast flips that around. Instead of looking back at what happened, you look ahead at what is going to happen to your balance, day by day, while you can still change it. It sounds like something an accountant does. In practice it takes a list, a calendar and about twenty minutes the first time.
What a forecast is (and what it isn’t)
A forecast answers one question: where will my balance be on each day between now and the end of the month?
A budget answers a different one: how much do I plan to spend on groceries, rent, fun and everything else? Both are useful, and they fit together, but they are not the same tool. A budget can be perfectly on track while your account still dips below zero on the 14th, because rent and the car insurance both came out before payday. We go deeper on this in forecast vs budget.
A forecast cares about three things only:
- Money coming in, and on which date
- Bills going out, and on which date
- Everyday spending, spread across the days
Dates are the whole point. The same $3,000 of income and $2,800 of costs can be a calm month or a scary one depending on when each piece lands.
The method, in five steps
1. Start with today’s real balance
Use the balance in the account your bills and spending come from. Leave out any overdraft limit: that is borrowed room, not your money. If you have charges that are still pending, treat them as already gone. Pending transactions are the most common reason a balance looks better than it is.
2. Put every payday on a date
Write down each deposit you expect before the month ends, with its date and a careful amount. If your pay varies, use a lower figure you are confident about rather than your best week.
3. Put every bill on a date
Go through the last two or three months of your statement and pull out everything that repeats: rent or mortgage, phone, internet, utilities, insurance, subscriptions, loan payments, scheduled transfers. Give each one the date it usually comes out. Watch for the ones that don’t come every month, like annual renewals and quarterly bills.
If you like paper, a wall calendar works beautifully for this. Here’s how to set up a cash flow calendar at home. If you like spreadsheets, try the month end balance spreadsheet.
4. Spread your everyday spending across the days
Groceries, gas, transit, coffee, takeout. Look at what you actually spent on these last month and divide by the number of days. That gives you a daily figure to subtract. Honest beats hopeful here.
5. Walk forward one day at a time
Start at today’s balance. For each day, add any money coming in, take away any bill due that day, and take away the daily spending figure. Write the result down. When you reach the end of the month, you have a line of balances, one per day.
The number that matters most: the lowest point
When you look at your line of daily balances, your eye goes to the last one. That is natural, and it is useful: it tells you roughly what you’ll carry into next month. If that’s the number you want, see how to predict your end of month balance.
But the number that decides whether you have a hard week is the lowest one. Bills tend to cluster. Rent, a phone bill and a car payment can all fall in the same five days, and if those days come before payday, your balance can drop far below where it ends the month. That low point is where overdrafts and declined payments happen. There’s a whole post on the lowest point in your month and why it deserves more attention than the end.
A worked example
Here’s an example with invented numbers. Today is the 1st. Pay of $2,100 arrives on the 15th and the 29th. Everyday spending is about $40 a day.
| Date | What happens | In | Out | Balance |
|---|---|---|---|---|
| 1st | Starting balance | $1,900 | ||
| 1st | Rent | $1,400 | $500 | |
| 1st to 7th | Everyday spending, 7 days | $280 | $220 | |
| 8th | Phone and internet | $120 | $100 | |
| 8th to 14th | Everyday spending, 7 days | $280 | $180 below zero | |
| 15th | Pay | $2,100 | $1,920 | |
| 18th | Car insurance | $160 | $1,760 | |
| 15th to 28th | Everyday spending, 14 days | $560 | $1,200 | |
| 29th | Pay | $2,100 | $3,300 | |
| 30th | Everyday spending, 2 days | $80 | $3,220 |
The month ends with $3,220, which looks great. But on the 14th this household is $180 below zero. Looking only at the end of the month, they would never have seen it coming.
Now that they can see it, they have two weeks to fix it: move the phone bill to the 16th, trim everyday spending for the first two weeks, or pause something that can wait. Any one of those closes the gap.
Shorter questions the same method answers
Once you have the habit, you can use cut down versions for specific worries:
- Will I make it to payday? Only the days between now and your next pay. Here’s the ten minute version, and the free payday check does the sums for you.
- How much can I spend until payday? Take bills out first, then divide what’s left by the days. See how much you can spend until payday.
- Will I go negative today or tomorrow? A quick look at same day bills and pending charges. See will my account go negative.
- Why does this keep happening? Lumpy bills, timing and five week months. See why you keep running out of money before payday.
Make it a rhythm, not a project
The first forecast is the slow one, because you are building your list of bills and paydays. After that, the list barely changes. Two short habits keep it current:
- Right after payday, check the next two weeks and decide what goes where. Here’s what to do in the first week after payday.
- At the end of the month, compare what happened with what you forecast and update the list. The five minute end of month money check walks through it.
Each time you do it, your daily spending figure gets more accurate and your bill list gets more complete. Within two or three months, very little surprises you.
Start today
Take ten minutes now. Write today’s balance, your next payday, and every bill between now and then. That one short list is the start of a forecast, and it will already tell you more than last month’s statement can.
If you’d rather not keep the list by hand, GroFunds connects to your bank accounts with read only access through Plaid, finds your bills and paydays, and shows where the month will land, every day.