Help & Support
Send Feedback
G-Accon for XERO
Instantly Connect Google Sheets to Xero and Automate Your Reports
www.accon.services
2,588 users
Works with
Install
Overview
G-Accon is a powerful Xero Add-On that seamlessly integrates Google Sheets with Xero in real-time. Easily pull/export Xero reports & raw data or design your own reports and dashboards using the power of Google Sheets. Automatically generate and email Xero reports by using a scheduler tool. Share spreadsheets and collaborate with your team & clients in Google Drive, so they can see live Xero reports without signing in to Xero! You can connect to as many Xero accounts as you like.

Product Features:
 * Google Sheets-Xero connector (through secure OAuth authentication and Xero API)

 * Pull raw data from Xero into Google Sheets to reconcile and find errors:
Invoices, Expense Claims, Contacts, Bank Transactions, Accounts, etc. Use Deep links to easily navigate directly to a document or resource within Xero.

 * Pull Xero Reports into Google Sheets (choose from 30+ reports)
Profit and Loss, Income Statement, Balance Sheet, Detailed Account Transactions, 1099, etc. Filter and customise your reports based on tracking categories, cash/accrual basis, date range, compare to previous periods options, etc.

 * Custom reports: 
Purchase Order Summary Report, Purchase Orders Report, VAT 126, VAT Audit Report with Supplier's VAT Registration Number, New Income Statement with compare to previous periods. 

 * Easily switch between multiple organizations.

 * Refresh all organizations with one click

 * Automatically refresh & email spreadsheets by using a flexible schedule

 * Save historical reports in Google Drive

 * Monitor your data by creating alerts and receive notifications when certain criteria is met
 
 * US and AU Payroll Data
 Payroll connector allows you to pull data from Employees, Pay stubs, Pay Schedules, etc.

 * 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, Gmail account and Google Drive enabled


Reviews
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 Google User
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
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.
January 23, 2018
A very responsive development team. The app certainly lends greater flexibility to what we can download from Xero.
Submit reply
Cancel
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-4 of 4
Additional information
Search
Clear search
Close search
Google apps
Main menu