Xero Bank Rules: Automate Transaction Categorisation

Xero Bank Rules: Automate Your Transaction Categorisation

Bank rules are one of Xero's most powerful features, yet many users either do not know about them or underutilise them. A well-configured set of bank rules can automatically categorise 50-70% of your transactions, dramatically reducing reconciliation time.

What Are Bank Rules?

A bank rule is an instruction that tells Xero: "When you see a transaction that matches these criteria, categorise it automatically." For example: "Any transaction from Telstra should go to the Phone and Internet expense account with GST on Expenses."

When a matching transaction comes through your bank feed, Xero applies the rule and presents the transaction as pre-categorised in your reconciliation screen. You just need to confirm it.

Creating Bank Rules

From the Reconciliation Screen

The easiest way to create a bank rule is from the reconciliation screen:

1. Categorise a transaction manually
2. Before clicking "OK," check the "Create Rule" option
3. Xero creates a rule based on the transaction details

From Bank Rules Settings

For more control, navigate to Accounting then Bank Accounts, select your account, and click "Bank Rules."

Here you can:

• View all existing rules
• Edit rule conditions
• Set rule priorities
• Create new rules from scratch

Rule Conditions

Each rule can match on:

Payee - The name or description from your bank feed. Use "contains" for partial matches (e.g., "Telstra" will match "Telstra Corporation" and "Telstra Mobile").

Amount - Match specific amounts or ranges. Useful for fixed recurring charges.

Reference - Match based on the bank reference or description field.

You can combine conditions for more precise matching.

Rule Actions

When a rule matches, it can:

• Assign an account code (expense category)
• Set the tax rate
• Assign a contact (supplier or customer)
• Set a description
• Assign tracking categories
• Split across multiple accounts

Best Practices for Bank Rules

Start with High-Frequency Transactions

Look at your last three months of bank transactions. Which suppliers, bills, and income sources appear most frequently? Create rules for those first.

Common candidates:

• Rent payments
• Phone and internet bills
• Insurance premiums
• Subscription services (software, memberships)
• Utility bills
• Regular supplier payments
• Bank fees and charges

Be Specific Enough

Make your rules specific enough to avoid false matches. A rule that matches any transaction containing "Insurance" might catch insurance claim payouts as well as insurance premium payments - which should go to different accounts.

Use multiple conditions when needed. For example: payee contains "QBE" AND amount equals "$450" to match your specific quarterly insurance premium.

Do Not Be Too Specific

Conversely, do not make rules so specific that they miss legitimate matches. A rule that matches exactly "$412.50" from "Telstra Pty Ltd" will not match if Telstra's charges change by a dollar or if the bank describes them slightly differently.

Find the balance between specificity and flexibility.

Review Rules Periodically

Business expenses change. You might switch suppliers, add new subscriptions, or cancel services. Review your bank rules quarterly and remove or update any that are no longer relevant.

Use Suggested Rules

Xero suggests rules based on how you have categorised similar transactions in the past. These suggestions appear in the reconciliation screen. If a suggestion is accurate, accept it and create the rule to save time on future transactions.

Going Beyond Bank Rules with AI

Bank rules are powerful but have limitations:

• They only work for transactions that match specific patterns
• New or unusual transactions are not covered
• You need to create and maintain rules manually
• Complex scenarios require multiple conditions

This is where AI-powered categorisation adds value. Tools like SortBooks use machine learning to categorise transactions that bank rules miss. The AI learns from your entire transaction history - not just pre-defined rules - and understands context that simple pattern matching cannot.

For example, a bank rule might categorise all payments to "Bunnings" as "Materials." But the AI knows that in your consulting business, a Bunnings purchase is more likely "Office Supplies." It adapts based on your specific business context.

The combination of bank rules (for predictable, recurring transactions) and AI (for everything else) creates a system where the vast majority of transactions are categorised automatically, leaving you to handle only the genuine exceptions.

Measuring Your Automation Rate

Track how many transactions you are manually categorising each month. As you add bank rules and automation tools, this number should steadily decrease. A well-optimised system automates 80-95% of transactions, leaving you with just the unusual items that genuinely need human judgment.

Troubleshooting Bank Rules

Rule is not matching: Check the payee spelling in the rule against how it actually appears in your bank feed. Bank feeds sometimes abbreviate or format names differently than you expect.

Rule matching the wrong transactions: Your conditions are too broad. Add more specific conditions or use the "does not contain" option to exclude certain matches.

Multiple rules matching the same transaction: Xero applies rules in priority order. Drag rules to reorder them so more specific rules are checked first.

Rule applied incorrectly: You can undo a rule match in the reconciliation screen and recategorise manually. Then edit the rule to prevent the same issue in future.

Bank rules are a foundational tool for efficient bookkeeping in Xero. Combined with AI-powered automation, they transform reconciliation from a tedious manual process into a quick review-and-confirm workflow. The time you invest in setting up good rules pays back many times over.