Treat each way of paying as its own lot: work out how many Australian dollars it cost for the euros it delivered, add the lots, and only then convert the total to rupees. That keeps three different effective rates from blurring together.
The numbers are made up, as is the rupee rate. Use your own statements.
Why separate the payment methods?
Card payments are converted by the card issuer when you pay. Cash is converted when you buy it, perhaps weeks earlier. A prepaid travel card is loaded in one go and spent over time. Each can have a different cost per euro, so mixing them in one pile hides which method was cheaper for you.
What does the table look like?
| Method | Euros spent | Cost (A$) | A$ per euro |
|---|---|---|---|
| Credit card | 520 | 845.00 | 1.625 |
| Cash | 200 | 318.00 | 1.59 |
| Prepaid travel card | 330 | 528.00 | 1.60 |
| Total | 1,050 | 1,691.00 | about 1.61 |
The costs add up to 845 plus 318 plus 528, or 1,691 Australian dollars. Dividing by 1,050 euros gives 1.6105.
How do you cost each lot?
- Card: use the amount billed on the statement for each euro payment.
- Cash: divide the Australian dollars paid for the euros by the euros received, then multiply by the euros you actually spent.
- Prepaid card: divide the Australian dollars loaded by the euros it was worth when you spent, or use the statement lines if it lists them.
What is the rupee figure?
Choose one rupees-per-Australian-dollar rate and state it. Say 55 for this illustration. Then 1,691 times 55 is 93,005 rupees. By method, the card part is 845 times 55, or 46,475; the cash part is 318 times 55, or 17,490; and the travel card part is 528 times 55, or 29,040. Those three add to 93,005.
What about leftover balances?
Unspent cash and any money still on the travel card are not trip cost. Subtract them. If you are likely to take them on the next trip, write down their value at what you paid, so the next trip's cost is not understated.
Which method came out cheapest?
In this invented example the cash lot cost 1.59 per euro against 1.625 on the card, a difference of 0.035 per euro. On 200 euros that is 7 dollars. Interesting, but small. Do not drive your whole plan from a few dollars; use it as one input when you decide how to pay next time.
What if the prepaid card does not itemise?
Some cards show only a balance and the individual payments in euros. In that case, take the Australian dollars loaded, subtract any amount still on the card when you got home, and treat the difference as the cost of the euros spent through it. Divide by the euros spent to get your effective rate. It will be an estimate rather than a statement fact, so mark it as one.
How early should you reconcile?
Do it within a week of getting home. Card statements close on set dates, so some euro purchases will land on the next statement, and prepaid card histories are sometimes available for a limited time. Waiting a few months means chasing missing lines. Spend half an hour checking each method's balance against its own record, then finish the rupee conversion afterwards, not before. The conversion is the easy step; the reconciliation is the one that protects the figure.
Before you close the file
- Reconcile each method's total with its own statement.
- Subtract unspent balances.
- Convert the combined Australian dollar total to rupees once.
- Save the method column so you can compare next trip.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

