Current Balance of inventory account

 I am using Simply Accounting by Sage Premium (Version 2010 Release D Update). Recently I tried to run a general ledger report of our inventory account (by selecting Report-->Financials-->General Ledger). But the current balance changes significantly depending on what I select as the start date in the General Ledger (see attached screen shots). If I select Feb 17 or earlier for starting date, and choose the current date as ending date, the general ledger will show the correct balance ( about $463K), but if I choose a day after Feb 17 as starting date, it will show as $803k.  Does anyone have any idea why this is happening? Thank you very much. I believe our real inventory level is at about 463K.

    By the way, the “Chart of Accounts” shows the  inventory balance as about $803k, which is wrong. However, the “Inventory Summary” shows the balance as $490k which is almost right.


    Any help would be appreciated.

 

Parents
  • 0

    In Maintenance | Check Data Integrity, is your inventory balanced to the General Ledger?

    Your balance 'as of' the very last transaction in the Inventory G/L account should match

    Each 'Inventory Summary' report for that account, if you choose 'Inventory by Asset', and the Report On date as 'Latest Transaction'.  (and if using Locations, choose all, and turn off 'show location information)

    If You have multiple inventory accounts you'll have to run a separate inventory, and G/L report for each account.

  • 0 in reply to RandyW

    Hi Randy,

        I just ran Check Data Integrity, it says Inventory & Services is not balanced. Not only that, Customers and Vendors are not balanced as well.

      We have only one location.

      And we are not running under Historical Mode, it's been  disabled.

      "Do you have your data set to 'clear' paid items, and have you ever 'cleared' the data?  

    Once the data is 'cleared', historical reports may not be accurate.    "

    Could you explain a little bit about that? How do I know if I have set it to "clear"?

       Thank you very much!

    Lawrence

Reply
  • 0 in reply to RandyW

    Hi Randy,

        I just ran Check Data Integrity, it says Inventory & Services is not balanced. Not only that, Customers and Vendors are not balanced as well.

      We have only one location.

      And we are not running under Historical Mode, it's been  disabled.

      "Do you have your data set to 'clear' paid items, and have you ever 'cleared' the data?  

    Once the data is 'cleared', historical reports may not be accurate.    "

    Could you explain a little bit about that? How do I know if I have set it to "clear"?

       Thank you very much!

    Lawrence

Children
No Data