CM | How to reconcile Bank Stmt line with GL Journal based on multiple segment (not just cash/natura
Amj Bronze Crown
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:
- Navigate to the Setup and Maintenance work area.
- Select the Financials offering.
- Search for and select the Manage Bank Accounts task.
- Create or Edit the bank account.
- Select Enable multiple cash account combinations for reconciliation option.
- 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.
- 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.1