Connect Google Sheets to Xero,
by-directionally. Get data from Xero Accounting, Payroll, Projects, Assets API's. Pull data, reports, and build custom queries. Make changes and import data into Xero directly from Google Sheets.
Generate reports using our flexible templates with filters and dynamic dates. Compare multiple periods, tracking categories, multi-currency, and more. Create 50+ reports including Account Transactions, Purchase Orders, Profit and Loss, Income Statement, Balance Sheet, etc.
Refresh your reports & dashboards automatically when you are offline using a flexible schedule: hourly, daily, weekly, monthly. Create BI dashboards by connecting your spreadsheets to Google Data Studio and setting auto-refresh.
Create/Update/Delete Invoices, Bank Transactions, Manual Journals, Contacts, Purchase Orders, Payments, etc. and post to Xero. No more hassle with CSV files. Schedule automatic data uploads from Google Sheets to Xero.
Automatically generate and email real-time reports to your team and clients in Excel, PDF, CSV or Google Sheets. Create and send alerts when certain criteria are met.
Easily share spreadsheets and collaborate with your team and clients in Google Drive. Work as a team on a shared spreadsheet, leave comments, and track changes. Your non-Xero users can now see live data!
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 your reporting and upload templates in the Cloud. Share with your team members.
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.
Convert all reports to the currency of your choice (160 currencies). Generate Account Receivables and Payables reports in the customer's currency.
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.
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.
Fantastic add-on! I've been able to remove a lot of monotonous work that needed detail and I've been able to setup alerts when changes occur on my reports. Very efficient and forward thinking...read more
GAccon allows me to prepare the most requested report NOT in Xero - profit and . loss by tracking category with filters. Without it I would be lost in excel for hours pulling this report together. GAccon is a crucial and indispensable tool for Xero...read more
Great add on, which had allowed me to automate a substantial part of my workflow. There was a report I needed that was unavailable however I spoke to Andrey at G-Accon and the report was added to their feature set within 2 weeks...read more
We're steadily building out our G-Accon powered set of Google Sheet based reporting systems across our CFO clients. The automated Xero report pulls feeding into our weekly and monthly reporting are saving us a whole lot of time so that we're more real-time and proactive than ever....read more
G-Accon is a fantastic plugin! As a cloud integrator specialist I can't express how magical this plugin has been in delivering important and relevant data to my clients all with a click of a button. Andrey is a fantastic developer and excellent at taking feedback and providing quick fixes to any bugs you may come across. You can't go wrong with this plugin...read more
I cannot overstress/-sell how this add-on has helped us! We have 3 entities in a group that needs to be consolidated and reported on on a fairly regular basis. Thanks to G-Accon, we've managed to live-link our TBs in Google Sheets, consolidate them and viola - "live" management accounts. This saves so much time each month and enables us to see the effects of transactions on the reports and forecasts...read more
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.
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.
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.
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.
Read our detailed documentation and user guides.Read Documentation
Schedule a 30-minute meeting and a free consultation call with us.Schedule Now
No credit card required.