Automatically export, refresh, and bulk upload data to QuickBooks directly from Google Sheets. Certified by Intuit QuickBooks.
Listing updated:October 19, 2024
Works with:
27K+
Overview
Connect Google Sheets to multiple QuickBooks companies in 2-way sync. Schedule automatic data uploads to QuickBooks directly from Google Sheets. Automatically refresh and email updated QuickBooks reports by using a flexible schedule. Share spreadsheets and collaborate with your team & clients in Google Drive. Connect to Google Data Studio to build BI dashboards.
 
Great tool for accountants, advisors, and business owners to customize and automate reporting, upload data in bulk, consolidate data, build charts, manipulate data using the power and convenience of Google Sheets.

Features:
  * Connect Google Sheets to unlimited companies
  * Create/update data queries/reporting templates
  * Save & Share templates in the Cloud
  * Schedule automatic data uploads to QuickBooks (Update, Insert, Delete)
  * Schedule automatic data refresh (hourly, daily, weekly, monthly)
  * Refresh data/reports for all companies in one click
  * Consolidate data for multiple companies in one or several spreadsheets
  * Auto-export and email updated reports in Google Sheets, Excel, PDF, CSV
  * Schedule backups of historical data snapshots in your Google Drive
 * Create workflows to automate your tasks
  
Contact us support@accon.services for all questions, issues or feature requests.
Additional information
PricingNot available
Developer
Privacy policy
Terms of service
G-Accon for QuickBooks will ask for the permissions shown below. Learn more
G-Accon for QuickBooks will need access to your Google account
This will allow G-Accon for QuickBooks to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
Send email as you
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Asad Hameed
February 20, 2023
I am thoroughly impressed with the software I am using! It is user-friendly and intuitive, making it easy for me to navigate and complete tasks quickly. The features are robust and reliable, allowing me to perform a wide range of functions with ease. Overall, this software has greatly improved my productivity and made my work much more efficient. Highly recommended!
Is this review helpful?
Yes
No
Profile Picture
Murtaza Sohail
February 20, 2023
I am thoroughly impressed with the software . Its user-friendly and seamless which makes it beautifully easy to use, even for a person like me who is not tech-savvy. G-Accon has helped me to achieve my goals and complete tasks efficiently, which otherwise would have taken a lot of my time . I highly recommend this software to anyone looking for a top-notch solution in its category. from Murtaza A HAPPY & SATISFIED User
Is this review helpful?
Yes
No
Profile Picture
Gavin DeJong
February 14, 2023
This is by far the best product in the market for linking Quickbooks with Google Sheets. When I first starting looking for app's on google sheets to linkk QBO with Google sheets, I found there were a lot of options. But the other options were overcomplicated and couldn't accomplish what I needed without having a background in coding. This app allows you to automate data fresh from a few hours to every day. This app has saved me hours each week in creating financial dashboards, and allows for me to have daily data that is always up to date without any manual labor. The app includes easy to use and helpful filters to help you pull the data you want in your sheet. And if you have a basic understanding of formulas on google sheets, you can build so many great snap-shots of your QBO data. Another great feature is the email notifications you can set up when certain cells of your choosing change. Lastly, this app allows for you to manipulate your data on google sheets, and then re-uploaded back into your QBO. I have found this very helpful when updating hundreds of transactions each month and not having to click into each individual transaction on QBO. Overall, a great product.
Is this review helpful?
Yes
No
Profile Picture
A User of G-Accon for QuickBooks
December 16, 2021
Fantastic product; enables us to automate a lot of reporting and get data into QBO in real time throughout the month rather than waiting until month end close. Once you figure out how it works, it's a breeze! It's a lot less complicated than it seems at first and actually quite intuitive. There are a few features I hope they add eventually (ability to filter Vendors/Customers by custom fields or the notes field would be awesome), but I have so many uses for this product that it's still worth it to have!
Is this review helpful?
Yes
No
Profile Picture
James Hogan
February 17, 2021
This App not only downloads any QBO module to Google Sheets; you can also design layouts to send data back into QBO in bulk. You can retrieve the unique IDs. Customers, Suppliers/Vendors, Invoices, Bills ,Credit notes/(memos), products...the lot. Include or use all the data items that are not available to use via QBO built-in import feature. No need to layout CSV or XLS files to match the QBO Import feature. Send it directly from Google Sheets with the click of a mouse. Map it all from within Google Sheets. Up until the day I found this app I was a Sage / Excel evangelist. Now its QBO with G-Accon for everything! Incredible? Well I am struggling to beleive just how good it is and how it's making things so much more efficient. Thank you G-Accon.
Is this review helpful?
Yes
No
Profile Picture
James Giddings
November 23, 2020
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. Definitely a product you need if you have QuickBooks.
Is this review helpful?
Yes
No
Profile Picture
A User of G-Accon for QuickBooks
July 17, 2019
We've been waiting awhile for this great new product. It's still in Beta, with the extract Reports function just recently released. But its stunning! I've run the Data Table extract for a number of months now, and its been flawless. Reports I have only a week or so of experience with. But the options they provide to customize the output, as well as the detail scheduling available, make this tool invaluable and unique for getting QBOL data out into G-Sheets. Thank you G-Accon for this totally valuable tool.
Is this review helpful?
Yes
No
Profile Picture
Ron
April 7, 2021
I have set up my financials in Google Sheets the way I want them to look and the layout. I would then export reports from QBO to excel and laboriously copy and paste into google sheets. This was fine for a while until I needed frequent updates. I searched for software that could import the data into google sheets so that my financials and graphs could be updated without this process of copy and paste. I found G-ACCON and it was a weight that was lifted off my shoulders. It is so simple to use and even though I needed support on one instance it was answered within a day (due to time differences) and even then figured out before that I could manually update at any time - It has made working with QBO a pleasure and the day has been saved . I have not even touched the surface of what G-ACCON offers but the simplicity of its workings makes it an absolute pleasure to work with. I can now concentrate on my core duties and this is what it should be all about. Well done G-ACCON I still cannot believe I found this.
Is this review helpful?
Yes
No
Profile Picture
Jeffrey Abrams
August 26, 2020
I love this tool! Such a huge timesaver.
Is this review helpful?
Yes
No
Profile Picture
A User of G-Accon for QuickBooks
February 25, 2020
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.
Is this review helpful?
Yes
No
1-10 of 21
Search
Clear search
Close search
Google apps
Main menu