To find what a trip cost, pick a date window that starts a few days before you left and ends a few days after you returned, pull every card and UPI row inside it, then add the cash you spent. Do the sum per category, not as one big number, so you can see where the money went and whether any of it was a work cost you should record separately.
What is the date window, and why include the extra days?
Trip spending begins earlier and ends later than the journey. A cab to the airport, a luggage purchase or a hotel advance may land two or three days before departure, and a card charge for the hotel often posts after you are home. Say you left on 12 March and returned on 19 March. Take 9 March to 25 March, then remove rows that clearly do not belong, such as your regular rent or EMI.
Hotel and flight charges are sometimes made weeks earlier at booking. Search the statement by the name of the hotel, airline or booking site, not only by date.
Where do you find all the rows?
- Credit card statements for the month of the trip and the month after, because charges post late.
- The bank account statement for UPI, NEFT and debit card spends in the same window.
- Any wallet or prepaid card you used, if it keeps its own statement.
- Your memory for cash: ATM withdrawals on the trip are a clue, and a withdrawal of ₹5,000 with ₹1,200 left over means ₹3,800 was spent.
Look at your own statement to see how each foreign charge is shown. Some show the original currency and some show only the rupee amount, and the layout differs from one card to another.
How do you add the numbers? A worked example
Say a gig worker, who drives for a ride platform and does delivery shifts, takes a family trip. All figures are made up.
| Line | Source | Amount (₹) |
|---|---|---|
| Train tickets | Card | 3,600 |
| Hotel, 4 nights | Card | 9,200 |
| Food and snacks | UPI and card | 6,150 |
| Local cabs | UPI | 2,400 |
| Entry tickets | Card | 1,800 |
| Cash spends | ATM leftover | 3,800 |
Total: 3,600 plus 9,200 plus 6,150 plus 2,400 plus 1,800 plus 3,800 equals ₹26,950. Divided across 8 days that is about ₹3,369 a day, which is more useful for planning the next trip than the total alone.
What about income lost and work costs?
A gig worker's trip also costs the shifts you did not take. That is not an expense on any statement, so keep it as a separate note rather than mixing it into the ₹26,950. If you carried work equipment or topped up a phone plan for work, mark those rows as work costs and leave them out of the holiday total. Rules about what can be treated as a business cost are for your CA to decide, so just keep the records clean.
Can a tool do the grouping for you?
If you already import statements, SpendixAI can take the card statement as a PDF, CSV or Excel file, let you review rows before saving and keep each transaction against its account. Cash spends can be added by hand, several at once, and the Report builder can filter and group the rows. It does not read SMS or connect to your bank, so the statement upload is the starting point.
What should you keep after you finish?
- The total, the per-day figure and the category split.
- A one-line note on anything that surprised you, such as a hotel deposit or foreign fees.
- The statement files, saved by month, in case a charge is disputed.
- A rough budget line for the next trip, built from this one.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

