How to reconcile inventory
/What is an Inventory Reconciliation?
An inventory reconciliation is the process of comparing on-hand inventory to your records and adjusting the records as necessary. This is a good way to spot errors in your inventory tracking system. A well-run inventory reconciliation is quite detailed, and is designed to not only spot specific errors in your inventory records, but also to identify the underlying triggering events and take steps to ensure that they do not happen again. By conducting an inventory reconciliation, you can gain better control over your inventory asset.
Advantages of an Inventory Reconciliation
It takes time to conduct an inventory reconciliation, but doing so is well worth the effort. Here are some of the advantages of conducting ongoing reconciliations:
Better inventory record accuracy. Reconciliations result in a close match between the actual amounts of on-hand inventory and what is stated in your inventory records.
Improved processes. By focusing on the issues that caused inventory errors, you can reduce inventory losses, which improves overall profitability. This also allows you to spot the underlying issues sooner, which reduces costs.
Better customer service. When your inventory records match your on-hand inventory, you can avoid backorders, which improves the speed with which customer orders can be fulfilled.
More accurate financial statements. By reporting the cost of goods sold and ending inventory levels with confidence, you can issue more accurate financial statements, which in turn gains the trust of investors.
Better inventory management. When you know that your inventory records are accurate, you can reduce the excess inventory levels kept on hand, resulting in a lower working capital investment in inventory.
How to Reconcile Inventory in 9 Steps
To reconcile inventory, compare the inventory counts in the company's records to the actual amounts on the warehouse shelves, figure out why there are differences between the two amounts, and adjust the records to reflect this analysis. Inventory reconciliation is an important part of cycle counting, since the warehouse staff uses it to continually update the accuracy of its inventory records. Inventory record accuracy is needed to ensure that replacement items are ordered in a timely manner, that inventory is properly valued, and that parts are available for sale or production when needed. An inventory reconciliation is also needed to ensure that the actual and recorded inventory amounts are the same at the end of the year, so that there will be no issues when the inventory is audited.
Inventory reconciliation is not as simple as adjusting the book balance to match the physical count. There may be other reasons why there is a difference between the two numbers that cannot be corrected with such an adjustment. In particular, you should consider following any or all of the steps noted below.
Step 1. Recount the Inventory
Someone may have incorrectly counted the inventory. If so, have a different person count it again (since the first counter could make the same counting mistake a second time). Further, if the physical count appears to be significantly lower than the book balance, it is possible that there is more inventory in a second location - so look around for a second cache of it. Recounting is the most likely reason for a variance, so consider this step first.
Related AccountingTools Courses
Step 2. Match the Units of Measure
Are the units of measure used for the count and the book balance the same? One might be in individual units (known as "eaches"), while the other might be in dozens, or boxes, or pounds, or kilograms. If you have already conducted a recount and there is still a difference that is orders of magnitude apart, it is likely that the units of measure are the problem.
Step 3. Verify the Part Number
It is possible that you are misreading the part number of the item on the shelf, or guessing at its identification because there is no part number at all. If so, get a second opinion from an experienced warehouse staff person, or compare the item to the descriptions in the item master records. Another option is to look for some other item for which there is a unit count variance in the opposite direction - that could be the part number you are looking for.
Step 4. Look for Missing Paperwork
This is a large source of inventory reconciliation issues. The unit count in the inventory records may be incorrect because a transaction has occurred, but no one has yet logged it. This is a massive issue for cycle counters, who may have to root around for unentered paperwork of this sort before they feel comfortable in making an adjustment to the inventory records. Other examples of this problem are receipts that have not yet been entered (so the inventory record is too low) or issuances from the warehouse to the production area that have not been entered (so the inventory record is too high).
Step 5. Examine Scrap
Scrap can arise anywhere in a company (especially production), and the staff may easily overlook its proper recordation in the inventory records. If you see a modest variance where the inventory records are always just a small amount higher than the physical count, this is a likely cause.
Step 6. Investigate Possible Customer Ownership
If you have no record of an inventory item at all in the accounting records, there may be a good reason for it, which is that the company does not own it - a customer does. This is especially common when the company remodels or enhances products for its customers.
Step 7. Investigate Possible Supplier Ownership
To follow up on the last item, it is also possible that you have items in stock that are on consignment from a supplier, and which are therefore owned by the supplier. This is most common in a retail environment, and unlikely anywhere else.
Step 8. Investigate Backflushing Records
If your company uses backflushing to alter inventory records (where you relieve inventory based on the number of finished goods produced), then the bill of materials and the finished goods production numbers had better both be in excellent condition, or the reconciliation process will be painful. Backflushing is not recommended unless your manufacturing record keeping is superb.
Step 9. Accept the Variance
If all forms of investigation fail, then you really have no choice but to alter the inventory record to match the physical count. It is possible that some other error will eventually be found that explains the discrepancy, but for now you cannot leave a variance; when in doubt, the physical count is correct.
Related Articles
How to Calculate Ending Inventory
How to Estimate Ending Inventory
How to Improve Inventory Record Accuracy