How to Enter Inventory in QuickBooks Desktop and Online?

QuickBooks provides a user-friendly interface that allows you to manage your Inventory efficiently. It lets you easily track how much you make and spend on each product or service, what’s on hand, get alerts when it’s time to restock and see insights on what you buy and sell.

You can also enter non-inventory products and services you sell as items so you can quickly add them to sales forms. This gives you more detailed financial reports and helps you to complete transactions faster.

As a business owner, keeping track of Inventory can be challenging at times, especially if your sales are steadily growing. QuickBooks can make tracking inventory easier for you, allowing businesses to save time and money, optimize performance, and increase customer satisfaction. Like other cloud-based software, QuickBooks allows users to access information from anywhere and backs up their work securely. This means that everyone can view the most recent data, no matter where they are or when they need those numbers. 

Record everything you buy and sell in your Inventory into QuickBooks. Then, let QuickBooks update the quantity on hand as you work so you don’t have to. Once you’re set-up, it’s easy to track Inventory in QuickBooks and add products to sales forms.

QuickBooks Inventory Tracking: A Detailed Overview

QuickBooks inventory tracking is a powerful tool designed to simplify your business management stock. It’s a comprehensive solution for adding, monitoring, and managing Inventory. When adding Inventory to QuickBooks, it’s important to note that you’re not just organizing your stock. You’re tapping into a system that automates your tasks. 

This is especially beneficial if you require multiple location tracking, as this is when you allocate items to different locations. It has the ability to provide real-time insights into your stock levels for better inventory management.

Why Enter Inventory Items into QuickBooks?

Adding items to QuickBooks Online Inventory ensures accurate tracking of stock levels and financial reporting. It helps in managing Inventory efficiently, so you can:

• Check inventory levels on a regular basis
• Reconcile Inventory with the physical count
• Catalog items for easier search
• Analyze inventory trends, sales, and product performance
• Calculate the total inventory worth
• Audit inventory for accuracy

What information do I need to provide when adding inventory items to QuickBooks? 

When recording inventory items, you typically must provide details, such as the item name or number, description, cost, income account, expense account, asset account, and initial quantity on hand. Plus, you can also include additional details like the manufacturer’s part number, reorder point, preferred vendor, and tax codes.

Steps to Enter Inventory in QuickBooks Online

QuickBooks Online Essentials, Advanced, and Plus customers have the opportunity to add on QuickBooks Commerce, an all-in-one platform that provides you total control over your multi-channel businesses. 

QuickBooks Commerce is a cloud-based inventory management system that you can access on the go. This platform makes tracking Inventory easier by allowing you to stay on top of your inventories from different sales channels and locations on one single platform. 

Step 1: Turn on inventory tracking

To begin using the QuickBooks inventory feature, you’ll first have to check your subscription plan and then enable inventory tracking in the settings. QuickBooks Online inventory is only available to QuickBooks Online Plus, Essentials, and Advanced customers. If you’re unable to see the option to add Inventory, you may need to upgrade your plan. Make sure to turn on inventory tracking so you can add your inventory items. Here’s how: 

1. Navigate to Settings and then choose Account and Settings. 
2. Hit the Sales tab.
3. Click Edit under the Products and Services section.
4. Enable the option Show Product/Service column on sales forms. 

Tip: You can also turn on price rules if you need to set up flexible pricing for the things you sell.

5. Turn on both Track quantity and price/rate and Track inventory quantity on hand.
6. Press Save and then Done.

Once you’ve updated your settings, you can start adding Inventory to QuickBooks Online.

Step 2: Add Your Inventory Items 

Now, you can add your inventory items as well as other products and services you sell into QuickBooks. This allows you to quickly add them as line items to your sales forms. Follow these steps to add different Inventory, non-inventory, and service items into QuickBooks. 

1. Click the Gear icon and turn on inventory tracking under Settings. 
2. Navigate to Sales, then select Products and Services.
3. Press New to Add a product or service. Then, choose Inventory.
4. Add an item Name and SKU for what you’re tracking. 
5. From the Category dropdown menu, select the Category. 

Tip: You can organize your goods and services into categories or item types to make them easier to find instead of scanning an entire item list.  

Step 3: Add your product’s quantity, reorder point, and inventory asset account

1. Add your product’s Initial quantity on hand and then type when you started tracking that quantity under the As of date field.
2. Enter a Reorder point to get alerts when it’s time to reorder. 
3. Click on the Inventory asset account dropdown and then select Inventory Asset. QuickBooks uses this account to track the cost of all the products you have in stock (or inventory value).

Note: If you’re new to QuickBooks, the initial quantity on hand depends on what date you plan to start tracking your business. For example, if you’ll start tracking from the beginning of your fiscal year, write down your products’ quantities at that time. 

However,  if you’re simply adding a new product from a supplier/vendor, enter “0” as its initial quantity. Then, after saving, track how many of these products you receive from suppliers. This ensures you don’t double its initial quantity.

Step 4: Add your product’s sales, tax, and purchasing info

If you want to track how much you spend on a product or service, do the following:

1. Mention your product’s description on sales forms. This shows on invoices, sales receipts, and other forms you send to customers.
2. Add the Sales price/rate.
3. Choose the Income account dropdown and locate the account you use to track what you sell. 
4. Tick mark the Inclusive of sales tax check box, if applicable.
5. Click on the Sales Tax dropdown and then select the tax rate to be used for the item. If you don’t see this dropdown, set up sales tax in QuickBooks.
6. Enter your product’s description on the purchase forms. This will show on bills, purchase orders, and other forms you send to suppliers.
7. Write down the product’s Purchase Cost. If this changes, you can still enter the updated price when you buy supplies.
8. From the Expense account dropdown menu, choose Cost of Goods Sold. QuickBooks uses this account to track the cost of products you sell.
9. Mark the Inclusive of purchase tax check box, if applicable.
10. Select the applicable purchase tax under the Purchase Tax dropdown menu.
11. Opt for a Preferred Supplier. QuickBooks remembers your preferred supplier, so you can reorder this product easily.
12. Press Save and then Close at the end. 

If you start selling new products, you can use the same steps to set them up.

When Inventory is added to QuickBooks Online without a Bill associated, it is supposed that inventory items have already been to the Cost of Goods Sold account prior to the customer using QuickBooks Online. 

Whenever Inventory needs to be added to QBO, and the customer wants to assign a Cost of Goods Sold Value to the Inventory items, a Bill will need to be created for the inventory items, and backdated if necessary. Any Inventory items that don’t have Bills related to them, will be assigned a zero dollar value for Cost of Goods Sold. 

Step 5: Add a New Product, Service, or Non-inventory items

You only have to create a product or service once. After creating them, you can add them to sales forms as many times as you need. 

Tip: Already keeping track of your products and services in a spreadsheet? Save time and import them all at once. 

To add service or non-inventory items, follow these steps:

1. Navigate to the Sales menu and then hit the Products and Services tab.
2. Now, click New.
3. Select Non-inventory or Service.
4. Enter a Name or SKU if you’re tracking SKUs for the product. 
5. From the Category dropdown menu, choose the Category that best defines your product or service.
6. Tickmark the I sell this product/service to my customers checkbox. If you aren’t selling the product or service, you can leave this box unchecked. 
7. Under the Description on sales forms field, provide a description. This is what your customers will see when they view sales forms.
8. Type an amount in the Sales price/rate field. 

Note: You can leave this data field blank if you charge a variable rate for services. Instead, add the price when you fill out the invoice or sales receipt.uu

9. Click on the Income account dropdown list menu and select the account you want to use to track the sale.  

Tip: You can use an income account QuickBooks has already set up for you, or click + Add new to create a new income account. 

Important: Changing an Income account mapping is not retroactive. The change will only affect future transactions.

10. In the Sales tax section, sales tax is applied by default based on location. For more specific options, or to make the product or service nontaxable, press Edit sales tax. Then do one of the following, depending on the product or service:
    • If the product or service is tax-exempt, choose Nontaxable. Then, click Done.
    • However, if the item has a special tax rate, use the Search field or Browse all to find and select a more specific product or service type. Then, hit the Done tab.

11. When you’re ready, press Save and Close.

Step 6: Keep Track of Your Sales

Once you’ve set up all your inventory products, you can track your sales to analyze how they’re performing and adjust Inventory as needed. Inventory analysis is a great way to determine the number of products your business should carry to keep your company profitable and increase sales. To keep track of your sales, follow these steps:

1. Enable inventory tracking in Settings.
2. Select and add your inventory products, such as  work-in-process (WIP) inventory or finished goods.
3. Create an invoice if a customer will pay you later.
4. Or add a sales receipt if your customer paid on the spot.
5. Restock your Inventory using QuickBooks.
6. Use reports to check the status of your Inventory. This lets you review what’s selling well, the cost of goods sold (COGS), products on hand, and more.

Step 7: Monitor Your Inventory Levels

With QuickBooks, you can monitor your inventory levels to determine when to restock, analyze your Inventory carrying costs, and determine which items are bestsellers. QuickBooks allows you to reorder inventory right on the platform so you can track what you receive from vendors and what’s still on order. 

As you receive inventory items, the quantity on hand will automatically update. However, once you add or remove items from your Inventory, QuickBooks automatically increases or decreases both the number of items available as well as the inventory value. 

Check what’s running low or out of stock

You can prioritize ordering the products you need the most. Once you’ve set up your reorder points, here’s how to verify if you have inventory items that are running low or out of stock.

1. Navigate to Settings and then choose Products & services.
2. On the top, you’ll quickly see if you have low-stock or out-of-stock items.
3. Select Low stock, Out of stock, or See all next to either option to filter for those products.

Note: If you need to reorder both low stock and out of stock products from the same vendor, don’t use any of the filters from the top.

Step 8: Use reports to check the status of your Inventory

Use reports to get helpful insights on the things you buy and sell, as well as the status of your inventory. You can access reports to instantly see your best sellers, what’s on hand, the cost of goods, and more. To get started, navigate to Reports and then choose Standard. Once you’re there, here’s what you can do.

See your Best Sellers

1. Move to the Sales and Customers group of reports.
2. Then, run these reports to see your sales by products and services:
   • Sales by Product/Service Summary: Your total sales for each product and service.
   • Sales by Product/Service Detail: Your sale transactions by product or service.

Check what’s in stock

1. Navigate to the Sales and Customers group of reports. 
2. Run these reports to know what’s on hand, so you always have what your customers want:
   • Inventory Valuation Summary: The quantity on hand, value, and average cost for each product.
   • Inventory Valuation Detail: Your transactions for each inventory item, and how they affect quantity on hand, value, and cost.
   • Physical Inventory Worksheet: Your inventory items with space to enter your physical count, so you can compare to the quantity on hand in QuickBooks.

Check what’s still on order

1. Hover over the “Expenses and vendors” group of reports.
2. Then run the Open Purchase Order Detail report.

This shows you how many items are still on order and how many you’ve received so far.

How to check what’s in stock and what’s on order as you work?

Check what’s on hand and what’s still on order as you work on an invoice, sales receipt, or another type of transaction. Just hover your pointer over the quantity you entered on any transaction. 

If you set reorder points, QuickBooks will also let you know when something is running low. 

Steps to Enter Inventory in QuickBooks Desktop 

Below are the steps to set up Inventory in QuickBooks Desktop. 

Step 1: Turn on Inventory Tracking

Begin with opening QuickBooks Desktop and then your company file. When you log in, QuickBooks Desktop will direct you to its home screen. 

1. Click Edit from the top menu and then select Preferences.
2. Now, choose Items & Inventory in the left-side menu under the Preferences window.
3. Tick mark the checkbox Inventory and purchase orders are active. 
4. Set up additional preferences (Optional), like “Warn about duplicate purchase order numbers, Warn if there is not enough inventory to sell,” and “Don’t allow negative quantities” as needed.
5. Press OK to save the changes.

Step 2: Access the Item List

1. Navigate to the top menu and choose Lists. 
2. Select Item List from the dropdown menu.

Step 3: Create a New Inventory Item

1. Click on the Item menu in the Item List window and then press New. 
2. This will open a new window where you can create a new item. 

Step 4: Identify the Item Type

1. Under the New Item, you need to identify the type of the item. 
2. Select Inventory Part from the list of item types. 

Step 5: Enter Item Details

Fill out the required information for your inventory item. Here’s what you need to provide:

1. Item Name/Number: Type a unique name or number to identify the inventory item.
2. Description: Give a brief description of the item (optional).
3. Cost: Mention the price at which you purchase the item.
4. Income Account: Select the appropriate income account to track the sales revenue for this item.
5. Expense Account: Choose the expense account corresponding to this item’s cost of goods sold (COGS).
6. Asset Account: Name the asset account where you want to track the inventory value.
7. Quantity On Hand: Write down the initial quantity of your stock item.

Step 6: Additional Information

QuickBooks Desktop offers additional fields to capture more information about your inventory item. You can answer the following details if applicable:

1. Manufacturer’s Part Number: Type the manufacturer’s part number for the item.
2. Reorder Point: Mention the quantity you want to reorder the item.
3. Preferred Vendor: Specify the name of the preferred vendor for purchasing this item.
4. Tax code: Provide a tax code if applicable.

Step 7: Save and Close

1. Review the entered information to ensure accuracy.
2. Once you’re ready, press the OK button to add the inventory item to QuickBooks Desktop. 

Bottom Line!

Recording Inventory in QuickBooks allows you to track stock levels, sales, and cost of goods sold. It helps you to maintain accurate records, make informed business decisions, and streamline inventory management processes. QuickBooks is a best choice for adding automated inventory tracking to your accounting and bookkeeping software solutions. 

With this, you can easily manage multiple locations and warehouses, product listings and pricing across multiple channels, Inventory, orders, and accounting all in one platform, reordering with automated purchase orders, and much more.

FAQs:

How do I enter physical inventory in QuickBooks?

To enter physical inventory in QuickBooks, you can quickly update your inventory by copying data from an Excel file and pasting it directly into QuickBooks using the Add/Edit Multiple List Entries feature. Here’s how:

Steps:

1. Open QuickBooks and go to the List menu.
2. Select Add/Edit Multiple List Entries.
3. In the dropdown list for List, choose Inventory Parts.
4. Copy your inventory data from your Excel file and paste it into the QuickBooks screen.
5. Click Save Changes.

This method can also be used to update information for customers, vendors, and other items.

Disclaimer: The information outlined above for “How to Enter Inventory in QuickBooks Desktop and Online?” is applicable to all supported versions, including QuickBooks Desktop Pro, Premier, Accountant, and Enterprise. It is designed to work with operating systems such as Windows 7, 10, and 11, as well as macOS.