G-Accon is a leader in the market of integrating Google Sheets with various Cloud Accounting platforms, including Xero and QuickBooks Online.
G-Accon integrates Google Sheets with Xero and QBO and synchronizes data in both directions. This eliminates the need for mistake-prone manual exports and imports. With G-Accon, you can use the power and convenience of Google Sheets to customize and manipulate data in ways you aren’t able to in your cloud accounting software.
Save hours on exporting, reporting, uploading data, and much more. Imagine automatically sending your clients all of the reports they request, with just the data they need, right when they need it. With G-Accon, you can create workflows to automate your manual tedious tasks when you are offline. You can also save time by uploading your data in bulk directly from Google Sheets.
Securely connect Google Sheets to your Cloud Accounting software and pull your data in seconds. The data is transferred directly between Google Sheets and Xero or QuickBooks through secure OAuth 2.0 protocol and API. Easily build custom reports and dashboards using our flexible templates.
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. Haven't braved the data pulls or updating yet but look forward to using that to auto-create invoices too...read more
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....read more
Why Xero doesn't just buy this company and create better dashboards, forecasting and data analysis tools is beyond me. But I'm so glad they are here. They stand behind their product and it works. When you combine G Accon with the power of sheets you really can make Xero's data into the financial dashboard of your dreams. Superb, responsive, and helpful team....read more
Great product that has enabled some very informative visual dashboards to be created in Google Data Studio. These dashboards have enabled different teams to access and view their information without giving them access to all our accounting information. This has enabled them to make great finance based decisions moving forward. Lots of setup options and their support team are really great...read more
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, as they happen. Super-easy to use: set it up, automate it and walk away. So now we can project cash flows based on invoice due dates, collect on debts, calculate sales commissions, etc all in mere minutes....read more
We do ALL of our budgeting and cash management in Google Sheets, and G-Accon is as absolutely a solid application for moving data from QuickBooks to Google Sheets as you are going to find anywhere... and I've tried a lot. We're using it now for I think several years... since they first introduced a QBOL version. The staff is incredibly responsive and helpful, and the product dependably, day after day, grabs the data out of QBOL...read more
Huge Time Saver. Love this product - and the customer support is fantastic. I've been pleasantly surprised with how driven their team has been to make sure I'm able to use G-accon in exactly the way I want to streamline my reporting. I've been looking for this integration solution for over a year and so happy to have it! Already saving me so much unnecessary time on formatting and copy/paste of QBO data into custom reports!...read more
Fantastic. This is exactly what I have been looking for! I have been spending hundreds of hours alternating between exporting manually and writing api scripts for the past 3 years and now I can get it all done for a nominal cost. The unlimited number of companies allow for a lot of growth of my own business and the simple interface makes set-up a breeze....read more
Seamlessly connect Google Sheets to your Cloud Accounting software and synchronize data in both directions. Pull your data into Google Sheets or make changes and push them back to Xero or QBO (Update, Insert, Delete).
Automatically refresh your data and reports using a flexible schedule: hourly, daily, weekly, monthly.
Use our flexible templates to build custom reports and charts. Easily connect to Google Data Studio to create powerful analytics.
Automatically generate and send updated reports to multiple recipients in PDF, Excel, CSV or Google Sheets.
Create, Update, Delete invoices, Accounts, Transactions, Journals, Contacts, etc. directly from Google Sheets. No more hassle with CSV files.
Collaborate with your team and clients in real-time using the native features of Google Sheets - Share, Comment, and Track Changes.
To install G-Accon Add-on for Xero or QuickBooks 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 (Or QuickBooks 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.
Register for our weekly webinars to see G-Accon in action and ask us any questions!
No credit card required.