Expense categories

Why uncategorised transactions skew euro reports, and how to clear them

Many uncategorised euro transactions are transfers and card repayments that double count spending. Learn to spot them and clear the pile in a few steps.

Editorial illustration for Why uncategorised transactions skew euro reports, and how to clear them

A large share of uncategorised transactions in a euro account are not purchases at all. They are card repayments, savings moves and transfers between your own accounts, and counting them as spending makes a month look more expensive than it was. Label those first, and the pile often halves.

Only after that is it worth thinking about true unknown merchants, which are a much smaller job.

Which uncategorised rows are really transfers?

  • Repayments of a credit or charge card from your current account.
  • Money moved to a savings or investment account.
  • Top-ups of a prepaid or travel card.
  • Payments between a joint account and your own account.
  • Reimbursements from or to friends and flatmates.

None of these is spending in the sense a budget cares about. The spending happened when you used the card, not when you paid it off.

What does double counting look like in euros?

Say your current account shows €2,950 going out in a month.

Outgoing itemAmountSpending?
Rent€980Yes
Groceries€410Yes
Card repayment€620No, the card purchases are counted elsewhere
Move to savings€500No, it is a transfer
Other payments€440Yes

The rows add up to €2,950 (980 + 410 + 620 + 500 + 440). True spending from this account is €1,830, found by taking away the repayment and the savings move (2,950 minus 620 minus 500). Without that step the month looks 61 percent more expensive than it was: 2,950 divided by 1,830 is about 1.61.

How do you clear them quickly?

  1. Sort the uncategorised rows by amount and look at the largest first; transfers are usually the biggest rows.
  2. Give each recurring transfer, such as the monthly savings move, a Transfers category and a rule.
  3. Check that a card repayment appears in your card account as money received, then mark both sides as transfers.
  4. Handle shops and services last, grouped by merchant.

A good habit is to test your month with one sum: money out of all accounts, minus transfers between your own accounts, should equal what you call spending. If the two figures differ, something is double counted or missing, and the difference tells you roughly how big the missing item is. Do this before you start worrying about individual merchants.

What about shared costs with a partner or flatmates?

A transfer to a partner for shared rent can be either an expense or a transfer, depending on how you record the household. Choose one approach and apply it every month. Mixed treatment is what leads to totals that no one trusts.

Will a different currency complicate it?

If some rows are in another currency, keep each row in its original currency and total in a single base currency using the exchange rate for that transaction. SpendixAI supports this, though it is built around India and INR, so check any tool for your region before you rely on it.

Checklist for the clean-up

  • Count the uncategorised rows and euros before and after.
  • Make sure transfers are labelled and excluded from spending totals.
  • Keep one rule for each recurring transfer.
  • Reconcile monthly: outgoing less transfers should equal what you call spending.

This is about getting your records consistent. If a local tax or benefit rule depends on the classification, ask an accountant in your country.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports