In this blog, we are going to discuss how we can create new categories in QuickBooks. The user of QuickBooks can easily view all the Products and Services by just pressing the Gear icon button and then, Products and Services. We will tell the whole process of creating the products and services list. And, also how to import the data from the excel sheet or from the comma-separated value (CSV) file. If you want quick assistance and understand this term to set up products and services list in QuickBooks Online.
Let’s start how to create new expenses categories in QuickBooks Online.
Process of Create New Categories in QuickBooks Online
Follow these instructions properly to get the complete and satisfied result.
Step 1: Locate the Products and Services option.
- Firstly, log in to QuickBooks Online account
- Click on the left-menu bar button.
- You will see the option of the Sales button.
- Then, click on the option of products and services.
- The screen of products and services will open on your desktop screen.
- Move to the next step mentioned below.
Step 2: Then, Create a New Item
- When the screen of products and services will open.
- You will see a green button of “New” in the upper right corner.
- Then, easily create a product or service in QuickBooks Online.
Step 3: Choose the Item Type
When you click on New option, you will four option available on the screen that can be created for products and services, which is,
Or, you can also go for a shortcut method given below:
Create a Category
You can choose categories to group items of the same type. If you require to be more specific with grouping items. Also, you can create sub-categories.
- Click on the Sales menu, then click on the Products and Services.
- Also, you can Manage the Categories, by clicking on the More Dropdown button.
- Choose on the New Category, then give the category name.
- Also, if you want to create a Sub-Category, then click on the Is a subcategory and the main category.
- Then, save it.
Categorize the Products and Services you sell
Firstly, add a new category of product and services when you add a new inventory product, service or non-inventory product.
Add a Product or Service to a category
You can categorize, if you have an uncategorized item.
- Select to the sales menu, then click on the Products and Service.
- Then, select the products and services you want to categorize.
- After that, click on Edit from the Auction column.
- Click on the Category dropdown button then, choose that time which fits the item. Then, click on the Add New button to create one.
- Then, Save and Shut.
Use the Categories in transaction
When you create transactions and save time. Because, you can easily use categories to find the products and services if you buy and sell many different things.
Edit or Remove the Category
- Click on the Sales menu, then click on the Products and Services
- Then, click on the dropdown More and manage the categories.
- Choose the Edit option from the Auction column.
- Do the change which you require and save.
Steps to Import Product and Service Item from Excel sheet.
It is easier to import the products and service information into an excel sheet. Follow these steps mentioned below:
Step 1: Make Your Spreadsheet
In the spreadsheet, the one row should have to be each product and service item which you want to import. And every column should have to represent the field type which is to be transferred into QuickBooks Online. But the sheet column of field type should not be match QuickBooks Online field name
Step 2: Upgrade the Excel or CSV file
- Go to the Products and Service screen.
- Click the dropdown button shown on the side of the Next button.
- For importing the data, do browse and choose the file of CSV or Excel which you require to upload.
- Then, press the Next button in the bottom right corner of the screen.
Step 3: Map the Columns to QuickBooks fields
This screen will show the option to choose the columns that will import to each of QuickBooks Online.
Fields are shown in the left column available for import into the QuickBooks. And the right column instructs the QuickBooks which column of your sheet stores the information for a particular field. If in case, one of the QuickBooks fields on the left is not in your information file then, select the No Match option in the list.
Step 4: Check your Data
The final screen will provide to check and ensure the data which will be imported into QuickBooks Online. If you want to make some changes, you can do so here. And after the checking process, click on the Import button in the bottom right corner. Then a notification will be prompt on the screen of successful import. And, the new items will appear on the product and services screen.
In the END:
Now, you will know how to create and categorize the products and services in QuickBooks Online. If you have any query you can contact us at +1-818-850-7805 of QuickBooks Support. This blog of Create New Categories in QuickBooks Online.