AI and MCP

Create categorisation rules for your small business by chatting

How a small business owner can ask an assistant for categorisation rules for courier, supplier and utility payments, test them, and keep books tidy.

Editorial illustration for Create categorisation rules for your small business by chatting

Roughly twenty payees repeat month after month in a small business: the courier, the main supplier, the electricity bill, the accountant. Writing a rule for each means they land in the right category on arrival, and your month-end shrinks from an afternoon to a quick scan. You can ask a connected assistant to draft the rules, as long as you test them.

Pick the payees worth a rule

Scan three months of transactions and list payees that appear at least three times with the same purpose. A courier, a regular raw material supplier, a utility, a software subscription and your accountant's fees are typical. One-off purchases do not deserve rules.

Worked example: courier charges

Say a month shows nine courier rows: ₹120, ₹95, ₹240, ₹180, ₹60, ₹310, ₹150, ₹85 and ₹200. The total is 120 + 95 = 215, plus 240 = 455, plus 180 = 635, plus 60 = 695, plus 310 = 1,005, plus 150 = 1,155, plus 85 = 1,240, plus 200 = 1,440. A rule on the courier's name filed under Logistics catches all nine, so the Logistics line should show ₹1,440 for the month.

Payee typeWording to testCategory
Couriercontains the courier's nameLogistics
Main suppliercontains the supplier's nameRaw material or stock
Electricitycontains ELECTRICITYUtilities
Accountantcontains the firm's nameProfessional fees

Steps for the chat

  1. Connect your assistant with a read-only scope first. SpendixAI lets you choose and disconnect at any time.
  2. Ask for the transactions that match each payee wording and compare with your own list.
  3. Ask it to summarise the total, so you can compare it with your sum above.
  4. Create each rule, or make it in the app if your connection cannot write.
  5. Import a fresh statement and confirm the rules fired.

When one payee has two purposes

The same supplier may sell you stock and also fix your shop shutters. A single rule would file both as stock. Handle it by leaving the odd ones for manual review, or by using the sub-categories you have defined. SpendixAI allows custom categories and sub-categories, each with its own GST rate, ITC-eligible and tax-deductible settings and accounting code, so decide with your accountant how to split before you build rules.

What rules cannot do

  • They cannot tell a personal purchase from a business one if the narration is identical.
  • They do not replace your judgement about cash expenses, which you add by hand.
  • They will not fix an old month unless you ask for them to be applied to existing rows. Ask how your tool treats existing transactions.
  • They need pruning. A supplier you stopped using still has a rule.

Rules and your accountant's chart of accounts

Ask your accountant for the ledger names they expect, then name your categories to match, with the accounting code on each. A rule that files courier charges under Logistics is more useful if Logistics maps to the same ledger your accountant uses in Tally, Zoho Books or QuickBooks. Settling names once avoids a mapping exercise at every export.

  • Agree ledger names before building more than a handful of rules.
  • Keep one category per ledger where you can.
  • Revisit names when your business adds a new line of work.

Monthly upkeep

  • Clear unmatched rows first and ask whether any repeat enough to deserve a rule.
  • Add one or two rules a month rather than thirty at once.
  • Look at the sub-category totals against your budget.
  • Back up by exporting the categories-and-tax-codes file after major changes.
SPENDIXAI JOURNAL

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

Explore your reports