Long story short, an inventory adjustment was made with an astronomical amount. I investigated it and found the cause, which was an item that was adjusted with a very large Rate. But, I also noticed something odd with a couple of the other items. Before the adjustment, there were zero on hand but they had positive Total Values. I ran an item saved search with Total Value and a formula that calculated the On Hand amount multiplied by the Last Purchase Price, which should be very close to an accurate value. I found that there were about 500 items that are overvalued by as much as $11,500. Most of these items should be under $2-$3. I believe all of these items are Lot-Numbered Inventory Items.
Our inventory is overvalued by about 10%
When looking at transactions for these items, I've discovered some errors in many Inventory Adjustments. I am trying to figure out 1) how these errors occur and 2) how to correct the numbers.
There are two types of errors that I see:
1) Inventory Adjustments were made where quantities were adjusted out, but the Rate was $0.00.
I have tried to recreate this, and I cannot change the Rate when I remove items from inventory.
Does anyone know how to remove inventory and change the Rate?
2) Inventory Adjustments were made where quantities were adjusted in with very large Rates.
Changing the Rate when adding items to inventory is easy enough, but someone would have to make an effort to do this, and I'm told they weren't manually changed. We've had several instances where Inventory adjustments were much higher than they should have been because an item's Rate was up to 100 times what it should have been. The large numbers that I am seeing are numbers that I can not figure out. I cannot do any calculations using data for the items that come up with the number that I am seeing, so I have no idea where it is being sourced.
Our accountant is saying that the numbers he sees when he looks at the Balance Sheet for 2012 are different than the 2012 Balance Sheet printouts he has from when he did our taxes last year.
When he looks at the financial data now, he can see that our inventory was inflated in 2012. His printouts from May 2013 do not show these inflated numbers. This is no small amount form a transaction that was backdated.
Has anyone else had inventory valuation issues like this, or does anyone ever do there own calculations to verify inventory values?