Money tips

How to find the largest transactions of the month as a gig worker

Find the biggest debits of the month in a long statement using sort, filters and two spreadsheet formulas, with a gig worker's worked example in rupees.

Editorial illustration for How to find the largest transactions of the month as a gig worker

To find the largest transactions of the month, separate debits from credits first, then sort the debit column from highest to lowest and read the top five or ten rows. For a gig worker this matters more than usual, because platform payouts, fuel, phone bills and vehicle instalments all sit in one long list and one odd entry hides easily.

Why do big transactions slip past you?

A month of delivery or ride work can easily produce hundreds of lines: small UPI payments for chai, fuel top-ups, daily payout credits. Scrolling in date order, your eye lands on the pattern and skips the exception. A repeated ₹150 never worries you, but a single ₹9,800 debit to a name you do not recognise should.

Credits make it worse. A payout of ₹6,400 looks large, but it is money in, not money out. If you sort the raw amount column, credits and debits mix and the list tells you nothing.

What should you do before sorting?

  1. Download the month's statement as CSV or Excel from your bank, covering only that calendar month.
  2. Make sure amounts are real numbers, not text. If a cell is left-aligned or shows a green corner, the sort will misbehave.
  3. Keep only the debit rows, either by filtering on the debit column or by copying them to a new sheet.
  4. Remove opening and closing balance rows and totals, which would otherwise appear as the largest items.

How do you list the top five debits in a spreadsheet?

Say your debit amounts are in column C, rows 2 to 500, descriptions in column B. These work in Excel and Google Sheets:

  • Biggest single debit: =MAX($C$2:$C$500)
  • Second biggest, third biggest and so on: =LARGE($C$2:$C$500, 2) and then 3, 4, 5
  • Description of the biggest debit: =INDEX($B$2:$B$500, MATCH(MAX($C$2:$C$500), $C$2:$C$500, 0))
  • Whole table sorted high to low in one go: =SORT($A$2:$C$500, 3, -1) in Excel 365 or 2021, or =SORT($A$2:$C$500, 3, FALSE) in Google Sheets

One catch: if two debits are exactly the same amount, MATCH returns the first one only. Use the sorted table when you suspect ties.

A worked example with made-up numbers

Say a delivery rider's debit column for the month totals ₹41,300 across 180 rows. After sorting, the top five look like this:

RankAmountWhat it turned out to be
1₹12,500Vehicle instalment, expected
2₹6,200Annual two-wheeler insurance, expected but yearly
3₹4,800Transfer to a friend, forgotten
4₹2,150Phone recharge plus data pack
5₹1,900Fuel, three top-ups on the same day

Together the five come to ₹27,550, which is about two thirds of the month's debits (27,550 divided by 41,300 is roughly 0.67). The remaining 175 rows add up to ₹13,750. That split alone tells you where a saving effort should go: not the chai, but the instalment, the insurance timing and the one forgotten transfer.

Which large items deserve a second look?

  • Any amount you cannot name from memory within a few seconds.
  • Two debits of the same amount to the same payee within a day or two, which can be a double payment.
  • Yearly or quarterly items such as insurance, which are fine once but alarming if they appear again.
  • Cash withdrawals, since the statement cannot tell you what the cash was spent on.

What should you do after you find the big ones?

Write a one-line reason next to each of the top ten: instalment, insurance, fuel, personal transfer, unknown. Anything marked unknown gets a search in your messages and payment apps that same day. If it still means nothing to you after that, look at the full statement line for a reference, and if the payment looks wrong, call your bank using the number printed on your card or on the official site, never a number from a message or a search result. Then carry the sorted list into next month as a comparison: if the same big item moved up or down by a few thousand rupees, you now know where to ask why.

When a sheet stops being enough

If you do this every month, the repeated cleaning gets tiresome. SpendixAI lets you upload the statement as PDF, CSV or Excel, review the rows before saving, and then filter and group in the Report builder or download the result as CSV. Whichever route you take, the habit that matters is the same: look at the top ten debits within a week of month end, while you can still remember what they were.

SPENDIXAI JOURNAL

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

Explore your reports