Pairing each category you use, such as "Software" or "Meals", with the code or label your accountant files it under gives you a categories and tax codes file, which is just a short table. You build it once, send it with your transactions, and the year-end conversation shrinks from twenty emails to two. The codes themselves come from your accountant, not from you.
Why would an accountant want one?
Your categories are personal. Yours might say "Gear" where your accountant's ledger says "Equipment" and "Gadgets under limit" somewhere else. Without a key, they have to guess, and each guess is a possible error. A key turns your labels into their labels without anyone guessing.
What goes in the file?
| Column | Purpose | Example |
|---|---|---|
| Category | Your own label | Gear |
| Sub-category | Optional detail | Cameras |
| Accountant code | Their ledger code, as they give it to you | 5120 |
| Tax treatment note | What they told you, in their words | Ask before year-end |
| Business use | Share of use if mixed | Phone, half work, half personal |
The codes in this article are placeholders. Do not copy them; ask your accountant for their real list, and do not assume a treatment from a code number alone.
How do I build it in an afternoon?
- Export all your transactions for the year and list every distinct category you actually used. In a sheet, =UNIQUE(D2:D2000) does this in Excel 365 or Google Sheets.
- Count how many transactions and how many dollars each category holds, using =COUNTIF($D$2:$D$2000, G2) and =SUMIFS($C$2:$C$2000, $D$2:$D$2000, G2).
- Send the list to your accountant and ask which code each belongs under.
- Paste their answers into the code column.
- Mark any category they could not place and decide what to do with it together.
What do the counts tell me?
Say your list has Software at 38 transactions totalling $1,284.00, Meals at 61 totalling $2,310.40, Gear at 9 totalling $3,894.75 and Misc at 44 totalling $912.30. The grand total is 1,284.00 + 2,310.40 + 3,894.75 + 912.30 = $8,401.45 across 38 + 61 + 9 + 44 = 152 transactions. The accountant's attention goes first to Gear (large amounts, few rows) and Misc (vague and numerous). Those are the categories to explain, not the rest. These numbers are invented.
What about categories that mix business and personal use?
Add a note, not a guess. If your phone bill is part work, say so in the notes column and let your accountant decide how to treat it. Do not split the amounts yourself unless they tell you how, and keep any records of your usage they may ask for.
Can SpendixAI produce this file?
Its export centre includes a categories and tax codes file, and categories can carry settings such as tax-deductible, GST rate and an accounting code. The product is built around India and INR, so the GST wording will not match a US setup, and we are not suggesting it as a US solution. For readers elsewhere it shows the shape of the file worth asking for.
How often should I update it?
Review the file whenever you add or rename a category, and once more before you send year-end records. A short, dated copy beats a long one you cannot trust. If you take on a new kind of work, such as selling a product for the first time, ask your accountant which category and code it should use before the first purchase, not after fifty. That one question avoids a rework of the whole file later and keeps the year's totals comparable from month to month.
Send-off checklist
- Every category used this year appears once in the file.
- Each has a code or a note saying "to confirm".
- No category called Misc, or Misc explained.
- The file is dated, so next year you know which version you used.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


