Add your euro spending day by day, then convert each day's total into rupees at the rate for that day and add the results. If the rate barely moved during the trip, a single rate gives almost the same answer, but writing the day-by-day version once shows you how large the difference could be.
The example is a three-day business and family trip counted in euros, with invented rates. They are not market rates.
When is one rate enough?
For a weekend trip, one rate from the middle of the trip is usually close enough. For a month, the rate may drift, and then a weekly rate is a fair compromise. The more money you spend early or late in the trip, the more the choice matters.
How do you build the day table?
- List each date in column A.
- Put the day's euro total in column B.
- Put the rupees-per-euro rate for that day in column C.
- In column D, enter =B2*C2 and copy it down.
- Under the last row add =SUM(B2:B4) for euros and =SUM(D2:D4) for rupees.
These formulas work the same in Excel and Google Sheets. Replace the row numbers to suit your list.
What does it look like with numbers?
| Day | Euros spent | Rupees per euro | Rupees |
|---|---|---|---|
| Day 1 | 120 | 95 | 11,400 |
| Day 2 | 85 | 96 | 8,160 |
| Day 3 | 200 | 94 | 18,800 |
| Total | 405 | - | 38,360 |
The rupee total is 11,400 plus 8,160 plus 18,800, which is 38,360. Dividing by 405 euros gives an average of about 94.72 rupees per euro. If you had used 96 for every day, the total would be 405 times 96, or 38,880, which is 520 rupees higher.
Which rate source should you pick?
Choose one published daily rate, from a source you can name, and use it throughout. Your bank's own rate on a card or transfer will differ from a published mid-market figure, and that difference is part of what the trip cost you. If you transferred rupees abroad, or your family back home paid in rupees, use the rupee amounts that actually moved.
Why does a rupee figure matter at all?
It lets you compare this trip with spending you track in rupees, or explain to someone at home what you spent without asking them to do arithmetic. It does not change what you paid in euros. Treat it as a translation, and label it as such.
What if you spent in several currencies?
If part of the trip was in euros and part in another currency, keep a separate euro-style table for each and combine the rupee totals only at the end. It is tempting to convert everything into euros first, but that adds a second conversion and a second rate to defend. Two clean tables and one grand total are easier to check against your receipts.
Can a spreadsheet fetch the rates for you?
Google Sheets has a currency function that can pull a rate on request, and Excel has a currency data type in some versions. Both give a rate as of the time you open the file, not as of your trip, so values may change each time. For a travel record, it is safer to paste the rate you used as a plain number on each row and leave it alone. A record that changes every morning cannot be reconciled.
Final check
- Each day's euro total matches the receipts or statement lines.
- The rate column is filled for every date.
- Rupee total equals the sum of the rows, not a separate calculation.
- Any big refund is a negative row on the date it arrived.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


