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:
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.
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!
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.
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
4. Paste the link generated by Google Sheets (1) and press Next(2).
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.
6. Congratulations! The Google Sheets file has been successfully imported into your QuickBooks Online company.
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.
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).
Does it cost to use Google Quickbooks?