The question: my CA asked for expenses in a Tally-friendly format and I sent screenshots. What should I send instead? Send one tidy file with a date, a narration, an amount and the ledger name your CA uses, not pictures. SpendixAI has an export centre with a Tally template, which turns reviewed transactions into a file for your CA to work with.
Why do screenshots cause trouble?
A CA cannot sort, filter or total a picture. Someone has to type each line again, which costs time and invites typos, and that time often turns into a fee or a delay. A file with consistent columns can be loaded or checked in minutes.
What should you sort out before exporting?
- Ask your CA for their ledger names. If they call fuel Motor Car Expenses and you call it Petrol, you will need a mapping.
- Group your transactions into categories that match those ledgers as closely as you can.
- Review the month's rows. Fix wrong categories, remove duplicate imports and add cash expenses you missed.
- Decide whether payments between your own accounts should be left out of the file. Ask your CA.
- Pick the date range the CA wants, usually a month, a quarter or the full April to March year.
What does a tidy list look like?
Take five made-up lines mapped to ledgers.
| Date | Narration | Ledger | Amount |
|---|---|---|---|
| 03-Oct | Office broadband | Telephone and Internet | ₹1,180 |
| 08-Oct | Courier to client | Postage and Courier | ₹340 |
| 12-Oct | Laptop repair | Repairs and Maintenance | ₹4,500 |
| 19-Oct | Client lunch | Business Promotion | ₹2,260 |
| 27-Oct | Software subscription | Software Expenses | ₹1,999 |
The five lines add up to 1,180 + 340 + 4,500 + 2,260 + 1,999, which is ₹10,279. If the CA's own total of the same period differs, the gap points to a missing or duplicated line, and you know where to look.
How do you use the Tally template?
- Open the export centre in SpendixAI and choose the Tally template.
- Narrow it to the period your CA wants using whatever filters the screen offers.
- Download the file and open it once yourself to check the columns and totals.
- Send it to your CA and ask whether the ledger names need adjusting.
Categories in the app carry an accounting code, and you can set GST rate and ITC-eligible flags. Those are estimates for your own tracking, so your CA decides what goes into the books.
What if the CA wants a different layout?
Ask for a sample row from their own sheet. You can use the standard all-transactions file or the categories-and-tax-codes file instead, or use the report builder to filter and group, then download CSV. Small column changes in a spreadsheet are quicker than retyping.
How do you check the file before it reaches the CA?
- Sort by amount and read the five largest lines. A wrong decimal or an extra zero usually hides there.
- Filter by ledger and scan for entries sitting in a catch-all ledger.
- Check that refunds appear as credits and not as extra expenses.
- Compare the file's total with your own report for the same dates.
Ten minutes of this saves a round of emails with your CA. Tell them if you are unsure about any mapping, and ask them to confirm it once so it is the same every month.
Before you hit send
- Check the date range.
- Check the grand total against your own sense of the month.
- Look for blank ledgers.
- Keep a copy of what you sent.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
