inventory value reconciliation vs BS

Agspec4

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 ?

 

also despite checked all entries are correct, my inventory value recon shows out of balance though.

 

TIA for the help.

Agspec4

Thanks for the swift response, Mike

 

i ran per 30/6/23 the delta is 27,568.29 which the stock value greater than the GL/BS

i ran per 30/5/23 the delta is -3,355.29 which GL/BS is greater than stock value

 

in fact i ran each month throughout FY22/23 , each month is Out of balance 

 

What could possibility happened? someone i iknew who uses MYOB for many years told me , hers also always Out of Balance, Therefore she doesnt rely on this inventory value reconciliation report.

 

and how to rectify this for our EOFY? 

 

i checked the ff FY21/22 and FY20/21 too :

as of 30/6/22 the out of balance only -$0.33 but as of 30/6/21 the out of balance was $45,721.20

 

TIA