How to Connect Xero to Your Reconciliation Tool: A Step-by-Step Guide

Connecting your accounting software to a reconciliation tool is one of those tasks that sounds technical but is actually straightforward — as long as you know what you are authorising and what happens afterwards. This guide explains the connection process, the data involved, and the safeguards you should expect.

How Xero Integrations Work: OAuth 2.0

Xero uses OAuth 2.0 for third-party integrations. When you connect an external tool to Xero, you are redirected to Xero's authorisation page, where you log in and grant access. Xero then issues an access token to the third-party tool — it never shares your password.

You control which Xero organisation the tool can access, and you can revoke access at any time from Xero's Connected Apps settings. The integration is entirely reversible.

What Data Does a Reconciliation Tool Pull from Xero?

A reconciliation tool typically requests access to: your chart of accounts (GL account list), manual journal entries, invoices, and bank transactions. It uses this data to compare Xero's recorded balances against your internal schedules — prepayment amortisation tables, accrual registers, and so on.

• Chart of accounts — account codes, names, and types
• Manual journals — the debit/credit entries your team posts for amortisation and accruals
• Invoices — sales and purchase invoices that affect balance sheet accounts
• Bank transactions — payments and receipts reconciled to bank statements

Read-Only Access: Why It Matters

A well-designed reconciliation tool should request read-only access. This means it can see your Xero data but cannot create, edit, or delete anything in Xero. Your source ledger is protected. If a reconciliation tool asks for write access and you do not understand why, that is a red flag worth questioning.

Step-by-Step: What to Expect When Connecting

• 1. In your reconciliation tool, navigate to Integrations or Settings and select Xero
• 2. Click "Connect" — you will be redirected to the Xero authorisation page
• 3. Log in to Xero and select which organisation to connect (if you have multiple)
• 4. Review the permissions requested (check for read-only scope)
• 5. Click Authorise — you are redirected back to the reconciliation tool
• 6. The tool performs an initial sync, pulling your chart of accounts and recent transactions
• 7. You select which GL accounts to map and begin reconciling

What to Check Before You Connect

• Your Xero chart of accounts is clean and consistently coded — messy account names make mapping harder
• You have the right Xero role (Standard or Adviser) to authorise integrations
• Your organisation's IT or compliance policy permits third-party integrations (relevant for larger UK businesses or those under FRS 102 audit)
• You understand what data will be synced and how it will be stored

After Connecting: The Initial Sync

The first sync imports your chart of accounts and a history of transactions. Depending on how much data you have, this can take a few minutes. After the initial sync, the tool will show you your Xero GL balances alongside your internal schedules — and you can begin identifying variances.