Business

Export India Expenses to Tally Format as an NRI

An NRI whose Indian CA wants expenses in Tally format can prepare a clean INR list from card and bank statements instead of sending screenshots.

Editorial illustration for Export India Expenses to Tally Format as an NRI

If your CA in India asks for expenses in Tally format, send one INR list for the period: date, narration, category and amount, built from your Indian account statements and the bills your family sends. Screenshots from abroad, in odd time zones and several apps, are the slowest thing you can hand a CA. A structured export saves them a day.

What do NRIs usually need to list?

  • Costs of an Indian property you own: maintenance, repairs, society charges.
  • Money spent in India for family needs, if your CA has asked for it.
  • Costs linked to any income you earn in India, such as rent from a flat.

Which of those matter, and how they are treated, is a question for your CA. This article covers only how to hand the list over.

Why is a screenshot especially painful from abroad?

Time zones make questions slow. If a CA cannot read a line, a reply takes a day. Multiply that by dozens of rows and your filing waits on messaging. A list with a clear narration for every row cuts the number of questions.

A worked example for a rented-out flat

Say your Indian flat has a monthly rent of ₹25,000 and in one month you paid ₹2,400 society maintenance, ₹3,100 for a plumbing repair and ₹600 for a water-tank cleaning. The costs add to 2,400 + 3,100 + 600 = ₹6,100.

DateNarrationCategoryAmount in ₹
01-OctSociety maintenanceProperty upkeep2,400
12-OctPlumber, bathroom leakRepairs3,100
20-OctWater tank cleaningRepairs600

The narration is what your CA needs most. Write what the money was for, not just the payee's name.

How do you prepare the export?

  1. Choose INR as the base for these records, before you import anything.
  2. Upload the Indian account or card statements, selecting the right account each time.
  3. Review the rows and remove transfers between your own accounts.
  4. Apply the categories your CA uses.
  5. Export with the Tally template and send it with a note on period and accounts.

SpendixAI supports this flow: statements in PDF, CSV or Excel are reviewed before saving, each row keeps its account, and the export centre has a Tally template. The base currency cannot be changed once transactions exist, so choose it first. It does not connect to banks and does not read SMS.

What if some payments were in a foreign currency?

Each expense can carry its own currency, with totals in the base currency using the rate saved with that transaction. Ask your CA which rate they want for foreign-currency items, and note the source of the rate on the row.

How do you keep the CA's questions short?

Batch them. Instead of ten separate messages as each doubt arises, collect them in one list and send it with the file: the three rows you are unsure about, the bill you could not obtain, and the date range. A CA is far more likely to reply usefully to one organised message than a stream.

  • Number your questions so replies can match them.
  • Attach bill photos by row date.
  • State your time zone and the best time for a call.

If your CA has a portal or an email routine, follow it, and never send passwords, PINs or OTPs by chat or email in the course of this work.

Before you press send

  • Period matches what the CA asked for.
  • Totals match your statements.
  • Bills are attached or listed.
  • Questions for your CA are written down in one message.
SPENDIXAI JOURNAL

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

Explore your reports