QBO to Google sheets sync

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.

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.

You may also consider looking for a third-party application that supports syncing and managing data to Google Sheets. Then, integrate it into QuickBooks to handle the report in the software.

Here's how you can connect the app to QBO's system:

1. Log in to your QBO account and go to the Apps menu.
2. Enter the application's name on the Search bar or choose the category on the Browse category dropdown.
3. Follow the onscreen process of linking the app to QuickBooks.

For future reference, I'm adding these articles to guide you once you need to transport data from QuickBooks:

• Export data out of QuickBooks Online.
• Export reports, lists, and other data from QuickBooks Online.

You can always add a reply on this thread if you have more concerns about syncing reports or managing data in QBO. 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:

1. Open your QBO account.
2. Go to the Gear icon and select Feedback.
3. Enter your suggestions and then click on Next.

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:

• Customize reports in QuickBooks Online
• Memorize reports in QuickBooks Online

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 said "Please note Spreadsheet Sync is compatible with the Office 365 version of Excel and Google Sheets."

You are from Quickbooks and that statement appears to be 50% inaccurate.  Why would you tell someone that as method of providing support?

Does Spreadsheet Sync support Google Sheets or not?

I appreciate you for joining this thread, @JohnnykT. Allow me to answer your question.

Yes, Spreadsheet Sync for Google Sheets is available. However, it's only available for QuickBooks Online (QBO) Advanced. You can read more details by clicking this article: Firm of the future.

You can also contact the Spreadsheet sync and Google Sheets support to learn more about the specifications of their product for a successful integration.

Concerning about the statement Spreadsheet Sync is compatible with the Office 365 version of Excel and Google Sheets, it's based on the system requirements when installing them in QBO Advanced, you can read this article for detailed info: Frequently Asked Questions about Spreadsheet Sync in QuickBooks Online Advanced or Accountant.

If you have additional questions about Spreadsheet sync and Google sheets in QBO, don't hesitate to reply to this post. Keep safe, and have good one.

sadf

I have QBO advanced and have found Zero instructions that show someone how to sync google sheets wit...

I appreciate you for taking the time to share your concerns here in the Community, Grimayoj. Let me clarify things for you.

With the Spreadsheet Sync feature for Google Sheets, you can now securely transfer data between QuickBooks Online Advanced and Google Sheets. This functionality was previously only available with Microsoft Excel, but now it allows you to create pivot charts, graphs, and collaborate seamlessly with clients using Google Sheets.

Here's how to do this:

1. Go to Reports on the left navigation panel.
2. Pick a report.
3. Click the Export icon and select Export to Google Sheets.
4. Follow the prompts to authorize QuickBooks to access your Google Sheets account.

Once you’ve exported the report, you should see an option to enable automatic synchronization. Make sure to turn on the automatic sync feature so that any changes made in QuickBooks Online are reflected in your connected Google Sheet.

For more information, feel free to check out these helpful resources:

• Spreadsheet Sync for Google Sheets
• Get started with Spreadsheet Sync

You might also want to check out this article on maximizing Spreadsheet Sync with Google Sheets: Use Google sheets integration in QuickBooks Online Advanced.

If you have any more questions about Spreadsheet Sync for Google Sheets, please don't hesitate to reach out, Grimayoj. I'm here to support you and make sure you get the most out of your QuickBooks Online Advanced subscription. Take care!

Thanks for the information, which is, yet again, confusing and the opposite of what others at Quickbooks have posted.

THis feature, as you describe it does NOT seem to work at all as described.  Please don't tell me to get QBO Advanced -- I have it and understand that it is required.

When I produce a report, I have the option to Export to Google sheets.

When I tried for the first time, nothing happened.  THe second time, it asked me to authenticate to Google -- which I did.  I gave QBO access to my Google account as required.  Easy stuff -- all kinds of apps need that.

Now that I've done that, the ONLY thing I can do is export a report into Google SHeets... that's it.  I don't get to select the sheet, it isn't connected to anything, I don't get asked to connect it to anything.  It just creates a Google Sheet with my report in it.

There is nothing SYNC about this. It just dumps a Google SHeets version of my report into MY Drive on Google.  If I try exporting the same exact report again, it just creates a new file.

Please please please --- do NOT send me instructions on how to make this work with Excel.  I don't want it to work with Excel, I want it to work with Google SHeets.

Hi there, JohnnykT. Allow me to route you to our support team who can assist you with this matter.

I appreciate the efforts you've made to export your report to Google Sheets. Since you're encountering issues with selecting the sheet and it's only creating a new file, I suggest contacting our Customer Support team. They have the tools to verify the integration and review the exported data.

To reach them, follow the steps below:

1. Log in to your QuickBooks Online company.

2. Click on Help (?) and head to the Search tab.

3. Select Contact US, then pick Ask about something else.

3. Enter your concern in the designated box and hit Continue.

4. Choose how you would like to connect with an expert: Start a chat or Get a callback.

Please also note their support hours so you can connect with them accordingly. For more information, visit this page: QuickBooks Online Support.

Additionally, I've added these articles that'll help you in managing and personalizing your reports in the program:

• Run reports in QuickBooks Online
• Customize reports in QuickBooks Online

If you have other questions while working with your data through Google Sheet or concerns with QuickBooks, let me know by leaving a comment below. I'm just a few clicks away to help.

These instructions below that you are describing do not occur.. There is no automatic sync that occurs in google sheets. That exact step is for excel not google sheets.. Maybe do a print screen on that piece of hte instruction where it states auto sync with GOOGLE SHEETS... And every link that everyone sent basically shows EXPORTING TO GOOGLE SHEETS which is not SYNCING.. And the other links are SYNCING with EXCEL... 

1. Follow the prompts to authorize QuickBooks to access your Google Sheets account.

Once you’ve exported the report, you should see an option to enable automatic synchronization. Make sure to turn on the automatic sync feature so that any changes made in QuickBooks Online are reflected in your connected Google Sheet.

I've done this multiple times. Each time I'm told I need to speak with a special department and given an 800. That number rings on some guys phone that has a full mailbox.

It would be great if they have it and it works.. But so far not a single person has pointed me to any instructions that actually are related to a data sync between QBO and GOOGLE SHEETS.  I think people are mixing up 

data sync with QBO and EXCEL and also thinking an EXPORT FROM QBO to GOOGLE SHEETS is deemed a sync when in fact its just an export.  Just need someone to send us detailed instructions on this..

THans

So far, the online chat support team is even worse than on here... they don't even know what sync is.  And, when they do, they route me to a "special" department and give me a phone number.  This new phone number goes to Quickbooks Time... which is completely unrelated.