Life events

Student UPI leaks: late-night orders and small top-ups you miss

Student UPI spending leaks are easy to find: group a month of small payments by hour and merchant type to see where student money disappears each month.

Editorial illustration for Student UPI leaks: late-night orders and small top-ups you miss

To find where student money disappears, take one month of small UPI payments and group them two ways: by the hour of the day, and by the kind of merchant. A few patterns, such as late-night orders and repeat top-ups, usually explain most of the small leaks.

Why do small payments hide so well?

A ₹60 tea or a ₹240 late-night order never feels like a decision. But thirty or forty of these in a month are a real amount, and they do not show up as one big item on your statement. The only way to see them is to group them.

How do you collect the month's payments?

  1. Open your bank statement for the month, or the payment history in your UPI app. Statements differ, so check what your own shows; some list only the date, not the time.
  2. Copy the small payments, say everything under ₹300, into a sheet.
  3. Use columns: A date, B time, C merchant, D amount, E hour.
  4. In E2, type =HOUR(B2) and fill it down, so you have the hour of each payment (works in Excel and Google Sheets if the time is stored as a time).
  5. Add a column F for the type: food delivery, tea and snacks, recharge, rides, games.

How do you group by hour?

Late night is 10 pm to 2 am. That crosses midnight, so use two parts and add them:

  • =SUMIFS($D$2:$D$300, $E$2:$E$300, ">=22") + SUMIFS($D$2:$D$300, $E$2:$E$300, "<2")
  • Count the payments with =COUNTIFS($E$2:$E$300, ">=22") + COUNTIFS($E$2:$E$300, "<2")
  • Total by merchant type: =SUMIFS($D$2:$D$300, $F$2:$F$300, "Food delivery")

What does the result look like?

Placeholder numbers for a month of 49 small payments.

WhenTypePaymentsTotal
10 pm to 2 amFood delivery9₹2,430
6 pm to 9 pmTea and snacks near campus21₹1,260
Any hourMobile and app top-ups6₹1,150
2 pm to 6 pmAuto and cab rides8₹960
Any hourGames and in-app purchases5₹700
AllTotal49₹6,500

2,430 plus 1,260 plus 1,150 plus 960 plus 700 is 6,500. If your monthly pocket money is ₹9,000, these small payments alone use about 72% of it (6,500 divided by 9,000). The late-night orders are the biggest single row, nine payments for ₹2,430.

What can you do about it?

  • Set a delivery cut-off hour, for example none after 11 pm on weekdays.
  • Move app top-ups to a planned weekly slot.
  • Give yourself a weekly UPI allowance and stop when it is gone.
  • Delete saved cards and payment links from apps you overuse, so each order takes a conscious step.

Can an app help?

SpendixAI can take the statement as PDF, CSV or Excel and categorise merchants with your own rules and history, and its Report builder can filter and group the rows. Time of day depends on what your statement shows, so check your own. A sheet is enough for one monthly look.

What if there are too many payments to sort by hand?

Sort by merchant name first, so repeat names sit together, and then total each. Often three or four names account for most of the money. Give those names a type once, and use a filter for the rest. If the month has well over a hundred rows, sort the biggest merchant groups only and leave the tail as miscellaneous. You are looking for patterns, not for a perfect ledger.

A quick monthly routine

  1. Export the month's small payments.
  2. Group by hour and type.
  3. Choose one pattern to cap.
  4. Look again next month to see whether it moved.

If a pattern is hard to break alone, tell a friend which one you are working on and ask them to check in at month end. Small public promises work better than private ones.

SPENDIXAI JOURNAL

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

Explore your reports