Import Transactions from Google Sheets into QuickBooks Online

Import transactions into Google Sheets

How to Import Transactions from Google Sheets into QuickBooks Online

After reading this guide you will be able to import your transactions with a Google Sheets link into QuickBooksⓇ Online using Business Importer.

Overview:

  1. Preparation of your Google Sheets file for import into QuickBooks Online
  2. Steps of importing your Google Sheets (Google Drive) file into QuickBooks Online
  3. Useful tips on how to import your data from a Google Sheets file into QuickBooks

Preparation of your file to import transactions from Google Sheets into QuickBooks Online

1. Open your Google Sheets (Google Drive) file you want to import.

2. Open File menu and select Publish to the Web.

Business Importer

3. Select the name of the sheet needed.

4. Click Publish Content and Settings:
Tick Automatically republish and untick the Sign in requirement option.

5. Press Publish. Now you’re good to go!

Import Transactions from Google Sheets

6. Confirm your decision to publish it in the pop-up window.

Great, now the link is prepared for import! Copy the link generated by Google Sheets.

Import Transactions from Google Sheets into QuickBooks Online

Steps of importing your Google Sheets (Google Drive) file into QuickBooks Online

1. Open Business Importer and click Upload file
2. Select the entry you want to get on QuickBooks end
3. Click Next

Import Google Sheets (Google Drive) file into QuickBooks

4. Paste the link generated by Google Sheets (1) and press Next(2).

Import your Google Sheets (Google Drive) file into QuickBooks

5. Proceed to mapping: select the Company Name(1) and Entity(2) here and do the mapping. After that scroll down and click Start Import.

Proceed to mapping to Import Transactions

6. Congratulations! The Google Sheets file has been successfully imported into your QuickBooks Online company.

import your data from a cloud storage file into QuickBooks

Press Invoice ID number to see your Invoice on QuickBooks side.

Useful tips on how to import your data from a cloud storage file into QuickBooks

1. If Require viewers to sign in with their corporate name account option is ticked you will get the Unknown file store error when importing the file. Make sure you allow access to the file by the link you provide.

import your data from a cloud storage file into QuickBooks

2. You can delete transactions that have been imported with the help of our app using Revert function in one click. Check out our detailed guide on the matter.

3. Another useful feature of Business Importer is that you can schedule your imports to be done automatically without you even logging in to the app.

In case you need any help or have any questions about the app, we are always by your side! Just initiate a live chat or reach out in any way you prefer (see the contact details mentioned in the footer of this page).

adodvolha

This entry has 2 replies

Leave a reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>