Treat the main card and the travel card as two accounts feeding one ledger. Import or paste both, label each row with its account, mark movements between them as transfers, and total only what is left. The numbers here are Australian dollars and entirely invented, built around a two-week touring holiday.
Think in accounts, not in statements
A statement is just a view of an account. If you tell yourself you have two accounts, the logic becomes obvious: money moving from one to the other is not an expense, however it appears on the page. The travel card is a pot you filled from the main card.
A two-week touring example
Say you topped up the travel card with A$1,000 before leaving and A$300 later in the trip. Before sorting anything else, find those two lines on the main statement.
| Date | Account | Item | Amount (A$) | Tag |
|---|---|---|---|---|
| Day 1 | Main card | Top-up | 1,000.00 | Transfer |
| Day 2 | Travel card | Camper park fees | 96.00 | Stay |
| Day 4 | Travel card | Groceries | 187.45 | Food |
| Day 6 | Main card | Top-up | 300.00 | Transfer |
| Day 7 | Travel card | Fuel | 142.80 | Transport |
| Day 9 | Travel card | Reef tour | 410.00 | Activities |
| Day 12 | Main card | Vehicle service | 220.00 | Transport |
Spending: 96.00 + 187.45 + 142.80 + 410.00 + 220.00 = A$1,056.25. Travel card spend is 96.00 + 187.45 + 142.80 + 410.00 = A$836.25. Loads were 1,000 + 300 = A$1,300, so A$463.75 should remain.
Why do totals sometimes look too high?
- Top-ups were counted as spending.
- A refund was listed as a new purchase instead of a negative.
- The same charge appears as pending on one download and posted on another.
- Statements were merged with overlapping dates.
Search your sheet for each of these in turn. The last one is easy to miss if you paste a fortnight from one card and a month from the other.
Can you do it without a spreadsheet?
Yes, with pen and a notebook for a short trip, but the sheet pays off when you want to filter by category. A formula such as =SUMIFS($D$2:$D$200, $E$2:$E$200, "Food") adds up one category, where column D holds amounts and column E holds the tag. Keep transfers tagged Transfer so they never match a spending category.
When a tool is worth it
If you reconcile cards every month, an app that imports one statement per account saves effort. SpendixAI does that for rupee accounts and is built around India and INR, so for an Australian trip use the sheet. Rows imported there are reviewed before saving, a habit worth copying by hand.
What does the merged list tell you?
Once totals are clean, ask two questions. First, the daily rate: A$1,056.25 over 14 days is about A$75.45 a day. Second, where the money went: the A$410.00 reef tour is roughly 38.8 percent of the spend, so one booking shaped the whole trip. Neither number is a benchmark; both are yours, which is what makes them useful for planning the next trip.
Write both numbers at the top of the sheet along with the dates, the card names and the opening loads. A year later, when you plan another trip or a relative asks what the holiday cost, you will find the answer in one glance rather than rebuilding it from two old statements.
Wrap-up list
- Find every top-up on the main card first.
- Tag transfers and refunds.
- Total spending by category.
- Reconcile the travel card to its balance.
- Save the sheet with the route and year.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


