Check out the store for many more

G-Accon for XERO

1,743 users


Work with your live Xero accounting data and reports directly from Google Spreadsheets.
Award-winning Xero Add-On that seamlessly integrates Google Sheets with Xero in both directions. Easily extract Xero reports & data or make changes and upload data into Xero directly from Google Sheets. Automatically refresh and email Xero reports by using a flexible scheduler tool when you are offline. Share spreadsheets and collaborate with your team & clients in Google Drive. Connect to Google Data Studio to build beautiful BI dashboards. Emerging App Partner of the Year in Xero Awards 2018.

Product Features:

* Get real-time Xero Reports in Google Sheets. Use templates to easily customize your reports and schedule automatic data refresh:
Profit and Loss, Income Statement, Balance Sheet, Detailed Account Transactions, 
Purchase Order Summary Report, Purchase Orders Report, etc.
* Xero Accounting: pull and refresh data queries in Google Sheets from
Invoices, Journals, Expense Claims, Contacts, Bank Transactions, Accounts, etc. 

* Xero Projects: pull and refresh data from Projects, Users, Tasks, Time tables

* Xero Assets: pull and refresh data from Assets, Asset Types, Settings tables

* Xero Payroll (AU, NZ): pull and refresh data from Employees, Pay stubs, Pay Schedules, etc. 
* Import data into Xero: UPDATE, CREATE, DELETE data directly from Google Sheets and post to Xero - Invoices, Bank Transactions, Contacts, Credit Notes, Items, Contact Groups, Manual Journals, Linked Transactions, Payments, Purchase Orders.

 * Automatically refresh & email reports and data queries by using a flexible schedule

 * Easily switch between multiple organizations.

 * Schedule a backup of historical data in Google Drive

 * Monitor your data by creating alerts and receive notifications when certain criteria is met
 * Support
Contact us at for all questions, 
technical issues, feedback or if you would like to request new features.  

 * Product Requirements
You must have an active Xero account and Gmail account

Documentation can be found on our website:


Version: 117
Updated: June 14, 2019
Language: English (United States)