Getting started

A categories and tax-codes file: why your CA may ask for one

Why a categories and tax-codes file travels with your transactions, what a small sample looks like, and what to review before you send it to your CA.

Editorial illustration for A categories and tax-codes file: why your CA may ask for one

A categories and tax-codes file lists every category you use, along with its GST rate, tax settings and accounting code. Your CA may ask for it because the transactions file only says 'Fuel' or 'Software', and without this companion list they cannot tell what you meant or how each category should be treated. Send the two files together.

What is this file actually for?

Think of the transactions file as the sentences and this one as the dictionary. Your CA opens a transaction marked 'Travel' and wonders: is that a train ticket for the office or a family holiday? Is GST included? Should it go under conveyance or something else in their books? The category list answers those questions once, instead of row by row.

In SpendixAI, categories and sub-categories can carry a colour, a GST rate, an ITC-eligible setting, a tax-deductible setting and an accounting code. The Export centre has a categories-and-tax-codes file built from those settings.

What does a small sample look like?

The sample below is invented to show the shape. Your own rows, rates and codes will differ, and the settings are your working notes, not a ruling.

CategoryGST rateITC-eligibleTax-deductibleCode
Office rent18%YesYes5010
Software subscriptions18%YesYes5020
Client meals5%NoCheck with CA5030
Groceries0%NoNo6010
FuelVariesCheck with CACheck with CA5040

Notice the honest 'Check with CA' entries. Where you are not sure, it is better to leave a visible question than to fill in a confident guess that is wrong.

Why would my CA need the codes?

Accountants usually work from a chart of accounts, a numbered list of heads that their books and software use. A code on each of your categories gives them a hook: they can map your code 5020 to the head they already have. Without codes they map by name, and names are easy to misread. Two categories called 'Misc' and 'Other' look alike but may belong in different places.

What should I review before sending it?

Do this review before you export, because it is much easier to fix a category than to explain a mistake afterwards.

  1. Read the full category list top to bottom and delete or merge anything you no longer use.
  2. Look for near-duplicates, such as Eating out and Restaurants, and decide which one stays.
  3. Check every GST rate against the supplier invoices you hold, not against memory. Rates and rules change, so confirm the current position with your CA or the official source.
  4. Where a category mixes things with different rates, split it into sub-categories.
  5. Make sure every category you want in the books has a code, and no two categories share one by accident.
  6. Mark the unsure ones for your CA to confirm instead of choosing for them.

Is a personal user expected to send this?

Not necessarily. If you only track household spending, the file may be more detail than anyone needs. It earns its place when a CA, a bookkeeper or you yourself will use the figures for a business, a side income or a GST-registered activity. Ask your CA whether they want it, and if so, which settings they care about most.

One more habit helps. Keep a dated copy of each category file you send. If your CA asks in a later year why a category carried a certain rate in an earlier period, you can show what the list said at the time instead of reconstructing it from memory.

Quick closing checklist

  • Export the transactions file and this file for the same moment in time, so the category names match.
  • Rename the files so both mention the period and the date you exported them.
  • In your email, say which tax and GST settings you are sure of and which you are not.
  • Re-export the category file whenever you add, rename or recode a category, and tell your CA that the old one is out of date.
SPENDIXAI JOURNAL

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

Explore your reports