This article is for company which has chosen to track their inventory in FIFO costing method. For companies using average costing, please refer to this article.
You can also this report called Non-Zero Inventory/Negative Cost Value report which lists any FIFO bucket that has zero quantity on hand but non-zero value.
If you use the FIFO costing method for inventory costing, sometimes you would find that some inventoried products would have negative cost in a FIFO bucket or zero quantity but positive value. A FIFO bucket (which is sub-account under the inventory asset account for the product) created when new inventory is received into the system (via Shipment Receipts or Bills). The reason for the negative cost is often due to adjustment and bill posting , or transfer done after inventory is received.
Consider this scenario, you receive some inventory at the cost of 100 dollar. The system records 100 as the value of the inventory and this is stored in the inventory asset account for the product . Then you sell all of the inventory. The system deducts 100 off the the inventory asset account. You now have 0 value in the inventory asset account. You then receive a bill for the shipment receipt at at cost of 90 (your supplier decided to give you a discount). When this bill is posted, the system would reverse the 100 value as received and the put in a new value of 90. Since the entire inventory was sold at 100 value, this leaves us with -10 as the value of the inventory. You can also go into negative if you transfer stock to another facility and then corrected the cost of the stock to a lower value.
To correct this, you can do a manual GL entry by going to main menu General Ledger, New G/L entry, new transaction. You would need to create a draft transaction that debit the inventory asset account for the FIFO bucket and credit a balancing account.
In Versa, each FIFO bucket has a sub-account under the inventory asset account. To find this sub-account, just type in the FIFO bucket id into the account search field. The FIFO bucket id can be found by going to Products, Search Parts, enter the part number of the product. Once you find the product, the various quantity in different facility will be listed. Find the row that has the negative cost. Click on the quantity under On Hand. This view will give you all the FIFO buckets in the system. Note the id under Bucket ID This balancing account can be your cost of goods sold account. Consult with your accountant on which account should be used for crediting.
Post this GL entry and your inventory value would be corrected.
When you run the report Non-Zero/Negative Inventory Value Report, it gives you an option to create adjusting GL transactions to clear out all the values . It a draft transaction which means you can review it and revise before posting.