Bank statements

GPay or PhonePe Statement vs Bank Statement: Double Counting for NRIs

An NRI guide to keeping one source of truth when a UPI app history and a bank statement show the same payment, with a worked remittance example.

Editorial illustration for GPay or PhonePe Statement vs Bank Statement: Double Counting for NRIs

One rupee can appear in three places when family pays bills from money you send to India: your overseas transfer record, the Indian bank statement and the UPI app history. Pick the bank statement of the Indian account as your ledger, use the UPI app only to find out what a payment was for, and never add both to the same expense list.

Why one payment turns up three times

A UPI app is only a front door. When your mother pays the pharmacy through a UPI app, the money leaves her bank account, and the bank statement carries a line for it. The app history carries its own line for the same payment. Add the remittance you made from abroad and a careless tracker can count the same money as income, as a transfer and as spending.

NRIs feel this more than most because the story of one rupee crosses two countries, two currencies and two sets of records. The habit that saves you is deciding, once, which record is the ledger.

Which record should be the ledger?

RecordWhat it tells youUse it for
Overseas bank or transfer receiptHow much foreign currency left you and the rate you gotRemittance cost and rate, kept as a note
Indian account statementEvery credit and debit that actually movedThe ledger you import
UPI app historyA friendlier label, such as the shop or person paidCross-check and memory aid only

The Indian account statement wins because it is complete: it includes cash withdrawals, auto-debits and charges that a UPI app never shows. If a payment is missing from it, the payment did not leave that account.

A worked example with made-up numbers

Say you transfer AED 2,000 and the Indian account is credited ₹45,000, which works out at ₹22.50 per dirham. During the month your parents spend ₹6,500 at a hospital pharmacy, ₹1,200 on an electricity bill and ₹3,800 on groceries, all through a UPI app, and ₹8,000 is withdrawn in cash.

  • Bank statement lines: one credit of ₹45,000 and four debits totalling ₹6,500 + ₹1,200 + ₹3,800 + ₹8,000 = ₹19,500.
  • UPI app history: three lines totalling ₹11,500, the same three debits again.
  • Double counting would show ₹19,500 + ₹11,500 = ₹31,000 of spending. The truth is ₹19,500.

The ₹45,000 credit is a transfer from you, not income to the Indian account's owner, so keep it out of the spending total. If you track in rupees, note the AED figure and the rate in the description so you can see what the month cost you abroad.

How do I stop the same payment being counted twice?

  1. Choose one import source per Indian account: the bank statement, downloaded monthly as PDF, CSV or Excel.
  2. Treat the UPI app history as a lookup. If a bank line reads like a string of codes, search the app for the amount and day, then edit the description to something you will recognise.
  3. Add cash withdrawals as cash spending only when your family tells you what the money was used for; until then, leave the withdrawal itself as the entry.
  4. Record your overseas transfer once, in the currency you sent, and mark it as money moved rather than a purchase.
  5. Before closing the month, scan for pairs of equal amounts on the same day. A pair usually means two sources slipped in.

What can SpendixAI do about duplicates?

You pick the account before importing a statement, so each transaction stays tied to that account, and the import flags possible duplicate imports. A Possible duplicate charges report lists the same amount to the same merchant within two days, which is a quick way to spot a doubled entry. It does not read your UPI app and it never asks for net-banking logins, so you still upload statements yourself and review the rows before saving.

If your tracking currency matters, choose the base currency before the first import, because it cannot be changed once transactions exist. Each expense can carry its own currency, with totals converted using the rate saved with that transaction.

A monthly check before you close the books

  • Do the Indian account credits match the transfers you sent, allowing for the rate on the day?
  • Does the sum of debits in your tracker match the statement's total debits?
  • Are there lines you only recognise from the UPI app? Rename them now, while the memory is fresh.
  • Is any transfer sitting in your spending total? Move it out.
SPENDIXAI JOURNAL

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

Explore your reports