Easy

Easy point and click

Fast

Setup in under 5 minutes

Secure

Secure data architecture

Xero Accounting

Xero Accounting Integration

One way sync
Accounting
OAuth2 Authentication

Datasets

Accounts-All

Bank Transactions-Alltime

Bank Transactions-Last30days

Bank Transactions-Last365days

Bank Transactions-Last60days

Bank Transactions-Last90days

Bank Transfers-Alltime

Bank Transfers-Last30days

Bank Transfers-Last365days

Bank Transfers-Last7days

Bank Transfers-Last90days

Batch Payments-Alltime

Batch Payments-Last30days

Batch Payments-Last365days

Batch Payments-Last60days

Batch Payments-Last90days

Branding Themes

Contact Groups

Contacts-Alltime

Contacts-Last365days

Credit Notes-Alltime

Credit Notes-Last30days

Credit Notes-Last365days

Credit Notes-Last60days

Credit Notes-Last90days

Currencies

Employees-Alltime

Employees-Last365days

History+Notes by Contact

History+Notes-AllContacts

History+Notes-BankTransactions

History+Notes-BankTransactions-Last365days

History+Notes-Invoices

History+Notes-Invoices-Last365days

Invoices+LineItems-Alltime

Invoices+LineItems-Last30days

Invoices+LineItems-Last365days

Invoices+LineItems-Last60days

Invoices+LineItems-Last90days

Invoices-Alltime

Invoices-Last30days

Invoices-Last365days

Invoices-Last60days

Invoices-Last90days

Items

Journals-All

ManualJournals-Alltime

ManualJournals-Last30days

ManualJournals-Last365days

ManualJournals-Last60days

ManualJournals-Last90days

Organisations

Overpayments-Alltime

Overpayments-Last30days

Overpayments-Last365days

Overpayments-Last60days

Overpayments-Last90days

Payments-Alltime

Payments-Last30days

Payments-Last365days

Payments-Last60days

Payments-Last90days

Prepayments-Alltime

Prepayments-Last30days

Prepayments-Last365days

Prepayments-Last60days

Prepayments-Last90days

PurchaseOrders+LineItems-Alltime

PurchaseOrders+LineItems-Last30days

PurchaseOrders+LineItems-Last365days

PurchaseOrders+LineItems-Last60days

PurchaseOrders+LineItems-Last90days

Quotes+LineItems-Alltime

Quotes+LineItems-Last30days

Quotes+LineItems-Last365days

Quotes+LineItems-Last60days

Quotes+LineItems-Last90days

RepeatingInvoices

Report-1099

Report-BalanceSheet

Report-P+L-Last2Years

Report-P+L-Last365days

TaxRates

Users

Auto export Xero Accounting data to Excel Online

Every 10 Minutes, Hourly, Daily, Weekly


Full DatasetsData IntegrationFlat files

Established in 2006, Xero is a web-based accounting system designed for small and growing businesses.

Excel Online

Export and sync comprehensive Xero Accounting datasets to Excel Online XLSX files in OneDrive or OneDrive for Business on a recurring, automatic basis. Historical data is included. Connect to PowerBI via OneDrive.

Excel Online

External Resources about Excel Online: