Xero Accounting to Google BigQuery

Automatically Export & Sync Xero Accounting Data to Google BigQuery

Xero Accounting
a black arrow pointing to the right
Google BigQuery
Full data sets
No instructions needed
No code
No complicated flow charts
No triggers
Set up in under 3 minutes
Flat pricing starting at $19 /month

Data sets

Accounts-All
Filterable
Bank Transactions-Alltime
Filterable
Bank Transactions-Last X days
Date Rangable
Filterable
Bank Transfers-Alltime
Bank Transfers-Last X days
Date Rangable
Batch Payments-Alltime
Filterable
Batch Payments-Last X days
Date Rangable
Filterable
Branding Themes
Contacts-Alltime
Filterable
Contacts-Last X days
Date Rangable
Filterable
Contact Groups
Credit Notes-Alltime
Filterable
Credit Notes-Last X days
Date Rangable
Filterable
Credit Notes+LineItems-Alltime
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Credit Notes+LineItems-Last X days
Date Rangable
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Currencies
Employees-Alltime
Filterable
Employees-Last X days
Date Rangable
Filterable
History+Notes by Contact
Filterable
Pre-blended combo set HISTORY-AND-NOTES
History+Notes-AllContacts
Filterable
Pre-blended combo set HISTORY-AND-NOTES
History+Notes-BankTransactions
Pre-blended combo set HISTORY-AND-NOTES
History+Notes-BankTransactions-Last X days
Date Rangable
Pre-blended combo set HISTORY-AND-NOTES
History+Notes-Invoices
Pre-blended combo set HISTORY-AND-NOTES
History+Notes-Invoices-Last X days
Date Rangable
Pre-blended combo set HISTORY-AND-NOTES
Invoices-Alltime
Filterable
Invoices-Last X days
Date Rangable
Filterable
Invoices+LineItems-Alltime
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Invoices+LineItems-Issued-Last X days
Date Rangable
Pre-blended combo set SELF-LEFT-JOINED
Invoices+LineItems-Modified-Last X days
Date Rangable
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Items
Journals-All
Journals by LastModifiedDate
Date Rangable
Filterable
Journals+Lines-All
Pre-blended combo set SELF-LEFT-JOINED
Journals+Lines by LastModifiedDate
Date Rangable
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Linked Transactions
ManualJournals+Lines-Alltime
Filterable
Pre-blended combo set SELF-LEFT-JOINED
ManualJournals+Lines-Last X days
Date Rangable
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Organisations
Filterable
Overpayments-Alltime
Filterable
Overpayments-Last X days
Date Rangable
Filterable
Payments-Alltime
Filterable
Payments-Last X days
Date Rangable
Filterable
Prepayments-Alltime
Filterable
Prepayments-Last X days
Date Rangable
Filterable
PurchaseOrders+LineItems-Alltime
Filterable
Pre-blended combo set SELF-LEFT-JOINED
PurchaseOrders+LineItems-Last X days
Date Rangable
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Quotes+LineItems-Alltime
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Quotes+LineItems-Last X days
Date Rangable
Filterable
Pre-blended combo set SELF-LEFT-JOINED
RepeatingInvoices
Filterable
Report-1099
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Report-BalanceSheet
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Report-BankSummary by Date
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Report-BankSummary-Last X days
Date Rangable
Pre-blended combo set SELF-LEFT-JOINED
Report-BankSummary-Last 365 days
Date Rangable
Pre-blended combo set SELF-LEFT-JOINED
Report-P+L Standard
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Report-P+L by Date
Filterable
Pre-blended combo set SELF-LEFT-JOINED
Report-P+L-Last365days
Date Rangable
Pre-blended combo set SELF-LEFT-JOINED
Report-P+L-Last90days
Date Rangable
Pre-blended combo set SELF-LEFT-JOINED
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
Date Rangable
TaxRates
Filterable
Users

Built for Synchronization

This service is designed to help anyone continuously export (i.e. "sync") bulk data from Xero Accounting.

If you only need to export your data one time, check the website of Xero Accounting to see if their service offers a one-time export feature natively. Sometimes a Data Source's native export feature may provide not as much data as its API does, in which case Flatly is the solution.

Additional Information

Flatly uses official API channels to provide an integration with Xero Accounting.
Established in 2006, Xero is a web-based accounting system designed for small and growing businesses.
Employees

Xero offers two different Employees data sets, one from Xero Payroll and one from Xero Accounting. While Flatly supports both, most analysts will find the Employees data set from Xero Payroll more populated and useful.


Nested Items

Flatly offers several key data sets that present Items and Lines on their own unique rows, which makes data analysis of these nested data sets more convenient.

Scopes

Flatly's access to Plaid and Plaid's downstream connected financial institutions is read-only access to text. It is limited to account data (words, numbers, dates). It does not include any money-movement, transfer capabilities or account holder profiles/identities.

Plaid alone interfaces directly with financial institutions, caches data from those institutions on Plaid infrastructure, and then makes the appropriate scoped subset of that data available to partners like Flatly using secure connections called client libraries.

Looker reads tables from Google BigQuery.

File Formats

NDJSON

Integration Flow

Setup

Step 1

Select Xero Accounting from the Data Source dropdown and Google BigQuery from the Data Destination dropdown.

Step 2

Authorize Xero Accounting with your credentials using the OAuth flow.

Step 3

Authorize Google BigQuery with your credentials using the Service Account flow.

Step 4

Select your Data Set from the 64 Data Sets available using the dropdown.

Step 5

Click Flatten to sync your data.

Walkthrough Video

Extended Data Sources

Get started with your data pipelines

Connect your data with our turnkey data integration solution so you can focus on running your business.