How to Set Up and Track Inventory in QuickBooks Online?

Managing inventory efficiently is essential for any business that sells products. With QuickBooks Online, you gain powerful tools to monitor stock levels, track cost of goods sold, and make informed purchasing decisions. This comprehensive guide walks you through how to set up and track inventory in QuickBooks Online, helping you streamline operations and improve profitability.

Why Inventory Management in QuickBooks Online Matters?

Effective inventory management ensures you always know what’s in stock, what’s selling, and when to reorder. QuickBooks Online offers built-in features that allow you to:

• Track inventory quantities in real time
• Monitor cost of goods sold (COGS)
• Receive low-stock alerts
• Generate detailed inventory reports
• Simplify invoicing and sales tracking

These features are available in QuickBooks Online Plus and Advanced plans. If you’re using Simple Start or Essentials, you can upgrade or add inventory tracking to access these capabilities.

Steps to Setting Up and Tracking Inventory in QuickBooks Online

Setting up and tracking inventory in QuickBooks Online allows you to maintain accurate stock levels and streamline your sales process. Follow these step-by-step instructions to efficiently manage your products, monitor inventory movement, and make smarter business decisions.

Prerequisites for QuickBooks Inventory Tracking

Before setting up inventory, ensure your QuickBooks subscription supports inventory features. If not, upgrade your plan to unlock full inventory functionality. Once enabled, you’ll be able to track stock levels, manage pricing, and monitor product performance efficiently.

Step 1: Enable Inventory Tracking in QuickBooks Online

To begin tracking inventory, you need to activate the appropriate settings:

1. Navigate to the Settings (Gear Icon)
2. Select Account and Settings
3. Click on the Sales tab
4. In the Products and Services section, click Edit
5. Turn on the following options:
   • Show Product/Service column on sales forms
   • Track quantity and price/rate
   • Track inventory quantity on hand
6. (Optional) Enable Price Rules for flexible pricing strategies
7. Click Save, then Done

This setup allows QuickBooks to monitor inventory levels automatically.

Step 2: Add Inventory Products and Services

Once inventory tracking is enabled, you can start adding items. QuickBooks allows you to categorize products into three types:

1. Inventory Items: These are physical products you sell and track in stock. When adding inventory items, include:
   • Product name and SKU
   • Initial quantity on hand
   • Reorder point
   • Cost and sales price
2. Non-Inventory Items: These are products you buy or sell but don’t track as stock, such as small parts or materials used in services.
3. Service Items: These represent services your business offers, like consulting or maintenance work.
4. Bundles: Bundles allow you to group multiple items together (e.g., gift sets or packages), saving time when creating invoices.

Adding these items ensures faster transaction processing and better organization.

Step 3: Track Inventory as You Sell

After setting up your products, QuickBooks automatically updates inventory levels as sales occur.

A. How to Record Sales:

• Create an Invoice if payment will be received later
• Generate a Sales Receipt if payment is made immediately

Each time a sale is recorded, QuickBooks reduces the inventory quantity accordingly.

B. Monitor Stock in Real Time

While creating transactions, you can:

• Hover over item quantities to view stock details
• Check available and incoming stock
• Receive alerts when inventory reaches reorder levels

This real-time tracking helps prevent stockouts and overstocking.

Step 4: Restock Inventory Efficiently

Keeping your shelves stocked is crucial for uninterrupted sales. QuickBooks simplifies restocking by:

• Sending low-stock alerts
• Allowing you to create purchase orders
• Tracking incoming inventory from vendors

When items are received, QuickBooks automatically updates your stock levels, ensuring accurate records at all times.

Step 5: Use Inventory Reports for Business Insights

QuickBooks Online provides powerful reporting tools to help you analyze inventory performance. Key reports include:

• Inventory Valuation Summary
• Best-Selling Products
• Stock Quantity on Hand
• Cost of Goods Sold Reports

These insights help you identify trends, optimize purchasing decisions, and improve overall business efficiency.

Manual Inventory Tracking for quickBooks Online Basic Plans

If you’re using QuickBooks Online Essentials or Simple Start, you can still track inventory manually.

A. Create an Inventory Asset Account

1. Go to Settings → Chart of Accounts
2. Click New
3. Choose Current Assets as Account Type
4. Select Other Current Assets as Detail Type
5. Enter account details and save

This account tracks the value of your inventory.

B. Set Up Cost of Goods Sold Account

1. Navigate to Chart of Accounts
2. Click New
3. Select Cost of Goods Sold
4. Choose an appropriate detail type
5. Save the account

C. Recording Inventory Purchases

When purchasing inventory using expenses, checks, or bills:

• Assign the transaction to your inventory asset account
• This increases your inventory value

D. Recording Inventory Sales

To adjust inventory after a sale:

1. Create a Journal Entry
2. Debit your Cost of Goods Sold account (for the product’s cost)
3. Credit your Inventory Asset account

This reduces inventory value and records the cost accurately.

Adding Inventory Tracking to quickBooks Online Subscription

If your current plan doesn’t support inventory tracking, you can easily add it:

1. Go to the Inventory tab
2. Click Subscribe Now
3. Complete the subscription process

Once activated, all required settings are automatically enabled, allowing you to start tracking inventory immediately.

Important Tip: If you integrate external sales channels, ensure the “Track inventory for sales channels” option is enabled in your account settings for accurate synchronization.

Canceling the Inventory Add-On

You can cancel your inventory subscription anytime. However:

• You will retain read-only access to existing inventory data
• You won’t be able to edit or update inventory records

Make sure to export important data before canceling if needed.

Best Practices for Inventory Management in QuickBooks Online

To maximize efficiency, follow these best practices:

• Regularly review inventory reports
• Set accurate reorder points
• Keep product details updated
• Conduct periodic physical inventory counts
• Use bundles for faster invoicing

Consistent monitoring and updates ensure your inventory data remains accurate and reliable.

Conclusion

Setting up and tracking inventory in QuickBooks Online is a powerful way to gain control over your business operations. From real-time stock tracking to insightful reporting, these tools help you reduce errors, improve cash flow, and make smarter decisions.

Whether you’re using advanced inventory features or managing stock manually, QuickBooks provides flexible solutions tailored to your business needs. By following this guide, you can streamline inventory processes and focus on growing your business with confidence.