Xero Accounting & Payroll Data in Google Sheets
Pull real-time Invoices, Journals, Bank Transactions, Accounts, Contacts, Expense Claims, Employees, etc.
Xero & Custom Reports
Get Detailed Account Transactions, Purchase Orders, Profit and Loss, Income Statement, Balance Sheet, etc. Read more>>
Pull data for multiple organizations and connect in one sheet. Refresh reports for all companies in one click
Data Monitoring & Alerts
Create alerts and receive notifications if certain criteria is met. Read more>>
Share & Collaborate
Share spreadsheets with anyone. Your non-Xero users can now see live data! Work as a team in Google Drive and track changes.
Secure: We use secure OAuth 2.0 protocol, SSL encryption and Xero API. You will be redirected to Xero.com to enter your credentials. You can securely share your spreadsheets with anyone by assigning read or write access.
Easy Setup: Instantly install Add-On in your Google Drive, connect to Xero and start pulling your data in seconds. All future updates will be automatically pushed, so you will always have the latest version of the Add-On.
Automation: Automatically refresh & email the latest Xero reports & data to your clients. No more hassle with manually downloading reports from Xero.
Latest Product Releases
Watch this video on how to consolidate information across multiple companies into a google sheet.read more >>
August Release: now you can customize your user and reports settings.
Stay logged in to Xero
Report and Data Pull Settings
Redesigned Cash Summary Reportread more >>
Automatically generate and email Xero reports
Backup Historical Dataread more >>
Now you can modify, update or delete query or report metadata
Added Dynamic Date Range
New Pull Settings
Multiple Organization Support
Fiscal and calendar years are now supportedread more >>
New Report: Custom Date Range Balance Sheet
New Report: Cash Summary
Balance Sheet report can now display previous comparable periods
Revised Detailed Account Transaction reportread more >>