Trial Balance opening balance does not match ending balance previous month

I am using Sage 300.  My ending balance in retained earnings for year end (12/31/24) is correct, but the beginning balance for January does not match that.  There are no entries, so I don't understand how there can be a difference.  

  • 0

    Check the Setting for Account Type of the Retained Earnings Account.  It should be set to 'Retained Earnings'.

  • 0 in reply to Dana B. Stidsen

    Thank you, Dana.  It was correctly set to Retained Earnings.

  • Hi  is it possible 2025 was added to the Fiscal Calendar but Year End Processing was never run in the database?  Lets check some things:

    • Open General Ledger -> G/L Periodic Processing -> Create New Year -> Check it says "Change the current fiscal year to 2026".  If its not you need to run a backup (database dump), get all users out, then click Process on the G/L Create New Year screen.
    • Is this an established database or was 2024 the first year for this database?  I'm asking to check whether there are already multiple years in this database to confirm whether the G/L configuration is already correct.
    • On the General Ledger -> G/L Reports -> Trial Balance screen, click Settings -> Clear Saved Settings and try running the report again.  Maybe there is a filter you missed on that screen.
      • You could also try right-clicking on the Trial Balance icon -> left-click on Restore Defaults.

    Let us know how you go with those.  Don't forget to report back once you figure it out as we'll be fascinated to know what the issue was.

    Good luck!

  • 0

    Hi Lisa, 

    First step is to check Account History Inquiry and see if there are any entries entered in the Closing Period (CLS) period.

    Another possibility is you ran your Create New Process in GL - Periodic Processing - Create New Year then subsequently posted an entry to 2024 which involved an Income Statement type account ( that would normally close to Retained Earnings).. the program automatically does the closing entry in this scenario, however there is no actual Journal Entry batch created.. instead, in the posted GL Batch you will see an extra closing entry in the Batch Listing and Posting Journal.. 

    (ie.. if you enter Entry # 1 in a batch that is a prior  year batch.. upon posting entry number 2 of the batch will be the closing entry) however you can't actually view this in the GL Batch but you can in the Batch Listing and Posting Journal reports. 

    Regards,

    DCrampton

  • 0 in reply to Tim - Accsys Consulting

    Thank you for the response, Tim, but I must be dealing with an older version of 300.  I don't have a Periodic Processing.  I did check and the 2024 fiscal year is closed.  I also don't have a Clear Saved Settings option in the TB. 

  • 0 in reply to Lisa Coleman

    Hi Lisa, 

    Your user may not have permissions to run Create New Year process in General Ledger.. 

    Can you try signing into Sage as the ADMIN user?

    This process has been in the product since Day 1 so it should be there.

    Regards,

    DCrampton