Reconciliation Tool  

General Ledger Reconciliation
Step Action Note
1. Post

Ensure all entries are posted.

Overview


GL Post Entries

Click Overview to find links to each application for posting in the pre-reconciliation tasks list.

Click the link; then select Post Entries under the Task menu.

Note:  Review posting journals for rejecting entries that must be corrected.

2. Data Verification

Review the current ledger to verify that the Beginning Balance total is zero, the debits and credits are equal and the Ending Balance is zero.

Current Ledger

If the ending balance is not zero, the transaction file does not equal the master file. Look for accounts that appear on your ledger with exclamation points (!!) next to the ending balance.

How to correct:

In the Knowledgebase type article number KB69749  in the Search for a Solution section, then follow the instructions in the article.

3. GL Summary Reconciliation

 

GL Summary

Review this summary to determine if your accounts balance.

If General Ledger is in balance skip to step 7 to print period end reports,
    otherwise, continue with step 4. 
4. Detail

Batch Detail: Identify which batches are out of balance

Totals by Batch

This step allows you to perform a more detailed analysis of your transactions by reviewing batches to see if any are out-of-balance. This report offers drill down capability into each batch to see transaction detail.

5. Common causes if out of balance

Entries have been made to a prior year

Prior Year Adjustments

Select this report to determine if you have any prior year adjustments.

How to correct:

In the Knowledgebase Type article number KB85880 in the Search for a Solution section, then follow the instruction in the article.
 

Entry spanning two accounting periods

Batches by Accounting Date

This report locates debit and credit entries that were entered into different accounting periods.
 

Inter-company discrepancy

Batches by Prefix

This report locates debit and credit entries that were split between two prefixes without the needed inter-company account entries.

6. Repeat

Repeat steps 3, 4 & 5 as needed for each account and/or batch that is out of balance.

 

 

7. Period End Reports

 

Trial Balance

Current Ledger

Year-to-Date Ledger

Print common period end reports, such as the Trial Balance, Current Ledger, and Year-to-Date Ledger.

© 2005 Sage Software, Inc. All rights reserved. The Sage Software logo and the Sage Software product and service names mentioned herein are registered trademarks or trademarks of Sage Software, Inc. or its affiliated entities. Other brands are trademarks of their respective companies.