Business

Annual Expense Report for NRIs: Records to Prepare for India Tax Filing

For NRIs sending money home: how to prepare an annual expense and remittance report for India tax filing in a day, with currency and rupee totals.

Editorial illustration for Annual Expense Report for NRIs: Records to Prepare for India Tax Filing

An NRI's annual expense report should show three things side by side: what you sent to India with the rate and rupee amount, what was spent or earned inside India, and which papers support each. Prepare it in a day by working from your remittance records first, then India-side statements, and take the pack to a CA who understands your residential status.

Where an NRI's year gets messy

Money moves in two directions and two currencies. You send support to parents, pay an EMI on a flat in India, maybe receive rent from a tenant, and your India account may earn interest. Each of those lands in a different statement, and the foreign-side transfer records live in a different bank. Whether any of it affects your Indian filing depends on your residential status and current rules, so that decision belongs to a CA, not to this sheet.

The remittance table

Build one row per transfer: date, amount sent in your currency, rate used, rupees credited, and the purpose. Say you sent 1,200 units every month for twelve months at rates that averaged 81. The units sent are 1,200 times 12, which is 14,400, and the rupees credited come to roughly 14,400 times 81, or ₹11,66,400. Use real per-transfer rates in your sheet, since the average is only for illustration.

PurposeUnits sentApprox rupeesNote
Parents' monthly support14,40011,66,40012 transfers
Flat EMI top-up3,0002,43,000Quarterly
Property maintenance60048,600Annual

Check the arithmetic: 14,400 plus 3,000 plus 600 is 18,000 units, and 11,66,400 plus 2,43,000 plus 48,600 is ₹14,58,000, which is 18,000 times 81.

What should I collect from the India side?

  • Statements from your India accounts for April to March.
  • Rent received, with the tenant's name and dates.
  • Interest credited on savings or deposits.
  • Property tax, society maintenance and repair receipts.
  • The loan lender's statement for any home loan.

How do I keep rupee totals consistent?

Use the rate saved at the time of each transfer, not a single rate you look up now. Mixed rates are normal; one new rate applied to the whole year will not match what actually reached the account. If you track in a tool, check that each foreign expense carries its own rate and that the base currency was chosen before you began.

A one-day plan

  1. Morning: export the transfer history from your foreign-side account and list every remittance.
  2. Late morning: add India-side credits and debits from statements.
  3. Early afternoon: attach purpose and category to each row.
  4. Afternoon: total by purpose, in units and rupees.
  5. Evening: write a one-page note listing anything missing, and save the pack.

What if a transfer went through an intermediary?

Some remittances pass through a money-transfer service that adds a fee or a margin on the rate. Record the amount you paid out, the amount that arrived and the difference, so the fee is visible. If your statement does not show the rate, take it from the confirmation you received at the time of transfer, and keep that confirmation with the pack.

Using a tool for the rupee side

SpendixAI is built around India and INR. It imports bank and card statements as PDF, CSV or Excel, supports expenses in different currencies with totals in a base currency using the rate saved on each transaction, has a foreign-currency spend report, and lets you download CSV. It does not read SMS or connect to banks, and its tax figures are estimates to check with your CA.

A last tip: keep the pack tidy by financial year, and keep both a spreadsheet and the original statements, so every number can be traced to a source document.

SPENDIXAI JOURNAL

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

Explore your reports