A credit card payment is counted twice when it is recorded once on the bank side as an expense and again on the card side as a charge or as income, or when the same statement was imported twice. Find the pair, mark it as a transfer, and your spending total corrects itself.
What are the three usual causes?
- Both sides imported: the bank statement shows a debit to the card, and the card statement shows a payment received, and both are treated as transactions.
- Overlapping imports: the same statement, or two statements with overlapping dates, loaded twice.
- Manual plus import: you typed the payment by hand and then imported the same debit.
Each leaves a pair of equal amounts, which is how you find them.
A worked example with made-up figures
Say your bank statement shows a debit of ₹18,000 labelled card payment on 20 November, and the card statement shows a payment received of ₹18,000 on 21 November. Your real spending for the month is ₹41,500, excluding the payment.
| Source | Row | Effect on the spending total (₹) |
|---|---|---|
| Real purchases | All categories | 41,500 |
| Bank debit to card | Counted as expense | +18,000 |
| Card payment received | Counted as income or ignored | 0 or −18,000 |
| Reported spending | If the debit is counted | 59,500 |
The total is 41,500 + 18,000 = 59,500, an overstatement of ₹18,000. If the payment-received row is counted as a negative expense, the two cancel out but the picture is still confused; the clean solution is to label both rows as a transfer and exclude them.
How do I find the pairs in a spreadsheet?
Put the amount in column C, dates in column A and the account in column B, with rows 2 to 500. In D2 enter this and fill down.
- =COUNTIF($C$2:$C$500, C2) counts how many rows share this exact amount.
- =COUNTIFS($C$2:$C$500, C2, $B$2:$B$500, "<>"&B2) counts rows with the same amount in a different account, which is the signature of a transfer pair.
- Filter column D for values of 1 or more, sort by amount, and read the narration.
An 18,000 appearing once in the bank account and once in the card account is a transfer. An 18,000 appearing twice in the same account on the same date may be a duplicate import.
What is the fix?
- Transfer pair: give both rows a Transfer category and exclude that category from spending reports.
- Duplicate import: delete one copy, keeping the one that carries your category and notes.
- Manual plus import: keep the imported row and delete your typed one, or the reverse, but not both.
How do I stop it recurring?
Pick the account before every import, import by statement cycle, and do not hand-type anything you will also import. Name the bank-side narration a rule if your tool allows.
What can an app do about it?
In SpendixAI, each transaction keeps its account, which makes it easy to filter the bank and card separately. Possible duplicate imports are flagged, and the Possible duplicate charges report lists the same amount to the same merchant within two days. For the transfer pair, check how the rows are categorised after import and correct them; do not assume it is automatic.
Does the same thing happen with wallets and UPI top-ups?
Yes, in a different shape. Adding ₹2,000 from your bank to a wallet is a move, and spending ₹2,000 from the wallet is the expense. If both appear as spending, you get the same double count. The test is identical: look for the same amount leaving one account and arriving in another within a day or two, and treat that pair as a transfer.
Checklist
- Pair found by amount.
- Cause named.
- Transfer or duplicate handled.
- Statement total and spending total match.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

