To merge a travel card with your main card records, put every account's transactions into one list with a column for the account, then remove the transfers that load money onto the travel card, because they appear twice. Otherwise your spending looks larger than it is.
Why does merging two cards double count money?
Say you load ₹30,000 from your savings account to the travel card. Your bank statement shows a debit of ₹30,000, and the travel card statement shows a credit of ₹30,000. When you spend ₹30,000 on the card, that appears as the real expense. If you add all three lines, you have counted the same ₹30,000 as spending twice.
What steps do you follow?
- Gather statements for the same period from the main card, the bank account you load from, and the travel card.
- Add an Account column and fill it in: Main card, Savings, Travel card.
- Put all rows into one sheet with these columns: date, description, amount, direction (debit or credit), account.
- Find the load transfers: a debit in savings and a matching credit on the travel card within a day or two.
- Mark both lines as Transfer and leave them out of spending totals.
- Sort by date and scan for duplicates.
How do you exclude transfers with a formula?
If column F holds the category and column C the amount, spending without transfers is: =SUMIFS($C$2:$C$800, $F$2:$F$800, "<>Transfer", $D$2:$D$800, "Debit"). This works in Excel and Google Sheets. The "<>Transfer" criterion means not equal to Transfer.
A worked example with made-up numbers
| Account | Debits | What is inside |
|---|---|---|
| Savings | ₹58,000 | ₹30,000 load to travel card, ₹28,000 other spending |
| Main card | ₹22,500 | All real spending |
| Travel card | ₹27,400 | All real spending abroad |
Adding the debits gives ₹1,07,900. Real spending is the savings spending of ₹28,000, plus ₹22,500 on the main card, plus ₹27,400 on the travel card, which is ₹77,900. The difference, ₹30,000, is the load. The ₹2,600 left on the travel card (30,000 minus 27,400) is not spending either: it is money still sitting on the card, or cash taken out.
What about leftover balance and withdrawals?
Money left on the card is not an expense, and ATM withdrawals on the card are not item-level expenses. Record the withdrawal as one line labelled Cash and then, if you can, note what the cash was spent on. If the card is reloaded or refunded later, those too are transfers, not income.
How do you check that the merge is right?
- The sum of all opening balances plus all credits minus all debits should match each closing balance
- Every Transfer row should have a partner in another account within a day or two
- No row should appear twice with the same date, description and amount unless you can name the reason
- The row count per account should match the statement
Do this check before you build any summary, since every later number depends on it.
Keep the cleaned merged sheet next to the raw statements, never in place of them. If a figure is ever questioned, the raw files let you show where each row came from, and a merge you can explain is a merge you can trust.
How does an expense tracker deal with several cards?
In SpendixAI you choose the account before importing a statement, so each transaction keeps the account it came from, and several accounts live in one workspace. You can then filter by account and review possible duplicate imports. The load transfers still need your judgement, so check how you categorise them before relying on totals.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


