Expense categories

Fix All Unmatched Merchants in One Pass for Gig Workers

Clear a pile of uncategorised merchants in one sitting: group by name, merge spellings, fix the biggest first and add rules so next month is shorter.

Editorial illustration for Fix All Unmatched Merchants in One Pass for Gig Workers

To fix unmatched merchants in one pass, list them by name instead of going row by row, merge the spellings that belong together, assign a category to each group and then add rules for the ones that will come back. Work from the largest total down. Twenty minutes with the grouped list is faster than correcting two hundred rows one at a time.

Why a grouped list beats row-by-row

A month of statements might show 150 rows, but the number of distinct payees is much lower. Gig workers see many small, similar rows: fuel stops, tea stalls, tolls, mobile recharges, platform fees. Correcting a payee once, with all its rows at the same time, is where the time saving comes from.

A worked example with made-up numbers

Say last month left 46 unmatched rows. Grouped by payee, they come down to six groups.

Payee groupRowsTotal in rupeesCategory to assign
Fuel station spellings147,800Vehicle fuel
Toll and FASTag top-ups62,400Tolls
Tea and snack stalls121,260Food on the road
Mobile recharge3897Phone
Mechanic and tyre shop23,100Vehicle repair
Individuals via UPI94,500Review one by one

The rows add up: 14 + 6 + 12 + 3 + 2 + 9 = 46, and the amounts add up to 7,800 + 2,400 + 1,260 + 897 + 3,100 + 4,500 = ₹19,957. Five groups can be settled in one go; only the UPI payments to individuals need a closer look, so you spend your attention where it is needed.

Steps for the one-pass session

  1. List the unmatched rows grouped by merchant name, with a total for each group.
  2. Sort by total and start at the top.
  3. Merge spellings that mean the same shop into one name.
  4. Assign the category to the whole group.
  5. Add a rule or alias for every group that will return next month.
  6. Open the leftover list and handle the individuals and one-offs by hand.

What SpendixAI offers for this

SpendixAI holds unmatched items for review when AI is off, and it lets you add merchant aliases so different spellings point to one name. Corrections become history, so the same shop is matched on the next import. Use the transaction list and filters to see what is still unmatched, and check which merchant tools your account shows.

Which rows deserve a second look?

  • Large amounts, where a wrong category distorts the month.
  • Payments to individuals, where the purpose is unknown to any tool.
  • Payee names you do not recognise, which could be a duplicate or a mistaken charge.
  • Rows in a foreign currency, if you travel for work.

A short example of merging

Say your statements show three spellings of one fuel stop, with ₹2,100, ₹2,700 and ₹3,000 across the month. Merged into one merchant they total 2,100 + 2,700 + 3,000 = ₹7,800, which matches the first row of the table above. Assign Vehicle fuel once, and the next time a fourth spelling appears, add it as an alias instead of starting again. The first few merges take the longest; after that most of the list is rows you recognise.

Make next month shorter

After the pass, count how many rows were unmatched at the start and how many are left. If your rules and aliases are working, the list should shrink with every import. Keep a short note of the payees you decided to leave as one-offs so you are not tempted to write a rule for them.

SPENDIXAI JOURNAL

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

Explore your reports