Use the Automatic Reconciliation report for automatic reconciliation. You can print a preliminary report by entering No for the Update Reconciliations parameter. The preliminary report shows all the transactions within the parameters you select that are eligible for automatic reconciliation.
General Ledger can only perform automatic reconciliation for transactions that have:
Matching accounts and reconciliation references
Matching balancing segment values and reconciliation references
Matching balancing segment values and accounts
Matching balancing segment values, accounts, and reconciliation references
To perform the automatic reconciliation, enter Yes for the Perform Reconciliations parameter when you submit the Automatic Reconciliation report. General Ledger reconciles all the eligible transactions within the parameters you select and prints the report for the reconciliations that were performed.
Use the Standard Request Submission windows to submit the Automatic Reconciliation report.
Enter the ledger of the transactions that you want to include in the report.
Enter the currency code for the currency of the transactions that you want to include on the report.
Enter the earliest accounting period for the transactions that you want to include on the report.
Enter the latest accounting period for the transactions that you want to include on the report.
Enter the earliest date for the transactions that you want to include on the report.
If you entered a From Period, the Start Date defaults to the first day of the From Period.
Enter the latest date for the transactions that you want to include on the report.
If you entered a To Period, the End Date defaults to the last day of the To Period.
Enter the first account in the account range that you want to include on the report.
Enter the last account in the account range that you want to include on the report.
This table shows the report headings.
| In this heading... | General Ledger prints... |
|---|---|
| <Data Access Set> | The data access set name. |
| <Report Title> | Automatic Reconciliation Report. If you print the preliminary report only, without performing automatic reconciliation, General Ledger prints Preliminary Report as the subtitle. |
| Report Date | The report date and time. |
| Page | The current and total page numbers. |
| Ledger | The ledger selected at runtime. |
| Reconciliation Rule | The matching attributes selected at runtime. |
This table shows the column headings.
| In this column... | General Ledger prints... |
|---|---|
| Account | The account combination for the transaction |
| Description | The account description |
| Batch | The batch name for the transaction |
| Journal | The journal entry name for the transaction |
| Effective Date | The effective date of the transaction |
| Period | The accounting period for the transaction |
| Currency | The transaction currency |
| Entered Debit | The debit amount in the entered currency, if the transaction is in an entered currency |
| Entered Credit | The credit amount in the entered currency, if the transaction is in an entered currency |
| Accounted Debit | The debit amount in your ledger currency |
| Accounted Credit | The credit amount in your ledger currency |
This table shows the row headings.
| In this row... | General Ledger prints... |
|---|---|
| Total | The total debit and credit amounts in your ledger currency |