Check out the store for many more

G-Accon for XERO

1,921 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. Connect Google Sheets to multiple Xero companies. Easily extract Xero reports & data or make changes and upload data into Xero directly from Google Sheets. Automatically refresh and email updated Xero reports by using a flexible schedule. Share live spreadsheets and collaborate with your team & clients in Google Drive. Connect to Google Data Studio to build BI dashboards. 

Great tool for accountants, advisors, bookkeepers, and business owners to customize and automate reporting, consolidate data, import data in bulk, build charts, manipulate data using the power and convenience of Google Sheets. 
Emerging App Partner of the Year in Xero Awards 2018.

Product Features:

 * Connect Google Sheets to unlimited Xero companies/organisations

 * Create/update data queries/reporting templates

 * Get real-time Xero Reports in Google Sheets:
Profit and Loss, Income Statement, Balance Sheet, Detailed Account Transactions, 
Purchase Order Summary Report, Purchase Orders Report, etc.
 * Xero Accounting data: get and refresh custom data queries in Google Sheets:
Invoices, Journals, Expense Claims, Contacts, Bank Transactions, Accounts, etc. 

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

 * Xero Assets: get and refresh data from Assets, Asset Types, Settings tables
 * Xero Payroll (AU, NZ): get 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 in bulk - Invoices, Bank Transactions, Contacts, Credit Notes, Items, Contact Groups, Manual Journals, Linked Transactions, Payments, Purchase Orders, etc.

 * Automatically refresh reports and data queries by using a flexible schedule (hourly, daily, weekly, monthly)

 * Auto-export and email updated reports in Google Sheets, Excel, PDF, and CSV format

 * Schedule a backup of historical data snapshots 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


Version: 131
Updated: October 15, 2019
Language: English (United States)