Build a budget from your last three months of spending
Skip the guesswork. Use three months of real statements to build a budget that fits your life: averages, outliers, irregular costs and a final check.
· 5 min read · By the GroFunds team
Most budgets fail in the first month because they’re built on hope. You sit down, decide groceries “should” be $400, and then discover you’ve spent $400 by the 18th.
A budget built from your last three months starts from what really happens. It won’t be perfect, but it will be believable, and a believable budget is one you’ll keep using. This takes about an evening.
What you need
- Statements for the last three full months from every account and card you spend from
- A spreadsheet or a sheet of paper
- Your take home pay for each of those months (what actually landed in your account, not your salary)
If you’re new to sorting transactions, categorising transactions: a simple system that sticks is a good primer.
Step 1: Clean the list before you add anything up
Raw statements overstate spending. Before you total anything, take out:
- Transfers between your own accounts, including moving money to savings.
- Credit card payments from your chequing account, if you’re already counting the purchases on the card itself. Otherwise you count the same coffee twice.
- Refunds, which you subtract from the category they belong to rather than ignore.
This step alone often makes a “terrible” month look reasonable.
Step 2: Group into categories and total each month
Use a short list, eight to ten categories at most. Then total each category for each month.
Here is an example with invented numbers for a single person renting an apartment:
| Category | August | September | October |
|---|---|---|---|
| Rent | $1,450 | $1,450 | $1,450 |
| Utilities and phone | $140 | $135 | $150 |
| Groceries | $380 | $410 | $360 |
| Eating out | $260 | $190 | $230 |
| Transit | $120 | $120 | $120 |
| Subscriptions | $55 | $55 | $55 |
| Clothing and shopping | $90 | $640 | $110 |
| Personal care | $45 | $60 | $40 |
| Gifts and events | $30 | $50 | $310 |
Step 3: Spot the outliers
Look across each row. Most categories are fairly steady. A few have one month that jumps far above the others. In the example:
- Clothing and shopping in September: $640. A new winter coat and boots.
- Gifts and events in October: $310. A friend’s wedding.
These are real costs, but they aren’t monthly costs. If you average them in, your budget will say you spend $280 a month on clothes, and most months you won’t. If you ignore them, next year’s wedding season will surprise you.
The fix is to pull them out of the monthly average and handle them separately (Step 5).
Step 4: Average what’s left
For each category, average the normal months. If a month was an outlier, use the other two.
| Category | Monthly budget |
|---|---|
| Rent | $1,450 |
| Utilities and phone | $142 |
| Groceries | $383 |
| Eating out | $227 |
| Transit | $120 |
| Subscriptions | $55 |
| Clothing and shopping | $100 |
| Personal care | $48 |
| Gifts and events | $40 |
| Monthly total | $2,565 |
Round the figures to something easy to remember if you like: groceries $385, eating out $225.
Step 5: Add the costs that don’t show up every month
Three months won’t catch everything. Some costs come once or twice a year. Make a short list from memory and from last year’s statements:
- clothing for the seasons
- gifts: birthdays, holidays, weddings
- annual subscriptions and memberships
- insurance paid yearly
- travel
Estimate a yearly total for each, divide by twelve, and add that as its own line. In the example, the person estimates $900 a year for clothing beyond the monthly $100, $600 for gifts and events beyond the monthly $40, and $1,200 for one trip home. That’s $2,700 a year, or $225 a month.
| Monthly | |
|---|---|
| Everyday budget | $2,565 |
| Set aside for irregular costs | $225 |
| Full monthly budget | $2,790 |
That $225 goes into a separate account each month so it’s there when the coat or the wedding comes. Sinking funds explained covers how to run one, and annual bills that catch people out helps you find the yearly ones.
Step 6: Check it against your pay
Now compare the full monthly budget with your take home pay. Say this person takes home $3,100 a month.
- $3,100 in
- $2,790 budgeted out
- $310 left
That’s the honest picture. If there’s room left, decide where it goes: a buffer, a goal, extra on something you care about. If the budget is higher than your pay, you’ve learned that your current spending doesn’t fit, which is painful but far better than finding out on the 25th.
Step 7: Decide what to change, one or two things at a time
Now you can make changes based on real numbers. Look for the categories where you’d be happy spending less. In the example, eating out at $227 might come down to $175 without much pain. That’s $52 a month.
Change one or two categories, not everything. A budget that asks for big cuts everywhere tends not to last. If you want help seeing whether a month is on track against your new numbers, is this month normal? shows how to compare as you go.
Use it, then update it
A budget from your last three months is a starting point, not a contract. After a month, compare what you actually spent to what you planned:
- Categories that were close: keep them.
- Categories that were way off: ask why. Was it a one off, or was the budget unrealistic?
- Categories you forgot: add them.
Every three months, rebuild from the most recent three. It gets faster each time because the categories already exist.
GroFunds builds budgets from your own spending in your bank accounts, so the first draft is already based on what you really spend. The steps above get you to the same starting point by hand.