GL Reconciliation

• Overview
• Reconciliation

Overview

This section explains how to request the Reconciliation option. Specifically, this section describes how to set up request parameters. You must set up request parameters before you can submit the request.

The GL Reconciliation process lets you determine whether or not reconciliation codes have been reconciled.

• If the total debits and credits are of equal value, the system considers the codes reconciled.
• If the total debits and credits are unequal, the system considers the codes unreconciled.

Reconciliation

You can set up request parameters for running the GL Reconciliation process. You can use this process to determine whether or not total debits and credits against the code are of equal value. If they are, the system considers the code reconciled. If they are not, the system considers the code unreconciled.

You can request the GL Reconciliation process for all reconciliation codes within a particular company, or you can enter specific reconciliation codes. If you enter specific reconciliation codes, the system forces reconciliation for the codes.

Reconciliation is marked at the nominal level using Reconciliation Required on the Controls format of the Nominal screen MEBB. Click the check box or leave this field blank. If you click the check box, reconciliation, comparing total debits to total credits, is at the account level. If you leave this field blank, the system performs reconciliation across accounts for the same reconciliation code. The reconciliation code is considered reconciled if total debits equal total credits. You enter reconciliation codes through data entry in GL. The AP system passes check numbers as reconciliation codes on cash transactions coming from the AP system.

You must define a reconciliation parameter record for a request before you submit it. Otherwise, the system will reject the request. If you submit a schedule and it contains a request without parameter details, the system will abort the request.

The reports produced for the GL Reconciliation process can display information relating to the codes that are reconciled, unreconciled or both.

You can inquire upon reconciliation code information. Specifically, when viewing a transaction with an associated reconciliation code on the Transaction by Account Code screen MEJE, the reconciliation flag indicates whether the code is reconciled, unreconciled, or forcibly reconciled. You can also inquire on transactions by reconciliation codes from the inquiry of the same name or the GL Inquiries menu. For more information on reconciliation code inquiries, see Enquiries.

To submit the automatic reconciliation process Enter 'Submit EL1' on a command line and click OK.

On the subsequent parameter screen MELA, You must enter either one of the following:

• In Company Level, click the check box to indicate that you want all reconciliation codes for the company to process. If you are going to designate individual reconciliation codes, this field should be left blank.
• Click the Reconcile Codes tab and enter the specific reconciliation codes you want to process in Reconciliation Code to Force. You may only use this if Company Level is blank. The system marks entered codes as forcible reconciled, regardless whether debit and credit values equal.

See Background Processing for more information on submitting processes.

See also

General Ledger Home Page