
Use item categories in QuickBooks Desktop Enterprise
by Intuit• Updated 4 months ago
Learn how to categorize your inventory items in QuickBooks Desktop Enterprise.
You can use item categories to keep your items organized. You can also get helpful insights with categories when you run reports.
In this article, you'll learn how to:
- Create categories
- Edit categories
- Delete categories
- Edit an item to add a category
- Move multiple items to a category
- Add/Edit multiple list entries with categories
- Filter Find & Select Items by category
- Reports with categories
- Set Price Rules based on Categories
- Customize Columns
- Troubleshoot common issues
Important: If you use categories in QuickBooks Enterprise, upgrade your company file(s) to the latest release. We've improved the categories feature and it'll be turned off in Release 1 (R1).
Manage categories
In the new Item list, you can perform multiple operations on categories.
Create categories:
- Go to Lists and select Category List.
- Select Manage Categories ▼ then select Add new category.
- Enter the category name. If you have a parent category, you can select Is a sub-category of to create a new sub-category.
- Enter an optional description. When you're done, select OK.
Edit categories:
- Go to Lists and select Category List.
- Right-click on the category you wish to edit.
- Select Edit category.
- You will see the category name. It'll also show if the category Is a sub-category of any parent category.
- Now, you can edit the category, by changing the name, path, or description.
- When you're done, select OK.
Delete categories:
- Go to Lists and select Category List.
- Right-click on the category you want to delete.
- Select Delete category.
- Make sure you move any items in that category or in its sub-categories before you can delete the category.
- To confirm, select Yes, delete.
Move multiple items to a category
You can move one or many items from one category to another.
- Select the category.
- Put a checkmark on all the items you want to be moved from the category.
- Select Batch actions ▼ below the list, and then choose Move to a different category.
- Choose the new category/sub-category where you want the items to be moved.
- When you're done, select Save.
- You'll be asked to confirm the items you moved. Select OK.
Edit an item to add a category
You can select a category when you edit an item by:
- Go to Lists, then select Item List.
- Select the item to add a category to. Then, select Item ▼ and select Edit Item.
- Select Category.
- Select an existing category or < Add New > to create a new category. If you have a parent category, you can select Is a sub-category of to create a new sub-category.
- Enter an optional description. When you're done, select OK, and then select OK again.
Repeat as necessary for multiple items and even create up to 4 levels of item categorization.
Add/Edit multiple list entries with categories
You can now onboard multiple items and categories using the Add/Edit Multiple List Entries screen.
- Go to Lists.
- Select Add/Edit Multiple List Entries.
Note: You can also select Lists, then Category List, then Manage Categories ▼, then Add/edit multiple categories and items. - Select List, then the list you want to work with for Item Categories.
- Service Items
- Inventory Parts
- Non-Inventory Parts
- Inventory Assemblies
- To add entries in the category column, type in the first empty row at the end of the list.
You can also copy (Ctrl+C) data from Excel and paste (Ctrl+V) it into the Add/Edit Multiple List Entries window. - To edit entries in the category column, select any field and begin making changes.
- To copy:
- To copy data from one field to the other records, highlight the field, right click then select Copy Down. Any data already in the fields will be overwritten.
- Copy a row, right-click the row and select Duplicate Row. The record is copied into the next row and starts with the word "DUP."
- Select Save Changes.
Filter find and select items by category
You can now filter the find and select items to enter your transactions faster.
- Once you are in a transaction window, you can select the ▼ dropdown below the Item column.
- Select < Find and Select items/ Filter by Category >.
- Select Filter items by category.
- Select the category/sub-category.
- Select the item of choice from this trimmed list.
Reports with categories
You can customize reports to see items and their categories.
Inventory report
- Select Reports, then select Inventory.
- Select one of the reports mentioned below:
- Hierarchical view: Inventory Valuation Summary, Inventory Stock Status by Item, Sales by Item Summary. Note: You can select Hide Category to switch between the category view and item view in these reports.
- Flat-view: Inventory Valuation Summary, Inventory Turnover by Item, Physical Inventory Worksheet (by enabling the category column from Customize Report).
- Select Report, then select List.
- Select one of the reports below:
- Item Price List
- Item Listing
The report displays and you can see the list of items with their categories and sub-categories.
Item report
- Select Report, then select Items.
- Select one of the reports below:
- Item Price List
- Item Listing
Custom transaction detail report
- Select Reports, Custom Reports, and then Transaction Detail.
- Go to Display, then Columns and then Total by.
- Select Category: Item Detail.
You can also filter a report by category.
- Select Customize Report, then go to the Filters tab.
- From the Filter list, select Category.
- Select the category of choice from the list and then select OK.
Set price rules based on categories
To use categories to set price rules, you need to make sure that Advanced Pricing is turned on.
- Go to Edit and select Preferences.
- Select Sales & Customers then Company Preferences.
- Select Enable Advanced Pricing.
Once Advanced Pricing is turned on, you can create rules based on categories. Here's how:
- Go to Lists and select Price Rule List.
- Select Price Rule and then select New. Give a name to the price rule.
- To add a condition, select the + button and select Items.
- Select Category then select your desired category.
Note: Make sure you choose a category other than uncategorized to apply a price rule. - Set the date range and price.
- Select OK once you’re done.
This rule will apply to all the items which are assigned to the selected category.
To see the price rule in action in a transaction:
- Go to Customers and select Create Invoices.
- Set the date in the date range set in the price rule.
- Select an item in the category with the price rule.
- Select the tooltip near the rate in the Rate column.
- The Applied Price Rules dialog box will contain the price rule that you applied.
Customize Columns
- Go to Lists and select Category List.
- Select the Item ▼ dropdown from the bottom panel.
- Select Customize columns.
- Now you can change the order of the categories and add or remove the columns you want to see in the Category List screen.
Troubleshoot potential crash
Fix a potential crash while using search on the item list in Categories for QuickBooks Enterprise 2023 R1 and R3.
- Go to Lists and select Category List.
- Select Manage Categories ▼ then select Add new category.
- Name the category as C1 and select OK.
- Put a checkmark on all the items in C1.
- Select Batch actions, then select Move to a different category.
- In the Category dropdown, select Uncategorized. Then, select Save.
- Right-click on C1, then select Delete category.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Update QuickBooks Desktop Enterprise to the latest versionby QuickBooks
- How to set up landed cost in QuickBooks Desktop Enterpriseby QuickBooks
- Calculate landed costs in QuickBooks Desktop Enterpriseby QuickBooks
- What’s new in QuickBooks Desktop 2023by QuickBooks