finished goods on balance sheet

Our finished goods number is badly out of sync with our valuation report under inventory management.  I understand the two are not connected but they should be in the same ball park.  my finished goods number is much higher on the balance sheet.  we actually count everything as a raw material and we use bill of materials to make an item when we ship it.  we should actually have zero finished goods.  but we should show inventory on the balance sheet.  Where is Mas 90 getting this number?  how do i fix this?  how do i keep this from happening again.  any help would be greatly appreciated.

  • 0
    The following is not all inclusive, but represent the two most common reasons I see this happen.

    General journal entries made to the inventory accounts is the simplest way to get them out of sync with your valuation report.

    The other common area is your g/l accounts setup in product line maintenance. If those are set incorrectly, it's a guarantee you will get out of sync. (I picked up a client last year and discovered that they had their inventory account set to account #2000 which was correct, but they set the inventory adjustment expense account to #2000 as well - which of course resulted in a zero entry to the balance sheet inventory account each time an adjustment was made).

    You may want to consult with your Sage Partner.
  • 0 in reply to TomTarget
    Thank you. i think you have me on the way. the issue is the way we are setting items up. should be an easy fix.