A shopping log abroad needs seven columns: item, shop, local price, rupee cost, who it is for, how you paid and a receipt photo. It answers two questions you will have later: how much of the trip budget went to shopping, and where is the receipt if something needs returning. Five minutes at the end of each shopping stop is enough to keep it accurate.
Which columns should the log have?
- Item and shop: enough to recognise it later, such as scarf, market near the old town.
- Local price and currency: as printed on the tag or receipt.
- Rupee cost: from the card statement or alert if paid by card, or the cash rate if paid in cash.
- For whom: yourself, or the gift recipient's name, so you can see gifts apart from your own buys.
- Paid by: card or cash, plus whether it was duty free.
- Receipt: a photo, filed the same day.
- Status: kept, returned, refunded or gifted.
A made-up shopping log
Say a trip budget is ₹1,20,000 and the euro cost about ₹93 on the days you shopped. These are invented numbers for the arithmetic.
| Item | For | Euros | Rupees | Paid by |
|---|---|---|---|---|
| Perfume (duty free) | Gift | 60 | 5,580 | Card |
| Chocolates | Gift | 35 | 3,255 | Card |
| Jacket | Self | 120 | 11,160 | Card |
| Scarf | Gift | 28 | 2,604 | Cash |
Total shopping is 5,580 + 3,255 + 11,160 + 2,604 = ₹22,599. Gifts add up to ₹11,439 and the jacket to ₹11,160, so the split is nearly even. Against a ₹1,20,000 budget, shopping took about 19 per cent (22,599 divided by 1,20,000 is 0.188).
How does the log help with returns?
A receipt photo, the local price and the date are the three things a shop assistant or your card issuer will ask for. If you buy something that might not fit, add a return deadline in the status column, such as return by 18 March. Remember that a refund on a foreign card purchase may come back as a different rupee amount, because the rate on the refund day is not the rate on the buying day.
What should I record for duty-free purchases?
Record the item, the price and currency, the airport and date, and keep the receipt and boarding pass photo together. Allowances and customs rules for what you may bring back change over time, so check the current rules on the official customs website before you travel, not from a forum post. Your log simply gives you the facts if you are ever asked.
What else belongs in the shopping total?
The sticker price is not the whole cost of bringing things home. If you had to pay for extra baggage, a bigger suitcase, bubble wrap or a courier to ship something, add those as rows too, with the item they relate to in the notes. If a shop offers a tax refund form, write it in the status column and ask the shop how it works, because the rules differ from place to place and the form may need a stamp before you leave. A jacket that cost ₹11,160 plus a ₹2,000 baggage fee really cost ₹13,160.
Should gifts count as shopping or as something else?
It depends on what you want to learn. If you want to know how much of the trip went to shopping, keep gifts inside shopping and use the For column to separate them. If you track gifts through the year, such as for festivals and weddings, give them their own category so the trip gift spends join the rest.
Where does a tracker fit in?
If you already keep records in SpendixAI, the receipt stays with its transaction and a custom category or sub-category such as Shopping and gifts keeps these buys together. For a one-off trip, the table above in a sheet is enough.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


