Xero bank rules can speed up repetitive bookkeeping by suggesting how familiar bank transactions should be recorded. A carefully designed rule can save time; a vague or incorrect rule can repeat the same mistake across many transactions.
What is a bank rule in Xero?
A bank rule looks for information in an imported statement line—such as a payee, reference or amount—and prepares a transaction using instructions you have set. It is particularly useful for regular payments whose bookkeeping treatment does not change.
A recurring software subscription paid to the same supplier with consistent evidence.
A retailer where purchases could belong to several different expense categories or have different VAT treatments.
How to create a bank rule in Xero
1. Start from a genuine statement line
Open the appropriate bank account and its reconciliation screen. Choose a representative transaction that you understand and for which supporting evidence is available.
2. Choose the rule direction
Select whether the rule applies to money spent or money received. This matters because the information required for receipts and payments is different.
3. Define the matching condition
Use a specific condition such as “payee equals” or “reference contains”. Avoid very short fragments that could match unrelated suppliers.
4. Set the contact and description
Choose a consistent contact and a useful description. Clear descriptions make later reviews easier than repeating a generic phrase such as “bank payment”.
5. Select the appropriate account category
The category should reflect what the transaction actually represents. Do not rely only on the supplier’s trading name, because one supplier may provide different types of goods or services.
6. Review the VAT treatment
Never use a default VAT rate simply because it is common. Check the invoice or receipt and make sure the treatment is appropriate for the transaction and the business.
7. Name, test and save the rule
Give the rule a name that another person could understand. Test it against a small number of suitable statement lines before relying on it more widely.
How to review an existing bank rule
- Check whether it matches only the intended supplier or customer.
- Confirm the description remains helpful.
- Review the account category and VAT treatment.
- Look for changes in the supplier’s service or invoice format.
- Disable or edit rules that produce incorrect suggestions.
Common bank-rule mistakes
Making the condition too broad
A broad word such as “shop” or “payment” may capture unrelated transactions. Use the clearest reliable identifier available.
Splitting transactions without evidence
Only use fixed or percentage splits when they consistently reflect the underlying documents.
Assuming every transaction is identical
Similar bank descriptions do not guarantee identical bookkeeping treatment. Review exceptions rather than forcing them through the rule.
Forgetting old rules
Rules should be reviewed periodically, especially when suppliers, subscriptions, VAT status or business activities change.
When bank rules are most useful
They can work well for regular subscriptions, bank charges, predictable transfers and consistent customer receipts. They are less suitable for mixed retailers, unusual purchases, cash withdrawals and transactions lacking evidence.
Related Xero bookkeeping guides
First read our Xero bank reconciliation guide. This guide will also link to our forthcoming bank-import and software-comparison pages.
Would you like your Xero bookkeeping reviewed?
Real Key Accountancy supports sole traders and small businesses with bookkeeping and computerised accountancy systems in Wolverhampton and the West Midlands.
Frequently asked questions
Do bank rules reconcile transactions automatically?
They can prepare or apply a suggested treatment depending on the available Xero features, but the result should still be checked.
Can I edit a bank rule later?
Yes. Review and amend rules when the matching condition or bookkeeping treatment is no longer appropriate.
Should I create a rule for every supplier?
No. Use rules only where transactions are sufficiently consistent and supported by reliable records.
Xero is a trademark of Xero Limited. Real Key Accountancy is not affiliated with or endorsed by Xero Limited. Interface illustrations are original examples and may differ from the current software.