How to Add Product and Service Items to QuickBooks Online

In QuickBooks Online, it is convenient to monitor how much you earn and spend on every service or product. It is possible to add these products and services (that you offer) as items. This will help you to add them quickly to sales forms. Not to mention, it provides you with more comprehensive financial reports and supports you to finish transactions quicker.

Read on to understand and learn how to add products and services that you do not plan to monitor inventory for, or in other words, non-inventory items.

How to Add Product and Services items to QuickBooks Online?

Here are the steps to add a new service or product item:

Step 1: Include a New Service or Product item

You need to create a service or product just once. Once you have created them, It is possible to include them in your sales forms several times, if you require.

• Navigate to Get Paid and Pay or Sales option. Now choose Products and Services.
• Now choose New.
• Choose Service or Non-inventory.
• Add a Name for the service or product along with an SKU in case you monitor them.
• From the dropdown▼ for Category, Choose the category that best illustrates your service or product.
• In case you sell particular item, Verify the checkbox chosen for I sell this Product/Service to my customers.
• In the field for Description on Sales forms, add a description. This description will be visible to your particular customers on their respective sales forms.
• Add an amount in the field for Sales price/Rate. In case, for your services, you charge a variable rate, you need to leave the field for Sales price/Rate blank. Next, you need to include the price when you have completed the sales receipt or invoice.
• Choose the dropdown for Income Account▼, along with the account that you wish to utilize to monitor the sales. It is also possible to use an income account that QuickBooks has set up for you already. You can also choose + Add New in order to create a new income account.
• In the Sales tax section, Sales tax is levied by default, depending on the location. For more exact options, or in order to make the service or product nontaxable, choose the Edit Sales tax option. Then you need to perform any one of the following, based on the service or product:
  • If the service or product is tax-exempted, choose Nontaxable. Now choose Done.
  • In case the item has a particular tax rate, use the field for Browse All or Search to locate and choose a particular service or product type. Now choose Done.
• When it is complete, Choose Save and Close.

Step 2: Include a Product or Service Purchasing info

If you wish to monitor how much you have spent on your service or product, follow the steps below:

• Navigate to the option, Sales or Get Paid & Pay. Now choose Products and Services.
• Locate the service or product on the particular list and choose Edit in the given Action column.
• Choose the option, I purchase this service/product from a vendor.
• Include a Description. It gets displayed on purchase orders, bills, and other kinds of forms that you send to vendors.
• Include the Cost. In case the price differs, do not take tension. It is still possible to add the updated price when you wish to purchase supplies.
• Choose the Expense Account ▼dropdown. Now select the account you utilize to monitor the price of the things you sell.
• Choose a preferred vendor.
• When it is Done, Choose Save and Close.

Step 3: Manage and Monitor Service and Product items You Sell

After you are set up, it is possible to monitor what you sell or buy. Here is how you can begin:

• In case you require supplies, get assistance with ordering from the particular vendors.
• Acquire Sales Insights with the help of these reports.

How to Edit a Service or Product Item?

You can examine and conduct changes to your service or product items from the particular Services or Products menu.

• Choose Settings⚙. Now choose Product and Services.
• Locate the Service or Product you wish to change.
• Choose Edit in the given Action column.
• Do your changes.
• When it is complete, Choose Save and Close.

How to Change a Service or Product Item Type?

In case you include an inventory item as a service item, a non-inventory item, or an inventory item by fault, do not take tension.

Here are the steps on how to change an item’s type:

• Navigate to Settings⚙. Now choose Product and Services.
• Locate the service item or non-inventory item that you wish to change.
• Choose Edit in the given Action column.
• Choose Change type.
• Choose Service, Non-inventory, or Inventory.
• Do as per the steps to set the item as a service item, inventory item, or a non-inventory item.
• When it is complete, Choose Save and Close.

How to Delete a Service or Product Item?

It is possible to make items inactive to restrict them from appearing on lists, sales forms, or financial reports. However, the item does not get deleted.

• Choose Settings⚙. No choose Products and Services.
• Locate the Product or Service you wish to change.
• From the dropdown▼ for Action, choose Make Inactive. Now choose Yes to confirm.

How can You Reactivate an Item later on?

Here are the steps to reactivate an item later on:

• Choose Settings⚙. Now choose Products and Services.
• Now choose the Filter icon.
• From the dropdown for Status▼, Choose All and then click Apply. It will display all the active and inactive items.
• Locate the service or product that you wish to reactivate.
• From the dropdown▼ for Action, Choose Make Active.

How to Import Service and Product Items?

It is quite easier to add product along with service details in a particular spreadsheet rather than using the data input screen available in QuickBooks Online.

Note: In case there is more than one item, it will be much quicker to add the data in Google Spreadsheet or Excel and then import the particular file.

Step 1: Create Your Spreadsheet

It is possible to create a spreadsheet on Google Sheets or Excel. It is important to note that your spreadsheet must have at least one row for every service or product item that you want to import. Every column shows a field like Service/Product, Sales Description, and service name to be shifted to QuickBooks Online.

The foremost row of the spreadsheet should have labels for every column, however, the labels are not required to match the given field names from QuickBooks Online. It will be possible to map every column to a specific field in QuickBooks while performing the import process.

Here are some of the fields that are possible to import for products and services:

Sales Description	Product/Service Name
Type (Non-inventory, Inventory, or Service)	SKU
Taxable (Yes/No)	Sales Price/rate
Purchase Description	Income Account
Expense Account	Purchase Cost
Reorder Point (Inventory Items Only)	Quantity on Hand (Inventory Items Only)
Quantity as-of date: (Inventory Items Only)	Quantity on Hand (Inventory Items Only)

Step 2: From the screen for Products and Services, press on the dropdown arrow near New in the upper-right corner. Now choose Import.

Step 3: In the import window, press Browse and choose the file you want to import. It is possible to upload an Excel file or comma-separated values (CSV), and import or connect a file from the Google Sheets.

Step 4: Now, after choosing the file, press the Next button which is green in color and at the bottom-right side of the window. The screen will enable you to decide which columns will be imported to which specific field, accumulated by QuickBooks Online.

Step 5: In case any of the QuickBooks fields on the left side is not in your spreadsheet, it will show, No Match. After all your columns are mapped to QuickBooks fields, press the Next button on the bottom right of the screen.

Step 6: The final screen will enable you to analyze the data that will be successfully imported to QuickBooks Online. It is possible to make last-minute changes on the screen directly.

Once the information is analyzed, press the green Import button. It is on the bottom-right corner of your screen. You will get a message that the import was completed and successful. Now the new items will show on the Products and Services screen.

How to Run a Services and Products List Report?

Once all the products and services are used, it is possible to run the report to check the complete list. From QuickBooks Online’s Services and Products window, choose the dropdown menu near More. It is present in the upper-right corner. Now press Run Report.

Hope that this article helps you to add product and service items to QuickBooks Online. We have highlighted all the causes and solutions concerning this topic. We have also stated additional information concerning adding product and service items to QuickBooks Online.

---

Frequently Asked Questions