Getting started

Which exchange rate does a tracker use for a foreign expense?

Which exchange rate does a tracker use for a foreign expense? Each transaction keeps its saved rate, so past totals stay put. With a worked trip example.

Editorial illustration for Which exchange rate does a tracker use for a foreign expense?

In SpendixAI, each foreign-currency transaction keeps the rate saved with it, and totals in your base currency are worked out from that saved rate. So when today's exchange rate moves, the figures for last month's trip do not change. A spreadsheet that revalues every row with one live rate behaves differently, and the difference is worth understanding.

What does 'the rate saved with each transaction' mean?

When a foreign expense is recorded, the tracker stores the amount in its original currency along with the conversion rate to your base currency. The base-currency amount comes from those two numbers multiplied. The rate belongs to that transaction, and it is not looked up again each time you open a report.

That means two purchases of the same dollar amount on different days can show different rupee values, each reflecting the rate saved with it. Both are correct for their own transaction.

What does that look like on a trip?

Here is an invented example with round rates, only to show the arithmetic. Say on day one you pay 50 dollars for a meal and the saved rate is ₹80 to the dollar. On day nine you pay another 50 dollars and the saved rate is ₹82.

DayAmountSaved rateBase-currency amount
Day 150 dollars₹80₹4,000
Day 950 dollars₹82₹4,100
Total100 dollarsTwo different rates₹8,100

The trip total is ₹8,100. If the rate then moves to ₹85 next month, the total stays ₹8,100, because each transaction carries its own saved rate. The number you saw on the day is the number you will see in a year, which suits record keeping.

Why not use today's rate for everything?

A spreadsheet might look up one live rate and apply it to every foreign row. At ₹85, the same 100 dollars would show as ₹8,500, and last year's trip would shift every time the market moves. That is fine for a what-would-it-cost-today question, but bad for a history. Your totals for April would be different in October, and you could never reconcile them with a statement.

Does the rate match my card statement?

Not necessarily to the last paisa. A card statement shows the rupee amount actually debited, and that includes the rate the card issuer applied and any fees or markup. A tracker's saved rate may be an approximation if it was set automatically. For reconciliation, compare the rupee figure on the statement with the rupee figure in the tracker, and if they differ, check what rate was saved on that transaction. How a card issuer converts, and what it charges, is something to check on your own statement.

What should I check on a foreign transaction?

  1. The original amount and currency are right.
  2. A conversion rate is saved with it, and it looks sensible for the date.
  3. The base-currency amount equals the original amount times the rate.
  4. The total agrees with the debit on your statement, where there is one.
  5. Cash spent abroad has the local currency and a rate that you note.

For your CA, the saved rate is a record of what was entered at the time. If they ask for rates from a particular source, such as the figures on a bank advice, ask what they would like you to hold, and keep those documents with the transactions they relate to.

When does the saved-rate approach not suit me?

If you want to see what your past foreign spending would cost at today's rates, a saved-rate tracker will not answer that, and you would do the sum separately. For most people, a stable history is more useful than a shifting one. Keep the original currency amounts visible, and you can always recompute for any rate you like.

SPENDIXAI JOURNAL

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

Explore your reports