Note: Before connecting Retention Track with Xero you must have an existing Xero account.
Introduction
Connecting to Xero allows you to simplify the tracking and recovery of your retention money.
In this article we walk you through:
Connecting your Xero account to Retention Track
Connecting your Xero organisation to Retention Track
Linking a Company to a Xero organisation
Configuring tax type mappings (UK reverse charge / DRC only)
Catch-up flows for existing companies
Unlinking from Xero
How to set up the integration
1. Connecting your Xero account to Retention Track
Option 1: Sign up using Xero (recommended)
Option 1: Sign up using Xero (recommended)
If you don't already have a Retention Track account you are able to easily create an account by signing into Retention Track using your Xero account.
Once you've logged in we will automatically create a Retention Track workspace for you and link it directly to your Xero account.
Option 2: Linking your existing Retention Track account to Xero
Option 2: Linking your existing Retention Track account to Xero
Note: For security reasons we only allow you to link a Xero account to a Retention Track account if they share the same email address. If this is not the case you should use option 1.
If you already have a Retention Track account and wish to link your Xero account to it you can do so by navigating to your profile page through the profile icon in the top right of Retention Track.
Once you're on your profile page scroll to the integrations section and select "Connect to Xero".
Follow the steps from Xero and once completed you will be redirected back to Retention Track with your accounts successfully linked.
2. Connecting your Xero organisation to Retention Track
Once you've successfully linked your Xero account to Retention Track you will be able to add your Xero organisation to your account. This can be completed by selecting "Connect New Xero Organisation" in the "Your Profile" page. This will redirect you to Xero and prompt you to allow access to one of your Xero organisations.
Follow the steps from Xero and you will be redirected back to Retention Track. The connected organisation will appear under the "Xero Account Connection" section of your profile page.
3. Linking a Company to a Xero organisation
Unlike Retention Track, Xero operates using a single operating entity model and as a result you must link your connected Xero organisation to a company within your Retention Track workspace.
Navigate to the company you wish to link to Xero, scroll down to the Integrations section and select "Link to Xero Organisation" to begin the linking process.
The linking wizard walks you through six steps. A progress bar at the top of the page shows your position throughout the flow.
Step 1 — Select Xero Organisation
Choose the Xero organisation you want to link with your company. If you do not see the organisation you expect, ensure that you allowed Retention Track access to it in Xero.
Note: Each Xero organisation has a region (e.g. AU, NZ, GB). Organisations whose region does not match your Retention Track workspace will appear disabled with an "Incompatible Region" badge.
Step 2 — Select Retention Debtors Account
Select the retention debtors account from your Xero chart of accounts. This is the asset account where retention withheld from your invoices will be tracked. If you don't already have one, click "Create Retention Debtors Account" and Retention Track will create the account for you in Xero (default code 699, name "Retention Debtors").
Step 3 — Select Retention Defects Liability Account
Select the retention defects liability account from your Xero chart of accounts. This liability account is used to track the portion of retention held against the defects liability period. If you don't already have one, click "Create Retention Defect Liabilities Account" and Retention Track will create it for you (default code 899, name "Retention Defects Liability").
Step 4 — Select Sales Account
Select the sales (revenue) account from your Xero chart of accounts. This account is used as the default revenue account when creating invoices and credit notes from Retention Track.
Step 5 — Select Cost of Goods Sold Account
Select the cost of goods sold account from your Xero chart of accounts. This account is used as the offset account when posting manual journals that record retention being used against defects.
Step 6 — Confirmation
Review the summary of your selections — the Xero organisation, retention debtors account, retention defects liability account, sales account and cost of goods sold account — then select "Connect Company to Xero" to complete the linking process.
Once the linking process has been successfully completed, Retention Track will allow you to add invoices directly from Xero as well as monitor your outstanding retention balances.
4. Configuring tax type mappings (UK reverse charge / DRC only)
Note: Tax type mappings are only required for workspaces in regions that support reverse charge VAT (currently the United Kingdom — Domestic Reverse Charge). The configuration section will not appear for AU or NZ workspaces.
After linking a company to Xero, UK workspaces can configure which Xero tax types map to reverse charge transactions. From the company page, scroll to the Xero integration card and open "View Tax Type Mappings", then select "Configure".
You can select multiple Xero tax types per purpose:
Reverse Charge (Income) — the Xero tax types used for reverse charge on income (sales invoices, retention debtors, and defect liabilities). UK examples:
DRCHARGE20,DRCHARGE5.Reverse Charge (Expense) — the Xero tax types used for reverse charge on expense (cost of goods sold). UK examples:
DRCHARGESUPPLY20,DRCHARGESUPPLY5.
Tick the tax types that apply for each purpose and select "Save Mappings". These mappings tell Retention Track which line items on a Xero invoice should be treated as reverse charge when calculating retention and creating new documents.
5. Catch-up flows for existing companies
Some Xero account types were added to the linking wizard after the original release. If a company was linked to Xero before these account types existed, the company's Xero integration card will display amber warning banners prompting you to complete the missing links.
Each catch-up flow opens a standalone page that asks you to select (or create) a single account, then returns you to the company page when done.
Link Sales Account
If the company has no sales account linked you will see an amber banner reading "No sales account linked. A sales account is required for creating invoices and credit notes." Select "Link Sales Account" to open the catch-up page, choose a revenue account from your Xero chart of accounts, and select "Link Sales Account" to save.
Link Cost of Goods Sold Account
If the company has no cost of goods sold account linked you will see an amber banner reading "No cost of goods sold account linked. A COGS account is required for creating invoices and credit notes." Select "Link COGS Account" to open the catch-up page, choose a cost of goods sold account from your Xero chart of accounts, and select "Link COGS Account" to save.
Link Defect Liabilities Account
Companies onboarded before the retention defects liability account became a required field can link or create one from the dedicated catch-up page. As with the wizard, you can either pick an existing liability account from your Xero chart of accounts or have Retention Track create one for you (default code 899, name "Retention Defect Liabilities"). Select "Link Account" to save.
Unlinking from Xero
Unlinking a Company from Xero
To unlink a Xero organisation from a company in Retention Track navigate back to the company page and select "Unlink".
Note: Unlinking a company from Xero stops all syncing of data between that company and Xero, and cannot be undone. You can reconnect at any time by linking the company again.
Disconnecting your Xero organisation from Retention Track
You are able to disconnect Retention Track's access to any of your Xero organisations through your profile page. Select "Disconnect" under the "Xero Account Connection" section and follow the steps.
Note: Retention Track will prompt you to first unlink any companies that are using the organisation before removing your Xero connection, to prevent accidental data loss.







