Budgeting

First-time merchants this month: a two-minute review

A new merchants on statement review: list payees that did not appear in the last six months, check each, and tag the ones that will recur. Takes two minutes.

Editorial illustration for First-time merchants this month: a two-minute review

A first-time merchant is any payee on this month's statement that was not on the previous six months'. Reviewing that short list takes about two minutes, catches charges you do not recognise, and tells you which new places are turning into habits.

Why look only at the new ones?

Scanning a whole statement means reading dozens of familiar names, and your eyes slide over them. New names are rarer, so they are worth full attention. A typical month might have 63 different payees and only 9 you have not seen lately. Two minutes on 9 rows is roughly 13 seconds each.

How do you list them?

Sort the month's transactions by merchant and compare against a list of merchants from the six months before. In a sheet, with merchants in B, dates in A and the first day of this month in H1, add a helper column that flags a new merchant: =IF(COUNTIFS($B$2:$B$3000,B2,$A$2:$A$3000,">="&EDATE($H$1,-6),$A$2:$A$3000,"<"&$H$1)=0,"New",""). Filter for New, then sort.

The two-minute checklist

  1. Do I recognise it? If not, look at the date, the amount and the other charges around it.
  2. Was it me? A relative, a family member or a subscription could have used a card or UPI.
  3. Is the amount right? Compare with the receipt, invoice or order.
  4. Will it recur? If it is a subscription, a service or a shop you will visit again, tag it.
  5. What category does it belong in? Fix the category now, while you remember what it was.

A sample month

New merchantAmountWhat it wasAction
Bookshop near the office₹640A giftOne-off; categorise as gifts
Plumbing service₹1,200Tap repairOne-off; home maintenance
Learning app₹799Monthly plan startedRecurring; set a reminder to review
Unfamiliar online charge₹349Not recognisedInvestigate before anything else
Cab app₹260Trip when the car was in serviceOne-off
Dry cleaner₹420New shop near homeMay recur; watch next month

Three of the six are one-offs, two may recur, and one needs follow-up. That is a typical shape: most new names are harmless, and a few matter a lot.

Be patient with the maybes. A dry cleaner you tried once may become your regular; wait for a second visit before you add it to the recurring list, and do not tag a shop as recurring only because you liked it.

Tagging the ones that will recur

When you tag a new merchant as recurring, you gain two things: next month it will not show up as new, and you can find it when you review subscriptions. A short Recurring column with Yes or No is enough in a sheet.

Where an app helps

If you import statements into SpendixAI, rows are reviewed before saving, which is a natural moment to look at the new names. Possible duplicate imports are flagged, and a Possible duplicate charges report lists the same amount to the same merchant within two days, useful when a new merchant shows two identical rows.

What if the new list is long?

After a trip, a festival or a house move, new merchants can run into dozens. Do not read all of them. Sort by amount and look at the biggest ten first, then any name you cannot place at all. The small ones that are obviously a chai stall or an auto ride can be skipped, and the review stays under a few minutes.

Build the habit

  • Do it right after importing or downloading the statement.
  • Keep the habit to two minutes; if the list is long, look at the biggest amounts first.
  • Write the date next to anything you chase up, so you remember to check the outcome.
SPENDIXAI JOURNAL

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

Explore your reports