Reconciliation is a control, not a clicking exercise
Xero presents bank statement lines on one side and proposed accounting transactions on the other. The user matches an existing transaction or creates the required accounting entry. The goal is to ensure every bank movement is recorded once, in the correct account and period, with appropriate GST and supporting evidence. A screen showing “reconciled” does not prove the ledger is correct if duplicates, omissions or incorrect coding remain.
Before starting, confirm that the bank feed covers the complete period and that the opening statement balance agrees to Xero. If the feed began late, import missing statement lines. Avoid importing the same period twice. Each real bank account and credit card should have its own Xero account and should be reconciled to an external statement at month-end.
Match existing transactions before creating new ones
When a sales invoice, bill, expense claim or transfer already exists, match the bank statement line to that transaction. Creating a new “spend money” or “receive money” entry instead can duplicate revenue or expenses while leaving the invoice unpaid. Review suggested matches carefully, especially where amounts repeat or several invoices make up one payment.
For transfers, reconcile both sides as transfers between the relevant bank accounts. For loan receipts or repayments, separate principal and interest according to the supporting statement. Payroll payments should match the payroll clearing or payable workflow rather than being coded directly to wages without checking the payroll journal.
Use bank rules with controlled scope
Bank rules can speed up recurring transactions by suggesting accounts, descriptions and tax rates. They should be narrow enough to avoid false matches. Use clear conditions based on payee, reference and amount patterns, and test the rule before applying it to multiple lines. Review old rules periodically because suppliers, subscriptions and GST treatment can change.
Do not use bank rules for complex transactions such as mixed private expenses, loan repayments, asset purchases, overseas transactions or payments requiring invoice matching. Automation is most valuable for stable, low-risk transactions. The more judgement a transaction requires, the more important it is to preserve human review.
Investigate unreconciled and duplicate items
At month-end, run the bank reconciliation report and compare the Xero statement balance with the actual bank statement. Investigate missing statement lines, duplicated imports, manually entered transactions that have not cleared, deleted items and timing differences. Old unreconciled entries can indicate duplicated expenses, unpresented payments, incorrect opening balances or transactions entered in the wrong bank account.
Review the account transactions report for manual postings and the history and notes where necessary. Confirm that payments through Stripe, PayPal, Shopify or other gateways are reconciled through a clearing account so gross sales, fees and net deposits are recorded correctly.
Complete a monthly quality review
After the bank agrees, scan transactions for uncategorised accounts, inconsistent GST, missing attachments, unusual descriptions and large or round-dollar entries. Reconcile credit cards, loans and cash accounts as well as the main bank. Compare total receipts and payments with expectations and follow up unexplained movements.
Lock completed periods only after GST and month-end review. Record recurring issues and update bank rules or coding guidance. Xero’s speed is valuable, but reliable books come from combining the software’s matching tools with disciplined evidence, reconciliation and reviewer oversight.