Negative inventory account balances
Hi
I have an item in inventory that has a negative account balance even though the item has had no transactions for in excess of 18 months. We are reonciling the inventory values in preparation for business sale so need to have the correct figures in place. There is nil stock of the item, so the value should be zero, not a negative amount. Can I correct his with a journal? If so can you help? If not how do i fix? TIA
Hi kyleenich
While the MYOB scripts may fix unusual inventory item values and on hand counts, they don't usually fix existing transactions.
Before you proceed with the suggested Inventory Adjustment Journal, it may pay to get a MYOB consultant well versed in inventory issues in AR2023 to take a closer look at the file to see what has caused this situation. It may well have been caused by an incorrect Item setting, or by an usual transaction, or by using an incorrect item value.
Without knowing how it was caused you are not going to confidently know how to fix it. Typically if an Inventory asset account is in negative, this means too much COS was shifted from this account to the P&L Cost of Sales account linked to the item(s). If there are no items on hand, an Inventory Adjustment Journal may make things worse. A general journal Dr the Inventory asset account and Cr the linked Cost of Sales is more likely to both fix the account balance and correct an overclaim of costs on the P&L.
Regards
Gavin
