Inventory Reconciliation

Question

I am having trouble getting my inventory to balance and also entering a credit note for items that we incorrectly charged in December as it is saying that is has a zero balance.&nbsp; The item in question also has&nbsp;a (-) value of 817.74 in the reconcilliation before I have done any transactions for this item.&nbsp; I have run a detail item transaction report back to 1/7/2020 and there are no transactions on this item before 13/10/21.&nbsp; Yet if I run a reconciliation report for 1/9/21 it is showing the item with the negative value above.

gavin12345 · Answer

Hi&nbsp;Mapleloor&nbsp;&nbsp;Unfortunately MYOB's inventory module is a little like that - unreliable - you will see posts all over the forum with different un-explainable examples. Sometimes it picks up figures randomly and then creates astronomically high COGS amts or on hand Values&nbsp;(into the millions!).&nbsp;&nbsp;From personal experience I would say the bulk of the errors are caused by editing or deleting invoices/bills. MYOB incorrectly updates things in the back end.&nbsp;It is essentially up to the user to manage and control inventory.&nbsp;&nbsp;The only solution I can suggest is to record an Inventory Adjustment Journal to set the SOH and Value to what it should be today.&nbsp;RegardsGavin

Forum Discussion

Inventory Reconciliation

1 Reply

Looking for something else?

Related content

Receivables reconciliation

Reconciliation out of balance

Inventory Issues

Bank reconciliation

EFT Reconciliation report .csv format

Inventory discrepancies

Reconciliation

GST Reconciliation