Bank statements

GPay or PhonePe statement vs bank statement: avoid double counting

Why UPI app history and bank statements show the same payment twice, how to pick one source per account, and how to check your totals.

Editorial illustration for GPay or PhonePe statement vs bank statement: avoid double counting

A UPI app and your bank both record the same payment, so loading both into an expense tracker counts it twice. The fix is to choose one source of truth per account, usually the bank statement, and use the UPI app only to look up what a payment was for. SpendixAI is described for bank and card statements, flags possible duplicate imports, and reports same-amount, same-merchant charges within two days.

Why does the same payment appear twice?

Paying a kirana through a UPI app moves money out of your bank account. The app logs a payment, and the bank logs a debit. They are one event with two records. The app record usually has the shop's name; the bank line has a reference string. If both sets of records enter your tracker, each payment is two expenses.

Worked example: one month, two sources

Say in October the bank statement shows: 48 UPI payments totalling ₹21,600, rent of ₹18,000, a loan instalment of ₹6,500 and a salary credit. Your UPI app shows the same 48 payments, ₹21,600. Load both and your expenses read as 21,600 + 21,600 + 18,000 + 6,500 = ₹67,700, but real spending is 21,600 + 18,000 + 6,500 = ₹46,100. The overcount is exactly ₹21,600, the UPI total.

SourceContentsTotal
Bank statementUPI, rent, instalment₹46,100
UPI appUPI payments only₹21,600
Both loaded togetherSame payments twice₹67,700

Which source should you pick?

  • Prefer the bank or card statement: it contains everything that left the account, not only UPI.
  • Use the UPI app history only as a lookup for a shop's name.
  • If you must use the app because the bank file is poor, exclude those payments from the bank import, not the other way round.
  • Keep one rule per account and write it down.

What about wallet top-ups?

Adding money from your bank to a wallet is a transfer between your own accounts, not an expense. The spending happens when the wallet pays someone. If you track both the bank and the wallet, the top-up appears as an outflow in one and an inflow in the other. Treat it as a transfer, or you will count it as spending when you top up and again when you spend.

How do you check for double counting?

  1. Add up the UPI payments in the bank statement alone.
  2. Compare with your tracker's total for the same month.
  3. Search for same amount, same merchant, one or two days apart.
  4. Open the Possible duplicate charges report and review each pair.
  5. Delete the extra; deleted rows stay in the recycle bin for 30 days.

Before importing, pick the account the statement belongs to. In SpendixAI each transaction keeps its account, which makes it easier to see where a duplicate came from.

Rules for different situations

Freelancers should let the bank statement lead and attach invoices to receipts. Students can often rely on one account and ignore the app history entirely. Couples with a shared UPI handle should note whose account a payment came from before importing. NRIs holding both an Indian and a foreign account should pick the base currency before importing, because it cannot be changed once transactions exist.

A closing check

At month end, compare your tracker's total outflow with the bank statement's total debits. They should match within the transfers you set aside. If they are far apart, you have either a duplicate or a missing row, and the same-amount search will usually show which.

SPENDIXAI JOURNAL

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

Explore your reports