Balance Reconciliation

The Balance Reconciliation, reconciles the balances from the operational systems of a bank with the balances as maintained in General Ledger (hereinafter referred to as GL) of the bank. With this application, banks can also reconcile between General Ledgers maintained in the bank. The balances in the GL of a bank are the ones that are audited and duly certified by the internal and external auditors. Hence considered to be the final version of the truth in a bank. Therefore, all data extracted from any other operating systems of a bank must be reconciled with the balances maintained in the GL to ensure that they are complete, accurate, and comprehensive. It then acts as an authentic and reliable base for any further decision-making.

The bank's operational data are sourced into standard product processor entities/tables. GL Reconciliation application has pre-configured GL/PP table GL code and corresponding balances in the application, for which the reconciliation definition process must be executed. See Balance Reconciliation for more information.

Option is available to reconcile GL data with other operational data used by the bank, which does not flow into the standard Product Processors configured in the application. For more information on adding operational data tables to the data.

The list of Product Processors supported by this application is as follows.

Table: Product Processor supported by this application
Product Processor	Table Name
BILLS	Stage Bill Contracts
BORROWINGS	Stage Borrowings
CARDS	Stage Cards
CASA	Stage Casa
EQUITY	Stage Equity Exposures Contracts
FUTURES	Stage Futures Contracts
FX_CONTRACTS	Stage Foreign Exchange Contracts
INVESTMENTS	Stage Investments
LC	Stage Letter Of Credit Contracts
LEASES_CONTRACTS	Stage Leases Contracts
LOANS	Stage Loan Contracts
OD	Stage Over Draft Accounts
OPTIONS	Stage Option Contracts
REPO_CONTRACTS	Stage Repo Contracts
TD_CONTRACTS	Stage Term Deposit Contracts

Measures List

The following table provides the list of entity names and their corresponding measures.

Table: Entity name and its measures list
Table	Measure	GL code
Stage General Ledger Data	Amount In Accounting Currency Amount In Local Currency Amount Mtd In Accounting Currency Movement Mtd in Accounting Currency Movement Ytd in Accounting Currency
Stage Annuity Contracts	Undrawn Amount End of Period Balance Provision Amount	· Undrawn GL Code · General Ledger Account Code · Provision GL Code
Stage Repo Contracts	End Of Period Balance Provision Amount Undrawn Amount Current Write Off Amount	· General Ledger Account Code · Provision GL Code · Undrawn GL Code · Write-Off Gl Code
Stage Option Contracts	End Of Period Balance Provision Amount Total Fees And Charges Undrawn Amount Current Write Off Amount	General Ledger Account Code · Provision GL Code Fee GL Code · Undrawn GL Code Write-Off Gl Code
Stage Investments	End Of Period Balance Provision Amount Undrawn Amount Current Write Off Amount	· General Ledger Account Code · Provision GL Code · Undrawn GL Code · Write-Off Gl Code
Stage Loan Contracts	Commission Amount End Of Period Balance Total Fes And Charges Current Write Off Amount	Commission Gl Code General Ledger Account Code Fee GL Code Write-Off Gl Code
Stage Casa	Commission Amount End Of Period Balance Provision Amount Total Fees And Charges Current Write Off Amount	Commission Gl Code General Ledger Account Code · Provision GL Code Fee GL Code Write-Off Gl Code
Stage Cards	Commission Amount End Of Period Balance Provision Amount Total Fees And Charges Undrawn Amount Current Write Off Amount	Commission Gl Code General Ledger Account Code · Provision GL Code · Fee GL Code · Undrawn GL Code Write-Off Gl Code
Stage Term Deposit Contracts	Commission Amount End Of Period Balance Interest Accrued Amount Month Till Date Total Fees And Charges	· Commission Gl Code · General Ledger Account Code · Accr Int GL Code · Fee GL Code
Stage Futures Contracts	End Of Period Balance Provision Amount Undrawn Amount Current Write Off Amount	· General Ledger Account Code · Provision GL Code · Undrawn GL Code · Write-Off Gl Code
Stage Leases Contracts	End Of Period Balance Total Fees And Charges Undrawn Amount Current Write Off Amount	· General Ledger Account Code · Fee GL Code · Undrawn GL Code · Write-Off Gl Code
Stage Bill Contracts	Commission Amount End Of Period Balance Provision Amount Total Fees And Charges Undrawn Amount	· Commission Gl Code · General Ledger Account Code · Provision GL Code · Fee GL Code · Undrawn GL Code
Stage Letter Of Credit Contracts	Commission Amount End Of Period Balance Provision Amount Total Fees And Charges Undrawn Amount	· Commission Gl Code · General Ledger Account Code · Provision GL Code · Fee GL Code · Undrawn GL Code
Stage Borrowings	Commission Amount End Of Period Balance Provision Amount Undrawn Amount	· Commission Gl Code · General Ledger Account Code · Provision GL Code · Undrawn GL Code
Stage Foreign Exchange Contracts	End Of Period Balance Provision Amount Total Fees And Charges Current Write Off Amount	· General Ledger Account Code · Provision GL Code · Fee GL Code · Write-Off Gl Code
Stage Over Draft Accounts	Commission Amount End Of Period Balance Interest Accrued Amount Month Till Date Provision Amount Undrawn Amount Total fee and Charges Current Write off Amount	· Commission Gl Code · General Ledger Account Code · Accr Int GL Code · Provision GL Code · Undrawn GL Code · Fee GL Code · Write-Off Gl Code

Before you Begin

· Select the Domain and Deploy the selected Domain

Access Balance Reconciliation UI

To access the Balance Reconciliation, follow these steps:

1. From the Oracle Financial Services Accounting Foundation Cloud Page, select Subledger Applications.
The Subledger Application Window is displayed.

2. Select Balance Reconciliation.
The Type Window of Balance Reconciliation is displayed.

3. You can navigate to following UIs:

§ Type

§ Entity

§ Reconciliation Rule

§ Reconciliation Summary

§ Adjustments