Live link to Xero in Google Sheets

Connect and sync Google Sheets with Xero Accounting, Payroll, Assets, Projects data. Refresh automatically or manually. Read more>>

Xero & Custom Reports

40+ Reports: Account Transactions, Purchase Orders, Profit and Loss, Income Statement, Balance Sheet, etc. Features: Multi-Currency, Tracking Categories, Filters, Compare Time Periods 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


Certified by Xero and Google


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.


Get G-Accon Now Try Xero for Free


Without the functionality of G-Accon, the Purchase Order component of Xero is very limited. With G-Accon, it becomes powerful. I have had a fantastic response from the G-Accon support team, when needed.
Gillian Dale-Jones
G-Accon allows me to prepare the most requested report NOT in Xero - profit and loss by tracking category with filters. Without it I would be lost in excel for hours pulling this report together. GAccon is a crucial and indispensable tool for Xero
Sue Binney
We use this to consolidate multiple Xero entities over different countries and currencies, automate a lot of our month end processes (including uploading journals), and pull out Xero data to run analytics on (in PowerBi and in google sheets).
Sam White
We're steadily building out our G-Accon powered set of Google Sheet based reporting systems across our CFO clients. The automated Xero report pulls feeding into our weekly and monthly reporting are saving us a whole lot of time so that we're more real-time and proactive than ever.
Remco Marcelis

Reporting


 Automation

Save hours on reporting by using our automatic operations

  Auto-Refresh

  Emailing

  Alerts

  Backups

 Multi-Currency Reporting

New Feature - Generate reports in multiple currencies. Currency conversion process is highly efficient when you need to deliver Profit and Loss, Budget vs Actual, Invoices, and other financial reports to the clients from different countries.

 BI-Ready: Historical Layout

Easily connect G-Accon spreadsheets to BI software to visualize your reports:

  Power BI

  Google Data Studio

  Tableau

  Publish Google Charts


 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

  Quarterly

  Weekly

Reporting Documentation


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.

 Upload Automation

New - Schedule automatic data uploads to Xero to save time and automate your workflow. New or modified rows in spreadsheets will be automatically imported to Xero even when you are offline.


Upload Documentation


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.


Videos


Watch our video tutorials to get started


How to get reports from Xero - Detailed Account Transactions report



How to get data into Google Sheets, edit and push back to Xero - Bi-Directional Bills synchronization



How to schedule automatic data refresh


New Product Releases



Read Release Notes


  Multi-Currency Reporting

  Schedule automatic uploads to Xero

New Reports Released

  Income By Contacts Report

  Statement of Cash Flows Report

read more >>

New Features Released

  Historical Layout in Reports

  Filter by Contact Group

  Added Contact Name

read more >>

New Reports have been released:

  Aged Payables Summary Report

  Aged Receivables Summary Report

read more >>

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

  PDF

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

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

Consolidate Multiple Companies into a Google Sheet

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

read more >>