Export data to Google Sheets with QuickBooks Online Advanced

You can now export QuickBooks reports to Google Sheets using QuickBooks Online Advanced.

Before you begin

If you are exporting data for the first time:

• Ensure you have a Google account already created.
• Adjust your web browser settings to allow pop-up windows from QuickBooks Online.

Export data to Google Sheets

1. Sign in to your QuickBooks Online account.
2. Go to Reports and select Standard reports (Take me there).
3. Open the report you’d like to export to Google Sheets.
4. Select the export icon , then select Export to Google Sheets.
5. Enter the verification code sent to you, then select Continue.
6. Select Get started.
7. Review the permissions information presented.
8. Select Allow to accept permissions. Your Google account opens.
9. Sign in to Google, if prompted, and follow the next steps.
10. Google Sheets links to your QuickBooks Online account and allows for the export of data.
    Note: If you have previously completed your verification, you can access Google Sheets.

Manage exported Google Sheet data

Once the Google Sheet is created, any exported data will be saved on the Google Sheet and can be accessed using the same Google account. The exported data is not controlled any longer by Intuit, and the Google Sheet cannot be imported back into QuickBooks Online.

Note: Any data exported to a Google Sheet will not reflect subsequent changes made in QuickBooks Online unless another export is undertaken.

How can I best use Google Sheets?

Review this article (available in English only) to learn ways to use Google Sheets integration in QuickBooks Online Advanced as an Accountant.