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		Connector level
API configurable		API configuration
Priority-first sync
Fivetran data models		Get the models: source / transform; Supports Quickstart data models
Private networking
Authorization via API

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 connectors.

To zoom, open the ERD in a new window.

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 connector.

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.