Expense categories

Mapping expense categories to Tally ledgers: a worksheet for your CA

A salaried person handing expense data to a CA can map each category to a ledger name and accounting code in one worksheet. Here is a simple method.

Editorial illustration for Mapping expense categories to Tally ledgers: a worksheet for your CA

To give your CA data that goes into Tally without rework, make one small worksheet with three columns: your category, the ledger name your CA uses, and an accounting code. Fill it in once, ask your CA to correct it, and then every export carries the same labels.

Why would a salaried person need this?

Most salaried people never touch accounting software, but a CA preparing a return, or a household that also has rental income or a side project, may want expenses in the books' own language. Your categories say Dining and Commute. Their ledgers say things like Travelling Expenses or Staff Welfare. Without a map, the CA retypes it.

What are the three columns?

  • Category: the word you use in your tracker
  • Ledger: the exact ledger name the CA wants, spelled their way
  • Code: a short accounting code used on the export

Do not invent ledger names. Ask the CA for their list, or for a sample export from last year. Rules and treatments differ by person, so confirm the current position with your CA.

A sample worksheet with made-up codes

CategoryLedger name (ask CA)Code (example)
Rent paidRent4010
Electricity and gasUtilities4020
Commute and fuelConveyance4030
MedicalMedical Expenses4040
DonationsDonations4050
Insurance premiumsInsurance4060

The codes above are examples only. The pattern is worth copying: leave gaps of ten so you can add a new code between two others without renumbering.

How do I check the map is complete?

Export a month of transactions and count the rows whose category has no ledger. Say a month has 118 transactions and 14 are in categories you did not map. That is about 12 percent unmapped. Fix those categories first, since they are what the CA will otherwise ask you about.

How does SpendixAI help?

In SpendixAI, a category can hold an accounting code, and the Export centre has templates for Tally, Zoho Books and QuickBooks plus a categories-and-tax-codes file, so the codes travel with your data. Check one export against your CA's sample before you send a full year. It is not a filing tool, and the GST figures in reports are estimates to be checked against invoices.

If your household has few categories, you may not need more than a dozen codes. The goal is not completeness but that every row has an obvious home. A salaried person who also earns a little rent from a spare room might add two or three income codes and a repairs code. Keep the rest of life under one personal code.

Also agree on the period. Financial years run April to March, so if your CA wants a full year, export from the first of April to the end of March in one go, and keep monthly exports as working copies. Mixing calendar and financial years is a common cause of mismatched totals. Keep a one-line definition beside each code, such as Conveyance meaning local travel for work or commute, so that a new category you add next year goes into the right place and the map does not drift. Review the sheet once a year when the new financial year starts. Keep a one-line definition beside each code, such as Conveyance meaning local travel for work or commute, so that a new category you add next year goes into the right place and the map does not drift.

What should I send, and when?

  1. Share the worksheet with your CA and ask for corrections.
  2. Update the categories to match the corrected names.
  3. Export one month and let the CA test it.
  4. Fix gaps and mismatches.
  5. Export the full period after the CA is happy.
  6. Keep your receipts and invoices with the transactions.
SPENDIXAI JOURNAL

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

Explore your reports