Before you send an accounting export, clean the category list: keep names short, merge duplicates, drop emoji, give each category one clear meaning, and add a code to each one. Your accountant will read the list as the ground rules of your spending, and a tidy one cuts down the number of questions they have to ask.
What makes a category name hard for an accountant?
Personal tracking tolerates things that accounting does not. A name like 'Lunch with Priya 🍛' is a memory, not a head of expense. The common problems are easy to spot once you look for them.
- Duplicates in disguise, such as Eating out, Restaurants and Food outside.
- Emoji and symbols that may not survive a file export.
- Names that mix two meanings, such as Travel and misc.
- Very long names that get cut off in a spreadsheet.
- Names that only you understand, such as Fun money or Treats.
- A category that has become a dumping ground for everything unsure.
Can you show a before and after?
Here is an invented messy list and a cleaned version. The right-hand names are an example of a tidy style, not a standard your accountant must use.
| Before | After | What changed |
|---|---|---|
| Eating out 🍕 | Meals and eating out | Emoji removed, plain name |
| Restaurants | Meals and eating out | Merged with the one above |
| Petrol/diesel/CNG | Fuel | Shorter, one meaning |
| Misc | Uncategorised, to review | Honest holding name; clear it each month |
| Netflix etc | Subscriptions | Describes the type, not one brand |
| Home stuff | Household supplies | Clearer purpose |
| Mom's medicines | Medical | Personal label removed |
How do I merge without losing history?
Choose the name you want to keep, move the transactions from the duplicate into it, then delete the empty duplicate. Do this a category at a time and check the totals afterwards: the combined total should equal the two old totals added together. If Eating out was ₹9,400 and Restaurants was ₹3,100 for the year, the merged category should show ₹12,500. In SpendixAI, corrections become history, so later imports lean towards the merged name.
Do codes really matter?
They help the accountant map your category to a head in their chart. SpendixAI lets you give each category an accounting code. Keep codes unique and consistent: Fuel is always the same code, and no two categories share one. Sub-categories are useful when one category covers items with different GST treatment, since the GST rate setting sits at the category level. Where unsure of a rate or setting, leave a note for your CA rather than a confident wrong answer.
What about categories I only use for myself?
You can keep personal categories for your own insight and still send a business export. Filter the export to the accounts or categories your CA needs. If personal and business spending share one account, discuss with your CA how to separate them, instead of trying to solve it quietly in category names.
Aim for a list your CA can read in two minutes. For most people that means a few dozen categories at most, and often far fewer. If you find yourself creating a new category for every occasion, ask whether a sub-category under an existing one would do the job without cluttering the list.
A ten-minute checklist
- Print or open the full category list and read it once, top to bottom.
- Merge every pair that means the same thing.
- Remove emoji, symbols and personal nicknames.
- Shorten anything that wraps over two lines.
- Make sure each category has one meaning and one code.
- Rename the catch-all to say it needs review, then empty it.
- Export a small period and check the category column before sending the real thing.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
