Here is a claim that sounds wrong: the best expense category list is usually shorter than the one you have, and it should look slightly uncomfortable to use day to day.
The instinct when setting up a sheet is to build categories that make sense while you are entering data. You spent money at a hardware store, so you want a "Hardware" category. You bought lunch, so "Meals". The list grows organically until it has forty entries and three of them mean roughly the same thing.
Then tax time arrives and you discover the list was optimised for the wrong moment. Your accountant does not need to know you shop at a particular hardware store. They need to know which of your spending maps to each line of a tax form, and your forty categories map to those lines in a many-to-many mess that someone now has to untangle by hand.
Categories should be designed backwards from the output.
Start from the form, not the spending
Pull up whatever you actually file. A US sole proprietor filing Schedule C has around twenty expense lines. A UK sole trader's Self Assessment has a shorter list of allowable expense headings. An Australian sole trader's return has its own groupings. Whichever applies, that list is your anchor.
The exercise takes fifteen minutes: write each line of the form down the left of a page, then list the kinds of spending you actually do beside it. Two things fall out immediately.
Some form lines you will never use. A freelance designer has no cost of goods sold. Delete those categories rather than carrying them around empty.
Some of your spending maps nowhere obvious. This is the useful discovery. Spending with no clear home is spending your accountant will ask about, and finding that out in August is cheaper than finding out in January.
The one-to-one rule
Every category you keep should map to exactly one line of the form. Not "mostly" one line. Exactly one.
This is the rule that makes the finished sheet feel slightly uncomfortable, because it forces splits that feel unnatural at entry time. The clearest example is a trip: a train ticket, a hotel, and dinner are one event in your head, but they frequently land on different lines of a tax form. One "Travel" category that lumps all three means someone has to reopen every travel row later and split it.
Better to have "Travel — transport", "Travel — accommodation", and "Travel — meals" and take the extra half-second at capture.
The inverse also applies: if two of your categories always end up on the same form line and you never report on them separately, merge them. "Software" and "Subscriptions" are usually the same line and the same decision. Two names for one thing just creates a daily choice with no payoff.
A starter set that maps cleanly
This set works for most service businesses and sole traders. Adjust the names to match your own form's wording — matching the wording exactly is worth doing, because it removes the translation step entirely.
| Category | Typically covers | Watch for |
|---|---|---|
| Software and subscriptions | SaaS, domains, hosting, app stores | Annual renewals straddling two tax years |
| Professional services | Accountancy, legal, bookkeeping | Fees that relate to capital purchases are treated differently |
| Travel — transport | Trains, flights, taxis, parking, tolls | Keep separate from vehicle running costs |
| Travel — accommodation | Hotels, short stays | Breakfast often itemised separately on the invoice |
| Meals and entertainment | Client meals, subsistence | Deductibility differs sharply by jurisdiction |
| Vehicle running costs | Fuel, servicing, insurance | Usually incompatible with claiming mileage; pick one method |
| Equipment | Laptops, cameras, tools | May be capital rather than an expense |
| Office supplies | Consumables, stationery, small items | The dumping ground; audit it quarterly |
| Marketing and advertising | Ads, print, sponsorship | Website build costs may be capital |
| Insurance | Professional indemnity, public liability | Personal policies do not belong here |
| Home office | Apportioned household costs | Record the apportionment basis, not just the amount |
| Bank and payment fees | Card fees, transfer charges, interest | Interest is often a separate form line |
Twelve categories. If yours has thirty, the extra eighteen are almost certainly subdivisions you could handle with a second column instead.
Use a second dimension instead of more categories
Most category sprawl happens because people encode two different things in one field. "Hardware store — Jones Street job" is a category plus a project. "Client lunch — Acme" is a category plus a client.
Split them. One column for the tax category, a second for project, client, or property. Now you can filter by job for your own reporting and by category for your return, without the two systems fighting. In Google Sheets a pivot table across those two columns gives you both views from one dataset, which is the entire reason the data lives in a spreadsheet rather than an app.
Naming rules that prevent drift
Category lists decay through tiny inconsistencies that are invisible until you try to summarise.
- One word form, always. "Meals" or "Meals and entertainment", never both. A SUMIF over "Meals" silently ignores every row tagged "Meals & Entertainment".
- No ampersands. They get typed as "and" half the time. Pick the word.
- No trailing spaces. The commonest cause of a category appearing twice in a pivot table.
TRIM()in a helper column catches it. - Lock the list. Use Data → Data validation → Dropdown from a range, pointing at a category list on a separate tab. Free-typed categories are the single biggest source of drift, and validation eliminates the problem at source rather than cleaning it up later.
That last one matters more than the rest combined. A dropdown makes the inconsistent entry impossible rather than merely discouraged.
The quarterly audit
Once a quarter, build a pivot table of category against total and read it with two questions in mind.
First: which categories have fewer than three rows? Either they are not real categories, or something is being miscoded into a neighbour.
Second: which category is suspiciously large? "Office supplies" swelling past every other line usually means it has become the default for anything ambiguous. Open those rows and look at what is actually in there — it is normally two or three distinct kinds of spending that deserve their own home.
Where automatic categorisation fits
Tools that categorise receipts automatically, including Scan2Sheet, work well against a list like this precisely because the categories are few and distinct. A twelve-item list with clear boundaries is easy to assign correctly; a forty-item list with three overlapping travel categories produces coin-flip results no matter what is doing the assigning.
Two practical habits regardless of tool: review the assigned category on anything above a threshold you set yourself, and never let an automated category be the only evidence of a decision you had to make — the apportionment basis, the project link, the reason a cost was business rather than personal still belongs in a notes column, written by you.
Rebuild your list against your own form before the next quarter closes. It is a fifteen-minute job that removes an afternoon of reconciliation later.