Getting started

Rows to leave out of spending: transfers, card payments, reversals

Which statement rows are money moving, not money spent: own-account transfers, card bill payments and reversals, with a three-account example.

Editorial illustration for Rows to leave out of spending: transfers, card payments, reversals

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.

RowAccountAmountTreatment
UPI to the grocerSalary account₹1,800Count as spending
Transfer to own savingsSalary account₹10,000Leave out
Received from salary accountSavings account₹10,000Leave out
FuelCredit card₹3,000Count as spending
ShirtCredit card₹2,500Count as spending
Shirt returned, credited backCredit card₹2,500Net against the shirt
Card bill paidSalary account₹5,500Leave 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.

  1. Create the category once.
  2. 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.
  3. Move them into the category and add a rule for the wording that repeats, as it appears on your own statement.
  4. 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.

SPENDIXAI JOURNAL

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

Explore your reports