Xero Accounting Integration
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-Last365days
Report-P+L-Last90days
TaxRates
Users
Auto export Xero Accounting data to Power BI
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.
Export and sync comprehensive Xero Accounting datasets to Excel Online XLSX or CSV files in OneDrive folders on a recurring, automatic basis. Historical data is included. Connect to Power BI via OneDrive.
