To find your trip cost in rupees, take each payment's rupee amount from the statement that shows it, not the euro price at today's rate. Card statements usually show the rupee debit; forex card and cash purchases need the rate you got at the time. Add them in one sheet, euros in one column and rupees in the next.
Why does the euro price not tell you the rupee cost?
The rate changes daily, your card may convert on a later date than the swipe, and charges may be added on top. Look at your own statement, since banks differ and this article cannot tell you what yours charges. A hotel listed at 100 euros can leave your account at a different rupee figure on each card.
Where does each rupee figure come from?
- Credit or debit card: the rupee debit on the statement, plus any separate fee line
- Forex card: the rate on the date of the load or the transaction, as your card statement shows
- Cash exchanged: the rupees you handed over divided by the euros you got
- UPI abroad, if used: the rupee debit in your bank statement
How do you build the trip sheet?
- Make columns for date, what it was, euros, rupees paid and source.
- Fill euros from your photos of bills or booking emails.
- Fill rupees from statements once they arrive, which can take a few days.
- In the next column compute the rate actually paid: =D2/C2 for rupees divided by euros.
- Add a total row with =SUM() on each of the two columns, and one more cell dividing the rupee total by the euro total for an average rate.
A worked example with hypothetical numbers
| Item | Euros | Rupees paid | Rate paid |
|---|---|---|---|
| Hotel, 3 nights (card) | 450 | ₹41,850 | ₹93.00 |
| Train tickets (card) | 120 | ₹11,280 | ₹94.00 |
| Meals and shopping (forex card) | 300 | ₹28,200 | ₹94.00 |
| Cash spent | 80 | ₹7,600 | ₹95.00 |
| Total | 950 | ₹88,930 | ₹93.61 |
Check: 41,850 plus 11,280 plus 28,200 plus 7,600 is ₹88,930, and 88,930 divided by 950 is about ₹93.61 per euro. If you had assumed a flat ₹92 you would have said the trip cost ₹87,400 and been out by ₹1,530. The rates here are invented; use your own statement lines.
Which costs do people forget?
- A fee line posted on a different date from the main charge
- Visa, travel insurance and airport transfers paid in rupees before leaving
- The cash you did not spend and brought back, which should reduce the cost
- Refunds, such as a hotel deposit returned days later
What is a sensible way to share the cost with others?
If you travelled with friends and paid some bills for the group, keep your own share and the group's share in separate columns, and note who owes whom. Do not net them into the trip cost, or your total will be too high. Settle the amounts in rupees once the statements arrive, using the rate you actually paid, so that nobody is arguing about a rate nobody can find later.
How does an expense tracker store this?
SpendixAI lets each expense carry its own currency, and totals appear in your base currency using the rate saved with each transaction. The base currency has to be chosen before importing, and it cannot be changed once transactions exist. There is also a Foreign-currency spend report. Check the saved rate against your statement, because the rupee debit on your card statement is the final truth.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

