Getting started

How to total your monthly UPI spend from a bank statement

A salaried metro worker's way to add up daily UPI payments: filter the narration, count the payments, find the average and see which habit costs most.

Editorial illustration for How to total your monthly UPI spend from a bank statement

To know how much you spend on UPI in a month, take your bank statement for that month, pick out every debit whose narration mentions UPI, and add them. Then divide by the number of payments. The total is rarely the surprise; the number of payments and the average size usually are.

Where the figure is hiding

A UPI payment leaves your account as a debit and carries a narration that normally includes the word UPI and a merchant or person's name. Download the statement for the month as a spreadsheet or CSV from your bank's own site or app, and check how your bank writes the narration, because that differs from one statement to another.

If you spend through several apps, you do not have to open each one. All of them settle into your bank account, so the bank statement is the one list that has everything.

The spreadsheet route, step by step

Say the dates are in column A, the narration in column C, the debit amount in column D and the data runs to row 500. These formulas use ranges so they do not slow the sheet.

  • Total UPI debits: =SUMIF($C$2:$C$500,"*UPI*",$D$2:$D$500)
  • Number of UPI payments: =COUNTIF($C$2:$C$500,"*UPI*")
  • Average payment: =total divided by count, for example =F1/F2 if the total sits in F1 and the count in F2
  • Biggest single UPI payment: =MAXIFS($D$2:$D$500,$C$2:$C$500,"*UPI*") in Excel 2019 or later and Google Sheets

The asterisks are wildcards, so the formula matches any narration that contains UPI. If your credits and debits sit in one column with signs, change the sum range or filter to debits first.

A worked month for a salaried person

Say a metro employee finds 96 UPI payments totalling ₹18,240. The average is 18,240 divided by 96, which is ₹190. That feels harmless until you split it by habit.

HabitPaymentsTotal
Tea, snacks and lunch near the office38₹5,320
Cabs, autos and metro top-ups24₹4,560
Quick grocery and household orders18₹5,400
Everything else16₹2,960
All UPI payments96₹18,240

Check the arithmetic: 38 + 24 + 18 + 16 is 96, and 5,320 + 4,560 + 5,400 + 2,960 is 18,240. The ₹140 average at the tea stall (5,320 divided by 38) looks small, but those 38 payments are nearly as large a bill as a month's grocery orders.

Which payments are not really spending?

Not every UPI debit is a purchase. Rent sent to a landlord, money sent to a family member, and a transfer to your own other account all show the same word in the narration. If you leave them in, the total will look like lifestyle spend when part of it is a transfer. Mark these out before you read the number, and keep a separate line for them.

When does a sheet stop being enough?

Doing this once is fine. Doing it every month, then sorting 90 narrations into habits by hand, is where people give up. SpendixAI reads a statement you upload as a PDF, CSV or Excel file, lets you review the rows before saving, and then groups spend by category. Merchants it has seen before are categorised from your history, so the monthly UPI view becomes a matter of reviewing, not retyping.

Your next twenty minutes

  1. Download last month's statement.
  2. Total the UPI debits and count them.
  3. Divide to get the average payment.
  4. Split the total into three or four habits.
  5. Pick one habit and set a number you would be happy with next month.
SPENDIXAI JOURNAL

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

Explore your reports