Bank statements

Failed transactions in a wallet export when you send money home

For NRIs whose wallet or transfer exports mix failed attempts, refunds and two currencies, here is how to total only completed transfers and spot rate differences.

Editorial illustration for Failed transactions in a wallet export when you send money home

When you send money home or pay Indian bills from abroad, the export from your wallet or transfer service can show failed attempts, returned money and two currencies in one list. To keep your totals honest, count only completed transfers, record each refund separately, and note the rate on every line so differences do not slip by.

What makes NRI exports trickier?

Each row can carry an amount in the currency you paid and an amount in rupees. A failed transfer may be retried, and a returned amount may come back in a different figure from what left. If you add all rows regardless of status, you double count the retry and miss the difference on the return.

Columns worth having

  • Date
  • Status, such as completed, failed or returned
  • Amount sent in your currency
  • Amount received in ₹
  • Rate used, which you can calculate as rupees divided by amount sent

A hypothetical example

Say you try to send 300 units of your currency to a parent in India at a rate of ₹84, which would be 300 x 84 = ₹25,200. The transfer fails and the money returns to you. You try again the next day and it completes at ₹83.50, which is 300 x 83.50 = ₹25,050. These rates are invented to show the arithmetic.

DateStatusAmount sentRupees received
10 JanFailed30025,200
11 JanCompleted30025,050

Counting both rows would show 600 sent and ₹50,250 received, which never happened. Counting only the completed row shows 300 sent and ₹25,050 received. The difference between the failed attempt's quoted figure and the real one, 25,200 - 25,050 = ₹150, is a rate difference, not a loss to hunt down.

Formulas that do the work

With status in B, amount sent in C and rupees in D:

  1. Total sent: =SUMIFS($C$2:$C$300,$B$2:$B$300,"Completed")
  2. Total received in rupees: =SUMIFS($D$2:$D$300,$B$2:$B$300,"Completed")
  3. Average rate: the second result divided by the first

Where do bank charges fit?

Your own bank or the service may charge a fee for sending, but we cannot tell you what it is or whether it exists in your case. Look for a fee line on your statement or in the export, and record it as its own row so the transfer amount stays clean.

Keeping Indian and foreign records together

If you also track spending on an Indian card or account, SpendixAI lets each expense carry its own currency with totals in a base currency, using the rate saved with each transaction. You choose the base currency before importing, and it cannot be changed once transactions exist. It reads statements uploaded as PDF, CSV or Excel and shows rows for review before saving, so you can drop failed rows yourself.

What should I tell a family member on the Indian side?

Keep it simple. Share the date, the rupee amount that arrived and the reason, and keep the rate and your own currency amount in your sheet. A failed attempt on your side does not need explaining to a parent unless the money was expected by a certain day. If it was, tell them promptly that the first attempt did not go through and that you have started again, and that way nobody is left wondering about a missing deposit. Record the message date in a Notes column if you want a trail.

Over a year, a column of rates tells you something your memory never will: how far apart your best and worst transfers were, in rupees, for the same amount sent.

Checklist

  • Only completed rows in totals
  • Each failed attempt and its retry visible as separate lines
  • Rate worked out for every completed transfer
  • Returned money recorded as a return
SPENDIXAI JOURNAL

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

Explore your reports