To compare remittance fees from your own history, log every transfer with the amount sent, the fee, the exchange rate you were given and the rupees that arrived, then add a reference rate for the same day. The effective cost is the gap between what a reference rate would have given and what you actually received, plus the fee. Ranking your transfers by that number shows which channel was truly cheapest.
What should I log for each transfer?
- Date and channel used, such as a bank transfer, an app or a money transfer service
- Amount sent in the foreign currency
- Fee charged, and whether it was on top of the amount or inside it
- Exchange rate you were offered
- Rupees that reached the receiver
- A reference rate for that day, noted from any source you trust at the time
The reference rate is the missing piece for most people. Pick one source, for example the rate shown on a currency site or from your own bank's published rate, and use it consistently. You are not looking for a perfect number; you want a steady yardstick across transfers.
What does the arithmetic look like?
Say you send 1,000 units of the foreign currency each time. Both transfers happen on a day when the reference rate is 84.00 rupees per unit (a made-up figure), so the value at the reference rate is 1,000 × 84 = ₹84,000.
| Item | Channel A | Channel B |
|---|---|---|
| Amount sent | 1,000 | 1,000 |
| Fee paid on top | 5 units | 0 |
| Rate given | 83.20 | 82.60 |
| Rupees received | ₹83,200 | ₹82,600 |
| Shortfall against the reference | ₹84,000 − ₹83,200 = ₹800 | ₹84,000 − ₹82,600 = ₹1,400 |
| Fee in rupees at the reference rate | 5 × 84 = ₹420 | ₹0 |
| Total effective cost | ₹800 + ₹420 = ₹1,220 | ₹1,400 |
| Cost as a share of ₹84,000 | 1.45% | 1.67% |
Channel B shows no fee, but the weaker rate costs more: ₹1,400 against ₹1,220. This is why a zero-fee label does not settle the question. Check the percentages: ₹1,220 ÷ ₹84,000 is about 1.45%, and ₹1,400 ÷ ₹84,000 is about 1.67%.
What if the fee is inside the amount?
Then the amount that gets converted is smaller. If you pay 1,000 and a fee of 5 is taken from it, only 995 is converted. Rupees received would be 995 × the rate given, and the reference value is still on the 1,000 you paid. The shortfall then includes the fee automatically, so skip the separate fee line.
How do I set this up in a spreadsheet?
Use columns A to I: Date, Channel, Sent, Fee on top, Rate given, Rupees received, Reference rate, Effective cost in rupees, Cost as a share. In H2, with the fee on top, the formula is =(C2*G2)-F2+(D2*G2), which is reference value minus rupees received plus the fee at the reference rate. In I2 the share is =H2/(C2*G2). Fill both down. Then sort by that last column, or use AVERAGEIFS by channel, with channels in B2:B200 and costs in I2:I200: =AVERAGEIFS($I$2:$I$200,$B$2:$B$200,"Channel A").
Where do multi-currency records help?
If you keep records in SpendixAI, each expense can carry its own currency, and totals are shown in your base currency using the rate saved with the transaction. You choose the base currency before importing, and it cannot be changed once transactions exist, so decide it first. It does not replace the rate comparison above, but it gives you an organised list of the amounts to compare.
Before your next transfer
- Note the reference rate before you start.
- Ask the channel for the fee and the rate it will give, in writing or on screen.
- Work out the effective cost with the table above.
- Log the rupees actually received once they arrive.
- After three transfers, compare channels by effective cost.
Rules on sending money across borders, limits and taxes change and depend on your situation, so confirm them with your bank or CA.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


