Expense categorization for individuals and businesses
A practical guide to designing expense categories, writing rules that survive, and avoiding the classic categorization traps.
Expense categorization decides whether a bank statement means anything at all. Uncategorized transactions are just a list; categorized transactions become a budget, a P&L, a tax deduction, or a decision. This guide covers how to design categories that work, how to keep them working over time, and the traps that make categorization feel like a chore.
Categories serve a question
Never design categories in the abstract. Design them to answer a specific question: how much do I spend on housing, how much of my business runs on subscriptions, how much of last quarter went to marketing. If a category cannot be traced back to a question you actually ask, it is noise.
Personal categories that work
For personal spending, ten to fourteen top-level groups is the right size. Housing, Utilities, Groceries, Dining, Transport, Health, Personal, Subscriptions, Entertainment, Shopping, Travel, Fees, Income, Transfers. If you split any of these into sub-categories, do it because you make a decision at the sub-category level (Groceries vs Restaurants inside Dining, for example).
Business categories that work
For a small business, align categories with your tax return line items. In the US that means the Schedule C or 1120 categories: Advertising, Car and truck, Contract labor, Depreciation, Insurance, Legal, Office, Rent, Repairs, Supplies, Taxes and licenses, Travel, Meals, Utilities, Wages. Anything else goes under Other. If your bookkeeping tool cannot map to your tax form, you will do the mapping by hand at year end.
Rules that survive
Categorization at scale means rules, not one-off tagging. Every rule is a match string, a category, and a priority. Write rules from specific to general: STARBUCKS RESERVE above STARBUCKS, HILTON above generic HOTEL. When a merchant renames itself, add the new string to the existing rule. Do not create parallel rules for the same merchant.
The uncategorized bucket is a feature
Do not chase 100 percent categorization. Leave low-frequency, low-value transactions in Uncategorized. Every hour spent perfecting the last 3 percent is an hour you did not spend on the decision the categorization was supposed to inform.
Common traps
- Category creep: adding a new leaf every time you see an oddly-shaped transaction. The tree becomes unnavigable. Merge leaves quarterly.
- Timing errors: categorizing a transfer as income or expense. Transfers deserve their own category and should be excluded from both sides of your cash flow.
- Amount-based rules: categorizing on amount is fragile. A restaurant charge of 42 USD is not always dinner. Use the merchant, not the amount.
- Personal-business mixing: if you buy something on the personal card that was actually business, do not retroactively edit the rule. Reclassify the individual transaction and note it.
Reviewing categorization periodically
Once a quarter, look at your top ten categories by spend and ask if the split still tells you what you want to know. If two categories always move together, merge them. If one category has become dominant, split it. Categories are not sacred; they are tools for answering questions.