Help & Support
Send Feedback
G-Accon for XERO
Instantly Connect Google Sheets to Xero and Automate Your Reports
www.accon.services
5,309 users
Works with
Install
Overview
Award-winning Xero Add-On that seamlessly integrates Google Sheets with Xero in both directions. Easily extract Xero reports & data or make changes and upload data into Xero directly from Google Sheets. Automatically refresh and email Xero reports by using a flexible scheduler tool when you are offline. Share spreadsheets and collaborate with your team & clients in Google Drive. Connect to Google Data Studio to build beautiful BI dashboards. Emerging App Partner of the Year in Xero Awards 2018.

Product Features:

* Get real-time Xero Reports in Google Sheets. Use templates to easily customize your reports and schedule automatic data refresh:
Profit and Loss, Income Statement, Balance Sheet, Detailed Account Transactions, 
Purchase Order Summary Report, Purchase Orders Report, etc.
  
* Xero Accounting: pull and refresh data queries in Google Sheets from
Invoices, Journals, Expense Claims, Contacts, Bank Transactions, Accounts, etc. 

* Xero Projects: pull and refresh data from Projects, Users, Tasks, Time tables

* Xero Assets: pull and refresh data from Assets, Asset Types, Settings tables

* Xero Payroll (AU, NZ): pull and refresh data from Employees, Pay stubs, Pay Schedules, etc. 
 
* Import data into Xero: UPDATE, CREATE, DELETE data directly from Google Sheets and post to Xero - Invoices, Bank Transactions, Contacts, Credit Notes, Items, Contact Groups, Manual Journals, Linked Transactions, Payments, Purchase Orders.

 * Automatically refresh & email reports and data queries by using a flexible schedule

 * Easily switch between multiple organizations.

 * Schedule a backup of historical data 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.  

 * Product Requirements
You must have an active Xero account and Gmail account

Documentation can be found on our website:
http://www.accon.services/gacconforxero.html
Reviews
Damion Viney
March 28, 2019
This is a brilliant addition to the toolkit. It is going to revolutionise reporting.
Submit reply
Cancel
A User of G-Accon for XERO
February 6, 2019
Works like clockwork. Team is also very helpful and responsive if you have a question.
Submit reply
Cancel
A User of G-Accon for XERO
September 7, 2018
So incredibly stoked to find this add-on. Saved me hours and hours!
Submit reply
Cancel
Idan Kfir
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!
Submit reply
Cancel
A User of G-Accon for XERO
March 11, 2018
Excellent piece of software, thank you! Future idea: Would be nice to get a list of Bills that can be reconciled against a PO they were copied from to be sure all line items were paid (or not).
Submit reply
Cancel
A user of G-Accon for XERO
March 17, 2018
Hi There, We just added 3 new reports that can be used to reconcile PO and Bills: Customer Running Account Details, Customer Running Account Summary and Sales Invoice Summary. Thanks.
A User of G-Accon for XERO
January 23, 2018
A very responsive development team. The app certainly lends greater flexibility to what we can download from Xero.
Submit reply
Cancel
Ron Abarbanel
November 11, 2017
If you need to pull data from XERO into sheets, this little app has got your back. The responsive of the developers is also amazing. I found an issue and they fixed it within 4 hrs!! And while it currently does most things you would ever need, I only expect it to get better.
Submit reply
Cancel
1-7 of 7
Additional information
Search
Clear search
Close search
Google apps
Main menu