Integration OAuth
Sync Xero Accounting Data
to Flat Files
& Spreadsheets
Automatically sync your Xero Accounting data to cloud storage and spreadsheets with Flatly's no-code, triggerless, turnkey integration service.
Historical & Dynamic Data
One-way Sync
For Non-technical Users
About the integration: Established in 2006, Xero is a web-based accounting system designed for small and growing businesses. Flatly integrates with Xero Accounting's official APIs.
Available Datasets
Flatly can sync the following datasets from Xero Accounting.
- Accounts-All
- Bank Transactions-Alltime
- Bank Transactions-Last X days Date-ranged
- Bank Transfers-Alltime
- Bank Transfers-Last X days Date-ranged
- Batch Payments-Alltime
- Batch Payments-Last X days Date-ranged
- Branding Themes
- Contacts-Alltime
- Contacts-Last X days Date-ranged
- Contact Groups
- Credit Notes-Alltime
- Credit Notes-Last X days Date-ranged
- Credit Notes+LineItems-Alltime Combo
- Credit Notes+LineItems-Last X days Combo Date-ranged
- Currencies
- Employees-Alltime
- Employees-Last X days Date-ranged
- History+Notes by Contact Combo
- History+Notes-AllContacts Combo
- History+Notes-BankTransactions Combo
- History+Notes-BankTransactions-Last X days Combo Date-ranged
- History+Notes-Invoices Combo
- History+Notes-Invoices-Last X days Combo Date-ranged
- Invoices-Alltime
- Invoices-Last X days Date-ranged
- Invoices+LineItems-Alltime Combo
- Invoices+LineItems-Issued-Last X days Combo Date-ranged
- Invoices+LineItems-Modified-Last X days Combo Date-ranged
- Items
- Linked Transactions
- ManualJournals+Lines-Alltime Combo
- ManualJournals+Lines-Last X days Combo Date-ranged
- Organisations
- Overpayments-Alltime
- Overpayments-Last X days Date-ranged
- Payments-Alltime
- Payments-Last X days Date-ranged
- Prepayments-Alltime
- Prepayments-Last X days Date-ranged
- PurchaseOrders+LineItems-Alltime Combo
- PurchaseOrders+LineItems-Last X days Combo Date-ranged
- Quotes+LineItems-Alltime Combo
- Quotes+LineItems-Last X days Combo Date-ranged
- RepeatingInvoices
- Report-1099
- Report-BalanceSheet
- Report-BankSummary by Date
- Report-BankSummary-Last X days Date-ranged
- Report-BankSummary-Last 365 days
- Report-P+L Standard Combo
- Report-P+L by Date Combo
- Report-P+L-Last365days Combo
- Report-P+L-Last90days Combo
- Report-TrialBalance at X days Back
- Report-TrialBalance MonthEnd at X months Back
- Report-TrialBalance at Today
- Report-TrialBalance at Yesterday
- Report-TrialBalance at LastWeek
- TaxRates
- Users
Send Xero Accounting data to
Flatly can sync Xero Accounting data to any of these destinations.
- Airtable Airtable
- Amazon S3 XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Azure Storage XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Box XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- CSV
- ChatGPT Apps
- Cloud Storage
- Dropbox XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Excel
- Excel Online XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- FTP XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google BigQuery NDJSON
- Google Cloud Storage XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google Drive Google Sheets (Parsed) Google Sheets (Raw) XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google Looker Studio
- Google Sheets Google Sheets (Parsed) Google Sheets (Raw) XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Looker NDJSON
- Markdown
- Microsoft Power BI
- OneDrive XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- OneDrive for Business XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- SFTP XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- SharePoint XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Smartsheet Smartsheet
- Zoho Sheet Zoho Sheet
Note: Some destinations are aliased, for intents and purposes they are functionally equivalent.