When you hand your records to a new bookkeeper, the most useful single file is a list of your categories next to the codes they will use for them. It saves them reading your transactions line by line to work out what you meant. Send it before the first call, and ask them to mark anything they would file differently.
What should I send on day one?
- A list of every category and sub-category in your records, with a one-line description of what goes in each.
- A blank column for their code, for them to fill in.
- The date range of the transactions you are sending.
- A note on any category that mixes personal and business spending.
Do not invent codes to look organised. A code you made up that clashes with their system creates more work than no code at all.
What will they ask in return?
Expect questions like these, and have answers ready: Do you run everything through one account? Are any transactions shared with a partner or family? Is there anything in "Other" over a certain amount? Which items have receipts? The categories file answers the first of these almost by itself, because it shows which accounts feed which categories if you add a column for it.
What does the file look like with real-feeling data?
| My category | What goes in it | Their code | Note |
|---|---|---|---|
| Travel | Train fares, parking, fuel | (they fill in) | Fuel used for personal trips too |
| Software | Subscriptions, licences | (they fill in) | Some billed annually |
| Home office | Part of broadband and electricity | (they fill in) | Ask how they want it recorded |
| Training | Courses, books | (they fill in) | None |
Write "None" rather than leaving a note blank, because a gap can look like an oversight.
How do I show what each category holds?
A column of totals helps them judge where to look first. If your sheet has categories in column D and amounts in column C, the total for Travel is =SUMIFS($C$2:$C$1500, $D$2:$D$1500, "Travel"). Suppose Travel holds £1,148.60, Software £486.00, Home office £620.40 and Training £310.00. The total across the four is 1,148.60 + 486.00 + 620.40 + 310.00 = £2,565.00. A bookkeeper who sees that Home office is nearly a quarter of the list (620.40 / 2,565.00 is about 24 percent) knows to ask how you arrived at it. The numbers are illustrative only.
What if my categories are a mess?
Better to send the mess with a note than to tidy it hurriedly. Sort by category, merge obvious duplicates such as "Subs" and "Subscriptions", and flag the rest. A bookkeeper can normally work from an honest, slightly untidy file. They cannot work from one that has been quietly altered.
Is there an app that exports this file?
SpendixAI has an export centre with a categories and tax codes file, and each category can hold an accounting code and tax-related settings. It is built around India and INR, so the settings are tied to Indian GST and we are not claiming UK support. The principle holds anywhere: look for a tool that can export your category setup, not just your transactions.
Keeping it useful after the first month
A good file outlives the first call. Each time your bookkeeper answers a question about a category, record the answer in the notes column with the date. After a quarter you have a short rulebook in their own words, which you can reuse when you add a new purchase type or hand the books to someone else. It also helps you spot drift: if you find yourself creating a new category every week, the list probably needs a firmer structure.
After the first call
- Update the file with the codes they gave you.
- Rename or merge categories to match, if they suggested it.
- Keep the file with the year's records so you can send the same one next time.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


