Merging two card statements is mostly a matter of choosing one row layout and treating money moved between your own cards as a transfer, not as spending. This guide uses euros and a month-long rail trip as the example, with invented numbers, so you can follow the arithmetic and copy the layout.
Pick one row layout before you copy anything
Decide the columns once: date, account, merchant, amount in euros, category, and a notes column for the place. Matching columns make the merge a paste job. If one statement has separate debit and credit columns and the other a single signed amount, convert both to signed amounts, with spending negative.
Why do the same euros appear twice?
When you load the travel card from the main account, the movement appears in both statements. Add them both and you report twice what you have. Mark both lines Transfer. The only exception is a fee charged for loading, which is a real cost and should be its own row.
A rail-trip example
Say you loaded €500 onto the travel card and paid a €2.50 loading fee. Over the trip, the rows below come from both statements.
| Item | Account | Amount | Category |
|---|---|---|---|
| Load to travel card | Main card | -€500.00 | Transfer |
| Load received | Travel card | +€500.00 | Transfer |
| Loading fee | Main card | -€2.50 | Fees |
| Rail pass top-up | Main card | -€189.00 | Transport |
| Hostel, five nights | Travel card | -€165.00 | Stay |
| Street food and cafés | Travel card | -€94.30 | Food |
| Museum entries | Travel card | -€41.00 | Activities |
Real spending is 2.50 + 189.00 + 165.00 + 94.30 + 41.00 = €491.80. The travel card spend is 165.00 + 94.30 + 41.00 = €300.30, so €500.00 - €300.30 = €199.70 should remain on the card.
What if the balance is off?
- Check both statements cover exactly the same dates.
- Look for charges that had not settled when you downloaded.
- Look for a security deposit or hold, which may come back later.
- Check for a refund that reversed one of your rows.
- Compare against the card's own balance screen, not memory.
Work down the list in that order; most gaps are a missing pending line.
Does currency need special care?
If you travelled across countries that use different currencies, a statement may show a local amount and a euro amount. Use the euro amount that left your account as the row value and keep the local figure in notes. That way your total matches the statement even if you cannot reproduce the exchange rate.
When a spreadsheet gets heavy
If you do this for every trip and for monthly life too, an expense tracker that imports each statement into a named account saves the copy-paste. SpendixAI works that way, though it is built around India and INR, so it suits readers tracking rupee spending, not euro accounts. For a euro trip, the sheet above is enough.
How do you keep merchant names consistent?
The same café can appear as its trading name on one statement and as a code string on another, such as the name followed by a store number. Pick one clean name and use it everywhere. A short alias list on a second sheet, with the raw text on the left and your clean name on the right, lets you fix repeats quickly and makes category totals honest. After the first trip, the list pays for itself because you rarely meet new names twice.
Before you file it away
- Transfers excluded from spending totals.
- Fees recorded as spending.
- Card balance reconciles to the cent.
- Sheet saved with the route and month in the name.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


