To measure how small UPI payments add up, choose a threshold such as ₹100, filter one month's UPI debits below it, and total them. Then group the filtered list by payee. The total shows the size of the habit and the grouping shows which few payees account for most of it.
How do you choose the threshold?
Pick the amount at which a payment stops feeling like a decision. For some people that is ₹100, for others ₹200 or ₹50. The exact figure matters less than keeping it the same every month so that comparisons mean something. Write it in a cell, for example F1, and let the formulas refer to it.
What formulas do you need?
Assume amounts in column C, type (Debit or Credit) in column D and payee in column B.
- Total of small payments: =SUMIFS($C$2:$C$500, $D$2:$D$500, "Debit", $C$2:$C$500, "<"&$F$1)
- Number of small payments: =COUNTIFS($D$2:$D$500, "Debit", $C$2:$C$500, "<"&$F$1)
- Small payments to one payee: =SUMIFS($C$2:$C$500, $D$2:$D$500, "Debit", $B$2:$B$500, H2, $C$2:$C$500, "<"&$F$1) with the payee name in H2.
The "<"&$F$1 piece joins the less-than sign to the number in F1. These work the same in Excel and Google Sheets.
A worked example
Say your threshold is ₹100 and your month has 64 UPI payments below it. Grouped by payee, they look like this:
| Payee | Payments | Total |
|---|---|---|
| Tea stall | 31 | ₹1,085 |
| Auto fares | 14 | ₹1,120 |
| Bakery and snacks | 12 | ₹1,020 |
| Seven other payees, one each | 7 | ₹275 |
| All below ₹100 | 64 | ₹3,500 |
Check: 1,085 + 1,120 + 1,020 + 275 = ₹3,500 and 31 + 14 + 12 + 7 = 64. If your total UPI spending that month was ₹21,400, small payments are 3,500 divided by 21,400, or about 16%.
What should you read into it?
Not every small payment is waste. Auto fares to work are needed, and the tea stall may be the best part of your day. The aim is to see the number rather than to scold yourself. Three payees explain ₹3,225 of the ₹3,500, so a conversation with yourself about three habits is more useful than a general promise to spend less.
Which options do you have after measuring?
- Keep it as is, and budget for it knowingly.
- Put a monthly cap on one category, say snacks, and check it mid-month.
- Switch one habit, such as paying a weekly amount to a vendor in advance, if that suits both sides.
- Re-measure next month to see whether anything changed.
What does three months side by side show?
One month shows a number. Three months show a direction.
| Month | Small payments | Total |
|---|---|---|
| August | 58 | ₹3,120 |
| September | 61 | ₹3,310 |
| October | 64 | ₹3,500 |
Between August and October, the count rose by 6 and the total by ₹380, because 3,500 minus 3,120 is 380. That is about ₹127 more a month in a habit that never felt like a decision. If the rise came from festival treats, it may fall again. If it came from a new daily payee, it will not.
Mistakes to avoid
- Including credits or refunds in the total; filter for debits only.
- Counting transfers to your own accounts, which are rarely small but can be.
- Comparing a full month with a part month.
- Changing the threshold between months.
Where does an app fit?
If you import statements into SpendixAI, the Report builder can filter and group transactions, which is the same job without formulas. Setting a budget on the category (budgets are part of Pro) gives you a running view. The app only sees what is in your statements, so cash tea is still yours to add by hand.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

