Cards and UPI

Debit and matching credit on a statement: reading reversals

A reversal on a statement is a debit and a matching credit. Learn to read the pair, net them, and keep your spending totals clean with a simple formula.

Editorial illustration for Debit and matching credit on a statement: reading reversals

A reversal on a card or bank statement is a pair of entries: one debit for the original charge and a later credit for the same amount. Together they net to zero, so the money has not left you. In your spending totals, count the pair as nothing, or count the debit and subtract the credit, and the month will not be overstated.

Why do I see two lines for one transaction?

Statements record every movement, not the story behind it. When a payment fails midway, a merchant cancels, or a duplicate is withdrawn, the bank does not delete the first line. It adds an opposite one. The statement is a ledger, so the debit stays and the credit appears on its own date, sometimes on a different day from the debit.

The description on the credit often looks similar to the debit, with words such as reversal, refund or cancelled, but wording differs from one issuer to another. Check your own statement for the pattern rather than relying on a keyword.

How do I tell a reversal from a refund?

  • A reversal usually follows a failed or cancelled payment and returns the full amount.
  • A refund usually follows a return or complaint, and may be for a different amount.
  • In both cases the credit lands on the account or card you paid from, unless the seller chose another route.

For your totals the distinction matters less than the arithmetic: both lower the net amount you spent.

How do I net them in a spreadsheet?

Put the date in column A, the merchant in column B and the amount in column C. Enter debits as positive numbers and credits or reversals as negative numbers. Then your real spend is a plain sum.

  • Net spend for the whole sheet: =SUM($C$2:$C$500)
  • Net spend for one merchant: =SUMIFS($C$2:$C$500, $B$2:$B$500, "Store name")
  • Flag a debit that has an equal and opposite credit from the same merchant, in cell D2 and filled down: =IF(COUNTIFS($B$2:$B$500, B2, $C$2:$C$500, -C2)>0, "Has pair", "")

The third formula looks for any row with the same merchant text and the opposite amount. It will flag both the debit and the credit, which is what you want when reviewing. Merchant text can differ slightly between the two lines, so a pair that is not flagged may still be a pair.

A worked example

Say a card shows a debit of ₹2,499 to an online store on the 3rd, and a credit of ₹2,499 from the same store on the 5th. You then buy the same item successfully for ₹2,499 on the 6th. Three lines, but only one real purchase: 2,499 - 2,499 + 2,499 = ₹2,499.

DateLineAmount (₹)Running net (₹)
3rdDebit, online store2,4992,499
5thCredit, reversal-2,4990
6thDebit, repeat purchase2,4992,499

If you only counted debits, you would show ₹4,998 for something that cost ₹2,499.

What if a debit has no credit yet?

Mark it pending, note the date, and look again after the period your bank or the merchant quotes. If it never arrives, take the details to your bank. If you use SpendixAI, the Possible duplicate charges report lists the same amount to the same merchant within two days, which is a useful starting point for spotting a repeated debit that may need a reversal.

Month-end check

  1. Sort the statement by merchant.
  2. Find any debit with a same-size credit.
  3. Net the pairs and note the dates.
  4. Look for debits with no credit that you expected to be reversed.
  5. Compare your net total with your tracker.
SPENDIXAI JOURNAL

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

Explore your reports