Leave out any row that moves your own money rather than spending it: transfers between your own accounts, payments toward a credit card bill, and the matching pair of a purchase and its reversal. Count the purchases themselves once, on the account where they happened. Otherwise a ₹10,000 move to savings looks like ₹10,000 of spending, and your monthly total quietly inflates.
The three kinds of row to watch
- Transfers between your own accounts. The money leaves one account and arrives in another. You will see a debit in one statement and a credit in the other.
- Credit card bill payments. The bank statement shows a debit to the card. The card statement shows a matching payment received. The shops were counted when you swiped.
- Reversals and refunds. A purchase that is cancelled and credited back is not new income. It cancels part of an earlier expense.
A fourth, related case is wallet top-ups: loading money into a wallet is a transfer, and the spending happens when you pay from the wallet.
A three-account example
Say you have a salary account, a savings account and a credit card. One short month, with made-up numbers.
| Row | Account | Amount | Treatment |
|---|---|---|---|
| UPI to the grocer | Salary account | ₹1,800 | Count as spending |
| Transfer to own savings | Salary account | ₹10,000 | Leave out |
| Received from salary account | Savings account | ₹10,000 | Leave out |
| Fuel | Credit card | ₹3,000 | Count as spending |
| Shirt | Credit card | ₹2,500 | Count as spending |
| Shirt returned, credited back | Credit card | ₹2,500 | Net against the shirt |
| Card bill paid | Salary account | ₹5,500 | Leave out |
Real spending: 1,800 + 3,000 + 2,500 − 2,500 = ₹4,800. If you naively counted every debit, you would get 1,800 + 10,000 + 3,000 + 2,500 + 5,500 = ₹22,800. The overstatement is ₹18,000: ₹10,000 transfer, ₹5,500 card payment and ₹2,500 reversal that was never netted.
How do I keep them out of my totals?
Different trackers treat these rows differently, so check how yours does. A practical approach that works in most of them is to put these rows in a dedicated category, with a name like Transfers and card payments, and keep that category out of spending reports. In SpendixAI you can do this with a category of your own and filter it out in the Report builder when you want a pure spending view.
- Create the category once.
- After your first import, find the transfer and card-payment rows. They tend to be round numbers or contain your own name or a card reference.
- Move them into the category and add a rule for the wording that repeats, as it appears on your own statement.
- Import every account involved, so both halves of a transfer are visible and you can tick them off against each other.
Reversals need care
If you only import one side, a refund may look like income. Decide how you want to see it. Netting it against the original purchase keeps category totals honest: the shirt cost ₹0 once it was returned. If the refund arrives in a later month, it will reduce that month's category total, which is fine as long as you know why.
The Possible duplicate charges report is a different tool: it lists the same amount to the same merchant within two days, which can flag a real double charge that the merchant later reverses.
A quick test for any row
Ask: did my total wealth fall because of this row? A purchase, a fee or a payment to someone else: yes. A move between my own accounts, or a bill payment for something already counted: no. A refund: it restores something. Rows that fail the test are the ones to keep out, and your totals will start to look believable.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

