Correcting Beginning Balances That Don’t Match Prior Period’s Ending Balances

Hands holding a smart phone

If you ever wind up in this situation, the first thing to do is ensure you have a good working backup of your data. This function has the possibility of changing the information in the general ledger. Contact your Sage Business Partner for help.

Update transactions from all modules and post them to the General Ledger.

Confirm all users are logged off SAGE 100 ERP. This guarantees that no transactions are being updated when using this utility.

Select General Ledger | Utilities | Recalculate Account Balances.

This notice will immediately appear.

Correcting Beginning Balances That Don’t Match Prior Period’s Ending Balances

The timing of this varies and is based on how much history is being kept for that company code.

Recheck the balances. Be sure that “Year to Retain General Ledger History” is sufficient for the number of years containing data.

Correcting Beginning Balances That Don’t Match Prior Period’s Ending Balances

In this picture, you’ll only have data for two years of history. If an item was posted to 2012, you’d have to change the number of years to three. Then recalculate account balances and beginning balances (BB) for all three years should be visible.

If the issue persists, reinitialize GL PeriodPosting History. NOTE:  If beginning balances were initially entered as a BB journal entry, they may need to be reentered after reinitializing this file.

To reinitialize this file go to Library Master | Utilities | Reinitialize Data Files.

The following warning will appear.

Correcting Beginning Balances That Don’t Match Prior Period’s Ending Balances

Select the “Company Code” and “General Ledger Module.”

Correcting Beginning Balances That Don’t Match Prior Period’s Ending Balances

Scroll down to find the GL Period Posting History File.

Correcting Beginning Balances That Don’t Match Prior Period’s Ending Balances

Only check the GL PeriodPostingHistory box.

Click “Proceed.”

The following warning will appear.

Correcting Beginning Balances That Don’t Match Prior Period’s Ending Balances

Select “Yes.”

Return to General Ledger | Utilities | Recalculate Account Balances and click “Proceed.”

If the balances still don’t match or you’re uncomfortable with this process, please contact us for additional help.

Kate & Ben — How can we help you? Contact Us!

How can we help you?