Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowIm getting conflicting internet repsponses that state you can and cant connect google sheets to QBO through the new spreadsheet syncing function... I would like to update a dashboard in google sheets with a QBO report..
Thanks
It seems that you're facing an issue with connecting your google sheets to QuickBooks Online (QBO) through the new spreadsheet syncing function, @Grimayoj. Know that I'm here to educate you more about this feature.
Currently, the feature Spreadsheet Sync is exclusively available in QuickBooks Online Advanced or QuickBooks Online Accountant. If you're using QBO Simple Start, Essential, or Plus. You'll want to consider upgrading your subscription to achieve your goal.
Please note Spreadsheet Sync is compatible with the Office 365 version of Excel and Google Sheets.
For frequently asked questions about Spreadsheet Sync, feel free to check this article: Frequently Asked Questions about Spreadsheet Sync in QuickBooks Online Advanced or Accountant.
Moreover, you'll want to secure a copy of all your financial data out of QuickBooks before canceling them: Export reports, lists, and other data from QuickBooks Online.
I'm just one post away if you need assistance with any QuickBooks-related concerns. You can click the reply button below to enter your queries. You have a good one.
I pay for advanced but I cannot see how it works with Google sheets.. Please explain,
THanks
Good morning, @Grimayoj.
I appreciate you asking additional questions about using the Spreadsheet sync feature within your QuickBooks Online.
Have you used the steps listed in this guide? Get started with Spreadsheet Sync for QuickBooks Online Advanced or Accountant
The guide provides details on how to get started with the feature, create spreadsheet report, add or edit data to your QBO Advanced company, and more.
I'll be waiting for your response!
These instructions are for Excel. They dont show how to use Sync with Google sheets..
Thanks
I'm happy to add more information about syncing reports to Google Sheets from QuickBooks Online (QBO), Grimayoj. Also, I'll provide some alternatives so you can seamlessly manage your data on the said application.
Please know that the syncing feature of reports from QuickBooks works only on Excel. Furthermore, we can only export a report to Google Sheets, but it's exclusive to the classic view of reports. This function is unavailable in the modern experience.
Some reports still have the option to switch from both views. Meanwhile, some don't have this selection anymore.
That said, if the report you're trying to pull up still has the option to Switch to classic view, please select that button. Then, hit the Export dropdown and click Export to Google Sheets.
Nevertheless, if the option to switch is unavailable, I recommend looking for a third-party application that supports syncing and managing data to Google Sheets. Then, integrate it into QuickBooks to continue with your needed task.
Here's how you can connect the app to QBO's system:
For future reference, I'm adding these articles to guide you once you need to transport data from QuickBooks:
You can always add a reply on this thread if you have more concerns about syncing reports or managing data in QuickBooks. I'll be here to help you at any time.
I appreciate everyones responses however I'm just looking for someone to tell me does the SYNC option work for google sheets? I know it works for excel and I know how to download reports.. Im building a dashboard and want to use the sync option for two reports but Im doing it in google sheets.. The sync instructions dont show how to use it with google sheets..
Thanks
Hi there, Grimayoj. Let me chime in and provide clarification about managing reports with Google Sheets sync.
The feature of syncing your reports to Google Sheets is currently unavailable in QuickBooks Online (QBO). The system exclusively supports syncing data to Excel. I suggest sending a feature request directly to our Product Developers. They may consider adding it in future product updates. Here's how:
You can also consider looking for a third-party app to integrate with QBO and use it instead in syncing reports to Google Sheets. To find an app, visit this link: QuickBooks App Store.
Here are some resources you can refer to when handling reports moving forward:
I'm always around and ready to help if you need further assistance or have questions about managing data or reports in QBO. Leave a comment below to notify me.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here