Bank Rules: Helpful Until They Quietly Aren’t

Bank rules are the best labour-saving feature in modern accounting software and the most common source of large, invisible errors. Both things are true for the same reason: they apply a decision at scale without asking again.

Where they genuinely earn their keep

Rules work when the categorisation is unambiguous and stable. The monthly rent payment. The utility bill. The software subscription that has been the same amount to the same vendor for two years.

For these, a rule removes a decision that had exactly one right answer. That is pure gain.

Where they cause damage

Vendors that sell more than one thing. A rule sending every charge from a large general retailer to Office Supplies will be wrong every time that vendor sold you something else — equipment, materials, a personal item. The rule does not know the difference and will never flag one.

Rules matching on partial descriptions. A rule keyed on a short string will catch transactions nobody intended. Bank descriptions are inconsistent and change without notice.

Rules that auto-post. Most software distinguishes between a rule that suggests a category and one that records the transaction without review. The second is where the real risk lives. Auto-posting means transactions enter the books without a human ever seeing them — which is fine until the rule is wrong, and then it is hundreds of entries deep before anyone notices.

The compounding problem

A misapplied rule does not produce one wrong entry. It produces a consistent, plausible-looking pattern.

That is what makes it hard to spot. A single miscoded transaction looks odd in a report. Four hundred consistently miscoded transactions look like a category that is simply larger than you thought. The error blends into the baseline, and the year-over-year comparison normalises it.

Rules also survive changes in the business. One set up when a vendor supplied one thing keeps firing after they start supplying something else. Nobody revisits rules; they are set up once during a tidy-up and then forgotten.

How to use them safely

Suggest, do not auto-post, except for a small number of genuinely fixed transactions.

Be specific in the match. Match on the full vendor identifier, and where the software allows it, add an amount condition. A rule that only fires on the exact recurring amount will not catch the unusual purchase.

Review the rule list twice a year. Delete anything for a vendor you no longer use, and check the ones that fire most often. Ten minutes.

Watch the categories rules feed. If an account is growing steadily and nobody can say why, check whether a rule is pointing at it.

Finding damage already done

Sort your largest expense accounts by transaction count rather than amount. An account with an unusually high count of identical or near-identical entries from one vendor is the signature.

Then spot-check five of them against the actual receipts. If three are wrong, the rule has been wrong the whole time, and the fix is to correct the rule first and then the history — in that order, or you will be re-fixing the same transactions next month.

This is a routine finding in a cleanup, and configuring rules conservatively is part of how we do setup. Automation is worth having. It is just worth pointing at the transactions that genuinely have one right answer.