Travel and vehicles

Typed the exchange rate wrong on an expense? How to stop it

Typing an exchange rate by hand for every foreign expense goes wrong in a few predictable ways. Here are five steps to catch and stop the errors.

Editorial illustration for Typed the exchange rate wrong on an expense? How to stop it

The question: I add foreign-currency expenses and type the exchange rate myself each time, and my monthly total never matches my card statement. How do I stop making mistakes?

Short answer: the errors nearly always come from flipped digits, a rate typed in the wrong direction, or a rate pulled from memory instead of from a document. The cure is to treat the rupee amount on your statement as the truth, work the rate backwards from it, and sanity-check every typed rate against the one before. It costs about a minute per entry.

Where the mistakes really come from

  • Flipped or dropped digits: 65.20 becomes 56.20 or 6.52, and nothing on screen looks wrong.
  • Wrong direction: typing how many Singapore dollars one rupee buys (about 0.0153) when the box wants rupees per Singapore dollar (65.20).
  • A rate from memory or from a search made at some other hour, while your card posted the charge at its own rate.
  • One rate pasted down a whole trip, so day-one and day-nine purchases are treated alike.

What we would do, step by step

  1. Keep the foreign amount exactly as printed on the receipt or card alert, with the currency code next to it.
  2. When the statement posts the rupee figure, divide it by the foreign amount. That result is your real rate for that charge, so type that and nothing else.
  3. Until the statement posts, mark the entry as provisional and use the rate shown on the card alert, not a search result.
  4. Compare each new rate with the previous entry for the same currency. If it differs by more than a few percent with no obvious reason, stop and re-read what you typed.
  5. On the first of every month, put your recorded rupee total for foreign spends next to the card statement total and chase any gap.

A worked example with made-up numbers

Say you paid SGD 120 for a dinner and the statement later shows ₹7,824 posted. ₹7,824 divided by 120 is 65.20, so that is the rate. If your fingers typed 56.20, the sheet records 120 x 56.20 = ₹6,744, which is ₹1,080 short for one meal.

EntryForeign amountRate typedRupees recordedStatement showsGap
DinnerSGD 12056.206,744.007,8241,080.00 short
TaxiSGD 1865.201,173.601,1751.40 short
MuseumSGD 4565.202,934.002,9362.00 short
Total--10,851.6011,9351,083.40 short

Notice that the two small gaps are rounding, which is normal, while the big one is a typing slip. That difference in size is how you spot it.

How do I know a typed rate is sensible?

Divide the rupees you recorded by the foreign amount and see whether you get back the rate you meant. Then look at the sequence: rates for one currency in one week should sit close together. A single outlier is almost always a typo. A steady drift across weeks is just the currency moving, and that is fine.

What if the statement has not posted yet?

Card charges abroad can take a few days to appear. Record the entry now with the alert figure, add the word provisional in the note, and fix it when the real rupee amount shows. Nobody needs your card details or any code for this; everything you need is already on your own statement.

Where SpendixAI fits, and the honest limit

In SpendixAI each expense can carry its own currency, and totals are shown in a base currency using the rate saved with each transaction. That means a wrongly saved rate flows straight into your totals, so the checking above still matters. Choose the base currency before importing anything, because it cannot be changed once transactions exist.

Month-end checklist

  • Every foreign entry has the currency code, the original amount and a rate.
  • Rates for the same currency look consistent week to week.
  • Recorded rupee total is within a few rupees of the card statement total per charge.
  • Provisional entries have been replaced with statement figures.
SPENDIXAI JOURNAL

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

Explore your reports