Automatically export, refresh, upload Xero data directly from Google Sheets. Build custom reports and dashboards.
Listing updated:May 31, 2024
Works with:
87K+
Overview
Award-winning Xero Add-On that seamlessly integrates Google Sheets with Xero in both directions. Connect Google Sheets to multiple Xero companies. Auto-export Xero reports & data or make changes and auto-upload data to Xero directly from Google Sheets. Multi-Currency Reporting. Custom templates. 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, Tableau, Power BI to build BI dashboards with a live Xero data feed.

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. Connect your 
  companies once and refresh with one click or schedule an auto-refresh.

 * Create/update data queries/reporting templates

 * Multi-Currency converter in all reports

 * 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 (UK, AU, NZ): get and refresh data from Employees, Pay stubs, Pay Schedules, etc. 
 
 * Auto-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 support@accon.services for all questions, 
technical issues, feedback or if you would like to request new features. 

* Documentation
  https://wiki.accon.services/ 

 * Product Requirements
You must have an active Xero account and Google business or personal account
Additional information
PricingNot available
Developer
Privacy policy
Terms of service
G-Accon for XERO will ask for the permissions shown below. Learn more
G-Accon for XERO will need access to your Google account
This will allow G-Accon for XERO to :
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
John Hill
May 29, 2024
I now have Xero always connected to my dashboard sheet via G-Accon. I cannot run my business without it!
Is this review helpful?
Yes
No
Profile Picture
Greg Borchard
March 7, 2023
I've been a user of G-Accon since very soon after it launched. Our firm is a Gold Xero Advisor and we use this product to push and pull between Xero, Xero Practice Manager and Sheets every day, with many routines automatically scheduled. The tool is now an indispensable part of our systems as it significantly assists with saving time and automatically sending reports to staff and clients. We have always found support to be highly responsive, and the development team listen well to feedback - even producing reports we have requested. This is a quality, reliable product highly recommended.
Is this review helpful?
Yes
No
Profile Picture
Drew Griffiths
October 14, 2022
I cannot recommend this software enough. Combine the power of Google Sheets (app scripting, standard functions) with XERO data, add a touch of additional meta and you end up with a really powerful piece of kit. We use ours for forecasting, commissions, identifying trends and customer outreach scheduling (based on purchasing history). The staff at G-Accon have always been super super helpful and I thank them for giving us access to a tool which I can honestly say has increased our revenue in the business
Is this review helpful?
Yes
No
Profile Picture
Jeremiah Thee
December 19, 2022
G-accon is has allowed our company to prepare all needed financial statement reports for consolidation of multiple Xero books. Their support team is really responsive and is willing to implement changes and updates specific to our company to help us in financial reporting.
Is this review helpful?
Yes
No
Profile Picture
Melinda Byerley
November 3, 2020
If you're looking for a simple product to help you get more out of your Xero data, this is a great tool and an even better team that stands behind their product. Recently their team stood by me during a personnel and domain name change that was very thorny, and not entirely all on them. I really appreciated their crew and the reliability and ease of use of the product. How anyone uses Xero without a tool like this is beyond me! Thanks Yelena!
Is this review helpful?
Yes
No
Profile Picture
A User of G-Accon for XERO
August 19, 2019
We have been using this add on since the early days. It is well written and easy to use. It really helps us pull together our financial reporting much more quickly than without it. The app has continued to develop and get better over time with added functionality being added. Love it!
Is this review helpful?
Yes
No
Profile Picture
Juan Visser
October 14, 2020
The team does an exceptional job. We requested a customer/supplier analysis in foreign currency and they build it as an standard feature. Customer Support is the best of all the applications we tested. We are rolling this out as an standard add-on to all our clients.
Is this review helpful?
Yes
No
Profile Picture
A User of G-Accon for XERO
September 1, 2019
Thank you for keep adding new reports! I love this tool - it excellent add-on. I use the auto refresh feature which save me ton of my time. Very easy to use UI, a lot of wonderful features such as email notifications, alerts, scheduler, and data refreshes. Love it! Support is also great!
Is this review helpful?
Yes
No
Profile Picture
A User of G-Accon for XERO
May 16, 2018
I've been using Xero for 5 years and found out about this yesterday. This software is just amazing, I have sales team and finance teams that might not have access to Xero as I do, but now I can just prepare each one his / her own reports tailor made in under 5 minutes. This is amazing and I'd like to thank the developers for doing this. really great work!
Is this review helpful?
Yes
No
Profile Picture
A User of G-Accon for XERO
August 5, 2020
Hi there, I have a few questions - 1) how do you add multiple Xero organizations? So far I was only able to connect to one and I couldn't find the setting to add more organizations. 2) Is there a report to show the accounting report by divisions? thanks!
Is this review helpful?
Yes
No
1-10 of 24
Search
Clear search
Close search
Google apps
Main menu