AI and MCP

Creating categorisation rules by chatting: a guide for accountants

How accountants can use an assistant to draft categorisation rules for client books, test them against history, and keep rule sets consistent and auditable.

Editorial illustration for Creating categorisation rules by chatting: a guide for accountants

For an accountant, a categorisation rule is a bit of policy. It decides how a recurring narration is coded in a client's books, every period, without anyone looking. Drafting rules by chat with an assistant is quick; the discipline is testing each one against history and recording why it exists.

Why rules need more care in practice

A client will not notice a wrong rule until the quarter's figures look off. By then it has filed hundreds of rows. Treat each rule as a small piece of policy that needs a reason, a test and an owner.

A drafting and testing routine

  1. Pull the client's last quarter of imported transactions. Make sure each was imported against the right account.
  2. Ask the assistant for the ten most frequent narrations and their current categories. Connect read-only first. SpendixAI lets you choose the scope and disconnect at any time.
  3. For each candidate, ask for every historic row that would match the proposed wording.
  4. Count the matches and compare them with the rows you would code the same way by hand.
  5. Create the rule only when the match set is clean.
  6. Add the reason in your working paper: pattern, category, date, who agreed.

Worked example: a pattern that is too broad

Say a client's rows include 38 narrations containing the word AMAZON. You test a rule that files them all as Office supplies. By hand, 24 rows worth ₹41,200 really are office supplies. The other 14 rows worth ₹9,800 are personal purchases or cloud service charges. All 38 together total 41,200 + 9,800 = ₹51,000, so the rule would put ₹9,800 in the wrong place.

TestRowsAmountVerdict
Rows that match the proposed rule38₹51,000Too broad
Correct under the rule24₹41,200Keep, with narrower wording
Wrong under the rule14₹9,800Needs different treatment

The fix is narrower patterns, or leaving the merchant to manual review and putting rules on the cleaner recurring payees instead.

Category settings that ride along

SpendixAI categories can carry a colour, a GST rate, ITC-eligible and tax-deductible settings and an accounting code. That is useful, because a rule that sets the category also brings those settings with it. It is also why a wrong rule is not just cosmetic. Reports estimate the GST inside spending, but those are estimates to confirm against invoices, and the treatment for any client is your call.

Keeping rule sets consistent across clients

  • Keep a master list of patterns you reuse, and copy only those that apply.
  • Never assume a pattern means the same thing for two clients. A word that is a business cost for one is a personal cost for another.
  • Review each client's rules at period end and remove the dead ones.
  • Corrections you make by hand become history, so correct promptly and consistently.
  • Export the categories-and-tax-codes file to keep a record of the setup.

Reviewing a rule set at period end

At period end, export the categories-and-tax-codes file and read the rules beside the categories they feed. Ask of each rule: did it fire this period, did anything it caught need correcting, and has the client's business changed? Retire any that fail. Two minutes per rule keeps a set of thirty honest.

  • A rule with no hits for six months is a candidate for removal.
  • Frequent manual corrections after a rule mean its wording is too broad.
  • Compare category totals with last period before and after any rule change, so an edit does not hide a real movement.

Confidentiality

A connected assistant, through MCP, sees what the scope allows. Use read-only for drafting and testing, create the final rules yourself in the app if you prefer, and disconnect afterwards. Tell clients you use one.

SPENDIXAI JOURNAL

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

Explore your reports