Skip to content

Blog

Categorising transactions: a simple system that sticks

Fewer categories, a handful of rules and one firm line on transfers: a way to sort your spending that still works six months from now.

· 4 min read · By the GroFunds team

You sit down to sort last month’s spending and get stuck on the third transaction. Is a pharmacy run “health” or “household”? Is the $60 at the big box store groceries, gifts or home? Twenty minutes later you’ve sorted twelve items and you’re tired of it.

The problem usually isn’t you. It’s a system with too many choices. Here’s a simpler one that’s built to survive real life.

Why most category systems fall apart

Sorting gets hard for three reasons:

  • Too many categories. If you have 30 to choose from, every transaction becomes a small decision. Small decisions add up to giving up.
  • Categories that overlap. “Dining” and “coffee” and “treats” all claim the same $6 latte.
  • Money that isn’t spending gets counted as spending. Moving $500 to savings or paying off a card shows up as money going out, and it makes your month look far worse than it was.

Fix those three and the job gets quick.

Step 1: Start with about ten categories

You can always split a category later. You can’t easily merge a mess. Here’s a starting set that covers most households:

CategoryWhat goes in it
HousingRent or mortgage, condo fees, property tax
UtilitiesHydro or electricity, heating, water, phone, internet
GroceriesSupermarkets and anything you’d eat at home
Eating outRestaurants, takeout, delivery, coffee
TransportGas, transit, parking, car insurance, repairs
SubscriptionsStreaming, apps, memberships, cloud storage
ShoppingClothes, household items, electronics, gifts
HealthPharmacy, dental, glasses, therapy
Kids or petsChildcare, activities, food, vet
Everything elseThe rare thing that fits nowhere

Rename them to suit you. The point is a short list where each transaction has one obvious home.

Step 2: Decide your tie breakers once

Most of the time spent sorting goes on the same few awkward cases. Decide them now, write the answer down, and stop thinking about them.

Here are some examples of tie breakers you might set:

  • Mixed shops go by the main item. A big box store trip that was mostly food is groceries. Don’t split receipts unless the amount is large.
  • Coffee is eating out. One category for food you didn’t cook.
  • Car insurance is transport, not insurance, because you want to see the real cost of driving.
  • Gifts are shopping, unless you’ve set a separate gift budget.

It doesn’t matter which way you decide. It matters that you decide once and stay consistent, so that this month compares fairly with last month.

Step 3: Turn repeat decisions into rules

If you buy groceries at the same two stores every week, you shouldn’t have to sort them by hand every week.

In an app: many budgeting apps let you create a rule, such as “anything from this store goes in groceries.” Make one each time you correct the same merchant twice.

In a spreadsheet: keep a small table of merchant names next to their category, and look each new transaction up against it. You only type a category for the merchants that aren’t on the list yet.

After a month or two, the rules handle most of your transactions and you only sort the odd ones.

Step 4: Keep transfers out of spending

This is the step that changes your numbers the most.

Some money leaving an account isn’t spending at all. It’s just moving:

  • chequing to savings
  • savings back to chequing
  • a payment to your own credit card
  • money sent to your partner’s account for shared bills

If you count these as spending, you count the same money twice. You spent $120 on groceries with your card, then paid the card from chequing. Only the $120 groceries purchase was spending. The card payment was a transfer.

Give these their own label, such as “Transfer,” and leave them out of every spending total. There’s a full explanation, with an example, in transfers aren’t spending.

Step 5: Sort little and often

Sorting 150 transactions once a month is a chore. Sorting 35 once a week takes five minutes, and you still remember what that $47 was.

Pick one time each week, the same time, and sort only what’s new. If you want a full weekly routine around it, the 10 minute weekly money check has one.

A worked example

Here’s an example with invented numbers: one week for a household, before and after the system.

TransactionBeforeAfter
Supermarket, $142FoodGroceries (rule)
Coffee shop, $6TreatsEating out (tie breaker)
Transfer to savings, $300UncategorisedTransfer, not spending
Card payment, $900BillsTransfer, not spending
Pharmacy, $28Household?Health
Gas station, $65CarTransport (rule)

Before, the week’s “spending” looked like $1,441. After, real spending was $241, with $1,200 of money simply moved between accounts. Same bank statement, very different picture.

What to do with the categories once you have them

Categories are only useful if you look at them. Once you have two or three months sorted the same way, you can:

Start today

Open last week’s transactions. Sort them into the ten categories above, mark every transfer, and write down three tie breakers as you hit them. That’s the whole system, and it’s ready to repeat next week.

Once your spending is sorted consistently, GroFunds can learn what you usually spend and build budgets from your own numbers; the steps above work just as well on paper.