Two cards, one holiday, and a spreadsheet that does not add up: that is the usual problem. Combine the statements into one list, label how the travel card was funded, and compare the end balance with what the card should hold. The numbers below are made up to show the method.
Start with how the travel card was funded
Before touching any rows, write down every time you moved money onto the travel card. Say a family of four loaded it twice: £400 before leaving and £250 midway through the week when it ran low. Those two loads total £650, and they are the only deposits you expect to find.
Which statements do you need?
- The travel card statement or transaction history for the holiday dates.
- The main card or current account statement for the same dates, because the loads and any direct spends are there.
- Any receipts for big items such as a hotel balance or hire car, in case a statement line is unclear.
A family week in worked numbers
Here is the combined list, sorted by date. The two loads are labelled Transfer and excluded from totals.
| Date | Account | Item | Amount | Type |
|---|---|---|---|---|
| Sat | Main card | Load travel card | £400.00 | Transfer |
| Sat | Travel card | Airport lunch | £38.60 | Food |
| Mon | Travel card | Boat trip, four tickets | £92.00 | Activities |
| Wed | Travel card | Groceries | £64.25 | Food |
| Wed | Main card | Load travel card | £250.00 | Transfer |
| Thu | Travel card | Restaurant | £118.40 | Food |
| Fri | Main card | Hire car fuel | £71.30 | Transport |
Food: £38.60 + £64.25 + £118.40 = £221.25. Activities: £92.00. Transport: £71.30. Total spending is £221.25 + £92.00 + £71.30 = £384.55.
How do you check you have not missed anything?
Add the travel card spends: £38.60 + £92.00 + £64.25 + £118.40 = £313.25. The card received £650.00 in loads, so £650.00 - £313.25 = £336.75 should be left. Look at the card's remaining balance. If it shows less, a charge is missing from your list, perhaps one that was still pending when you downloaded the statement.
What should you do with pending items and refunds?
- Wait until pending items settle before you finalise, or tick them as provisional.
- Match a refund to the original purchase and show it as a negative in the same category.
- Treat a deposit refunded after the trip as a separate row dated when it arrived.
- Do not delete anything; label it instead, so the records still reconcile.
Keeping it simple next time
Keep a note on your phone during the trip listing each load as it happens. When you merge, you will already know the transfers. If you later find a spreadsheet gets heavy, SpendixAI is built around India and INR, so it is not a fit for pounds accounts, but its approach is a useful model: one account per statement, all in one workspace, with rows reviewed before they are saved.
What if two people used the same card?
Families often hand the travel card to a partner or teenager for a day. Add a Who column and record the name beside each spend, even if it takes a minute. Say your partner spent £27.50 at a bakery and £45.00 at a bike hire shop on Tuesday. With names in place you can total each person's spending, settle any argument about the budget, and spot at once if a charge is nobody's, which is the first sign of a card problem worth raising with the issuer.
A last pass
- Loads add up to what you remember moving.
- Spending plus remaining balance equals loads.
- Refunds sit next to the purchases they cancel.
- The file name has the destination and month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

