Live link to Xero
Connect and sync Google Sheets with Xero Accounting, Payroll, Assets, Projects data. Refresh automatically or manually.
Xero & Custom Reports
Get Detailed Account Transactions, Purchase Orders, Profit and Loss, Income Statement, Balance Sheet, etc. Read more>>
Multiple Organizations
Connect to multiple Xero organizations and consolidate data in one sheet. Read more>>
Automatic Data Refresh
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>>
Upload Data to Xero
Update/Create/Delete Invoices, Bank Transactions, Manual Journals, Contacts, Purchase Orders, Payments, etc. and post to Xero. No more hassle with CSV files. 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.
Data Monitoring & Alerts
Create alerts and receive notifications if certain criteria is met. Read more>>
Automatic Emails
Send real-time reports to your clients automatically in Excel, PDF, CSV or Google Sheets format. Read more>>
Backup Data
Auto-save spreadsheets snapshots in Google Drive to keep historical data. Read more>>
The Power of Google Sheets + Xero
Award-Winning Google Sheets Add-On for Xero by G-Accon
For Accountants, Advisors, Bookkeepers, Business Owners
Live link to Xero. Build & automate reports. Upload data to Xero. 
Connect to unlimited Xero organizations and consolidate data.
Reporting
Automation
Save hours on reporting by using our automatic operations
Auto-Refresh
Emailing
Alerts
Backups
Drill-down
Drill-down hierarchy to get raw data from Xero tables through Xero API:
Accounting
Projects
Payroll
Assets
BI-ready
Use historical layout to easily connect to BI software- Google Data Studio and build beautiful dashboards
Tracking Categories
Customize reports by using our pre-defined filters:
Xero Tracking Categories
Date Range
Cash/Accrual
Region
Save Templates
Create, save, update templates for each company to streamline and automate reporting.
Order By
Filter By
Pull Settings
Schedule Auto-Refresh
Compare to previous periods
Month by Month
Quaterly
Weekly
Importing data
Do you constantly prepare CSV files for importing data into Xero? Use G-Accon to save time on repetitive data loading tasks by pushing your data back into Xero in one click!
Upload Operations
Post data to Xero directly from Google Sheets by using Insert, Update, Delete operations.
Upload Templates
Create an upload template for each Xero organization once and re-use it to import data into Xero in one click.
Two-Way Sync
Pull your data into Google Sheets, analyze it, make changes and post to Xero. All the tools you need in one place!
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.
New Product Releases
New Reports have been released:
Aged Payables Summary Report
Aged Receivables Summary Report
New Report - Account Transactions
Account Transactions report is now available in G-Accon!
read more >>Automatic Data Operations Updates
Automatically convert Google Spreadsheets to
Excel
CSV
read more >>NZ Payroll (BETA)
Connect to Xero New Zealand Payroll directly from Google Sheets
Separate login for NZ Payroll users
Export Timesheets, Pay Stubs, Pay Items, Employees, etc.
Refresh data automatically or manually
Connect to Xero Projects
Xero Projects are now available in your Google Drive. Easily extract and refresh data from Projects, Users, Tasks, Time in Google Sheets
read more >>Import data into Xero directly from Google Sheets
2-Way Sync is finally here! You can now perform Update, Insert, Delete operations directly from Google Sheets and post transactions to Xero
watch video >>Customize User & Report Settings
August Release: now you can customize your user and reports settings.
Stay logged in to Xero
Report and Data Pull Settings
Redesigned Cash Summary Report
read more >>AU Payroll API & Assets API Connectors
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 Connector
read more >>April Release Notes
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 supported
read more >>Released Automation Features
Automatically generate and email Xero reports
Auto-Refresh Scheduler
Create/Receive Alerts
Backup Historical Data
read more >>Released New Reports
Aged Payables Detail Report
Aged Receivables Detail Report
Budget vs Actual Report
Customer Running Account Details Report
Sales Invoice Summary Report
read more >>February Release Notes
New Report: Custom Date Range Balance Sheet
New Report: Cash Summary
Balance Sheet report can now display previous comparable periods
Revised Detailed Account Transaction report
read more >>Introducing Purchase Orders Reports
Purchase Orders
Purchase Order Details
Purchase Order Summary
read more >>Consolidate Multiple Companies into a Google Sheet
Watch this video on how to consolidate information across multiple companies into a google sheet.
read more >>