Expense categories

Clear the uncategorised pile fast, without editing every row

Gig workers and freelancers can clear hundreds of uncategorised transactions by sorting by amount and merchant, writing rules and reviewing the leftovers.

Editorial illustration for Clear the uncategorised pile fast, without editing every row

Do not fix uncategorised rows one at a time. Sort them by amount, handle the biggest first, group the rest by merchant, and turn each repeating merchant into a rule so future rows sort themselves. For a delivery partner, driver or freelancer with hundreds of small credits and debits a month, this turns an evening of clicking into about twenty minutes.

Why do the reports lie while rows are uncategorised?

An uncategorised row is counted somewhere, usually as a lump called Other or Uncategorised. If that lump is large, your fuel, phone, food and platform fees all hide inside it and every other category looks smaller than it is. Your income can also look wrong, because platform payouts and customer tips arrive as credits with similar narrations.

Worked example: 140 rows in a messy month

Say you have 140 uncategorised rows worth ₹52,400 in total. You sort by amount and find the ten largest rows hold ₹31,000, which is about 59 per cent of the money. You then group the remaining 130 rows by merchant and find that six merchants account for 96 of them: a fuel pump, a mobile recharge, a tea stall, a vehicle workshop, a food delivery app and a parking operator.

StepRows handledRows left
Fix the ten largest rows by hand10130
Write rules for the six repeating merchants9634
Clear the long tail by hand340

Check: 10 plus 96 plus 34 is 140. You have made ten careful decisions, written six rules and reviewed 34 odd rows, instead of touching 140.

What are the steps?

  1. Sort uncategorised rows by amount, largest first, and categorise those yourself. Large rows need your judgment.
  2. Group the rest by merchant or narration. Anything appearing four or more times deserves a rule.
  3. Write a rule per merchant: fuel pump equals Fuel, recharge equals Phone and data, workshop equals Vehicle upkeep.
  4. Separate income. Platform payouts go to Income by platform, tips and direct UPI from customers to a second income category.
  5. Review the remainder once and mark one-off rows with the best available category.

How does an app help with the leftovers?

SpendixAI categorises in stages: your own rules first, then your history and similar merchants, and then, only if AI is switched on, an AI model for what is left. Corrections become history, so a row you fix today helps tomorrow's import. If AI is off, unmatched items are held for review, which is the queue you work through after the rules have done their share. You can also add merchant aliases so the same shop under different narrations is treated as one.

How do you keep the pile from growing back?

Set a fixed slot, ten minutes after you import each week, not a heroic monthly session. A weekly import means each batch is small, and the rules you wrote last month already cover most of it. Review only what remains, then stop.

Also keep your cash business in the habit. Tips in cash, a quick tea paid in notes, parking collected by hand: add these the same day, in a single entry if you must, because they never appear in a bank file and are the hardest to reconstruct.

A short checklist

  • Biggest rows first, then merchants, then the long tail.
  • One rule per repeating merchant.
  • Income categories kept separate from expense ones.
  • Cash entries added the day they happen.
  • A weekly ten-minute slot, not a monthly marathon.
SPENDIXAI JOURNAL

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

Explore your reports