A bank statement tells you who got paid and how much. It does not tell you how much went to food, housing or subscriptions, and that is the question a budget exists to answer. The step in between is categorizing your transactions. Done by hand every month it is tedious enough that most people quit; done once, with a few good rules, it becomes a five-minute check. This is how to set it up so you stop re-sorting the same merchants over and over.
Why categorizing is the step that makes a budget useful
A month of transactions is a long list of merchant names, many of them cryptic. Until each line has a category, you cannot say whether dining out went up, what your subscriptions add to, or whether the month's overspend came from one big purchase or from a hundred small ones. Categories are what let you compare this month with last month, and what let a budget say anything at all.
Most people stumble on three things. They invent too many categories and give up on the upkeep. They categorize the same merchant differently in different months, so the totals drift. Or they treat every transaction as equally important, when a short list of recurring merchants usually accounts for most of the lines. The method below is built around avoiding all three.
How to categorize a bank statement in five steps
You can do this in a spreadsheet or in an app, and the steps are the same:
- Start with 8 to 12 broad categories, such as housing, groceries, eating out, transport, health, subscriptions, shopping, savings and other. Official household budget surveys in the EU sort all spending into just 12 top-level groups, which is a good sign that you do not need dozens.
- Sort the statement by amount and categorize the biggest and most frequent merchants first. A handful of rent, utilities, supermarket and transport lines usually covers most of the money, and you can leave the long tail of small one-off purchases in "other" until later.
- Turn every decision into a rule: this merchant always goes to this category. A rule means you decide once, and the same merchant is sorted correctly every month afterwards, which is the whole point.
- Handle the awkward lines on purpose. A supermarket that also sells household goods, a marketplace that sells everything, and a payment service that hides the real merchant are the lines that blur your categories. Pick a default for each, and split or recategorize only when the amount is big enough to matter.
- Keep transfers, refunds and card payments out of your spending. Moving money between your own accounts and paying off a credit card are not spending, and counting them twice is the most common reason a total looks too high.
What the biggest categories look like in 10 countries
| Country | Housing / transport share of spending | What the figure measures | Source and year |
|---|---|---|---|
| United States | 33.4% / 17.0% | Average per household, housing and transportation as a share of total annual spending | BLS Consumer Expenditure Survey, 2024 |
| Canada | 32.1% / 15.8% | Average per household, shelter and transportation | Statistics Canada Survey of Household Spending, 2023 |
| United Kingdom | 18% / 14% | Average per household, "housing (net), fuel and power" and transport; the UK housing measure is narrower than the others | ONS Family Spending, April 2024 to March 2025 |
| Ireland | 34.7% / 11.2% | Average per household, housing, water, electricity, gas and other fuels, and transport (survey year affected by the pandemic) | Eurostat household budget survey, 2020 |
| Germany | 31.4% / 13.5% | Average per household, housing, water, electricity, gas and other fuels, and transport (survey year affected by the pandemic) | Eurostat household budget survey, 2020 |
| France | 28.9% / 13.2% | Average per household, housing, water, electricity, gas and other fuels, and transport (survey year affected by the pandemic) | Eurostat household budget survey, 2020 |
| Spain | 35.6% / 10.2% | Average per household, housing, water, electricity, gas and other fuels, and transport (survey year affected by the pandemic) | Eurostat household budget survey, 2020 |
| Portugal | 39.2% / 12.1% | Average per household, housing, water, electricity, gas and other fuels, and transport (survey year affected by the pandemic) | Eurostat household budget survey, 2020 |
| Netherlands | 30.7% / 10.3% | Average per household, housing, water, electricity, gas and other fuels, and transport (survey year affected by the pandemic) | Eurostat household budget survey, 2020 |
| Poland | 32.7% / 7.9% | Average per household, housing, water, electricity, gas and other fuels, and transport (survey year affected by the pandemic) | Eurostat household budget survey, 2020 |
How to read those numbers
The pattern is more useful than any single figure. Housing is the bigger of these two categories in every row, and housing and transport together take roughly 41% to 51% of spending in the nine rows with comparable definitions (the UK measure is narrower). That is why getting those two categories right matters more than agonizing over a coffee shop. If rent, utilities and transport are sorted correctly, most of your budget is already categorized.
Treat the table as a sanity check, not a target. The sources define categories slightly differently, the European figures come from a 2020 survey in a pandemic year, when transport and eating out were unusually low, and a household with a mortgage, a car or a big family will sit far from any average. For Ukraine we did not find a comparable recent official breakdown, so there is no row for it. What matters is that your own categories stay the same from month to month.
Where Home Budget Analytics fits
Home Budget Analytics is built around the rule step. You upload your statements, transactions are deduplicated, and each one is suggested a category using rules that you approve, with no black-box AI deciding about your money. Once you approve a rule, the same merchant is sorted automatically the next time it appears, so after the first review each month is mostly a quick check. Spending by category over time, budgets per category and recurring-payment detection all build on those categories.
The limits are worth knowing. The app works from statement files rather than a live bank connection, so categorizing happens when you upload, and it does not track investments or net worth. For how manual and automatic sorting compare in time and accuracy, see the related post below.
Common questions
How many categories should I have?
Between 8 and 12 is enough for most households. Fewer categories are easier to keep consistent, and you can always split a big one later, for example groceries and eating out, once the totals show it is worth it.
Do I need to categorize every single transaction?
No. Cover the biggest and most frequent ones first, and let the small leftovers sit in an "other" category. If "other" grows past a small share of your spending, look at what is in it and add a category or a rule.
How do I handle transfers between my own accounts?
Mark them as transfers so they do not count as income or spending. The same goes for credit card payments: the purchases on the card are the spending, and paying the card off is just moving money.
Can I just use the categories my bank assigns?
They are a useful starting point, but bank labels differ from one bank to the next and are often broad or wrong for small merchants. If you use more than one bank, your own categories and rules keep the totals comparable across accounts.
Sort your statements once, then let the rules do the work
Upload your bank statements, approve the category rules once, and see where your money goes by category - free to try, no card required.
Start your free trial