The hidden reason combined spending views fail is naming. The same coffee shop appears as three different strings across your accounts, so category totals scatter. Normalise the merchant name first, and categories, rules and reports all start working across every card and account.
What does the mess look like?
Here is one imaginary shop across three statements.
| Account | Description on the statement | Amount |
|---|---|---|
| Credit card 1 | CAFE NORD #0412 TORONTO | C$6.75 |
| Debit account | Purchase - Cafe Nord 0412 | C$5.40 |
| Credit card 2 | CAFENORD ONLINE | C$12.00 |
Three lines, one merchant, three descriptions. A filter on "Cafe Nord" would find only some of them. The total is 6.75 plus 5.40 plus 12.00, or C$24.15, but you would see it in pieces.
How do I normalise names?
- Choose one clean name for each merchant, such as Cafe Nord.
- Strip store numbers, city names and prefixes such as Purchase.
- Add a rule: anything containing "cafe nord" or "cafenord" becomes Cafe Nord, Category Eating out.
- Apply it to past lines, not just future ones.
Which merchants should I do first?
Sort your combined list by amount or by frequency and start at the top. Ten rules usually cover a large share of lines, so you get most of the benefit early.
Can the app help with names?
Some apps normalise merchant names automatically and let you add your own aliases. SpendixAI does this, and its categorisation works in stages: your rules, then your history and similar merchants, then an AI model only if switched on. It is built around India and INR and so is not a promise for Canadian users, but the staged approach is a good model to look for.
What about accounts in different formats?
Some statements put the merchant first, others the date and a code. When you combine them, copy each into the same five columns and tidy the description column as you go. Keep a note of which columns map to which, and the next month will be quicker.
How do I keep categories consistent across accounts?
Once names are tidy, use one category list for every account. A common mistake is letting each statement keep its own labels: one card calls a purchase Dining, another Restaurants. Merge them into one. Decide a short list of categories first, perhaps ten to fifteen, and map every merchant to one of them.
Revisit the list every few months. Delete categories you never use and split any that has grown too broad. A tidy category list is what makes the combined view readable in the first place.
How do I handle recurring subscriptions across cards?
The same service can bill two cards after an old card is replaced, and then you pay twice without noticing. Search the combined list for the merchant name and look at the dates. Two charges of C$16.99 in the same month is a signal. Pick the card you want to keep, cancel the duplicate, and write a rule so the surviving charge is labelled correctly.
Finally, test the result. Pick one category, such as Eating out, and total it across all accounts. If the number surprises you, open the lines behind it and check that nothing is mislabelled. A surprising total is either a real insight or a naming problem, and both are worth finding.
A normalising checklist
- One clean name per merchant.
- Rules for the top ten merchants.
- Past lines updated, not just new ones.
- Transfers between your own accounts kept out of spending.
This article covers records only. Bank fees and card terms are on your statements and agreements; check them there.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


