You do not need to read every transaction to review your spending. Sort by amount and look at the top ten, group by merchant to see who gets your money most often, check the unknown items, and compare your top five categories with last month. This four-part scan takes about ten minutes and covers most of what matters.
Why not read everything?
Most of the total sits in a small number of rows. A few large payments and a few frequent merchants usually explain the bulk of a month. Reading every small row is slow, and the effort rarely changes a decision.
How do you scan by amount?
Sort the month's transactions from largest to smallest and read the top ten. For each, ask whether it was planned, whether it will repeat, and whether the figure is correct. Rent, EMIs and fees will usually lead the list, so the interesting ones are the unplanned items further down.
In a spreadsheet with dates in column A, categories in column B and amounts in column C, this formula sorts rows 2 to 200 by amount, largest first. In Excel 365 or 2021: =SORT(A2:C200, 3, -1). In Google Sheets: =SORT(A2:C200, 3, FALSE). You can also just use the sort buttons on the column.
How do you group by merchant?
Group by merchant to see who gets your money most often. A merchant you pay ten times a month for ₹250 each is ₹2,500, more than a single ₹2,000 purchase, but it never stands out as a single row. Grouping is how you spot that. If your tracker shows merchant totals, scan the top five.
How do you handle the unknowns?
Filter to uncategorised or unknown items and clear them. If you cannot identify one, leave it in a holding category and look at the date. Unknowns are where mistakes and misuse hide, so they are worth the attention even though they are often small.
How do you compare your top five categories?
Put last month and this month side by side for your five biggest categories. Look at the change, not the total. Say groceries went from ₹9,000 to ₹10,200, up ₹1,200, while eating out went from ₹5,500 to ₹4,300, down ₹1,200. The two changes offset each other, so the overall total looks flat, but the story underneath is different.
| Category | Last month | This month | Change |
|---|---|---|---|
| Groceries | ₹9,000 | ₹10,200 | +₹1,200 |
| Eating out | ₹5,500 | ₹4,300 | -₹1,200 |
| Fuel | ₹3,000 | ₹3,300 | +₹300 |
| Shopping | ₹4,000 | ₹6,500 | +₹2,500 |
| Bills | ₹7,200 | ₹7,200 | ₹0 |
Shopping up by ₹2,500 is the line to look at. You can then open only the rows in that category, instead of reading the whole month. In a sheet, a category total is =SUMIFS($C$2:$C$500, $B$2:$B$500, "Shopping") once the data is in rows 2 to 500.
What if something looks off during the scan?
If a figure seems wrong, do not assume the worst. First check whether a transaction was imported twice, or whether a refund and the original purchase were both counted. Then compare the total of the account with the closing balance change on your own statement. If a charge truly looks unfamiliar, check it against your bank's official channel and report it there, rather than through a link sent to you in a message.
A ten-minute scan checklist
- Sort by amount and read the top ten.
- Group by merchant and note the top five.
- Clear the unknown items.
- Compare the top five categories with last month and open only the one that moved most.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

