App Icon
G-Accon
•  12,301
Overview
Instantly Connect Google Sheets to Xero and Automate Your Reports
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
Reviews
Language:
Sort by:
Profile Picture
Morris Bryant
November 18, 2020
Incredible product and amazing support.
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 Pciture
Yelena Tretyakova
November 3, 2020
Thank you, Melinda, for these nice words!
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
Bulelani Matiti
October 13, 2020
Hi What should I do if I don`t have a "Get Data" option on this add on? Many Thanks. Bulelani
Is this review helpful?
Yes
No
Profile Pciture
Yelena Tretyakova
October 13, 2020
Please select Add-ons-->G-Accon for Xero-->Get Data-->Get Accounting Data. You should be able to pull all required Xero tables. We also offer free Webinars on Wednesdays or we can send you the recorded version with our product overview.
Profile Picture
Zoe Liu
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
Profile Pciture
G-Accon Integrations
August 5, 2020
Hi G-Accon user, Let us answer your questions: 1). You don't add Xero organization, you need to set up templates for each of your organizations. Our application is based on templates. This is how it works... You log in to the first entity, create and execute the template, set up automation, and save your template in the cloud, log out from one company. Next step, you need to log in to another entity, load the saved template, execute it, set up automation... and do it for all your companies. Then you can close your spreadsheet - you don't have to be logged in to any organizations - our app brings data from all your Xero entities based on the refresh schedules. The bottom line, you still need to spend time and set up templates for all your entities, but it will be only once. As soon as you set up everything, the automation process will work by itself - you will be just monitoring it. 2) There are multiple reports available to you. In Xero 'divisions' are called "tracking categories". There are Account Transaction, P&L, Tracking Summary, Age Receivable/Payable Details, Casg Summary, Payable Invoice Details, and other reports. Feel free to send email to support and ask more questions.
Profile Picture
Rayhan Aleem
July 28, 2020
We are testing this software and can say that we are enjoying using it more and more. The team are very helpful and friendly too!
Is this review helpful?
Yes
No
Profile Picture
Sammy Choi
July 28, 2020
Does exactly what we needed it to do! Very easy to use and communication with the support team is exceptional. Their product team was able to take some of my feedback and add it into the next release pretty quickly.
Is this review helpful?
Yes
No
Profile Picture
A User of G-Accon for XERO
May 21, 2020
Is upload as a draft user expense supported?
Is this review helpful?
Yes
No
Profile Pciture
G-Accon Integrations
May 21, 2020
Thank you for your question! Xero API Expense claims are deprecated from the API perspective. Xero introduced a new expense process approximately in 2019 and had not to implement the corresponding API for app partners like G-Accon. As soon as API is available to us, we will be happy to implement expenses for all our users.
Profile Picture
A User of G-Accon for XERO
April 29, 2020
timesout when trying to pull account transaction report. tried one month and a small account. Pretty much useless without this.
Is this review helpful?
Yes
No
Profile Pciture
G-Accon Integrations
April 29, 2020
Thank you for your feedback. There are limits on how much data you can pull using a single request in an Account transaction. As we don't see details in your post we assume you pull data for multiple years which causes the timeout. In this situation we usually suggest to our customers to split data by chunking it out using Date Range. If you use our automation, we would suggest further action to spread the schedule and refresh data on the template level at different times. Any questions can be asked by sending email to support. We will answer all your questions and give you the solution.
Profile Picture
A User of G-Accon for XERO
October 11, 2019
I just love using this tool. So much time is saved! Excellent new reports! The new automation feature where I can just schedule my uploads and do it for multiple spreadsheets and for a different Xero organizations is absolutely brilliant. The support team is always there to answer all my questions. Thank you Accon!
Is this review helpful?
Yes
No
1-10 of 21
Additional information
G-Accon
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu