If you're running a business and need to track inventory, QuickBooks Desktop offers tools to make the process simpler. Here's what you need to know:
- Enable Inventory Tracking: Go to Edit > Preferences > Items & Inventory and activate the inventory features. For advanced tools like FIFO costing or barcode tracking, QuickBooks Desktop Enterprise editions are required.
- Add Products: Use the Item List to input details like SKU, purchase cost, sales price, and reorder points for each inventory item.
- Track Stock Automatically: QuickBooks updates inventory levels in real time as you record purchases, sales, and adjustments.
- Set Reorder Alerts: Define minimum stock levels to get low-stock notifications and avoid running out of products.
- Use Reports: Access inventory reports, like valuation summaries and stock status, to monitor inventory value, trends, and sales performance.
For businesses needing advanced features like multi-location tracking or barcode scanning, third-party tools like Rapid Inventory can integrate with QuickBooks Desktop for expanded functionality. With these steps, you can manage inventory efficiently and keep your financial records accurate.
How to set up inventory in QuickBooks Desktop
How to Enable Inventory Features in QuickBooks Desktop
To start tracking inventory in QuickBooks Desktop, you'll first need to enable its inventory features. Keep in mind that inventory tracking is only available in certain versions of QuickBooks Desktop. These include QuickBooks Desktop Pro Plus, Premier Plus, Accountant Desktop Plus, and the Enterprise editions (Gold, Platinum, Diamond, or Enterprise Accountant).
Steps to Activate Inventory Tracking
Activating inventory tracking in QuickBooks Desktop is a straightforward process. Begin by opening the software and navigating to Edit > Preferences. This will bring up the Preferences window, where you can adjust various settings for your company file.
On the left side of the Preferences window, locate and click on Items & Inventory. At the top of the screen, you’ll notice two tabs: My Preferences and Company Preferences. Select the Company Preferences tab, as this is where the inventory settings are located.
Next, check the box labeled Inventory and purchase orders are active, then click OK to save your changes.
If you're using QuickBooks Desktop Enterprise, you can unlock advanced inventory features - like FIFO costing, multi-location tracking, and barcode or serial number tracking - by clicking the Advanced Inventory Settings button. If this button is grayed out, go to Help > Manage my License > Sync License Data Online. After syncing, close and reopen QuickBooks, and the button should become accessible.
Once inventory tracking is activated, you’ll want to ensure your settings align with U.S. formatting standards for consistency.
Setting Up U.S. Format Preferences
After enabling inventory tracking, it’s important to confirm that your software is set to U.S. format standards. QuickBooks Desktop defaults to these standards, but it’s worth double-checking to avoid discrepancies in your records. For instance, currency is displayed in U.S. dollars ($) with commas separating thousands and periods for decimals (e.g., $1,234.56). Dates follow the MM/DD/YYYY format.
These preferences are typically set when you first create your company file. However, you can verify or adjust them by going back to the Edit menu and selecting Preferences. Different sections within Preferences allow you to customize specific formatting options. For example:
- The General section includes settings for decimal placement and date formatting.
- The Reports & Graphs section lets you adjust how numbers and data appear in your inventory reports.
When entering inventory quantities, use the exact units you measure. QuickBooks does not convert units, so if you sell items measured in imperial units like pounds, ounces, or gallons, enter those directly when setting up inventory items. Maintaining consistency in how you input and track measurements is essential for accurate inventory management.
Once you’ve enabled inventory tracking and confirmed your formatting preferences, QuickBooks Desktop is ready for you to start adding inventory items and recording transactions. The system will ensure your stock data and financial reports remain consistent with U.S. business standards.
How to Add and Manage Inventory Items
If you're using QuickBooks Desktop and have enabled inventory tracking, the next step is to add the products you buy and sell. Setting up inventory items properly ensures your financial records stay accurate and organized.
Adding New Inventory Items
To add a new inventory item, start by clicking the Items & Services icon on the Home page, or navigate to Lists > Item List. In the Item List window, click the Item button in the bottom-left corner and choose New from the dropdown menu. This will open the New Item window where you can input all the necessary product details.
From the Type dropdown menu, select Inventory Part - this identifies the item as a physical product you purchase, stock, and sell. If you're using QuickBooks Desktop Premier or a higher version, you'll also have the option to set a Unit of Measure.
In the Item Name/Number field, enter a unique identifier for the product, such as an SKU. Using SKU numbers is a common practice that helps maintain consistency across your inventory. Then, complete the Purchase Information section with the cost and description that will appear on purchase orders. Similarly, fill out the Sales Information section with the selling price and description for invoices and sales receipts.
QuickBooks will automatically assign your COGS account (Cost of Goods Sold) to track direct costs. You'll also need to select an Income account to record sales revenue. If you're unsure about which accounts to choose, it's a good idea to consult QuickBooks Support or your accountant.
Finally, use the Reorder Point field to set a minimum stock level. When inventory drops below this threshold, QuickBooks will alert you to reorder. After adding your items, take a moment to review and organize them for better management and reporting.
Organizing Items for Better Tracking
Once your inventory items are set up, keeping them organized is key to efficient tracking. Consistently using SKU numbers across all sales channels helps maintain order. Detailed product descriptions make it easier to identify items quickly. You can also include category information in item names or SKUs to simplify reporting and streamline your operations.
sbb-itb-19ed50f
How to Track Stock Levels and Record Transactions
Once you've set up your inventory items in QuickBooks Desktop, the system automatically updates stock levels in real time with every transaction. This ensures your inventory data stays accurate and helps you avoid potential discrepancies. Here's how you can manage purchases, sales, adjustments, and reorder points effectively.
Recording Purchases, Sales, and Adjustments
QuickBooks makes it easy to keep your stock levels up to date by processing transactions automatically.
- Recording Purchases: When you receive inventory, head to Vendors > Enter Bills. Select the vendor, add the inventory items along with their quantities and costs, and save. QuickBooks will update your stock levels and record the expense to Cost of Goods Sold (COGS).
- Recording Sales: For sales, go to Customers > Create Invoices or Enter Sales Receipts. Adding the sold inventory items will reduce your stock levels, record revenue, and calculate the COGS based on your chosen inventory valuation method.
- Making Adjustments: Sometimes, manual adjustments are necessary for reasons like damaged goods or errors during stock counts. Navigate to Vendors > Inventory Activities > Adjust Quantity/Value on Hand. Choose the relevant adjustment account, enter the date and reference, and update the quantities in the New Qty column. QuickBooks will show the difference in the Qty Difference column. You can adjust multiple items in one transaction, which is especially helpful during inventory counts. Always include a memo to document the reason for the adjustment and maintain an audit trail.
- Handling Purchase Orders: Purchase orders don’t immediately affect inventory levels. They simply track what you’ve ordered. Inventory quantities only update when you convert the purchase order into a bill or use Receive Items under Vendors > Receive Items.
- Building Assemblies: If your business uses Inventory Assemblies (available in QuickBooks Desktop Premier or Enterprise), creating assembled products adjusts the inventory of component items. When you build an assembly, QuickBooks reduces the component inventory and increases the finished product count. Access this feature through Vendors > Inventory Activities > Build Assemblies.
Setting Up Reorder Points for Low-Stock Alerts
Accurate transaction records lay the groundwork for managing inventory proactively by using reorder points. Reorder points help prevent stockouts by alerting you when inventory falls below a certain level. While you may have entered initial reorder points when setting up inventory items, you can adjust them anytime as your business needs evolve.
To update reorder points, open the Item List by going to Lists > Item List. Double-click the inventory item you want to modify, which opens the Edit Item window. Find the Reorder Point (Min) field and input the minimum quantity that should trigger a reorder. This number should factor in your lead time - the time it takes to receive new stock after placing an order.
For example, if you sell 10 units daily and your lead time is 7 days, you might set your reorder point at 85–90 units to include a safety buffer.
QuickBooks can send you reminders when inventory drops below these levels. To enable this feature, go to Edit > Preferences > Reminders, then select Company Preferences. Check the box for Inventory to Reorder and decide whether you want to see a summary, list, or no reminder. Choosing Show List gives you the most detailed view.
You can access these reminders by clicking the Reminders icon on the Home page or by navigating to Company > Reminders. The Reminders window shows inventory items that have fallen below their reorder points, along with their current quantities and reorder thresholds. From here, you can create purchase orders directly by selecting an item and clicking Order.
Another helpful tool is the Inventory Stock Status by Item report. Access it by going to Reports > Inventory > Inventory Stock Status by Item. This report provides an overview of your on-hand quantities, items on purchase orders, and average sales figures. It also highlights products below their reorder points, making it easy to prioritize restocking.
To stay ahead, adjust reorder points regularly to reflect changes in seasonal demand. This ensures you're not overstocked during slow periods or understocked when sales are high. Pair these reorder points with regular physical inventory counts - monthly or quarterly checks can help you catch discrepancies early and keep your reorder alerts accurate.
Using Inventory Reports and Rapid Inventory
QuickBooks Desktop's inventory reports turn transaction data into practical insights, helping you make smarter decisions about purchasing, stock control, and identifying trends.
Key Inventory Reports in QuickBooks Desktop
QuickBooks Desktop offers several specialized inventory reports to address various aspects of stock management. You can find all inventory and valuation reports under Reports > Inventory.
The Inventory Valuation Summary report provides a snapshot of your inventory's total value at any given time. It includes each item's quantity on hand, average cost, asset value, and its percentage of the total inventory value. This report is especially useful for financial reporting, insurance purposes, and identifying which products are tying up the most resources. You can adjust the date range to monitor changes over time and spot trends.
The Inventory Valuation Detail report breaks down every inventory transaction - purchases, sales, and adjustments - showing their effect on quantity and asset value. This is a great tool for tracking discrepancies or verifying that transactions have been posted correctly.
For physical stock counts, the Physical Inventory Worksheet is a handy resource. It lists all inventory items along with their current quantities. You can print this worksheet, conduct a physical count, and then compare your results to QuickBooks' records to identify any adjustments that may be needed.
The Inventory Stock Status by Vendor report organizes inventory items by vendor, showing quantities on hand, items on purchase orders, and average sales. This report is particularly useful for consolidating orders with specific vendors.
The Sales by Item Summary report (found under Reports > Sales > Sales by Item Summary) highlights total quantities sold and the revenue generated for each item during a selected period. Similarly, the Purchases by Item Summary report (located under Reports > Purchases > Purchases by Item Summary) provides an overview of your purchase data, helping you compare purchase quantities with sales to adjust ordering levels if necessary.
These reports can be customized and scheduled to keep your inventory management proactive. For businesses with more complex needs, Rapid Inventory offers advanced tools to complement these essential reports.
Expanding Capabilities with Rapid Inventory
Rapid Inventory enhances QuickBooks Desktop by adding features designed for more intricate inventory needs. It syncs seamlessly with QuickBooks Desktop, offering multi-location tracking, mobile barcode scanning, and support for FIFO and FEFO inventory strategies. The platform also provides real-time reporting, cycle counting, and tools for managing backorders.
While QuickBooks Desktop tracks overall inventory quantities, it doesn’t specify the exact location of items. Rapid Inventory solves this by allowing you to manage inventory across unlimited warehouses and locations, giving you real-time visibility into where each unit is stored. This is especially valuable for businesses operating multiple retail locations, distribution centers, or storage facilities.
With barcode scanning via smartphones or tablets, Rapid Inventory streamlines receiving, order fulfillment, and stock counts. This not only speeds up operations but also reduces errors and improves accuracy.
The platform also supports lot and serial number tracking, which is crucial for managing recalls, warranty claims, and meeting regulatory requirements. Additionally, it allows for partial shipping and receiving, enabling you to handle orders and shipments in multiple batches.
Rapid Inventory is available in two pricing tiers:
- Pro Plan: $90 per user per month for businesses with 1-9 users. This includes unlimited warehouses and locations, lot/serial number tracking, barcode scanning, and real-time reports.
- Unlimited Plan: $900 per month for businesses with 10 or more users. It includes all Pro features, plus unlimited users, custom inventory reports, a dedicated account manager, and priority support.
The platform’s web-based access ensures you can manage inventory from any device. Designed specifically for QuickBooks Desktop users, it integrates smoothly with your existing workflows. Together, QuickBooks Desktop reports and Rapid Inventory’s advanced capabilities create a comprehensive inventory management solution tailored to your needs.
Conclusion
Setting up inventory tracking in QuickBooks Desktop can be straightforward if you follow a few key steps: enable the inventory features, input accurate item details, record transactions consistently, and establish reorder points. These practices help create a dependable stock management system that minimizes the risk of running out of stock or overstocking.
The built-in inventory reports in QuickBooks Desktop provide valuable insights into stock levels, valuation, and sales trends. Regularly reviewing these reports allows you to make timely purchasing decisions and adapt quickly to shifts in demand. If your business requires more advanced tracking, additional tools can complement the core features.
For businesses managing multiple locations, handling lot numbers, or needing mobile barcode scanning, Rapid Inventory offers a robust solution. Its two-way sync with QuickBooks ensures your data remains up-to-date while providing advanced tools like multi-warehouse tracking and FIFO/FEFO strategies. As your business grows, Rapid Inventory is designed to scale alongside your needs, offering enhanced tracking capabilities and inventory strategies.
FAQs
What are the main differences between QuickBooks Desktop Pro Plus and Enterprise editions for inventory tracking?
The main distinctions between QuickBooks Desktop Pro Plus and QuickBooks Enterprise come down to the complexity and scale of their inventory management capabilities.
QuickBooks Desktop Pro Plus is designed for smaller businesses with straightforward inventory needs. It covers the essentials, such as tracking quantities, costs, and sales of inventory items - perfect for businesses that don’t require extensive inventory features.
In contrast, QuickBooks Enterprise is built for businesses with more demanding inventory requirements. It includes advanced tools like multi-location inventory tracking, barcode scanning, and the capacity to handle larger data sets. For companies managing complex inventory systems or processing high transaction volumes, Enterprise offers the detailed tracking and reporting needed to keep operations running smoothly.
How can I accurately track inventory when my products use different units of measurement?
To keep inventory tracking precise for products with varying units of measurement in QuickBooks Desktop, you can take advantage of the Unit of Measure feature. This tool lets you assign specific measurement units to products, whether they’re sold by weight, volume, or quantity.
First, enable the Unit of Measure feature in your QuickBooks preferences. After activation, you can create custom units like pounds, gallons, or pieces. Assign these units to individual products when adding them to your inventory list. This ensures your stock levels are recorded accurately, and all transactions reflect the correct measurement units.
Using this feature simplifies inventory management and helps minimize errors, ensuring your records stay accurate and meet your business requirements.
Why is the 'Advanced Inventory Settings' button grayed out in QuickBooks Desktop Enterprise, and how can I fix it?
If the 'Advanced Inventory Settings' button in QuickBooks Desktop Enterprise is grayed out, it usually indicates that the feature hasn’t been activated or isn’t included in your subscription. Here’s how you can address this:
- Confirm your subscription plan: Double-check that your QuickBooks Desktop Enterprise plan includes the Advanced Inventory feature. This option is only available with certain plans.
- Enable the feature: Navigate to Edit > Preferences > Items & Inventory > Company Preferences and see if the inventory tracking option is turned on. If it’s not, enable it.
- Review user permissions: If you’re not the admin, you might lack the permissions needed to access or change this setting. In this case, reach out to your administrator for help.
If none of these steps solve the problem, contacting QuickBooks support might be your next best move for additional assistance.
