Exporting expenses to Tally goes smoothly when the work is done before the export: agree the ledger names with your accountant, clean the dates and amounts, and test three entries. Tally Prime is usually described as dominant Indian accounting software for Windows desktops, so your accountant's setup, not the expense tool, decides which ledgers exist.
What do you need to settle before exporting?
- Which ledger each of your categories should post to, in your accountant's chart.
- Which bank or cash ledger the money came out of.
- Whether entries go in as payments, journals or something else; that is your accountant's call.
- The date range, and whether earlier periods are already closed.
- How GST on purchases should be shown; treat any tracker's GST figure as an estimate.
How do you prepare the mapping?
| Your category | Ledger your accountant uses | Bank or cash ledger |
|---|---|---|
| Groceries for office | Staff welfare | Current account |
| Courier | Freight and postage | Current account |
| Fuel | Vehicle running | Cash |
| Internet | Telephone and internet | Current account |
| Printing | Printing and stationery | Current account |
The left column is yours; the middle column must match the accountant's spelling exactly. A ledger called Printing & Stationery and one called Printing and Stationery are two different things to the software.
What steps keep the export clean?
- Ask your accountant for the ledger list, or a screenshot of it.
- Rename or map your categories to those names before exporting.
- Remove personal transactions and transfers between your own accounts from the export.
- Check each line has a date, an amount and a narration.
- Export a three-entry test first and give it to your accountant, or import it into a test company.
- Only when it posts correctly, export the full period.
What does the test check look like in numbers?
Say the three test lines are courier ₹640, internet ₹1,180 and printing ₹2,350. The total of the export is ₹640 + ₹1,180 + ₹2,350 = ₹4,170. After import, the expense ledgers together should show ₹4,170 and the bank or cash ledger should have gone down by ₹4,170. If the bank ledger moved by a different figure, an entry went to the wrong side or the wrong ledger.
What does SpendixAI offer?
SpendixAI's Export centre has a template for Tally alongside Zoho Books, QuickBooks, a standard all-transactions file and a categories-and-tax-codes file. Categories can carry an accounting code, which helps with mapping. It does not file GST or compute tax, and the template's fit with your company setup is for your accountant to confirm.
What if your categories and ledgers do not line up one to one?
That is common. You might track Fuel and Parking separately, while your accountant keeps one ledger called Vehicle running. Map several of your categories to one ledger and keep your finer detail in the narration. The reverse, one of your categories needing two ledgers, is harder: split it in your tracker first. For example, split Office supplies into Stationery and Pantry if the accountant keeps them apart. Settle this once at the start of the year and note the mapping in writing.
Keep a one-page note of what you exported: date range, number of entries, total, and the date you gave it to your accountant. When a figure in the books is questioned months later, that note, with the original export file, tells you quickly whether the question is about your data or about how it was posted.
Monthly handoff checklist
- Categories mapped to agreed ledger names.
- Personal and transfer lines removed.
- Totals compared before and after.
- Export file kept alongside the source statements.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
