5.13.3 Accounting Entries for facility/collateral
This topis describes about the detailed information on accounting entries for facility/collateral details.
Note:
Prerequisites:
The following setup is necessary for contingent accounting entries
handoff.
- GEDHSTMN
- Host code as branch's host code - FCUBS
- Accounting and GL system code as Enterprise Limits and Collateral Management
- GEDEXMNT
- External system code - FCUBS
- External system class - FCUBS
- Module - ACCHOFF - WSDL for FCUBSIF Service
- Core gateway maintenance for FCUBSIF Service with OB
Enterprise Limits and Collateral Management
- GWDETSYS - Enterprise Limits and Collateral Management
- GWDETFUN - FCUBSIFService - Enterprise Limits and Collateral Management
- CODSORCE - Enterprise Limits and Collateral Management
- CODUPLDM - Enterprise Limits and Collateral Management,IF
This section contains details of the suggested accounting entries that
can be set up, for Enterprise Limits and Collateral Management Facility. The details
of the suggested accounting entries are given event-wise.
Table 5-23 Event Code and Description
| Event Code | Description |
|---|---|
| INIT | Facility Initiation |
| AMND | Facility Amendment |
| UTIL | Facility Utilization |
| DUTL | Release of Utilization to Facility |
| FACR | Fee Accrual |
| FLIQ | Fee Liquidation |
| PRLQ | Pay Receive Liquidation |
INIT: Facility Initiation
Accounting Entries
Table 5-24 Accounting Entries
| Accounting Role | Amount Tags | Dr/Cr. Indicator |
|---|---|---|
| CONASSETGL | EFF_LINE_AMT | Dr |
| CONASSETOFF | EFF_LINE_AMT | Cr |
AMND: Facility Amendment
Table 5-25 Facility Amendment
| Accounting Role | Amount Tags | Dr/Cr. Indicator |
|---|---|---|
| CONASSETOFF | EFF_LINE_AMT_DECR | Dr |
| CONASSETGL | EFF_LINE_AMT_DECR | Cr |
| CONASSETGL | EFF_LINE_AMT_INCR | Dr |
| CONASSETOFF | EFF_LINE_AMT_INCR | Cr |
UTIL: Facility Utilization
Accounting Entries
Table 5-26 Facility Utilization
| Accounting Role | Amount Tags | Dr/Cr. Indicator |
|---|---|---|
| CONASSETGL | UTIL_INCR | Cr |
| CONASSETOFF | UTIL_INCR | Dr |
DUTIL: Release of Utilization to Facility
Accounting Entries
Table 5-27 Release of Utilization to Facility
| Accounting Role | Amount Tags | Dr/Cr. Indicator |
|---|---|---|
| CONASSETGL | UTIL_DECR | Dr |
| CONASSETOFF | UTIL_DECR | Cr |
FACR: Fee Accrual
Arrears Fee- Accounting Entries
Table 5-28 Fee Accrual
| Accounting Role | Amount Tags | Dr/Cr. Indicator |
|---|---|---|
| RULEINC | RULE_ACCR | Cr |
| RULEREC | RULE_ACCR | Dr |
FLIQ: Fee Liquidation
Arrears Fee- Accounting Entries
Table 5-29 Fee Liquidation
| Accounting Role | Amount Tags | Dr/Cr. Indicator |
|---|---|---|
| RULEREC | RULE_LIQD | Cr |
| CUSTOMER | RULE_LIQD | Dr |
FACR: Fee Accrual
Advance Fee- Accounting Entries
Table 5-30 Fee Accrual
| Accounting Role | Amount Tags | Dr/Cr. Indicator |
|---|---|---|
| RULEINC | RULE_ACCR | Cr |
| RULERIA | RULE_ACCR | Dr |
FLIQ: Fee Liquidation
Advance Fee- Accounting Entries
Table 5-31 Fee Liquidation
| Accounting Role | Amount Tags | Dr/Cr. Indicator |
|---|---|---|
| RULERIA | RULE_LIQD | Cr |
| CUSTOMER | RULE_LIQD | Dr |
PRLQ: Pay Receive Liquidation
Table 5-32 Pay Receive Liquidation
| Accounting Role | Amount Tags | Dr/Cr. Indicator |
|---|---|---|
| EFFLINE_AMTINC | EFFLINE_AMT_PAY | Dr |
| CUSTOMER | EFFLINE_AMT_PAY | Cr |
| EFFLINE_AMTINC | EFFLINE_AMT_REC | Cr |
| CUSTOMER | EFFLINE_AMT_REC | Dr |
OB Enterprise Limits and Collateral Management Integration with Corporate DDA
Note:
Prerequisites
- Maintain the external source system (Corporate DDA) in common core – STDECAMT
- Update the Accounting System as ‘CORPORATE DDA’ and GL systems as ‘FCUBS’ / any other GL system name (code) in Host Param Maintenance – GEDHSTMN
- Update the GL system code in GEDPARAM as FCUBS / any other GL system name (code)
- Configure External System Maintenance for Corporate DDA in
GEDEXMNT
- Specify External System Code as CORPORATE DDA
- Maintain the Module (ACCHOF), WSDL Link and Service Type of Corporate DDA system
- Select the required Accounting entry as Single or Double – if Double selected then specify the Inter System Bridge GL
- Update the Source Branch Code (same branch in OB Enterprise Limits and Collateral Management and Corporate DDA) and Source System (CORPORATE DDA) in Branch Core parameters maintenance STDCRBRN.
- Maintain Source System as CORPORATE DDA in Customer Maintenance – STDCIFCR
- Maintain account details in Customer Account Maintenance –
STDCRACC
- Same account number must be created in Corporate DDA system
- External Credit Approval System must be opted as the CORPORATE DDA
In case of Corporate DDA without separate bridge GL for source systems -
Single accounting entry:
- For all transactions (fees) in OB Enterprise Limits and Collateral Management, only one leg of accounting entry (customer account related) will be handed over to the Corporate DDA system
- The other leg of transaction (fee GL) will be sent to GL system
Table 5-33 ACCOUNTING ENTRY - SINGLE (WITHOUT BRIDGE GL) for ADVANCE/ARREARS FEE - FLIQ AND FACR
| ACCOUNTING ENTRY - SINGLE (WITHOUT BRIDGE GL) for ADVANCE/ARREARS FEE - FLIQ AND FACR | ||||
|---|---|---|---|---|
| FEE TYPE | FLIQ | FACR | ||
| DR | CR | DR | CR | |
| ADVANCE FEE | CUSTOMER | RECEIVED IN ADVANCE | RECEIVED IN ADVANCE | INCOME GL |
| HANDOFF TO | CORP DDA | GL SYSTEM | GL SYSTEM | GL SYSTEM |
| ARREARS FEE | CUSTOMER | RECEIVABLE GL | RECEIVABLE GL | INCOME GL |
| HANDOFF TO | CORP DDA | GL SYSTEM | GL SYSTEM | GL SYSTEM |
In case of Corporate DDA with separate bridge GL for each source system
- Double accounting entries:
- For all transactions in OB Enterprise Limits and Collateral Management (fees), first pair of entry (customer account + Bridge GL) will be handed over to the Corporate DDA system
- The second pair of entries (Bridge GL + fee GL) will be handed over to the GL system
Table 5-34 ACCOUNTING ENTRY - DOUBLE (WITH BRIDGE GL) for ADVANCE/ARREARS FEE - FLIQ AND FACR
| ACCOUNTING ENTRY - DOUBLE (WITH BRIDGE GL) for ADVANCE/ARREARS FEE - FLIQ AND FACR | ||||||
|---|---|---|---|---|---|---|
| FEE TYPE | FLIQ - PAIR 1 | FLIQ - PAIR 2 | FACR | |||
| DR | CR | DR | CR | DR | CR | |
| ADVANCE FEE | CUSTOMER | BRIDGE GL | BRIDGE GL | RECEIVED IN ADVANCE | RECEIVED IN ADVANCE | INCOME GL |
| HANDOFF TO | CORP DDA | CORP DDA | GL SYSTEM | GL SYSTEM | GL SYSTEM | GL SYSTEM |
| ARREARS FEE | CUSTOMER | BRIDGE GL | BRIDGE GL | RECEIVABLE GL | RECEIVABLE GL | INCOME GL |
| HANDOFF TO | CORP DDA | CORP DDA | GL SYSTEM | GL SYSTEM | GL SYSTEM | GL SYSTEM |
Note:
All transaction in OB Enterprise Limits and Collateral Management
can be viewed in daily_log_ac tables - GETB_DAILY_LOG_AC (facility) and
GCTB_COLLAT_DAILY_LOG_AC (collateral).
- The above table has a column CUST_GL with values as A (Accounting System) and G (GL system).
- Handoff to respective systems (DDA and GL) happens based on selected accounting entry (Single/Double) and value in above column.
Parent topic: Value Dated Fee Processing