Xero

Xero provides cloud accounting services and includes a cashbook, automated daily bank feeds, invoicing, debtors, creditors, sales tax and reporting.

Features

Feature Name	Supported	Notes
Capture deletes		`ACCOUNT`, `BANK_TRANSACTION`, `CONTACT`, `INVOICE`, `MANUAL_JOURNALS`, `PAYMENTS`, and `TAX STATUS` tables. Child tables support deletes through weak primary keys.
History mode
Custom data
Data blocking		Column level
Column hashing
Re-sync		Connection level
Row filtering
API configurable		API configuration
Priority-first sync
Fivetran data models		Model details
Private networking
Authorization via API

Supported deployment models

We support the SaaS Deployment model for the connector.

Setup guide

Follow our step-by-step Xero setup guide to connect Xero with your destination using Fivetran connectors.

Sync overview

We re-import the following tables during every sync:

ASSET
ASSET_TYPE
BRANDING_THEME
CURRENCY
ORGANIZATION
SETTINGS
TAX_RATE
TAX_RATE_COMPONENT
TRACKING_CATEGORY
TRACKING_CATEGORY_HAS_OPTION
TRACKING_CATEGORY_OPTION

We re-import the following tables once a day:

CONTACT
CONTACT_ADDRESS
CONTACT_GROUP_MEMBER

Schema information

This schema applies to all Xero connections.

Explore Xero schema ERD

Sync note

Xero limits the number of active connections to 25 for an uncertified app. We recommend that you don't have more than 24 active connections per uncertified app to avoid connection limit exceeded errors while re-authorizing the connection.

Migrate to new authentication

This is not applicable to connections using a certified app that is not managed by Fivetran.

Fivetran is updating the authentication methods supported by the Xero connector. The following migration scenarios depend on both your current authentication method and the region of your Xero organization:

Connections authenticated through the Fivetran-managed app, for Xero organizations based in Australia, New Zealand, the United Kingdom, or the United States must migrate to Custom connection. However, Fivetran-managed app connections outside these supported regions must now reauthenticate using the Web app.
Connections authenticated through the Web app can now opt to use Custom connections to reauthenticate if their Xero organization is located in Australia, New Zealand, the UK, or the US. However, it is not mandatory to migrate their connection to the new authentication method.
Connections authenticated through the Web app, and located outside the supported regions do not have to migrate their connection.

You must migrate all existing Xero connections that use the Fivetran-managed app to a Custom connection app or Web app before March 2, 2026. Only existing connections authenticated through the Fivetran-managed app that are not migrated by this date will stop syncing data. It is optional for the Web app connections based in Australia, New Zealand, the United Kingdom, or the United States to migrate to a Custom connection app.

Who needs to migrate

Existing connections that use a Fivetran-managed app for authentication must migrate to a Custom connection app or Web app. Depending on your Xero account region, you must do one of the following:

If your Xero organization belongs to Australia, New Zealand, the United Kingdom, or the United States, migrate to Custom connection.
If your Xero organization belongs to any other region, migrate to a Web app.

Optionally, existing connections authenticated through Web apps and associated with Xero accounts belonging to Australia, New Zealand, the United Kingdom, or the United States can also migrate.

Migration options

Choose one of the following options based on your current authentication method and region.

Option 1: Migrate to Custom connection

This option is available only for existing connections that authenticate using the Fivetran-managed app or Web app, where the Xero organization is located in Australia, New Zealand, the United Kingdom, or the United States. It is not applicable to connections using the Fivetran-managed app outside these regions.

Log in to your Fivetran dashboard and click Connections.
Select the connection that requires migration.
Go to the Setup tab and click Edit connection.
Follow the Custom connection setup instructions to reauthenticate.

Option 2: Migrate to Web app

All connections outside the supported regions (AU, NZ, UK, or US) using the Fivetran-managed app must migrate to the Web app authentication before March 2, 2026, to avoid interruptions in syncing your Xero data.

Log in to your Fivetran dashboard and click Connections.
Select the connection that requires migration.
Go to the Setup tab and click Edit connection.
Follow our Web app setup instructions to reauthenticate.

Limitations

We only support the Australian (AU-based) Payroll API endpoints.
Xero does not update the UpdatedDateUTC field on the invoice_line_item table or other related tables when the accountCode field is modified. If you need updated historical data for the accountCode field, you must trigger a full re-sync of the connection.

UTC conversion

We don't convert source timestamps to Universal Time Coordinated (UTC) but use the Xero account's time zone to store the data in your destination.