Skip to content

Blog

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:

CategoryAugustSeptemberOctober
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.

CategoryMonthly 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.