To map expense categories to Tally ledgers, make one table with a row per category and columns for the ledger name, the accounting code and the group, using the exact ledger names your accountant already has in Tally. Then check that every expense row finds a ledger before anything is exported. The mapping is a small piece of work that saves a long clean-up later.
What does a mapping table contain?
Four columns are enough to start: your category, the Tally ledger name, an accounting code and the expense nature. Add a fifth for a GST rate if your accountant wants it, but treat that as an estimate to confirm with a CA.
| Your category | Tally ledger name | Code | Nature |
|---|---|---|---|
| Office supplies | Office Expenses | 5010 | Indirect expense |
| Travel | Travelling Expenses | 5020 | Indirect expense |
| Internet and phone | Telephone and Internet | 5030 | Indirect expense |
| Fuel | Vehicle Running Expenses | 5040 | Indirect expense |
| Client meals | Business Promotion | 5050 | Indirect expense |
The codes above are invented for the example. Use whatever scheme your accountant follows; if there is none, keep codes short and leave gaps between numbers so new ledgers fit later.
Who decides the ledger names?
Your accountant or the existing Tally company file decides. A ledger spelled slightly differently from the one in Tally can create a duplicate ledger on import, so copy names exactly, including spaces and capital letters. Ask for the ledger list as a printout or spreadsheet and paste it as the master column. Do not guess, and do not rename ledgers yourself in the middle of a financial year without asking.
How do I catch rows that have no ledger?
Keep the mapping table on one sheet in cells F2:G40, with the category in column F and the ledger in column G. On the expenses sheet, put the category in column C and use this in D2: =IFERROR(VLOOKUP(C2,$F$2:$G$40,2,FALSE),"UNMAPPED"). Fill it down. To count the problem rows use =COUNTIF($D$2:$D$500,"UNMAPPED"). Anything above zero needs a new mapping row or a corrected category. XLOOKUP exists in Excel 2021, Excel 365 and Google Sheets, but VLOOKUP works in every version, so it is used here.
What should I reconcile before exporting?
- Total of all rows equals the total of the ledgers, so nothing is lost.
- No row shows UNMAPPED.
- Personal spending is kept out of business ledgers.
- Transfers and card bill payments are excluded so nothing is counted twice.
- The date range matches the accounting period being posted.
A small proof: say five ledgers hold ₹12,400, ₹8,650, ₹3,540, ₹6,200 and ₹4,310. They add up to ₹35,100. If your expense sheet for the period totals ₹35,100 and the ledger totals match, nothing was dropped. If the sheet says ₹35,350, ₹250 is sitting in a category that has no ledger.
How does SpendixAI fit into this?
In SpendixAI each category can carry an accounting code, a GST rate and ITC-eligible and tax-deductible settings, and the Export centre has a Tally template, plus a file listing categories and tax codes. Those GST figures are estimates, so confirm them against invoices and with your CA. Which ledger a code lands in is for your accountant to confirm, so share the categories file early.
What if the same category belongs in two ledgers?
It happens: a travel category may hold both local conveyance and an out-of-town trip that your accountant books differently. Either split the category into two, such as Travel local and Travel outstation, or keep one category and add a note column that tells the accountant how to split. Splitting the category is cleaner, because the mapping table stays one line per category and the lookup formula still works.
Maintenance habit
- Review the mapping table at the start of each financial year, April.
- Add a mapping row the day you create a new category.
- Keep a dated copy of the table with each export.
- Record who approved the mapping, and when.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

