Overview
Bank reconciliation is one of the most time-consuming bookkeeping tasks — and one of the most automatable. Xero's bank rules engine learns your recurring transactions and automatically matches them to the right accounts. This guide covers setting up bank rules for your most common transactions and layering in Hubdoc integration for receipt matching.
Before you start
- Xero account (any paid plan)
- Bank account connected to Xero via direct feed or import
- Hubdoc account (included in Xero plans)
- Receipts and invoices accessible via email
Step-by-step guide (5 steps)
Connect your bank accounts to Xero
In Xero, go to Accounting > Bank Accounts > Add Bank Account. Search for your bank and connect via direct feed or import. Xero supports direct feeds for most major banks — transactions import automatically daily.
Create bank rules for recurring transactions
Go to Accounting > Bank Accounts > your account > Manage > Bank Rules. Create rules for your most common transactions: rent, utilities, payroll, subscriptions. Set the rule: 'If description contains [payee name] → Categorize as [expense account].' Start with your top 10-15 recurring expenses.
Use 'Contains' rather than 'Exactly matches' for your bank rule conditions — payee names vary slightly between transactions.
Set up automatic receipt matching with Hubdoc
Connect Hubdoc (Xero's document capture tool) to your email. Forward receipts to your Hubdoc email address or set up automatic fetching from supplier email inboxes. Hubdoc OCRs the receipt and pushes it to Xero, pre-matched to the corresponding transaction.
Run a reconciliation session
With bank rules active, open Xero's bank reconciliation view. Most transactions will be auto-matched with a suggested account code. Review and accept in bulk — this typically takes 10-15 minutes instead of 2-3 hours.
Review monthly for new recurring transactions
Once a month, review any transactions that weren't auto-matched. Create bank rules for the new ones. After 3-4 months, 80-90% of transactions will be auto-coded and require just a quick review.
What you'll get
Reconciliation goes from hours to minutes weekly
Transactions coded consistently — no more categorization errors
Receipt matching eliminates the 'find that receipt' scramble at tax time
Accountant can review real-time data instead of waiting for month-end
Common mistakes to avoid
Creating bank rules that are too broad (matching transactions they shouldn't)
Not reviewing auto-matched transactions at all (errors accumulate)
Connecting the wrong bank account in Xero (causes duplicate transactions)
Frequently asked questions
Do I need coding experience to set up this Xero automation?
No coding is required. This guide walks you through everything using Xero's built-in features and Zapier's visual interface. If you can follow a recipe, you can follow this guide.
How long does this automation take to set up?
Most users complete this setup in 30–60 minutes on their first try. Once set up, it runs completely automatically with zero ongoing effort.
What happens if the automation fails?
Zapier and Make both have error notifications and task history, so you'll know immediately if something goes wrong. We cover troubleshooting steps in the guide above.
Can I customize this automation for my specific business?
Absolutely. The guide includes notes on common customizations. Most automations have multiple variation points — timing, conditions, notification recipients, and more.