How to Compare and Review Trial Balances

The quality of the trial balances that you import into General Ledger Manager is critical to creating reliable master trial balances. One way that you can help ensure the quality of your trial balances is to compare those that you add in the Import Queue that are valid and that you are considering importing into General Ledger Manager with similar ones that have already been importedTo bring a valid trial balance file into the General Ledger Manager database from the Import Queue. In the import process, only the trial balance data in the file gets brought into the database, all other data being discarded. Imported trial balance files are the files that General Ledger Manager combines into master trial balances.. This comparison can help you eliminate redundant, old, or otherwise unnecessary trial balance files.

To compare files, do the following:

1. Click the check box next to a valid trial balance in the Import Queue that you want to compare.
2. Click Compare & Review in the grid menu in the Import Queue.
3. The Compare File to Trial Balance page is displayed. It shows the name of the file in the Import Queue that you want to compare as well as its data type, associated chart of accounts, and date/time of arrival on the Import Queue.

Just below this data, a list of trial balance files that have already been importedTo bring a valid trial balance file into the General Ledger Manager database from the Import Queue. In the import process, only the trial balance data in the file gets brought into the database, all other data being discarded. Imported trial balance files are the files that General Ledger Manager combines into master trial balances. is displayed for you to make a selection. This list only includes those files that are from the same source, that have the same chart of accounts, and that are from the same time period as the file in the Import Queue that you have selected for comparison. If no imported trial balance files are displayed for your selection, then there are none in General Ledger Manager to compare.

4. In Compare File to Trial Balance, select the imported trial balance to which you want to compare the file in the Import Queue that you selected.
5. Either click Review comparison results and dispose data or click Compare to see the comparison results.
6. In Compare File to Trial Balance, review the results of the comparison. The comparison results are categorized as New, Edited, Deleted, and Comparison, which are also menu buttons that you click to see the following:

• All of the new records found in the file on the Import Queue. By default, each new record is also displayed. The records in the file on the Import Queue that are not found in the imported trial balance to which it was compared are considered new.
• All of the edited records found in the file on the Import Queue. The records in the file on the Import Queue that are found to have changes to their balances are considered to be edited. To view each of the edited records, click Edited.
• All of the deleted records found in the imported trial balance. Records in the imported trial balance that are not found in the file on the Import Queue to which it was compared are considered deleted records. To view the deleted records, click Deleted.
• A side-by-side comparison of any new and edited files in the file on the Import Queue with any deleted files in the imported trial balance with which it was compared.

Based on the results of your comparison, you can click Import to import the trial balance file on the Import Queue that you compared, or you can click the Back button to go back and compare a different imported trial balance to the file on the queue.