Travel and vehicles

ATM withdrawals abroad: log fees, rates and cash used

Foreign ATM withdrawal tracking made simple: one row per withdrawal with the rupee debit, fee lines, effective rate and cash actually spent.

Editorial illustration for ATM withdrawals abroad: log fees, rates and cash used

To track foreign ATM withdrawals, give each withdrawal one row with the local amount you received, the rupee debit, every fee line linked to it and how much of that cash you spent. Two formulas then do the work: total rupees divided by local amount gives the effective rate, and the fee divided by the total gives the fee share. Seeing those two numbers for each withdrawal tells you whether many small withdrawals are costing you more than a few larger ones.

What goes in each row?

  • Date and place: the city or the machine's location, so you can find the slip.
  • Local amount received: what the machine actually handed out, in local currency.
  • Rupee debit: the line on your account or card statement for the withdrawal itself.
  • Fee lines: any separate lines for charges, which often show up on the statement on a different day. Add them to the same row.
  • Total rupees: debit plus fees.
  • Effective rate: total rupees divided by local amount.
  • Fee share: fees divided by total rupees.
  • Cash spent: how much of the withdrawal you actually used before the trip ended.

A worked example with two withdrawals

These figures are invented, with a flat fee of ₹300 on each withdrawal to keep the arithmetic clear. Your own fees may be structured differently, so check your statement and do not assume.

WithdrawalEuros receivedRupee debitFee linesTotal rupeesEffective rateFee share
First, day 120018,90030019,20096.01.6%
Second, day 41009,4503009,75097.53.1%

Check the arithmetic: 19,200 divided by 200 is 96. The fee share is 300 divided by 19,200, about 1.6 per cent. For the second row, 9,750 divided by 100 is 97.5, and 300 divided by 9,750 is about 3.1 per cent. The smaller withdrawal paid almost double the fee share, because the fee was the same size.

How do I find my average rate across all withdrawals?

Do not average the two effective rates. Add up the rupees and add up the euros, then divide: (19,200 + 9,750) divided by (200 + 100) is 28,950 divided by 300, which is ₹96.50 per euro. In a sheet with total rupees in column E and euros in column C, that is =SUM($E$2:$E$100)/SUM($C$2:$C$100). Averaging 96 and 97.5 gives 96.75, which is slightly off because the two withdrawals were different sizes.

How do I track the cash I spent?

Suppose you spent €280 of the €300 and came home with €20. Valued at the average rate, the cash spent cost 280 × 96.5 = ₹27,020, and the leftover is 20 × 96.5 = ₹1,930. Together they make ₹28,950, which matches the total of the two withdrawals. Log the spent part as trip spending in whatever categories it went to, and treat the leftover as cash on hand.

Should I withdraw less often, or more?

The log gives you the answer for your own card. If most of the cost sits in flat fees, fewer and larger withdrawals will look better in your rows. If a percentage fee dominates, size matters less. Against that, carrying a lot of cash has its own risk, so use the data to decide, not as the only factor. Rules and fees differ between banks and over time, so read your card's terms rather than trusting a rule of thumb.

Before you travel

  1. Ask your bank how foreign ATM withdrawals appear on the statement and when fee lines post.
  2. Set up the sheet with the columns above and a few sample rows.
  3. Keep ATM slips until the statement arrives, then match them.
  4. After the trip, review the fee share per withdrawal and write down what you would change.

Entering a handful of ATM rows by hand is quick in any tracker. In SpendixAI you can add several expenses at once and keep the withdrawal and its fee line against the same account, so the foreign cash stays next to the rest of your records.

SPENDIXAI JOURNAL

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

Explore your reports