Performing Instrument-Level Reconciliation

The Instrument-Level Reconciliation application engine (FI_RECON) enables you to reconcile ledger balances with the equivalent tables at the instrument level by using specific reconciliation rules. Instrument-level reconciliation makes it possible for you to quickly analyze data, generate ad hoc reports, and update ledger information as frequently as business needs dictate. Instrument-level reconciliation facilitates comparison between any one of the summary-level balance tables that are listed on the left side of the following table with any one of the instrument-level balance tables listed on the right side:

Summary-Level Table	Instrument-Level Table
PF_LED_ADB_F00 The ADB Ledger table stores average daily balances at the summary ledger-account level.	FI_IINC_R00 Stores income statement transactions and balances at the instrument detail level. Choose balances from this table for reconciliation by selecting `Income Statement` from the available options that are in theReconciliation Type field (Reconciliation Rules page).
PF_LGR_RCN_F00 Stores any summary ledger balances that you may want to reconcile against the instrument balance tables.	FI_IBAL_R00 Stores balance sheet statement transactions and balances at the instrument detail level. The application engine obtains the dimensions from the parent, FI_INSTR_F00. All transactions matching a specific instrument ID receive the same dimensions. Choose balances from this table for reconciliation by selecting `Balance Sheet` from the available options in theReconciliation Type field (Reconciliation Rules page).
PF_LEDGER_F00 Stores current, end-of-period balances at the summary ledger-account level.	FI_IBALANCE_R00 Stores balance sheet statement transactions and balances at the instrument detail level. Each transaction balance has its own dimension and account information. Choose balances from this table for reconciliation by selecting `Balance Sheet with Dimensions` from the available options in the Reconciliation Type field (Reconciliation Rules page).
	FI_ILDGR_F00 Stores multidimensional instrument balances (instrument balances by dimension), using the precise dimension proportions that are in the source data. Choose balances from this table for reconciliation by selecting `Reconciled Ledger` from the available options in theReconciliation Type field (Reconciliation Rules page).

Summary-Level Table

Instrument-Level Table

PF_LED_ADB_F00

The ADB Ledger table stores average daily balances at the summary ledger-account level.

FI_IINC_R00

Stores income statement transactions and balances at the instrument detail level.

Choose balances from this table for reconciliation by selecting Income Statement from the available options that are in theReconciliation Type field (Reconciliation Rules page).

PF_LGR_RCN_F00

Stores any summary ledger balances that you may want to reconcile against the instrument balance tables.

FI_IBAL_R00

Stores balance sheet statement transactions and balances at the instrument detail level. The application engine obtains the dimensions from the parent, FI_INSTR_F00. All transactions matching a specific instrument ID receive the same dimensions.

Choose balances from this table for reconciliation by selecting Balance Sheet from the available options in theReconciliation Type field (Reconciliation Rules page).

PF_LEDGER_F00

Stores current, end-of-period balances at the summary ledger-account level.

FI_IBALANCE_R00

Stores balance sheet statement transactions and balances at the instrument detail level. Each transaction balance has its own dimension and account information.

Choose balances from this table for reconciliation by selecting Balance Sheet with Dimensions from the available options in the Reconciliation Type field (Reconciliation Rules page).

FI_ILDGR_F00

Stores multidimensional instrument balances (instrument balances by dimension), using the precise dimension proportions that are in the source data.

Choose balances from this table for reconciliation by selecting Reconciled Ledger from the available options in theReconciliation Type field (Reconciliation Rules page).

Using the Reconciliation Rules page, instrument-level reconciliation summarizes balances first by account, then by the selected table dimensions that are on the Model Definition - Engine Settings page, and puts the results to a specified table for further analysis or processing.

The Instrument-Level Reconciliation process can be run as needed to reconcile instrument-level balances to their respective ledger balances based on specific reconciliation rules that you define.