Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
Ivan_G
Moderator

Reply to message

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, not with Google Sheets. 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.

Export to google sheets.png

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:

 

 

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.

Need to get in touch?

Contact us