inventory value reconciliation vs BS
Hi, does the stock on hand shown on BS must have same figure shown on inventory value reconciliation report? if not, which inventory report that i can generate to match my BS inventory figure ? ...
Forum Discussion
Hi Agspec4 , export your items by going to File, import/export, choose export, then select items and follow the process through.
Hi Agspec4 , have you been able to review the item set-up?
Hi Mike, yes i managed to export out the item list
i dont see anything wrong. all item set up under the correct inventory asset account.
what's the possibility reason for this out of balance and i am lost for days how to fix this..
but we have few items that ' i inventory item' are not ticked as we dont keep this item in our WH, only get from supplier and resell it immediately for export. ( it was long time set up by my predecessor)
TMO, those items need to be ticked too right? cause recently we came accross that those items are not generated Cost of Sales so it causes my analaysis item report margin is 100% for those items.
Hi Agspec4 , the non-inventory items do not have "I inventory..." ticked, and therefore do not generate entries to an inventoy asset account, and therefore do not affect the out of balance issues.
Can you list out the imbalance figures for the last 6 month-ends (Jan23 to Jun23), across 6 lines like:
Month, Stock total, GL total, Out of Balance
I'm interested to see the trend. In fact I'd be keen to take a look at your file directly if it's in the cloud; if that's of interest please email me for an off-forum discussion.
Hi Agspec4 , have you been able to make any progress with this issue?
