Balancing Inventory (X months ago)

I have found that the inventory has never been balanced in the system.  Our cutover date was April 1, 2014.  We are using Sage 100 ERP (5.0).

Is there a possibility that we can balance the inventory on Apr. 1, then May 1, then ... and so on to find and check for any inventory errors along the way?

Also, if so, what would be the best procedure?

  • 0

    You could run the Inventory Trial Balance for the end of each month and make correcting entries in the GL.  However IMHO the best option would be, at year end, post everything in PO, SO and Inventory and then do a physical count, post and then run an Inventory Trail Balance as of 12/31/2014 and tie to the GL. Make any correcting entries in the GL as needed.