Bank Reconciliation Best Practices

Bank reconciliation is the single most important bookkeeping task for any business. It ensures every transaction in your bank account is accounted for in your books — and that your financial reports are accurate. Yet many SMEs let reconciliation slide for weeks or months, creating a mess at BAS time.

1. What Is Bank Reconciliation?

Bank reconciliation is the process of matching each transaction in your bank feed (deposits, withdrawals, transfers) against corresponding entries in your accounting software. In Xero, this means matching or creating transactions for every line in your bank feed until the balance is zero.

2. How Often Should You Reconcile?

The golden rule: never let reconciliation fall more than 2 weeks behind. The longer you wait, the harder it is to remember what each transaction was for.

3. The Reconciliation Process in Xero

1. Connect your bank feed: Xero automatically imports transactions from your bank (updated daily).
2. Match to existing entries: Xero suggests matches against invoices, bills, and transfers you've already created. Review and confirm each match.
3. Create new entries: For transactions without a match (e.g., bank fees, direct debits), create a new expense or income entry directly from the bank feed.
4. Use bank rules: Set up rules for recurring transactions (rent, subscriptions, bank fees) so Xero auto-categorises them.
5. Reconcile to zero: The goal is zero items waiting in your bank feed. All caught up.

4. Common Reconciliation Mistakes

• Leaving items unmatched: Don't skip transactions you don't recognise. Investigate every one — it could be a fraudulent charge or a legitimate expense you forgot about.
• Creating duplicates: If you manually enter an invoice AND match the bank feed to a new entry, you'll double-count income. Always check for existing entries first.
• Wrong GST treatment: Ensure each transaction has the correct GST code. A bank fee should be "No GST"; a supplier payment should include GST if they're registered.
• Ignoring credit cards: Your business credit card is a separate "bank account" in Xero. It must be reconciled separately.
• Not reconciling PayPal, Stripe, or Square: Every payment gateway used by your business needs its own feed and reconciliation.

5. What Happens If You Don't Reconcile?

• Inaccurate BAS: Your GST figures will be wrong, leading to overpayment or underpayment (and potential ATO penalties).
• Misleading financial reports: Your P&L and Balance Sheet won't reflect reality — you'll make decisions based on bad data.
• Missed deductions: Expenses that aren't recorded are deductions you'll never claim.
• Audit risk: The ATO can request your reconciliation records during an audit. Gaps raise red flags.