View Live Xero Data in Google Sheets
Export real-time Invoices, Journals, Bank Transactions, Accounts, Contacts, Expense Claims, Employees, etc. and refresh in one click
Xero & Custom Reports
Get Detailed Account Transactions, Purchase Orders, Profit and Loss, Income Statement, Balance Sheet, etc. Read more>>
Connect to multiple organizations and consolidate data in one sheet. Refresh reports for all companies in one click
Refresh your reports & dashboards automatically when you are offline using a flexible schedule. Create BI dashboards by connecting your spreadsheets to Google Data Studio and setting auto-refresh. Read more>>
Collaborate in Google Drive
Share spreadsheets with anyone and let your non-Xero users see live data. Collaborate with your team & clients in real-time and track changes.
Connect Google Sheets to real-time Xero Accounting, Payroll, Projects, Assets data
Automate reporting process and streamline data entry. Collaborate in Google Drive
Use the power of Google Sheets to customize reports, build pivot tables & charts
Build BI dashboards by connecting to Google Data Studio and scheduling auto-refresh
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.
Easy To Use: Instantly install Add-On in your Google Drive, connect to Xero and start pulling your data in seconds. Edit your data directly in Google Sheets or create new records and upload to Xero
Automation: Automatically refresh & email the latest Xero reports & data to your clients. No more hassle with manually downloading reports from Xero.
Latest Product Releases
Xero Projects are now available in your Google Drive. Easily extract and refresh data from Projects, Users, Tasks, Time in Google Sheetsread more >>
2-Way Sync is finally here! You can now perform Update, Insert, Delete operations directly from Google Sheets and post transactions to Xerowatch video >>
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 >>
View & Refresh your Australian Payroll Data and Assets Data in Google Sheets
Separate login for AU Payroll users
Export Timesheets, Pay Stubs, Pay Items, Employees, etc.
Assets API Connectorread 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 >>
Aged Payables Detail Report
Aged Receivables Detail Report
Budget vs Actual Report
Customer Running Account Details Report
Sales Invoice Summary Reportread more >>