You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

CM | How to reconcile Bank Stmt line with GL Journal based on multiple segment (not just cash/natura

Best Answer

  • Amj
    Amj Bronze Crown
    edited Mar 17, 2021 12:40AM Accepted Answer

    How to Have Reconcile Journal Lines for Multiple Cash Account Combinations? (Doc ID 2651137.1)

    Reconcile journal lines of multiple cash account combinations matching the same natural account and other specified segment values. Previously, only journal lines created for the complete cash account combination were available for reconciliation.

    When performing bank account reconciliation, Cash Managers will be able to manually or automatically reconcile all journal lines entered on different account code combinations matching the same natural account ‘1110’ and sub-account ‘0000’.

    The Cash to General Ledger Reconciliation Report is also enhanced to display journal lines and closing balances of such cash account combinations.

    Steps to Enable

    To enable this feature, perform the following steps:

    1. Navigate to the Setup and Maintenance work area.
    2. Select the Financials offering.
    3. Search for and select the Manage Bank Accounts task.
    4. Create or Edit the bank account.
    5. Select Enable multiple cash account combinations for reconciliation option.
    6. Select the GL Cash Account Segments you want to derive the corresponding segment values from the bank account's cash account to retrieve multiple cash account combinations.
    7. Save and close the page.

    Tips And Considerations

    You must have the Journal Reconciliation Enabled profile option (CE_GL_RECON_ENABLED) set to 'Yes' to perform manual and automatic reconciliation of bank statement lines directly from GL Journal Lines.

    Consider using the GL Recon Start Date as a beginning date of journal reconciliation for the bank account.

    The natural account segment is required and always selected as GL Cash Account Segment. Review and select additional segments that qualify the bank account and you want to consider for retrieving multiple cash account combinations.

    The closing book balance displayed in the Cash to General Ledger Reconciliation Report takes into consideration multiple cash account combinations when this option is enabled for a bank account.