The question: "I track expenses by category, but my CA wants Tally ledgers and codes. How do I map my categories to ledger names without redoing everything?" Short answer: build a small mapping table once, with one ledger and one code per category, get your CA to approve it, and let every future export reuse it.
Why do the two lists never match on their own?
You think in everyday words: Food delivery, Petrol, Phone. Your CA's books think in ledgers under heads such as indirect expenses, travel or telephone. Some of your categories will split across ledgers and some will merge. The mapping is the translation, and it is a business decision your CA owns, not something you should guess.
How do I build the mapping? Steps
- Export or list your categories. If you have forty, mark the ten that carry most of the money first.
- Ask your CA for the ledger names exactly as they appear in the company's Tally, including spelling and capital letters. A ledger called "Telephone Expenses" will not match "Phone bill".
- Write a two-column table: your category on the left, the ledger on the right. Add a third column for any numeric code your CA uses.
- Find the categories that need splitting, for example "Travel" that is part client visits and part personal. Split them in your tracker, not in the mapping.
- Send the table to your CA and ask for a yes on each row.
- Apply the codes to the categories in your tracker, then test with one month of data.
What does a worked example look like?
These names and codes are made up. Your CA's will differ.
| Your category | Ledger name (CA's) | Code | Month total (₹) |
|---|---|---|---|
| Food delivery | Staff Welfare | 5120 | 3,200 |
| Petrol | Conveyance | 5210 | 7,800 |
| Mobile and internet | Telephone Expenses | 5330 | 1,998 |
| Cloud tools | Software Subscriptions | 5410 | 4,500 |
The four rows total ₹17,498. After export, your CA should see the same total spread across four ledgers. If one ledger is off, you know exactly which category to open.
Where does SpendixAI fit?
In SpendixAI a category can carry an accounting code, along with a GST rate and tax settings, and the Export centre has a Tally template as well as a categories-and-tax-codes file. So the mapping you agreed with your CA lives on the category itself and travels with the export. The GST figures in reports are estimates, so keep invoices and confirm with your CA.
What should I check after the first export?
- Does the grand total equal your statement total for the same dates?
- Are any transactions sitting in "Uncategorised"? They will export with no ledger.
- Do ledger names match your CA's Tally spelling exactly?
- Did refunds and reversals export as credits, not as extra expenses?
What is the honest limit?
A tracker cannot tell you which ledger is correct for tax or audit purposes. It only keeps your mapping consistent. Rules and treatment change, so confirm the current position with your CA, and review the first import in Tally before you rely on it.
What if my CA uses different heads every year?
It happens when the firm restructures its chart of accounts or you move to a new CA. Do not rebuild your categories. Keep your everyday categories stable and change only the mapping column. That is the benefit of separating the two: your habits stay the same while the translation layer is replaced. Keep dated copies of each version of the table, for example "mapping April 2026", so a question about an old export can be answered by opening the table that was in force then.
Also decide who owns the table. If your CA changes a ledger name by email, update the table the same day and note the date. Small mismatches between the spelling in your export and the spelling in Tally are the most common reason an import needs cleaning, and they are avoidable.
A quick close-out list
- Ten biggest categories mapped first.
- CA's written approval on each ledger name.
- One month tested before the full year.
- Mapping table saved with your records.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

