View live Xero data in Google Sheets

Export real-time Invoices, Journals, Bank Transactions, Accounts, Contacts, Expense Claims, etc.

Xero & Custom Reports

Get Detailed Account Transactions, Purchase Orders, Profit and Loss, Income Statement, Balance Sheet, etc. Read more>>

Multiple Organizations

Connect to multiple organizations and consolidate data in one sheet. Refresh reports for all companies in one click

Auto-Refresh

Refresh your reports & dashboards automatically when you are offline using a flexible schedule. Read more>>

Import Data into Xero

Update/Create/Delete Invoices, Bank Transactions, Manual Journals, Contacts, Purchase Orders, Payments, etc. directly from Google Sheets and post to Xero. Read more>>

Collaborate in Google Drive

Share spreadsheets with anyone and let your non-Xero users see live data! Work as a team in Google Drive and track changes.

Data Monitoring & Alerts

Create alerts and receive notifications if certain criteria is met. Read more>>

Schedule Emails

Automatically refresh and email updated reports to your clients. Read more>>

Backup Your Reports

Save reports snapshots to Google Drive to keep historical data. Read more>>

Bi-directnional sync between Xero and Google Sheets with automation features

Install your free trial now!



Latest Product Releases

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 >>

Consolidate Multiple Companies into a Google Sheet

Watch this video on how to consolidate information across multiple companies into a google sheet.

read more >>

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 >>

Released Automation Features

Automatically generate and email Xero reports

  Auto-Refresh Scheduler

  Create/Receive Alerts

  Backup Historical Data

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 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 >>

January Release Notes

  VAT 126

  VAT Audit Report

  G-Accon is now a Xero App Partner

read more >>

Introducing Purchase Orders Reports

  Purchase Orders

  Purchase Order Details

  Purchase Order Summary

read more >>




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 by assigning read or write access.

Easy Setup: Instantly install Add-On in your Google Drive, connect to Xero and start pulling your data in seconds. All future updates will be automatically pushed, so you will always have the latest version of the Add-On.

Automation: Automatically refresh & email the latest Xero reports & data to your clients. No more hassle with manually downloading reports from Xero.

Watch our video tutorials to get started

  
  

G-Accon connects Google Sheets to Xero & automates Xero Reporting to save time

  Enhance your Xero Cloud Accounting with Cloud-Based spreadsheets to increase efficiency, save time & collaborate with others
  Reduce errors - no more manually copy-pasting into Excel - instantly pull & refresh your live Xero data in Google Sheets
  Use the power of Google Sheets to customize reports, build charts and share with your non-Xero users in Google Drive Cloud
  Connect you spreadsheets to Google Data Studio to design beautiful & interactive Xero dashboards
  Schedule automatic data refreshes to keep your reports updated for all organizations when you are offline
  Setup alerts to monitor your data based on threshold and make business decisions in real-time
  View your Google Spreadsheets on almost any device - Iphone/Ipad/Android. Export to various file formats - Excel, PDF, CSV

About Xero

Xero is world-leading online accounting software built for small business.

  • Get a real-time view of your cashflow. Log in anytime, anywhere on your Mac, PC, tablet or phone to get a real-time view of your cash flow. It's small business accounting software that's simple, smart and occasionally magical.
  • Run your business on the go. Use our mobile app to reconcile, send invoices, or create expense claims - from anywhere.
  • Get paid faster with online invoicing. Send online invoices to your customers - and get updated when they're opened.
  • Reconcile in seconds. Xero imports and categorises your latest bank transactions. Just click ok to reconcile.

Find out more or try Xero Accounting Software for free.