How to Manage Inventory in QuickBooks: A Step-by-Step Guide
Managing inventory efficiently is essential for small businesses to stay profitable and organized. QuickBooks offers powerful tools to track inventory, monitor stock levels, and generate insightful reports. In this article, we’ll walk you through the key steps to manage inventory in QuickBooks Online and QuickBooks Desktop.
1. Turn On Inventory Tracking
For QuickBooks Online:
- Go to the Gear icon > Account and Settings > Sales.
- In the Products and services section, turn on:
- Show Product/Service column
- Track quantity and price/rate
- Track inventory quantity on hand
For QuickBooks Desktop:
- Go to Edit > Preferences > Items & Inventory > Company Preferences.
- Check Inventory and purchase orders are active.
2. Add Your Inventory Items
Go to Sales > Products and Services (QuickBooks Online) or Lists > Item List (Desktop).
Click on New and select Inventory item. Then fill in:
- Item name or SKU
- Initial quantity on hand
- Reorder point
- Cost
- Sales price
- Preferred vendor
3. Track Inventory with Sales and Purchases
When you sell an item, QuickBooks automatically reduces the inventory quantity.
When you purchase items:
- Use Bills or Expenses to add inventory received.
- Select the item and enter the quantity received.
4. Adjust Inventory Manually (When Needed)
Sometimes, you may need to adjust inventory due to shrinkage, loss, or errors.
QuickBooks Online:
- Go to + New > Inventory Qty Adjustment
- Choose the item, reason for adjustment, and the new quantity.
QuickBooks Desktop:
- Go to Vendors > Inventory Activities > Adjust Quantity/Value on Hand.
5. Run Inventory Reports
Use inventory reports to monitor performance and avoid stock issues.
Helpful reports include:
- Inventory Valuation Summary
- Physical Inventory Worksheet
- Inventory Stock Status by Item
These can help you identify trends, forecast demand, and improve purchasing decisions.
Conclusion
QuickBooks makes inventory management easy and accessible for small business owners. Whether you’re tracking sales, receiving stock, or analyzing inventory trends, QuickBooks gives you the control you need to keep your business running smoothly.
If you need help setting up or managing your inventory in QuickBooks, Carlos Quiceno Financial Services is here to support you. Contact us today for expert bookkeeping and QuickBooks training.
