Bank rules explained: sorting repeat transactions automatically

A bank rule is a saved instruction: if a bank line looks like this, sort it like that. It saves retyping the same choice for rent, fees, subscriptions and other repeat payments.

What a rule contains

Names vary by product, so here's Zoho Books as one example. Its help says transaction rules identify and categorise bank transactions based on criteria you've set¹.

• A name for the rule.
• Whether it applies to money in or money out.
• One or more conditions on the payee, the description, a reference number or the amount.
• Whether all the conditions must match, or any one of them¹.
• What to do: which account to use, and how to record the line.

Text conditions can be strict or loose. In Zoho Books, "is" means an exact match, while "contains" means the field can contain any part of the criteria¹. Loose conditions catch more lines, and that's where trouble starts.

When a rule applies without you

Some products let you pick whether a rule only suggests, or goes ahead on its own. Zoho Books gives two choices. Recognized Transactions is for when you want to categorise your bank statements manually. Categorised Transactions is for when you want the software to categorise based on the rule¹.

Suggest-only is the slower, safer starting point. Watch what a new rule does for a few weeks before you let it run alone.

What can go wrong

• Too loose. A condition that matches a short word can pick up lines you never meant. A rule for "fuel" might catch a payment to a supplier whose name contains it.
• Descriptions change. The text the bank shows may differ from the name you expect. One reference notes that a card line's description may not always match a business's trading name². A rule built on one wording may miss the next.
• Wrong account. A rule applies your choice every time, including your mistakes. Check the first few results.
• Two rules overlap. Two rules could fit one line. Read your product's help to learn which one wins.
• Old rules left on. A supplier you've stopped using, or an account you've closed, still has a rule.

Changing a rule later may not undo earlier results. Zoho Books says lines already categorised by a deleted rule are not affected¹.

Rules and fees

Bank charges and interest are good candidates. Business Central's manual notes that such lines can't be matched at first. There's no related ledger entry, so you create one by posting a journal line³. A rule that records those lines the same way each time removes a repeated chore.

Rules aren't tax advice

A rule picks an account. It doesn't decide whether something is a business expense or how it's treated for tax. Ask your accountant, or your tax authority such as the ATO, HMRC or the IRS, how to treat a type of payment.

Related: how automatic matching works, and what a full month-end session looks like.