Travel and vehicles

How to Merge a Travel Card With Your Main Card Records (US)

A US-dollar walkthrough for combining a prepaid travel card with your main card records, avoiding double counting when you top up the card.

Editorial illustration for How to Merge a Travel Card With Your Main Card Records (US)

To merge a travel card with your main card, put every transaction from both into one list with an account column, then remove the transfers that move money between them. The top-up shows up on the main card as an outflow and on the travel card as a deposit, and counting both makes your spending look bigger than it was.

What are you trying to end up with?

A single record of what you spent on a trip, split by category, that you can trust when someone asks about it. Say you flew to a four-day conference and used a prepaid travel card for most of it while your main credit card covered the flight.

Step by step

  1. Download the statement for each card as a file: PDF, CSV or a spreadsheet export, whichever your issuer offers.
  2. Make one sheet with columns for date, description, amount, account and category.
  3. Paste the main card rows first, then the travel card rows underneath, filling the account column as you go.
  4. Sort by date so the two cards interleave.
  5. Mark top-ups and refunds, then handle them as described below.
  6. Add a category to each remaining row and total by category.

How do you deal with the top-up?

Say you loaded $600 onto the travel card from your main card. On the main card statement it looks like a $600 purchase. On the travel card it looks like a $600 credit. Neither is spending. Label both rows Transfer and leave them out of totals.

RowAccountAmountCounts as spending?
Load travel cardMain card$600.00No, it is a transfer
Load receivedTravel card$600.00No, it is a transfer
Hotel, two nightsTravel card$318.40Yes
Conference ticketMain card$250.00Yes
Airport taxiTravel card$46.75Yes

Spending here is $318.40 + $250.00 + $46.75 = $615.15. If you had counted the load as well, you would have reported $1,215.15, double the true figure.

What if the card has a leftover balance?

Check the final balance against your records. Opening load $600.00 minus the two travel card spends ($318.40 + $46.75 = $365.15) leaves $234.85. If the card statement says something different, a row is missing or a fee is hiding there. Look for small items before blaming the arithmetic.

Does it matter that the card is in another currency?

It can. If a charge was made abroad, your statement may show the foreign amount and a dollar amount. Record the dollar amount that actually left your account, not a figure you calculated yourself, and keep the original amount in a note. Whatever your issuer charged for conversion belongs in the dollar figure.

Where an app can help

A spreadsheet is enough for one trip. If you do this often, note that SpendixAI is built around India and INR rather than US dollars, so check availability before relying on it, but the idea it uses is worth copying: each statement is imported into its own account and all accounts sit in one workspace, so a combined view is a filter rather than a copy-paste job.

What about personal charges mixed into the trip?

On a work trip some charges are not work at all: a $42.00 dinner with an old friend, a souvenir, a gym day pass. Add a column called Purpose with values such as Work, Personal or Shared. Then totals can answer two questions: what the trip cost altogether, and what part belongs to the employer or client. Fill the column the same day you merge, while you still remember who was at the table.

Checklist before you close the sheet

  • Every top-up and refund is labelled and excluded.
  • Opening balance, spending and closing balance reconcile.
  • Both statements cover the same date range.
  • Each foreign-currency charge shows the dollar amount charged.
  • You saved the file with the trip name and month.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports