How do I run the Chart of Accounts Journal Synchronization test?

How to run the Chart of Accounts/Journal Synchronization test in Sage 50 Accounting.

 

1. Back up the company

1. Have all other users log out of the company.
2. Change your accounting period to Period 1. See How do I change the accounting period?.
3. Select Help, Support Utilities, and then select Integrity Check.
4. Click Backup.
5. Give your backup a name, choose where you want to save it, and then click Save.
6. Click OK in the box that tells you the size of the backup.

2. Reindex files

1. Select the Reindex Files box. From the Reindex File List select Chart and then click OK.
2. When the test is finished, select Help, Support Utilities, and Integrity Check.
3. Select Continue and check the Reindex Files box. From the Reindex File List select Jrnl Header and then click OK.
4. When the test is finished, select Help, Support Utilities, and Integrity Check.
5. Select Continue and check the Reindex Files box. From the Reindex File List select Jrnl Rows and then click OK.
6. When the test is finished, select Help, Support Utilities, and Integrity Check.

3. Run data synchronization tests

1. Select Continue and check the Chart of Accounts/Journal box under the Data Synchronization Tests section. Then click OK.
   • You may receive one or more messages stating that a synchronization error was corrected. Click OK each time the message appears
   • After the test concludes, open the standard Balance Sheet to verify if it is in balance
     Open the General Ledger Trial Balance to verify the total debits matches the total credits. If they don’t, proceed to the next step
2. Select Help, Support Utilities, and Integrity Check.
3. Select Continue, then select the Journal Balances box, and click OK.
4. Select Help, Support Utilities, and Integrity Check.
5. Select Continue, then select the G/L Balances box, and click OK.

4. After the tests are complete

1. Change back to your current accounting period. See How do I change the accounting period?.
2. Verify the issue is resolved.

 NOTE: You can’t see a one-sided entry.

 NOTE: The G/L Balances Test will forcibly restore an out-of-balance General Ledger into balance by moving the offset into the Equity Retained-Earnings account. If the balance doesn’t belong in Retained-Earnings, you can move it with a general journal entry.