How to categorize transactions without turning it into a second job

Categorization is useful until it becomes the hobby. The goal is a monthly review you can finish in under an hour, not a museum of merchant-level taxonomy.

The test for any category scheme is simple: does the extra line change a decision? If splitting “Food” into groceries, dining, coffee, and delivery would make you act differently next month, split it. If it would only produce four smaller numbers you glance at and ignore, you have added maintenance without adding information.

Start with fewer buckets than you think

A workable starter set:

• Housing
• Transport
• Food (groceries + dining combined at first)
• Utilities & telecom
• Health
• Subscriptions
• Debt payments
• Transfers to savings/investing
• Income
• Other

Split food or subscriptions later if the combined line keeps surprising you. Don’t split first.

“Other” is not a failure. It is a holding pen. If it stays small relative to everything else, leave it alone. When it starts growing, look at what is sitting in there and promote the one recurring thing that explains most of it. That is how new categories should be born: from evidence, not from anticipation.

Rules that prevent thrash

Transfers aren’t spending. Moving money to savings is not a lifestyle category.

Refunds reverse the original category. Don’t invent “misc income” for a returned sweater.

One rule for gray areas. Coffee with a client: business or dining? Pick a rule and keep it for a year.

Split a receipt only when the split is material. A warehouse-store run that is mostly groceries and a little household stuff can go in Food whole. Splitting is worth the keystrokes when a large chunk belongs somewhere genuinely different, like a car repair buried in a hardware-store trip.

Write the rules down somewhere in the workbook. A short tab called “conventions” with six lines on it settles arguments with your past self and with anyone else who touches the sheet. Most category drift is not indecision, it is forgetting what you decided in March.

Batch, don’t stream

Categorize weekly or twice a month, not every ping. Streaming categorization is how people burn out by week three.

If your sheet receives synced transactions, filter uncategorized rows and clear the backlog in one sitting. On Sheetful’s Premium plan those rows arrive automatically each day; on Free you run the sync yourself before you sit down. Either way the work is the same: sort by uncategorized, go top to bottom, stop.

Lean on the merchant name. Most households have a few dozen recurring merchants that cover the large majority of rows, so a lookup table mapping merchant to category handles the bulk of a batch and leaves you to judge only the handful that are genuinely ambiguous. Momentum beats perfection.

What “good enough” looks like

If you can answer “where did the last $500 of discretionary spend go?” in two minutes, your system works. If you need a taxonomy meeting to file a Target run, simplify.

Categories serve the same purpose as the split between cash flow and budgeting: they exist to make one decision visible at a time. A coarse scheme you actually keep up with beats a precise one you abandoned in February.