If your business sells products, you know how important it is to be able to track their numbers precisely. Keep your stock at the right levels, and you shouldn’t run out of items. You also won’t have a lot of money tied up in products that aren’t selling.
You probably have a sense of what’s hot and what’s not just from fulfilling orders, but you need more than guesses. You need real numbers, so you know when it’s time to reorder and when it’s time to discount and discontinue items that aren’t selling.
QuickBooks can provide a solution to your inventory problems. It:
- Allows you to create records for the products you sell.
- Keeps a real-time running tally of your item levels and alerts you when they’re running low.
- Generates specialized reports so you can get a detailed snapshot of your inventory at any time.
Before you begin setting up an inventory system, make sure QuickBooks is ready. Open the Edit menu and select Preferences, then Items & Inventory. If you’re the software administrator, you can access the options that appear when you click the Company Preferences tab, as shown in the image below.
Be sure QuickBooks is set up to manage inventory tracking before you start.
Click the box in front of Inventory and purchase orders are active if it’s not already checked. If your version of QuickBooks supports sales orders and purchase orders, select the options you want for the next two lines. For example, select When the quantity I want to sell exceeds Quantity Available in case you have items that are committed to assembles. When you’re done, click OK.
Building Your Product Records
Even if you don’t have a lot of inventory, consider creating a record for each item you sell so you always know where you stand. You don’t want to have to count or hunt for a unique product every time you fulfill an order. If you come up short and can’t complete a sale, you may lose that customer to a competitor who can.
Open the Lists menu and select Item List. Once you’ve created records, they’ll appear in this table. Click the down arrow next to the Item field in the lower left corner and select New. In the upper left corner of the window that opens, select Inventory Part for the Type so QuickBooks knows it will be tracking it.
Let’s say you’re buying bracelets in volume from a wholesaler and reselling them. If you’re assembling a product that requires multiple parts, that requires more complex records.
Partial view of a product record
Enter an Item Name/Number. The next two fields are optional. Now, enter the Purchase Information and Sales Information, starting with descriptions for transactions. Then, how much did you pay for them, and at what price will you sell them? The default COGS Account should be fine, and you can select a Preferred Vendor if you’d like. Be sure to select a Tax Code. If you need to collect sales tax and haven’t set it up, be sure to do that as well. The Income Account should be Retail Sales for this example.
The fields under Inventory Information are important. The default Asset Account should be correct. Enter the minimum Reorder Point and the number of this item you currently have On Hand. QuickBooks will calculate the Total Value of your stock. When you’re finished, click OK.
How does QuickBooks keep you from selling inventory items you don’t have? That’s easy. It’s unlikely, but let’s say someone really likes those multicolor beaded bracelets you’re selling and thinks he or she could sell them for more and make a bigger profit. They want to order 120 of them.
QuickBooks warns you if you try to sell items you don’t have.
There are two ways QuickBooks warns you about this. The first is pictured in the image above. If you try to invoice the customer for 120 of them, you’ll see that message. Second, if you get an unusually large order, you can consult QuickBooks’ Inventory Stock Status by Item report to get a real-time count (Reports | Inventory).
Need More Inventory Tracking Power?
QuickBooks does a good job of tracking inventory items. It’s up to you, though, to keep an eye on how everything is selling and determine your future purchasing habits. Other reports may be able to help you here, like Sales by Item Detail. If your business is doing really well and you need more inventory features than QuickBooks Pro or Premier offers, there are options. Please contact the office about your inventory tracking questions.