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:
| Category | What goes in it |
|---|---|
| Housing | Rent or mortgage, condo fees, property tax |
| Utilities | Hydro or electricity, heating, water, phone, internet |
| Groceries | Supermarkets and anything you’d eat at home |
| Eating out | Restaurants, takeout, delivery, coffee |
| Transport | Gas, transit, parking, car insurance, repairs |
| Subscriptions | Streaming, apps, memberships, cloud storage |
| Shopping | Clothes, household items, electronics, gifts |
| Health | Pharmacy, dental, glasses, therapy |
| Kids or pets | Childcare, activities, food, vet |
| Everything else | The 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.
| Transaction | Before | After |
|---|---|---|
| Supermarket, $142 | Food | Groceries (rule) |
| Coffee shop, $6 | Treats | Eating out (tie breaker) |
| Transfer to savings, $300 | Uncategorised | Transfer, not spending |
| Card payment, $900 | Bills | Transfer, not spending |
| Pharmacy, $28 | Household? | Health |
| Gas station, $65 | Car | Transport (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:
- see your own normal for each category, and spot when a month drifts away from it (is this month normal? shows how)
- build a budget from what you really spend, not a guess (build a budget from your last three months)
- notice a category that’s quietly growing, such as subscriptions or delivery
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.