Check out the store for many more

G-Accon for XERO

992 users


Work with your live Xero accounting data and reports directly from Google Spreadsheets.
G-Accon is a powerful Xero Add-On that seamlessly integrates Google Sheets with Xero in real-time. Easily pull/export Xero reports & raw data or design your own reports and dashboards using the power of Google Sheets. Automatically generate and email Xero reports by using a scheduler tool. Share spreadsheets and collaborate with your team & clients in Google Drive, so they can see live Xero reports without signing in to Xero! You can connect to as many Xero accounts as you like.

Product Features:
 * Google Sheets-Xero connector (through secure OAuth authentication and Xero API)

 * Pull raw data from Xero into Google Sheets to reconcile and find errors:
Invoices, Expense Claims, Contacts, Bank Transactions, Accounts, etc. Use Deep links to easily navigate directly to a document or resource within Xero.

 * Pull Xero Reports into Google Sheets (choose from 30+ reports)
Profit and Loss, Income Statement, Balance Sheet, Detailed Account Transactions, 1099, etc. Filter and customise your reports based on tracking categories, cash/accrual basis, date range, compare to previous periods options, etc.

 * Custom reports: 
Purchase Order Summary Report, Purchase Orders Report, VAT 126, VAT Audit Report with Supplier's VAT Registration Number, New Income Statement with compare to previous periods. 

 * Easily switch between multiple organizations.

 * Refresh all organizations with one click

 * Automatically refresh & email spreadsheets by using a flexible schedule

 * Save historical reports in Google Drive

 * Monitor your data by creating alerts and receive notifications when certain criteria is met
 * US and AU Payroll Data
 Payroll connector allows you to pull data from Employees, Pay stubs, Pay Schedules, etc.

 * 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, Gmail account and Google Drive enabled


Version: 84
Updated: August 9, 2018
Language: English (United States)