Release Notes

November 2024

We have improved the decimal precision of the currency_rate columns and now support a scale of 10 for decimal values in the currency_rate columns of the following tables:

• BANK_TRANSACTION
• BANK_TRANSFER
• CREDIT_NOTE
• INVOICE
• OVERPAYMENT
• PAYMENT
• PREPAYMENT

Previously, we supported a scale of 6 for decimal values and rounded the values to six decimal places.

February 2024

We now make individual API calls for each Xero's asset once a week. Previously, we made individual API calls with every sync. For more information about assets, see Xero's API documentation.

July 2023

Our Xero connector now uses webhooks to capture all updates for the INVOICE table. Previously, we did not capture updates for some columns, such as the sent_to_contact column of the INVOICE table. We have added a new toggle, Use Webhook, to the connector setup form. The toggle provides you the option to use a webhook for your connector. We have rolled out this feature for all new and existing Xero connectors. For more information, see our setup instructions.

March 2023

We have changed the new connector creation process for Xero connectors. We now use a different authentication method for Xero connectors created after March 24, 2023. We use Client ID and Client Secret for authentication. For more information, see our Xero Setup Guide.

We will continue to support the existing Xero connectors. You can also opt to migrate your existing connector to the new authentication method.

March 2022

We have added a new column, add_to_watch_list, to the ACCOUNT table.

April 2021

We now support the Employees, Leave Applications and Timesheets endpoints of the Xero-Payroll API. To use these endpoints, you must re-authorize your connector in your Fivetran dashboard. On the Connector Details page, go to the Setup tab, click Edit connection details, and then click Re-authorize connection. See Xero's API documentation to learn more about the Employees, Leave Applications, and Timesheets endpoints.

We have released pre-built, dbt Core-compatible data models for Xero. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

We have added three new tables to support Xero's Payroll API:

• AUS_PAYROLL_EMPLOYEE
• AUS_PAYROLL_LEAVE_APPLICATION
• AUS_PAYROLL_TIMESHEET

See Xero's API documentation to learn more about Employees, Leave Applications, and Timesheets.

We have added three new tables to support Xero's Assets API:

• ASSET
• ASSET_TYPE
• SETTINGS

See Xero's API documentation to learn more about Assets, Asset Types, and Settings.

We have added the following new columns to the BANK_TRANSACTION and PAYMENT tables:

• batch_payment_id
• batch_payment_date
• batch_payment_is_reconciled
• batch_payment_status
• batch_payment_total_amount
• batch_payment_type
• batch_payment_updated_date_utc

December 2020

We now support values with six decimal places in the following columns of the tables below:

• amount column of the ALLOCATION table
• sub_total, total_tax, total, and currency_rate columns of the BANK_TRANSACTION table
• unit_amount, tax_amount, and line_amount columns of the BANK_TRANSACTION_LINE_ITEM table
• amount, unit_amount, tax_amount, line_amount, and currency_rate columns of the BANK_TRANSFER table
• outstanding and overdue columns of the CONTACT table
• currency_rate, remaining_credit, applied_amount, sub_total, total_tax, and total columns of the CREDIT_NOTE table
• amount_due, amount_paid, and total columns of the EXPENSE_CLAIM table
• currency_rate, amount_due, amount_paid, amount_credited, cis_deduction, sub_total, total_tax, and total columns of the INVOICE table
• total_cost_pool, purchase_details_unit_price, and sales_details_unit_price columns of the ITEM table
• net_amount, gross_amount, and tax_amount columns of the JOURNAL_LINE table
• tax_amount and line_amount columns of the MANUAL_JOURNAL_LINE table
• sub_total, total_tax, total, applied_amount, currency_rate, and remaining_credit columns of the OVERPAYMENT table
• bank_ammount, amount, and currency_rate columns of the PAYMENT table
• sub_total, total_tax, total, applied_amount, currency_rate, and remaining_credit columns of the PREPAYMENT table
• unit_amount, line_amount, tax_amount, and discount_rate columns of the PURCHASE_ORDER_LINE_ITEM table
• sub_total, total_tax, and total columns of the RECEIPT table
• unit_amount, line_amount, tax_amount, and discount_rate columns of the RECEIPT_LINE_ITEM table
• sub_total, total_tax, total_discount, and total columns of the REPEATING_INVOICE table
• discount_rate column of the REPEATING_INVOICE_LINE_ITEM table
• display_tax_rate and effective_rate columns of the TAX_RATE table
• rate column of the TAX_RATE_COMPONENET table

Previously, we used to round the column values to two decimal places.

September 2020

We have added a new column, manual_journal_id, to the MANUAL_JOURNAL_LINE_HAS_TRACKING_CATEGORY table.

August 2020

We have added a new column, contact_id, to the INVOICE_LINKED_TRANSACTION table.

We have removed the _fivetran_deleted column from the CREDIT_NOTE table.

May 2020

When setting up your connector, you can now select the organizations you'd like to sync.

We have fixed an issue where the connector setup test was failing because of timeout errors.

We have added a new column, _fivetran_deleted, to the SUBSCRIPTION table.

April 2020

We have added a new field, item_code, to the PURCHASE_ORDER_LINE_ITEM table.

We have added support to authenticate the connector using OAuth 2.0. We will be migrating the active users to the new standard of authentication.

You can now configure your Xero connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.

February 2020

We have updated the data type of the inventory_asset_account_code column in the ITEM table from INT to STRING to match the type in the Xero API.

We now sync archived records from the TRACKING_CATEGORY table.

January 2020

We have added a new column, option, to the following tables:

• BANK_TRANSACTION_LINE_ITEM_HAS_TRACKING_CATEGORY
• MANUAL_JOURNAL_LINE_ITEM_HAS_TRACKING_CATEGORY
• INVOICE_LINE_ITEM_HAS_TRACKING_CATEGORY
• OVERPAYMENT_LINE_ITEM_HAS_TRACKING_CATEGORY
• PREPAYMENT_LINE_ITEM_HAS_TRACKING_CATEGORY
• REPEATING_INVOICE_LINE_ITEM_HAS_TRACKING_CATEGORY
• CREDIT_NOTE_LINE_ITEM_HAS_TRACKING_CATEGORY
• JOURNAL_LINE_ITEM_HAS_TRACKING_CATEGORY
• RECEIPT_LINE_ITEM_HAS_TRACKING_CATEGORY

We have added a new column, tracking_category_option_id, to the RECEIPT_LINE_ITEM_HAS_TRACKING_CATEGORY and CREDIT_NOTE_LINE_ITEM_HAS_TRACKING_CATEGORY tables.

We have added the following tables:

• PURCHASE_ORDER
• PURCHASE_ORDER_LINE_ITEM
• PURCHASE_ORDER_LINE_ITEM_HAS_TRACKING_CATEGORY

We have added a new primary key column, index, to the ALLOCATION table.

We can now delete all of the following records from the tables below:

• Bank transaction line items with no tracking from the BANK_TRANSACTION_LINE_ITEM_HAS_TRACKING_CATEGORY table
• Receipts with no tracking from the RECEIPT_LINE_ITEM_HAS_TRACKING_CATEGORY table
• Invoices with no line items from the INVOICE_LINE_ITEM table
• Invoice line items with no tracking from the INVOICE_LINE_ITEM_HAS_TRACKING_CATEGORY table
• Manual journal lines with no tracking from the MANUAL_JOURNAL_LINE_HAS_TRACKING_CATEGORY table
• Overpayment line items with no tracking from the OVERPAYMENT_LINE_ITEM_HAS_TRACKING_CATEGORY table
• Overpayments with no overpayment line items from the OVERPAYMENT_LINE_ITEM table
• Pre-payments with no pre-payment line items from the PREPAYMENT_LINE_ITEM table
• Repeating invoices with no repeating invoice line items from the REPEATING_INVOICE_LINE_ITEM table
• Repeating invoice line items with no tracking from the REPEATING_INVOICE_LINE_ITEM_HAS_TRACKING_CATEGORY table
• Credit note line items with no tracking from the CREDIT_NOTE_LINE_ITEM_HAS_TRACKING_CATEGORY table
• Credit notes with no credit note line items from the CREDIT_NOTE_LINE_ITEM table
• Contact addresses with no addresses from the CONTACT_ADDRESS table
• Purchase orders with no purchase line items from the PURCHASE_ORDER_LINE_ITEM table
• Purchase orders with no tracking from the PURCHASE_ORDER_LINE_ITEM_HAS_TRACKING_CATEGORY table
• Journals with no tracking or tracking categories from the JOURNAL_LINE_HAS_TRACKING_CATEGORY table

Previously, we were not able to remove these records because of the way we set up the primary key.

September 2019

We have added two new tables, INVOICE_LINKED_TRANSACTIONS and BANK_LINKED_TRANSACTIONS, to support the linked transactions endpoint.

February 2019

We have made the following primary key changes:

• invoice_id is new the primary key of the _INVOICE_LINE_ITEM table.
• overpayment_id is new the primary key of the _OVERPAYMENT_LINE_ITEM table.
• prepayment_id is new the primary key of the _PREPAYMENT_LINE_ITEM table.
• repeating_invoice_id is new the primary key of the _REPEATING_INVOICE_LINE_ITEM table.

Fivetran will not store the deleted line_item records for the above tables.

October 2018

We have added two new columns, edition and class, to the ORGANIZATION table.

June 2018

We now add the tax_number_name column to the ORGANISATION table, if the field is present in the API response.

We now add the account_id column to the MANUAL_JOURNAL_LINE table, if the field is present in the API response.