Open the card statements that cover the trip, pick the first and last day that belong to it, tag every row inside that window and add the tags up. That gives you a trip total you can trust far more than a memory of "about two thousand". The method takes under an hour, even for a two-week holiday, and you only need to do it once per trip.
Where does the trip start and end for the money?
The trip starts earlier than the flight. Plane tickets, a hotel deposit and travel insurance were probably paid weeks before you left. It also ends later than the landing: some merchants post charges days afterwards, and a refund may arrive after you are home. Set a window from the date of the first booking to about two weeks after you return, then decide for each row whether it belongs to the trip.
How do I tag the rows?
- Download every statement covering the window from each card and bank account you used.
- Paste the rows into one sheet: Date in A, Description in B, Amount in C, Category in D, Trip in E.
- Type the word Trip in column E for each row that belongs, or leave it blank.
- Give each tagged row a category such as Flights, Lodging, Local transport, Food, Activities or Gifts.
- Add up with =SUMIFS($C$2:$C$300,$E$2:$E$300,"Trip").
If the window is clean, with nothing else bought in those days, you can total by dates instead. Put the start date in H1 and the end date in H2, then use =SUMIFS($C$2:$C$300,$A$2:$A$300,">="&$H$1,$A$2:$A$300,"<="&$H$2). Dates must be real dates, not text, or the comparison will quietly return zero.
What does a finished trip look like?
| Category | Amount |
|---|---|
| Flights | $612.40 |
| Lodging | $894.00 |
| Local transport | $143.25 |
| Food and drink | $418.60 |
| Activities | $186.00 |
| Gifts and shopping | $127.50 |
| Trip total | $2,381.75 |
Those figures are made up, but the arithmetic is the real part: 612.40 plus 894.00 plus 143.25 plus 418.60 plus 186.00 plus 127.50 is 2,381.75. Over six days that is about $396.96 a day, which you get by dividing the total by the number of days. Use =C9/6 or whatever cell holds the total.
How do I treat purchases made abroad?
Card statements usually show each foreign purchase in your own currency, sometimes with a separate note of the original amount. Use the amount your statement shows, since that is what actually left your account. If a fee appears as its own row, tag it as part of the trip too, and give it its own category so you can see it. Do not try to convert anything by hand with a rate you looked up later, as it will not match what the bank charged.
What should I do with the number?
- Compare it with what you thought it cost. The gap is useful to know before you plan the next one.
- Divide by days and by people to get a daily and per-person cost.
- Look at the biggest category. If lodging is over a third of the trip, that is where a different booking would matter most.
- Keep the sheet. Next time you plan, you start from a real column of figures, not a guess.
Quick checklist
- Window set from the first booking to two weeks after your return.
- Every card and account used is included.
- Late postings and refunds added.
- Own-account transfers and card repayments left out.
- Total divided by days, and by people if you want that view.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


