Skip to content
Launching soon

How to Compare Your Spending Month Over Month (and What to Look For)

By Filipe de Castro, founder of SetBucks · · 6 min read

A table of three months and their average: money in $4,100 each month; Essentials $2,190, $2,210 and $2,240; Lifestyle $790, $830 and $1,040, highlighted; Saving $200; and what's left $920, $860 and $620.

One month of spending tells you what happened. Two months side by side tell you what's changing. Comparing your spending month over month is the simplest way to see whether a high grocery bill was a one-off or a new normal, whether lifestyle spending is creeping up, and whether what's left at the end of the month is growing or shrinking. This guide shows how to set up a comparison that stays honest, what to look at first, and how to tell a trend from a blip.

Why one month tells you less than you think

Every single month has a story that excuses it. This one had the car registration. That one had a wedding. The one before had a quarterly insurance bill. Looked at alone, each month seems unusual, and nothing ever gets compared to anything.

The way out is to put months next to each other, with the same groups and the same rules, so the unusual parts stand out against the parts that repeat. After a few months the excuses stop mattering, because the pattern underneath them is visible.

Set up the comparison so it stays honest

A comparison is only as good as its consistency. Three rules:

  1. The same groups every month. Essentials, Lifestyle, and Saving and investing. If a transaction was "Lifestyle" in March, it's "Lifestyle" in April. Changing the rules mid-way makes the months stop meaning the same thing.
  2. The same reading every month. Compare full months with full months. Comparing the first ten days of this month against all of last month is the most common way to scare yourself for no reason.
  3. Card purchases on the purchase date, card payments as transfers. Otherwise the month you paid the card looks twice as expensive as the month you spent the money.

If you don't have the groups yet, the monthly expenses list explains how to sort a month into them in about an hour.

Three numbers first

Before any group, compare the three numbers that summarize a month:

Last monthThis monthChange
Money in$4,100$4,100same
Money out$3,240$3,480+ $240
What's left$860$620− $240

Three numbers, one sentence: "I earned the same, spent $240 more, and kept $240 less." That's the whole month in a form you can act on. Everything below is about finding where the $240 went.

Last month against this month in three numbers: money in $4,100 both months; money out $3,240 then $3,480, up $240; what's left $860 then $620, down $240. Three numbers first. One sentence: earned the same, spent $240 more, kept $240 less.

Then the groups

Now the same comparison for the three groups:

  • Essentials: $2,210 → $2,240, up $30. That's noise. Utilities move with the weather.
  • Lifestyle: $830 → $1,040, up $210. There's most of the difference.
  • Saving and investing: $200 → $200, the same.

Say each one as a number and a direction. "Lifestyle was $1,040, up $210" is a fact you can look into. "I spent too much on fun" is a feeling that leads nowhere.

Two panels of bars, last month and this month: Essentials $2,210 then $2,240 (up $30), Lifestyle $830 then $1,040 (up $210), Saving $200 both months. Then the groups. One of them moved; that's the one to open.

Then the categories inside the group that moved

One group moved, so open that one. Not all three, just the one with the change:

  • Dining out: $410 → $590, up $180
  • Shopping: $190 → $220, up $30
  • Subscriptions: $45 → $45
  • Fun and entertainment: $185 → $185

Almost all of the $210 is dining out. Now the question is specific enough to answer: was that a few big nights, or a new weekly habit? Scroll the transactions in that category and you'll know in a minute.

This is the order that keeps a comparison short: three numbers, then groups, then only the categories inside the group that moved. Opening every category of every group every month is how people stop doing this.

The categories inside Lifestyle for the two months: dining out $410 then $590 (up $180, highlighted), shopping $190 then $220, subscriptions $45 both months, fun and entertainment $185 both months. Then only the categories inside the group that moved. Almost all of the change is one line.

Separate the one-offs from the trend

Some months are high for a reason that won't repeat:

  • A yearly bill: car registration, an annual membership, insurance paid every six months
  • A season: holiday gifts, back-to-school, a vacation
  • A repair: tires, a water heater, a vet visit

When one of these is behind the change, note it and move on. The comparison worked; it found the reason. If you want the one-offs to stop distorting months, divide the yearly ones by twelve and think of that as part of every month's cost, which the monthly expenses list covers in more detail.

A trend looks different: the same category, a little higher, three months in a row, with no single event to point to. That's the kind of change worth a decision.

Use an average as your baseline

Comparing against last month alone has a flaw: last month might have been the odd one. A better baseline is the average of the last three to six months.

Month 1Month 2Month 3Month 4Average
Essentials$2,190$2,210$2,240$2,205$2,211
Lifestyle$790$830$1,040$880$885
Saving$200$200$200$200$200
What's left$920$860$620$815$804

Against the average, Month 3's lifestyle spending is $155 high, not $210, and Month 4 is back near normal. The average smooths the blips and shows what a typical month really costs, which is also the number to use when you plan the next one.

A table of four months and their average: Essentials $2,190, $2,210, $2,240, $2,205 (average $2,211); Lifestyle $790, $830, $1,040 (highlighted), $880 (average $885); Saving $200 each month; what's left $920, $860, $620, $815 (average $804). Against the average, month 3's lifestyle spending is $155 high, not $210, and month 4 is back near normal.

What to do with what you find

Usually, one thing. Not a new budget for every category, not a resolution to cut everything. The comparison points at the one category that moved, and that's where a small change pays:

  • A number you now know (dining out was $590) tends to adjust itself a little, just from being seen.
  • If it doesn't, pick one specific change: one fewer restaurant night a week, or a cap on delivery, or a swap. Then compare again next month.
  • Leave the rest alone. Essentials didn't move. Saving didn't move. There's nothing to fix there.

Month over month, this is the loop: compare, find the one thing, change it or accept it, compare again. It takes ten minutes at the start of each month, and it's the closest thing there is to a steady hand on your money.

The automatic version

In a spreadsheet, the comparison means a column per month, consistent sorting, and an average formula. It works, as long as every month is sorted the same way.

See your own month this clearly.

SetBucks puts what came in, what went out and what's still coming on one screen.

We'll only email you about our launch. 14 days free, no card needed.

With your money in order, the only limit is you.

When we open, add your accounts and see where your money stands today, and every day ahead.

We'll only email you about our launch. 14 days free, no card needed.

Questions? Chat with us (opens in a new tab)