To see how much you spend on UPI each month, take your bank statement for the month, pick out the rows whose narration marks them as UPI, and add the debits. Do not add credits, and do not double-count a payment that also appears on a card or wallet statement. Then split the total by purpose so the number tells you something.
Where the total comes from
UPI itself keeps no single record of your whole spending. Each payment is a debit on a bank account, so the statement of that account is the record. If you use two or three accounts for UPI, you need a statement from each. Check how your own bank labels UPI rows, as the wording differs between banks.
The quick way in a spreadsheet
Paste a month of the statement into Excel or Google Sheets with dates in column A, narration in B and debit amounts in C. To total rows whose narration contains UPI for a month starting in the date in E1, use this:
- =SUMIFS($C$2:$C$500, $B$2:$B$500, "*UPI*", $A$2:$A$500, ">="&$E$1, $A$2:$A$500, "<"&EDATE($E$1,1))
- To count those rows, replace SUMIFS with COUNTIFS and drop the sum range: =COUNTIFS($B$2:$B$500, "*UPI*", $A$2:$A$500, ">="&$E$1, $A$2:$A$500, "<"&EDATE($E$1,1))
This works in Excel and Google Sheets. The star on each side of UPI is a wildcard, and the dates in column A must be real dates, not text.
A worked example with made-up numbers
Say October's debit rows for your main account look like this.
| Type of debit | Rows | Total in rupees |
|---|---|---|
| UPI payments | 42 | 31,600 |
| Card bill payment | 1 | 18,000 |
| Rent transfer by NEFT | 1 | 20,000 |
| ATM cash | 2 | 6,000 |
UPI is 31,600 out of a total of 31,600 + 18,000 + 20,000 + 6,000 = 75,600, so a bit over 41 percent of that month's debits, which is 31,600 divided by 75,600. The figure is specific to this example. Keep the rent and card bill out of the UPI line, because the card bill is a payment of spending that appears elsewhere.
How do I split UPI by purpose?
A single UPI total is a number without a story. Group the rows into categories such as groceries, transport, bills, eating out and payments to people. Rows to individuals are the hardest, as only you know whether it was rent, a loan to a friend or a split dinner.
- Total the UPI rows for the month.
- Group repeated payees first.
- Assign the rest by hand, beginning with the largest.
- Keep person-to-person transfers in their own category until you decide what they were.
- Compare this month with the last.
When a sheet stops being enough
After a few months the monthly paste gets tedious. SpendixAI lets you upload statements from each account as PDF, CSV or Excel, review the rows, and keep each transaction against its account. Categories, reports and a CSV download then give you the month by category without rebuilding formulas. It reads statements you upload and does not connect to your bank.
Limits of the number
A UPI total tells you how much left through UPI, not how much you spent in total. Cash, cards, standing instructions and cheque payments sit outside it, and so do payments made from another person's account on your behalf. Treat the figure as one part of your spending picture, and compare it with the same month in earlier periods rather than reading too much into a single month.
A monthly check
Make the UPI total a number you look at on a fixed day each month, perhaps the first. Note it down beside the previous months, and when it jumps, open the largest rows to find out why.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


