Managing Items in QuickBooks Desktop: Adding, Editing, and Deleting
QuickBooks Desktop users navigating item management face specific list limits and type restrictions that affect how invoices and sales forms are built.
QuickBooks Desktop relies on items to populate every line of an invoice, sales receipt, or purchase order. Whether a company tracks physical products, bills for professional hours, or applies shipping fees, the Item List is where those building blocks live. Users running Pro, Premier, or Enterprise all interact with the same core list mechanics, though the ceilings on how many entries that list can hold differ significantly across editions.
Creating New Items
To build a new entry, users navigate to the Lists menu and open the Item List on Windows, or Items on Mac. From there, selecting New launches the item-creation window. The first decision is choosing the item type, which dictates how QuickBooks tracks the associated revenue, cost, and inventory value.
Several item types are available, each tied to a specific business function. Service items cover labor or professional work, whether billed hourly or as a flat fee per job. Inventory Part items track physical products a business purchases for resale, requiring the inventory tracking preference to be enabled beforehand. Non-inventory parts cover materials or goods a company buys but does not track as stock. Other Charge items handle reimbursable expenses like freight or delivery fees. Additional types include Inventory Assembly for manufactured goods, which is available only on Windows.
When setting up an item, users map it to specific accounts and can check boxes that define its behavior. For example, a Non-inventory part can be flagged if it is purchased for and sold to a specific customer or job. A Service item can be marked as subcontracted work. These selections determine exactly where the financial data flows on the chart of accounts.
Importing Items in Bulk
For businesses migrating from another platform or setting up a file for the first time, manual entry is often impractical. QuickBooks Desktop includes a built-in workflow for bringing items in from an external spreadsheet. Users go to the File menu, select Import, and then choose Items. The import tool requires users to specify the item type — Service, Non-Inventory, or Inventory — and map the corresponding data into the required fields. Before finalizing the import, users must ensure the import checkbox is selected for each entry they want to bring into the company file.
Editing and Changing Types
Modifying an existing item requires opening the Item List, double-clicking the entry, and adjusting the details in the profile window. Users can rename items, adjust pricing, or reassign accounts.
QuickBooks also allows users to change an item’s type after it has been created, though this is restricted to certain combinations. To attempt a type change, users open the Item List, select the item, and choose the new type from the Type menu. Changing types is not universally supported, particularly if the item already has transaction history tied to it.
Duplicating, Hiding, and Deleting
To speed up data entry, users can duplicate existing items. Right-clicking an item on Windows — or using the plus icon on Mac — and selecting Duplicate Item creates a copy. Because QuickBooks requires every item name to be unique, the duplicated entry must be renamed before saving.
Businesses often accumulate outdated items they no longer sell but want to keep on file for historical reporting. Rather than deleting these entries, users can double-click the item and mark it as inactive. This removes it from standard dropdown lists on sales forms without erasing its past transaction history.
Fully deleting an item is a separate action. Users select the unwanted item from the list, go to the Edit menu, and choose Delete Item. This removes the entry entirely, though items tied to existing transactions may require additional handling to remove cleanly.
List Limits and Custom Fields
The total number of items a Desktop file can hold depends on the edition. QuickBooks Pro, Premier, and Mac share a combined limit of 14,500 total names, which includes customers, vendors, employees, and other names, alongside items. Files approaching this ceiling often experience noticeable performance degradation. QuickBooks Enterprise removes this restriction, allowing an effectively unlimited number of list entries.
Separate from total list capacity, QuickBooks also caps the number of custom fields users can attach to individual items. Pro and Mac editions allow up to 50 custom fields per item, while Premier allows up to 100. Enterprise supports up to 500 custom fields per item, reflecting its design for larger, more complex inventories. When files grow too large or hit the Pro and Premier list limits, users often look at condensing the company file to reduce overall size and restore performance.