Bank reconciliation — matching your bank statement transactions to the invoices and payments in your accounting software — used to require sitting down with a printed statement and working through it line by line. Modern accounting software with AI has made this largely automatic. This guide explains how to set it up properly in Sage Accounting and Xero so that reconciliation takes minutes rather than hours each month.
How AI Bank Reconciliation Works
The AI matching engine in accounting software compares each transaction imported from your bank feed against the unmatched transactions in your ledger — invoices raised, bills posted, payments made — and suggests the most likely match based on amount, date, supplier name and reference. You confirm the match or correct it. Over time, the AI learns your patterns and the proportion of transactions it can match automatically increases.
The components that make this work are: a live bank feed connection, correctly posted invoices and bills in the accounting software, and bank rules for recurring transactions. Get all three right and reconciliation becomes a review process rather than a data entry task.
Setting Up Bank Reconciliation in Sage Accounting
Step 1: Connect your bank feed
In Sage Accounting, go to Banking then Add a bank account. Search for your bank — most major UK banks are supported including Barclays, HSBC, NatWest, Lloyds, Santander and Starling. Follow the authentication steps to authorise Sage to read your transaction data. Once connected, transactions import automatically each day.
If your bank is not supported for automatic feeds, you can import transactions manually by downloading a CSV or OFX file from your online banking and uploading it to Sage. This is less convenient but provides the same matching functionality.
Step 2: Create bank rules for recurring transactions
Bank rules are the most powerful time-saving feature in Sage’s reconciliation. They automatically categorise transactions that match specific criteria — saving you from manually coding the same transactions every month.
In Sage Accounting, go to Banking → Bank Rules → Add a rule. A useful rule might be: When the transaction description contains “HMRC PAYE”, always code to Wages and Salaries (Nominal 7000) and mark as a payment to HMRC. Or: When the reference contains “DIRECT DEBIT XERO”, always code to Software subscriptions.
Set up rules for your top 10–15 recurring direct debits and standing orders first. These are the transactions that appear every month with consistent descriptions — subscriptions, utilities, rent, loan repayments. Once rules are in place, these match and categorise automatically without any human review.
Step 3: Run reconciliation
In Sage Accounting, go to Banking and open the account you want to reconcile. You will see imported bank transactions on one side and unmatched ledger transactions on the other. Sage suggests matches — transactions where the amount and approximate date align with a posted invoice or payment. Click Match to confirm a suggestion or select the correct ledger transaction manually if the suggestion is wrong.
Transactions with bank rules applied will already be categorised and may post automatically. Transactions with no match need to be either matched to an existing ledger item or coded as a new transaction (for items not yet in the ledger, such as a bank charge or interest payment).
Step 4: Investigate unmatched items
Any transaction remaining unmatched after AI matching and rules application needs attention. Common reasons include: an invoice posted with the wrong amount, a payment received against the wrong customer, a bank charge not yet coded, or a payment that has not yet been invoiced. Work through these systematically — do not leave unmatched items to accumulate, as they make future reconciliation harder and can mask errors.
Setting Up Bank Reconciliation in Xero
Step 1: Connect your bank feed
In Xero, go to Accounting → Bank accounts → Add bank account. Xero supports direct feeds from most UK banks. Select your bank, follow the authorisation process and your transactions will begin importing. Xero also supports Yodlee and other open banking connections for banks not directly integrated.
Step 2: Create bank rules in Xero
In Xero, bank rules are called Bank rules under the reconciliation screen. Click Create rule and set the conditions. Xero’s rule builder is flexible — you can match on payee name, description contains, description starts with, amount range, or transaction type (debit or credit).
For each rule you define the action: code to a specific account, set the tax rate, set the payee, and optionally auto-reconcile (post without requiring human confirmation). Auto-reconcile is useful for low-value, high-confidence transactions like small bank charges — use it selectively and check the results initially before applying it widely.
Step 3: Use the reconciliation screen
Xero’s reconciliation screen presents bank transactions and suggests matches from the ledger on the right. The AI suggestions use amount matching combined with contact name matching and date proximity. For invoices and bills already in Xero, the match rate is typically very high. Click OK to confirm a match, or Find & match to search for the correct item if the suggested match is wrong.
Transactions already processed by Hubdoc or Dext will appear in Xero as bills awaiting payment — when the payment appears in the bank feed, Xero matches the bank transaction to the bill automatically in most cases.
Tips for Getting the Most From AI Matching
- Post invoices and bills promptly. AI matching works best when the corresponding ledger transaction exists before the bank payment arrives. Posting bills on receipt rather than when you pay them dramatically improves automatic match rates.
- Use consistent supplier names. If the same supplier appears as “BT PLC”, “BT GROUP” and “British Telecom” in your bank statements at different times, the AI will not always match them to the same supplier record. Standardising supplier names in your rules improves consistency.
- Set payment references on bank transfers. When making payments via bank transfer, using the invoice number as the payment reference allows automatic matching even when the amounts are aggregated.
- Review suggested matches rather than auto-approving everything. AI matching is accurate but not perfect. Spot-checking suggested matches, especially for new suppliers or unusual amounts, catches errors before they embed in your ledger.
- Reconcile frequently. Weekly reconciliation takes 10–20 minutes for a typical small business. Monthly reconciliation for the same business takes significantly longer because more unmatched items accumulate and the trail goes cold.
Related Guides
- AI Accounts Payable: How to Automate Purchase Invoice Processing
- Dext vs Hubdoc vs AutoEntry: Best Invoice Capture Software UK 2026
- Sage Accounting Review UK 2026
- Best Accounting Software UK 2026
