Our Features

Work with your live Xero data directly
from Google Sheets

Powerful features for accountants

  • Consolidate Multiple Organisations

    Connect your Google spreadsheets to multiple Xero accounts - a separate tab will be created for every organisation. Consolidate your data. Refresh all organisations automatically or on demand.

  • Save & Share Templates in Cloud

    Save your reporting and upload templates in the Cloud. Share with your team members.

  • Audit Trail

    History & Notes summary for accounting transactions and user activities. By using this module, G-Accon users will be able to view an audit trail of the notes recorded against their organisation’s transactions.

  • Multi-Currency Reports

    Convert all reports to the currency of your choice (160 currencies). Generate Account Receivables and Payables reports in the customer's currency.

  • Bulk Uploads

    Make your changes in Google Sheets and upload to multiple Xero accounts in one click. For example, allocate credit notes for all your clients, create invoices, edit the chart of accounts, post transactions, etc.

  • Workflow Automation

    Use G-Accon's workflow builder to easily automate your manual repetitive tasks and focus more on your clients. Automatically generate reports, emails, exports, and bulk uploads. Easily schedule data backups in your Google Drive.

New Add-On

Connect Google Sheets to

WorkflowMax

Try G-Accon for WorkflowMax Beta now

No credit card required. Free Beta release.

Get Started Now
Top 10 App in the Xero marketplace

Thousands of businesses and accounting firms
use G-Accon


Read 5-star reviews on the Xero marketplace

How does G-Accon work?

01

Install Add-On

To install G-Accon Add-on for Xero you need to go to Google Drive and navigate to New -> Google Sheets. In a new Google Sheets press on Add-Ons -> Get add-ons. In a new popup “Google Workspace” window on the upper right side type “g-accon" and hit “Enter”. Then press on “+” next to G-Accon for Xero or QuickBooks. Accept Google permissions and finish the installation.

02

Connect to Xero

From the Google Sheets menu, select Add-ons -> G-Accon for XERO -> Xero Sign In. By pressing the “Connect to XERO” button you will be redirected to the xero.com website login screen. Enter your credentials and login to Xero. Select which organization you need to pull data from and click on the “Allow Access” button.

03

Create Templates

From the menu, select Add-ons -> G-Accon -> Get Accounting Reports or Get Accounting Data (to pull raw data). There are multiple accounting reports you can select from the drop down box which allow you to create reusable templates to use later on. Select your options, such as dynamic or custom dates, filters, multi-currency, time periods, etc. You can also save your templates in the Cloud and share them with your team or clients. Click "Execute" to generate your report and save your template.

04

Schedule Auto-Refresh

Use our workflow automation to automatically refresh your data in Google Sheets. From the G-Accon menu, select Automation -> Create Workflow. Drag and drop your templates in the Add Templates tab, select the Scheduler tab, and choose the automatic refresh interval: hourly, daily, weekly, or monthly. Email notification​ is a very powerful functionality that allows you to notify your customers about successfully refreshed queries/reports and provide them with the result of these updates as an attachment in Google Sheets, PDF, Excel, or CSV file.

Still have questions?


Partner with G-AcconLearn More

  • Install a Free Trial

  • Discuss with our team

  • Receive an excellent support

Install Your 14 Days Free Trial Now

No credit card required.