Help & Support
Send Feedback
G-Accon for XERO
Connect Google Sheets with Xero to pull live data & reports.
www.accon.services
3,533 users
Works with
Install
Overview
G-Accon is a Xero App Partner - powerful Add-On designed for Google Sheets integration with Xero Accounting Software. Sign in to Xero directly from spreadsheets and easily pull real-time data & reports or design your own reports and dashboards using the power of Google Sheets. Refresh data instantly and securely share with your team & clients in Google drive. 

Product Features:
 * Sign in to Xero from Google Sheets (through secure OAuth authorization)

 * Get Data from Xero tables
Pull data from Xero tables using accounting connector: Invoices, Expense Claims, Contacts, Bank Transactions, Accounts, etc. Deep links make it easy for you to navigate directly to a document or resource within Xero.

 * Download Xero Reports: 
Profit and Loss, Income Statement, Balance Sheet, Detailed Account Transactions, 1099, 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. Can't find a report you are looking for? Contact us and we will develop a custom report for your business.

 * Report search screen
Filter and customize your reports based on tracking categories, cash/accrual basis, date range, compare to previous periods options, etc. 

 * Get US Payroll Data
New: US Payroll connector allows you to pull data from Employees, Pay stubs, Pay Schedules, etc.

 * Easily switch between multiple organizations.

 * Refresh data instantly, without going to Xero.com 

 * Deep links allows you to link to Invoices, Contacts, Bank Transactions, Reports and other documents within Xero 

 * Design your own reports and dashboards using Google Sheets and real-time Xero data

 * Share and collaborate using Google Sheets functionality
With G-Accon, you can free yourself from copy and paste and manually exporting data from Xero to Excel or Google spreadsheets. All your data will be available in Google Sheets, so you will increase efficiency and save a lot of time!

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


Reviews
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-3 of 3
Additional information
Search
Clear search
Close search
Google apps
Main menu