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.
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.
Check the Setting for Account Type of the Retained Earnings Account. It should be set to 'Retained Earnings'.
Thank you, Dana. It was correctly set to Retained Earnings.
Hi Lisa Coleman is it possible 2025 was added to the Fiscal Calendar but Year End Processing was never run in the database? Lets check some things:
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!
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
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.
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
*Community Hub is the new name for Sage City