Getting started

Cleaning up category names before an accounting export

A checklist for cleaning category names before an accounting export: short names, no duplicates, one meaning each, with a before-and-after example.

Editorial illustration for Cleaning up category names before an accounting export

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.

BeforeAfterWhat changed
Eating out 🍕Meals and eating outEmoji removed, plain name
RestaurantsMeals and eating outMerged with the one above
Petrol/diesel/CNGFuelShorter, one meaning
MiscUncategorised, to reviewHonest holding name; clear it each month
Netflix etcSubscriptionsDescribes the type, not one brand
Home stuffHousehold suppliesClearer purpose
Mom's medicinesMedicalPersonal 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

  1. Print or open the full category list and read it once, top to bottom.
  2. Merge every pair that means the same thing.
  3. Remove emoji, symbols and personal nicknames.
  4. Shorten anything that wraps over two lines.
  5. Make sure each category has one meaning and one code.
  6. Rename the catch-all to say it needs review, then empty it.
  7. Export a small period and check the category column before sending the real thing.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports