Inventory Reconciliation: When and Why Do I Need It?

Inventory Reconciliation: When and Why Do I Need It?

In today’s fast-moving retail world, taking the time to conduct an inventory reconciliation can be difficult. It means pulling people away from their day-to-day tasks and doing what may seem like mundane (and routine) work. However, maintaining accurate inventory is crucial to business success.

Just ask these folks about the importance of tight inventory controls. Target, for example, found that barcodes of Barbie products didn’t match the numbers in their computer system. These mismatched product counts led to empty store shelves and disappointed shoppers. It also led to a $2 billion loss. Nike executives counted $100 million in sales due to inventory tracking issues. Ralph Lauren saw their profits drop 50% over two years because itself-admittedly couldn’t get a handle on its inventory management.

It can happen to the largest, most sophisticated companies and it happens to small and medium-sized businesses all over the world. If you’re in the retail business, your inventory is constantly changing. There are so many moving parts across locations and platforms that things can sometimes get out of sync.

Making sure your actual inventory aligns exactly with your inventory records is crucial. That’s where inventory reconciliation comes into play.

What is Inventory Reconciliation?

Inventory reconciliation is the act of taking inventory of everything you have and making sure your stock records match reality. It’s important to reconcile your inventory periodically to find any discrepancies that need to be addressed.

Why is Inventory Reconciliation Important?

When the records don’t agree with the physical inventory, there’s an issue.

Even with the right inventory management and control software, there’s always a bit of shrinkage in inventory. According to the National Retail Federation, the average shrink rate (as a percentage of sales) is 1.38% for U.S. retailers. While that may seem like a small percentage, it adds up to just shy of $50 billion of inventory that’s unaccounted for.

There’s no doubt that some of this shrinking is caused by human error and mistakes. The information in the inventory control system is only as good as the data that’s entered and managed. Inventory reconciliation helps you monitor the shrinkage and look for the warning signs of bigger issues, such as customer or employee theft.

Shoplifting and customer theft make up 36% of inventory losses while employee theft accounts for 30%. When the inventory numbers don’t match up with the physical inventory or your shrinkage rates start to grow, it may be a signal that you need to improve your loss prevention strategies. It can also reveal systematic problems, such as missing shipments or even fraud by suppliers.

Shrinkage is just one of the inventory KPIs you need to track using inventory management software.

How to do Inventory Reconciliation

Our implementation experts at SkuVault recommend a 6-step process many businesses use when conducting inventory reconciliation. It starts with the count.

1. Count the Products

Count the products on hand and compare the inventory records with the physical inventory. Most companies do multiple counts to reduce errors.

This includes noting stock numbers and serial numbers to match up with the records.

2. Check Your Records

Make sure that your inventory records, including inventory control systems, are current. This includes accurate and up-to-date sales and invoices.

Compare the inventory records with each item listed in stock. Make sure any stock numbers and serial numbers are accurate. Items that do not have any serial numbers or stock numbers associated with them should be compared to inventory-on-hand numbers and supplier invoices.

Just like in the counting process, most companies will check and then re-check the record matching to verify accuracy.

3. Examine Discrepancies

As you compare the results of your inventory audit, you will likely uncover discrepancies. Once the audit is completed, it’s time to address these discrepancies.

Some discrepancies may be attributed to human errors or math errors. If it appears that’s not the case, the next step is going through sales records to identify the possibility that sales had not been recorded accurately. If you are unable to find missing sales receipts, you may have lost or misplaced merchandise or indications of theft or fraud.

4. Chase Down the Discrepancies

It’s up to you to determine the acceptable level for shrinkage in your business. If the number or value of missing merchandise is small, it may be more time-consuming and expensive to narrow down the cause of the loss rather than just move on. If you decide to track it down, look first at your systems and then at your employees.

Often, steps get missed in the recording process either in the warehouse, the retail floor, or the eCommerce platforms. It’s helpful to interview employees responsible for each step to find out if there’s an explanation for the discrepancy that can be addressed.

5. Reconcile Your Inventory Records

Whether you can track down the discrepancy or not, you must have an accurate inventory count. Adjust your record to match the physical count. Then, make note of the changes for updated financial reporting or write-offs.

6. Compare Your Results to Previous Inventory Reconciliations

As a final step, compare the results on your inventory reconciliation with previous ones. This can help surface trends and patterns and indicate areas for further examination.

Streamlining Inventory Reconciliation

Inventory reconciliation can be a tedious and time-consuming task. For retailers, it can mean after-hours counting or even shutting down operations for a few days to do manual inventory checks. This may not be an option for you.

Some companies will streamline the reconciliation with a process called “cycle counting.” Instead of a once-a-year reconciliation process, they have their counting broken down so that some inventory items are being counted all the time. Doing a little bit at a time may be easier than doing it all at once.

Another way to handle inventory reconciliation is to break it down by priorities. Instead of counting everything, you group products into categories and focus more heavily on high-value items. They use what’s known as the ABC Inventory Control System.

The ABC Inventory Control System

Rather than look at all inventory equally, it’s first divided into three categories:

  1. Category A: High-Value Inventory
  2. Category B: Moderate-Value Inventory
  3. Category C: Low-Value Inventory

In most companies, Category A (high-value inventory) will represent 15-25% of items but represent large volumes of sales and/or profitability. Inventory that is less critical to your operation is grouped into Categories B or C depending on their value.

Category A inventory should be counted more frequently as it has a greater impact on your operations. Shrinkage or loss is a much bigger concern than for lower value items and it’s more important to identify problems or missing stock more quickly.

Delivering More Accurate Inventory Management

If you find some discrepancies as you are conducting your inventory reconciliation, don’t despair. It’s a normal occurrence. The larger the enterprise, the more likely you’ll find something’s not quite right. It’s when the numbers grow out of proportion, or you spot troubling trends, that you’ve got a problem.

The best way to keep accurate and current accounts of your inventory is to utilize an end-to-end inventory control system that ties your POS system, warehousing, and delivery together in an integrated manner. This allows for greater accuracy and accountability while providing real-time records for review.

Interested in learning more? Here are a few more resources we think you’ll like! 

Ready to improve your inventory reconciliation? One of our knowledgeable sales consultants is ready to walk you through exactly how SkuVault can benefit your business and answer all your questions about how our powerful Inventory and Warehouse Management System can help address the needs of your unique business.


Inventory Reconciliation Made Easy

Schedule a free personalized demo right now to see how Inventory Management Software can improve inventory count accuracy

Grow your eCommerce business with SkuVault

Schedule a Demo

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Loading