Importing QuickBooks Online Products and Services List

Written by Charley Blewett

Published: June 4, 2021

Feb 24, 2023

Part-3 of our QuickBooks List series Products and Services

Preparing Excel File for Import

In part-3 of our QuickBooks Online lists-based accounting software series, we continue our talk about importing your Products and Services list as an Excel, CSV, or Google Sheets file into your QBO Company File. Let’s review what we have gone over so far.

When you create each of your items for your Products and Services list, the headings that you see in the exported Excel file are similar to what you see when you create a new item in QBO – see part-1 of this series. – Exporting the Products and Services Report as an Excel or PDF file is fairly straight forward. When you open the Excel file for editing, remember to remove your company name and the Products and Services name from the first rows. You will want to leave only the column heading names in row 1. This is important because when you import the file, you will have to Map the headings to your QBO Accounts. Some of this list’s headings are:

  • Product/Service Name
  • SKU
  • Sales Description
  • Type
    • Inventory
    • Non-inventory
    • Service
    • Bundle
  • Price
  • Etc.

Starting the Import

After you have logged into your QuickBooks Online account in a Web Browser, not the smart phone app, navigate to the Products and Services list through the Sales section. Look on the top right hand side for the green New button. You would normally click this button to create a new Products and Services item to your company file. Notice the dropdown arrow to the right side of this button. Clicking it will bring up the dropdown “Import” option. Clicking this will open the Import Products and Services three-part window.

Upload File

The first Import Window is the Upload your file page. QuickBooks Online accepts Excel files (.xls & .xlsx file extensions), CSV (.csv file extensions), and Google Sheets files. You will see the “Select a CSV or Excel file to upload” and the “Select Google Sheet” dialog boxes. Depending on which dialog you use, you will either “Browse” for the file or “Connect” to your Google account to chose the correct file. Select your file and then click the green “Next” button on the lower right side.

Mapping the Headings to Accounts

Here you will need to review your file’s headings fields to the QuickBooks Online fields. You can change the selection through the dropdown arrow and scroll through your Chart of Accounts to select a different name. When you are satisfied with the field selections, you will click the next button.

QuickBooks Online Dashboard - import products and services

Import the File

On this last window before clicking the green Import button, review the chart and clear any red outlined items. Click the Import button. You should see a page describing how many items were successfully imported into your QuickBooks Online Company File. If there were any items with a problem, they will show here. Try to clear any faults and click the Import button again. When you have successfully imported the edited Products and Services file, you will be taken to your company Dashboard.

On a closing note, you will notice and option to overwrite all files. Select this if you are sure that you want to replace you Products and Services list with this new file. If you leave it unchecked, you will not overwrite the exiting items.

C and M Companies Inc – Small business support specialist.

We offer time saving services for the busy owner managing their company’s Payroll | Bookkeeping | Marketing | Web Design responsibilities. Building your brand takes a coordinated effort on many fronts. Call to see how we can help you manage your operations. We offer a free in-person 30 minute business services consultation.

Contact C and M today.


Submit a Comment

We would love to talk you about your business & success

We can help you avoid many pitfalls business owners experience. Your payroll obligations and financial account records will be treated with respect.

QuickBooks logo

Save 30% - QuickBooks Online

Small business’s #1 preferred accounting software. Powerfull organization to help run your business smoothly. Click here to get 30% off for 6 months. Try it out and save!

QuickBooks Accounting Software is geared towards helping the small business owner. QuickBooks Online is great for busy owners needing an easy method of bookkeeping.

We help our clients get the most out of their QuickBooks Online service. Click the button above to save 30% off the regular subscription price for 6 months.

We are here to help with any questions you might have about the role and function of accounting in business. Stay on top of your company’s financial picture to stay relevant with your customers.

You May Also Like…