To find your largest transactions this month, sort your list by amount from highest to lowest, or use the LARGE function to pull the top five. Then look at each of those lines and ask whether you expected it. Five minutes with the top of the list catches more problems than scrolling through every row.
The quickest route: sort by amount
Put your month's transactions in three columns: date in A, description in B, amount in C, with headings in row 1. Select the whole block and sort by column C, largest first. In Excel, use the Sort command on the Data tab and choose column C, Largest to Smallest. In Google Sheets, use Data, then Sort range. Always include all three columns, or the amounts will separate from their descriptions.
If you want the sorted copy in another place and your tool supports it, =SORT(A2:C13,3,-1) in Excel 365 or 2021 returns the rows in descending order of column 3, and =SORT(A2:C13,3,FALSE) does the same in Google Sheets.
A worked example
Say twelve transactions for the month are: rent $1,350.00; supermarket $86.40; car insurance $142.00; electronics store $329.99; utility bill $118.35; dinner $64.20; airline $287.50; pharmacy $23.15; online marketplace $459.00; fuel $52.30; dental $210.00; subscription $15.99. The month totals $3,138.88.
| Rank | Description | Amount | Working |
|---|---|---|---|
| 1 | Rent | $1,350.00 | Largest single line |
| 2 | Online marketplace | $459.00 | Check this order exists |
| 3 | Electronics store | $329.99 | Is there a receipt? |
| 4 | Airline | $287.50 | Planned trip? |
| 5 | Dental | $210.00 | Expected appointment? |
The top five total $1,350.00 + $459.00 + $329.99 + $287.50 + $210.00 = $2,636.49. The rest of the month, seven lines, comes to $3,138.88 - $2,636.49 = $502.39.
How do I pull the top five with formulas?
With amounts in C2:C13, the largest value is:
=LARGE($C$2:$C$13,1)
Change the last argument to 2, 3, 4 and 5 for the next ones. To bring back the description that belongs to an amount in E2:
=INDEX($B$2:$B$13,MATCH(E2,$C$2:$C$13,0))
MATCH with 0 finds the exact value and INDEX returns the description in the same row. One limit: if two transactions have exactly the same amount, MATCH will return the first one both times. If that happens, sort the data instead, or add a small helper column that separates them.
What should I ask about each large line?
- Do I recognise the merchant, or is the name on the statement unfamiliar?
- Did I authorise this amount, or is it higher than what I agreed?
- Does a receipt or confirmation exist, and have I kept it?
- Is it a one-off or the start of a pattern?
- Is it in the right category?
An unfamiliar name does not mean fraud. Many merchants bill under a parent company. But if you cannot place it after checking your emails and order history, use the contact route printed on your statement to ask your bank about it, and do it soon rather than later.
Should I check the smallest ones too?
Sort ascending once in a while. A run of small odd amounts, a few dollars each, can be a subscription trial that rolled on. The largest list shows money that hurt; the smallest list shows money that leaks.
Make it a habit
- Run the sort on the first weekend of each month for the month just gone.
- Keep a column called Checked, and mark the top five once you have confirmed them.
- Save the receipt for any item over an amount you choose, say $200, because that figure is yours to set.
- Note what changed from last month's top five, because a new name on the list is more interesting than an old one.
If you ever track spending in rupees as well, SpendixAI offers filters and a report builder for sorting and grouping transactions, though it is built around India and INR rather than the US.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
