For an expense you have already paid, use the exchange rate from the day of the payment, or better, the amount your card was actually charged. Today's rate answers a different question: what would this cost me now. Mixing the two gives records that change every time you open them.
The example below is in US dollars with invented rates, and it explains method only.
Why does the rate on the day matter more than today's?
An expense is an event in the past. You paid a particular amount of your own currency for it. If you restate it at today's rate, the dollar amount drifts away from the amount that left your account, and your records no longer match your statement. A record that does not match the statement is hard to defend and hard to reconcile.
What does the difference look like?
| Measure | Rate (USD per euro) | Dollar amount |
|---|---|---|
| Paid on the day | 1.08 | 540.00 |
| Revalued a month later | 1.12 | 560.00 |
| Difference | - | 20.00 |
For a 500 euro hotel bill, 500 times 1.08 is 540 dollars, and 500 times 1.12 is 560 dollars. The 20 dollar difference is not extra spending; it is just a different moment's rate. Your statement will show about 540, and that is the figure to keep.
Which source is best for the rate?
- The amount charged on your card statement, divided by the foreign amount, if you have it.
- The rate on a payment receipt or transfer confirmation.
- A single published daily rate from a source you name, if the first two do not exist.
Ranking them this way keeps you close to what actually happened. A published rate is an approximation of what your card did, so it comes last.
What about expenses you have not paid yet?
For planning, such as a budget for next month's trip, use a recent rate and leave a margin, because the real conversion will happen later. When the payment finally posts, replace the estimate with the actual figure. Budget rows and actual rows should be labelled separately so they are not added together.
How do you keep the records tidy?
- One column for the original currency and amount.
- One column for the dollar amount.
- One column for the rate, calculated as dollars divided by the original amount.
- A note when a figure is an estimate.
If you use an app that records the rate on each transaction, as SpendixAI does, you get that last column automatically. It is built around India and INR, so this is an example of the method, not an offer for dollar users.
What if you are comparing prices across trips?
For comparing what a hotel cost in two different years, use the original currency. A 150 euro room is a 150 euro room, whatever the dollar did in between. Convert to dollars only when you want to see the effect on your own budget. Keeping both views side by side tells you whether a trip became dearer because prices rose or because the exchange rate moved against you. Those are different problems, and only the second is outside the seller's control.
One more habit helps: when you photograph a receipt abroad, include the card terminal screen if it shows both the local price and the dollar price. That single image can settle a question months later.
Quick test before you finalise
- Does every foreign row show its original amount?
- Does the dollar total match the card statement?
- Are estimates marked?
- Have you written the policy at the top of the file?
Useful ideas start with a clearer picture of your own spending.
Explore your reports


