Small Business Inventory Management – The Ultimate Guide

Small business inventory management provides up to the minute data on current stock levels, inbound stock, and connects your key financials like sales and cost of goods sold. This data is critical to fine-tuning profits, cutting losses, and spotting theft and inefficiencies. In this article, we’ll show you how to get your inventory organized and on track in 8 easy steps.

1. Organize Your Product & Vendor Information

The first step in organizing your small business inventory system is to set up your stock and supplier information in a reliable and accessible system. Some businesses use manual tracking methods, but the best option generally is a budget-friendly POS system for retailers or order management system for ecommerce sellers.

Pro Tip: Streamline Inventory Management with a POS

If you’re looking for a POS system, the free Square POS software is a good option for smaller inventories. For larger inventories, a POS with advanced inventory tracking features like Lightspeed is best.

Lightspeed offers excellent inventory tracking methods right out of the box. Purchased items are automatically deducted from your inventory records, and you get notified when stock is running low. Lightspeed also lets you build purchase orders easily when it’s time to reach out to your suppliers. Click on the button below to start a free trial.

Visit Lightspeed

Whichever method you choose, you’ll need to record both product-specific information and supplier details into your inventory management system. Here’s the typical information you’ll need to track for each item you carry:

• Product name
• Your internal product SKU or code (if you use one)
• Manufacturer’s UPC/EAN or other unique identifiers
• Short description
• Product category, class or family
• Wholesale cost
• Regular retail price / MSRP
• Your selling price
• Colors or sizes
• Vendor, supplier, or manufacturer name
• Reorder quantities
• Shipping details: size, weight, box pack (if applicable)
• Picture or product image

If you sell less than 30 products, you can get away with using a spreadsheet or handwritten records to track this data. But neither are automated, so both methods are time-consuming and also prone to errors. A POS inventory system really is the best way for small businesses to manage their inventory.

Here’s a look at how Lightspeed organizes all of this product information into one intuitive screen:

An organized product page in Lightspeed

You also need to record key vendor data in your chosen inventory management method. This lets you quickly access supplier contact information, payment terms, etc. Here you’ll want to include:

• Vendor name
• Vendor contact name
• Vendor billing information
• Vendor phone
• Payment terms
• Line rep or showroom contact

If using a POS, you’ll enter this into your system and link it directly to each inventory item. You can even list multiple suppliers for each product in POS systems. This is helpful in case one supplier is out of stock or if you need to compare wholesale prices.

Once you have all of this data recorded in one place, be it a POS, spreadsheet, or notebook, you can ditch all of your paper clutter like Rolodex cards and dog-eared supplier catalogs.

Which POS System is Right for You?

2. Create & Submit Accurate Purchase Orders

Purchase orders (POs) are the easiest way to manage your inventory purchases. They let you efficiently track every stock purchase, from placing the order, to receiving the shipment, to paying the bill. Since they’re essentially financial transactions, inventory orders shouldn’t be done without planning. Ideally, only create POs when you have time to review your cash flow and realistically forecast your stock needs.

You can submit POs many ways, from handwritten orders sent via fax to emails sent from your POS. Nowadays, most vendors prefer to receive electronic POs like those that POS systems send in a few keystrokes. But if you’re managing inventory using spreadsheets or via handwritten methods, you can use the following templates to create consistent POs that can be emailed or faxed.

• Download – Detailed Purchase Order Template
• Download – Elegant Purchase Order Template
• Download – Basic Order Template

If you submit POs manually, make sure you use a dark ink, write legibly, and differentiate between letters and numbers that look similar, like 1’s, L’s, and I’s, to reduce errors.

With a POS, the ordering process is quite easy. Since a POS tracks your sales data and inventory for you, you can quickly place orders based on up-to-the-minute sales numbers and inventory levels. You can even set up automatic reorders or be notified you when products hit a low-stock level. If you sell in any sort of volume, this automated convenience is a major timesaver.

Here’s a look at how Lightspeed POS lets you quickly create purchase orders from a convenient screen:

Creating purchase orders in Lightspeed

3. Receive Inventory Accurately

“Not having a system and process in place to accurately receive inventory is one of the most common small business inventory management mistakes, and the data backs that up. According to the National Retail Federation, 28% of inventory shrink is attributed to supplier mistakes that aren’t caught during the stock receiving process. A sound process that includes checking all stock receipts against purchase orders minimizes these losses.”
— Jason Richelson, CEO, bookkeep & former CEO, Shopkeep

The most high-tech PO in the world can’t remedy stock receiving errors. So another key aspect of retail inventory management, restaurant inventory management, or any other small business is to have a standard method for receiving inventory shipments. This ensures:

• All boxes are received and unpacked together
• All items received are accurately counted
• All received items are checked against your PO for accuracy

It’s especially important to ensure that you check all received items against your PO. Suppliers generally include a packing slip that lists the items and quantities in your shipment. It’s easy for stockroom and warehouse staff to check in a stock shipment in with only the packing slip, but that’s a big mistake.

If the supplier made an error during order entry, their packing slip will match the shipment, but it won’t match your PO. If this isn’t caught by checking the received items against your PO, you’ll think you received stock that didn’t actually arrive. That leads to stock shortages, backorders, and ultimately, cash losses.

So, always check your receipts against each PO, not just the supplier’s packing slip. In fact, check your vendor’s invoice against each PO as well, to catch any price errors or changes.

How to Accurately Receive Stock Shipments

1. Ensure that you receive all boxes, containers, or other units in the shipment
2. Unpack the shipment and organize items by product
3. Check the items and counts against your PO
4. If the counts and products match, receive the PO in your POS, as shown below. Or, adjust the stock counts in your spreadsheet or manual inventory management system
5. If you find errors like wrong, shorted, or missing items, note these on your PO and contact your supplier immediately to resolve
6. Shelve or store all correctly received stock, tag or label first if needed for your system.
7. Enter your bill into QuickBooks or the accounting system that you use

Receiving stock is another task made easier by a POS. Unlike manual inventory management methods, when you receive the PO for a stock shipment in a POS, your inventory numbers are automatically, and correctly, adjusted.

Receiving purchase orders in Lightspeed

4. Tag & Label Inventory

You need to tag and label your inventory for two reasons. First, price tags and product labels display an item’s selling price to shoppers. Second, product labels, particularly barcode labels, help you closely track your inventory and speed up the checkout process.

For basic price tags, you can use a standard price tag gun to quickly price items, or even use hand-written price tags if they fit your store’s motif. Both work fine with spreadsheet, hand-entry, or free inventory management methods, but they don’t help you automate the overall inventory management process.

If you carry a large inventory, say over 100 unique products, barcode labels can make many key functions quick and easy. They speed up the checkout process, help you do fast and accurate inventory counts, and link each inventory item to your sales. Most POS systems, including Lightspeed, support barcode labels and some are even starting to work with the higher-tech electronic tags (RFID tags).

Regardless of the type of price tags or product labels you use, a good time to tag and label inventory is during the stock receipt process. That ensures the task isn’t overlooked and prevents unlabeled stock from being shelved or displayed for sale. You can simply build this step into the stock receipt process we covered above.

If using a POS, you can even have barcode labels print automatically when you receive stock into the system, like this:

Print barcode labels automatically with Lightspeed

Once printed, labels can be affixed directly to product packaging or attached to hang tags. Some inventory might even arrive pre-labeled with manufacturer’s barcodes, which you can also track in your POS. In that case, your job is easy. You can just add a price label.

5. Track Your Sales & Products Sold

Tracking sales is a must for any business operation and it involves more than just tallying up the totals at the end of the day. A good small business inventory control system also records every order in detail, including each item sold. With a manual system, you’ll record orders by hand or track them within a spreadsheet, then manually adjust the inventory quantities for each item sold.

A small operation can handle this manually as long as inventory reductions are tracked regularly, say at the close of each business day. But as you grow, a POS system will dramatically streamline your operation by automating your inventory reduction with every sale. That means every time you make a sale, each item sold is automatically removed from your inventory records. Plus, each recorded sale lists each item sold. It’s all very tidy.

A POS also gives you up-to-the-minute sales totals. You don’t have to wait for an end of day closeout to know your daily sales since you can run reports at any time. And remember those POs we covered in Step 2? As your inventory numbers click down with each sale, reorder alerts or automatic POs will generate. This makes stock reordering quick, easy and, most importantly, bases your reorders on actual sales trends, not your best guess.

“In the early days of my online business, I accepted orders without having the product on hand, but thought I had plenty based on my manual spreadsheet. Luckily, I was able to quickly restock and fill those orders. But what if I hadn’t been able to? It would have been a disaster. Now my POS system ties inventory management to every sales task. It keeps up with how many units I sell order-by-order and alerts me when I’m running low. This gives me peace of mind. I never have to worry about selling a product that I don’t have in stock.”
— Zondra Wilson, President of Blu Skin Care

6. Take Regular Physical Inventory Counts

Physical inventory counts certainly don’t top anyone’s bucket list. But done right, physical counts can dramatically reduce all types of inventory problems. Most small businesses do a full inventory count once each year for tax purposes, but it’s a good idea to smaller partial inventory counts regularly, too.

Here are the 2 primary types of inventory counts that most businesses use:

Annual Inventory Count

This is the full inventory count done at the close of each fiscal year for income tax purposes. For some small businesses, it’s the only real inventory count they perform. But beware! If you only do inventory counts once each year, you’re likely to uncover shortages due to miscounts, misplaced stock, and receiving errors. By year’s’ end, it’s too late to fix most of these issues. To catch them before they become costly, you’ll want to conduct periodic counts, called cycle counts.

Cycle Counts

Cycle counts are periodic spot-counts that you can easily fit into your daily activities. With cycle counts, you just count a small portion of your stock on a rotating basis, such as a single category or product line each week. Done regularly, cycle counts uncover receiving errors, misplaced stock, and theft shortages quickly before they become costly, long-term problems.

Pro Tip: Reorder Time is Cycle Count Time

“When it’s time to reorder items you are running low on think of it as a good time to do inventory. All the items you are about to reorder probably are down to a few. It’s a good time to make sure your inventory systems exactly match what’s on the shelf. So if your inventory system says 3 and you only have 2 then make that adjustment before you create the PO for the new order.”
— Jason Richelson, CEO, bookkeep & former CEO, Shopkeep

The Inventory Count Process

You need to start every physical inventory count with the current Quantity on Hand (QOH) for every item you’re planning to count. This is the amount you should have in stock for each item you carry, according to whatever inventory management system you’re using.

Stock counts are tracked as a running tally, so figuring your QOH for each item follows this basic formula:

Previous QOH + Received Inventory – Sold Inventory

=

 Quantity on Hand (QOH)

How quickly you can figure up the QOH for each item in stock depends on your chosen inventory management system.

Counting Inventory Using a POS System

With a POS system like Lightspeed, you can quickly print an inventory list for physical counts.

This list includes the name of each product to be counted, SKU, barcode if using a scanner, and the quantity of each product that you should have on-hand. This is termed your expected or starting QOH for purposes of your inventory count. Your POS does the math for you by tracking your received items and subtracting the sold items to give you an expected QOH for each item you carry.

Printing inventory counts in Lightspeed

Using your printed inventory sheet, you’ll physically count your stock and record that quantity next to your expected QOH for easy comparison. If the counted quantities match your expected QOH, your inventory is accurate. If they don’t, you have an error in your process and need to do some digging to uncover the reason for the shortage. We’ll discuss how in a minute.

Counting Inventory Using a Manual System

If you don’t use a POS, you must tally up the starting QOH totals yourself manually, or by using your inventory records in your spreadsheet. Then you’ll need to create your own inventory count sheets to record your physical counts, like these free inventory count templates.

Here are the steps:

1. Start with your beginning inventory count. This is the QOH you recorded for each item after your last inventory count.
2. Add the received inventory to the beginning QOH for each item. This is the stock you received since your last inventory count.
3. Subtract your items sold. This is the number of each item sold since your last inventory count.
4. The ending number is your new expected/starting QOH

Now that you have an expected/starting QOH for each item, you can begin your physical inventory count. Again, if the newly counted quantities match your expected QOH, your inventory records are accurate. If they don’t, you have an error in your process and need to do some digging, which we’ll discuss next.

See why a POS system is such a timesaver? Doing the manual steps listed above is time-consuming and prone to math and recording errors. Plus if you use a POS system with barcode scanners, you can save even more time since your physical counts can be integrated with the rest of your POS data in real time.

But no system, however sophisticated, is 100% foolproof. Next, we’ll explore what to do when your physical counts don’t match your expected QOH.

7. Reconcile Inventory Differences

In a perfect world, you’ll have no discrepancies at the end of your physical count. If that’s the case, bravo! Your small business inventory management techniques and systems are working great. But even the best process and system can have an occasional glitch. When these occur, you’ll need to investigate the problem, and if not solved, reconcile the QOH differences for accounting purposes.

The first step is researching the count discrepancy. There are many reasons inventory goes missing, physically and figuratively. It can be an actual loss, like employee theft, damaged goods not reported, or stock recorded as received but that never actually arrived. Other times, the stock is there, it’s just in the wrong place or incorrectly labeled.

If you can’t locate the stock, then you need to adjust the QOH for that item in your system to what you actually have on hand. This is as simple as just changing that number in your POS, spreadsheet, or written inventory record.

After that, you need to adjust your inventory value for that item in your accounting system to track the dollar value of the loss. This usually is reflected on your balance sheet as Inventory Shrink. Accuracy with inventory shrinkage is especially critical since you need to supply inventory valuation for insurance policies, investors, or if you’re applying for an SBA loan.

Pro Tip: Using a POS to Monitor Theft

Frequently, inventory levels don’t match because your vendor either sent less than you requested or an item walked out the door without anyone paying for it. As we saw earlier, a POS systems like Lightspeed can improve the accuracy of receiving orders. Once you know you received what you ordered, you can tell if the discrepancies between the items sold and those still on the shelves represent theft or shrinkage and take actions to protect your inventory.

8. Organize your Stockroom or Warehouse

So far, we’ve focused on the sales, stock receiving, and counting processes that drive good small business inventory management. But this discussion is incomplete without looking at ways to keep all of that stock organized and readily accessible.

Whether you have a retail store with a small stockroom in the back or an expansive warehouse for your ecommerce business, organization is key to smart inventory management. Even if you operate in a tiny space, it’s good to have organized overstock space so you can take advantage of discounts and deals on quantity purchases.

“After my first stock order of over 1000 units, we had boxes of inventory everywhere and were shipping orders from multiple locations. I realized I had a huge inventory management problem when we needed a balance sheet with accurate inventory counts for investors. Assembling that took days, and made me really stop and think.

Ultimately I hired someone to focus on inventory management. We organized the inventory by type, stored it all in one location, and started shipping from that one location. We also integrated our WooCommerce website with QuickBooks Online to ties sales to inventory in real time. With this system in place, I’m free to concentrate on what I’m best at: content creation for my website, managing my team, and finding potential partners.”
— Nicki Zevola Benvenuti, Founder, FutureDerm

In retail stores, tall storage shelves or double-tier hanging racks can maximize storage space along walls, yet allow movement through the space to access stored goods. In ecommerce fulfillment warehouse settings, you generally have more room to store goods on aisles built using light-duty metal shelving or heavier-duty shelving, depending on your needs.

Whatever your inventory storage method, your stored inventory needs to be well-organized, clearly labeled, and accessible for pulling and inventory counts. This can be done using the boxes goods come in, stacking bins, or even hanging separators for hung apparel. Periodic cycle counts of overstock also help keep track of extra inventory and ensure it’s not lost or misplaced over time.

The Bottom Line

Follow the inventory management techniques above and your retail store or ecommerce business will soon be running an efficient and effective small business inventory management system. Whether you’re looking to switch from spreadsheets to a modern POS system, reinvigorate an existing system that has become disorganized, or starting a system from scratch, these basic principles will help you set up and streamline your operation.

If you’re looking to switch to a small business POS, check out Lightspeed. As we’ve already seen, Lightspeed’s robust POS system makes it quick and easy to track inventory and place and receive orders. You can even set up automatic reorders that trigger when your inventory is low so you can get your products back on the shelves faster. Click here to try Lightspeed for free.

Visit Lightspeed