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
API configurable		API configuration
Priority-first sync
Fivetran data models		Get the model; Supports Quickstart data models
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.

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.