When you use Expected Credit Losses (ECL), your reports can display ECL information for either the IFRS or U.S. GAAP accounting bases. The following reports in Eagle Accounting’s report package allow you to report on ECL values.
Trade Activity Report
The Trade Activity report’s Show All result set includes the following fields added for ECL. These fields are pulled from the TRADESDBO.TRADE_DETAIL table. The table field names appear in parenthesis.
IFRS Fields:
U.S. GAAP and IFRS Fields:
For general information about this report, see Trade Activity Report.
Portfolio Valuation Report
The Portfolio Valuation report’s Show All result set includes the following fields added for ECL. These fields are pulled from the HOLDINGDBO.POSITION_COST_DETAIL / POSITION_COST_LOT tables and the field names appear in parenthesis.
ECL Local/Base (ECL_LOCAL/ECL_BASE) (tags 16990/16991).
URGL FX on ECL (tag 17272). This value is pulled from the UNREALIZED_CURR_GL field on the POSITION_DETAIL and LOT_LEVEL_POSITION tables when the processing security type (PST) is Expected Credit Loss Group (ECLGRP). This value is also used for security/lot level ECL amounts.
ECL FX URGL (ECL_FX_URGL) (tag 18044). This value relates to the ECL allowance reported within OCI for IFRS FV-OCI investments.
URGL after ECL local/base (tags 18031/18032). The total URGL after ECL local/base equals the market value less the (amortized cost - ECL - non-credit loss).
Non-Credit local/base (tags 2704/2705). These tags represent additional losses recognized through OCI for U.S. GAAP investments classified with the Available-for Sale (AFS) regulatory category. Non-credit losses are recognized when an expected credit loss at the lot level is recorded and the market value of the security is less than the amortized cost minus the expected credit loss.
Amortized Cost after ECL Local/Base (tags 17273/17274). Amortized Cost after ECL fields are calculated by taking the Amortized Cost (tags 4601/4602) – ECL Amount (tags 16990/16991) values – Non-credit amount (tags 2704/2705) values.
The following tabs/report options are included for the both the Advanced and grid versions of the Portfolio Valuation Report:
For general information about this report, see Portfolio Valuation Report.
Holdings Report
The Holdings report’s Show All result set includes the following fields added for ECL. These fields are pulled from the HOLDINGDBO.POSITION_COST_DETAIL / POSITION_COST_LOT tables and the field names appear in parenthesis.
ECL Local/Base (ECL_LOCAL/ECL_BASE) (tags 16990/16991).
Non-Credit local/base (tags 2704/2705). These tags represent additional losses recognized through OCI for U.S. GAAP investments classified with the Available-for Sale (AFS) regulatory category. Non-credit losses are recognized when an expected credit loss at the lot level is recorded and the market value of the security is less than the amortized cost minus the expected credit loss.
Amortized Cost after ECL Local/Base (tags 17273/17274). The Amortized Cost after ECL fields are calculated by taking the Amortized Cost (tags 4601/4602) – ECL Amount (tags 16990/16991) values – Non-credit amount (tags 2704/2705) values.
The following tags are included in the Holdings report’s Show All result set but are not included in the Holdings reports with ECL listed below.
URGL FX on ECL (tag 17272). This value is pulled from the UNREALIZED_CURR_GL field on the POSITION_DETAIL and LOT_LEVEL_POSITION tables when the Processing Security Type is ECLGRP. This value also used for security/lot level ECL amounts.
ECL FX URGL (ECL_FX_URGL) (tag 18044). This value relates to the ECL allowance reported within OCI for IFRS FV-OCI investments.
URGL after ECL local/base (tags 18031/18032). The total URGL after ECL local/base is equal to the market value less the (amortized cost- ECL - non-credit loss).
The following tab/report options are included for the both the Advanced and grid versions of the Holdings Report:
Advanced report options:
Detail with ECL
Impairments with ECL
Grid report tabs:
Holdings Detail with ECL
Impairments with ECL
For general information about this report, see Holdings Report.
Ledger Subledger Reconciliation Report
The Ledger Subledger (LSL) report includes a number of accounts to support ECL processing, including:
5001000902 Impairment Expense for ECL
1010010419 Allowance for ECL
3005000406 Allowance for ECL - OCI
1010010421 CURRENCY GAIN ALLOWANCE ECL
1010010422 CURRENCY LOSS ALLOWANCE ECL
3003000309 ACCUMULATED UNREALIZED CURRENCY GAIN/LOSS ECL OCI
3005000406 ALLOWANCE FOR ECL OCI
3303000307 UNREALIZED CURRENCY GAIN ALLOWANCE ECL - OCI
3303000308 UNREALIZED CURRENCY LOSS ALLOWANCE ECL - OCI
4004000404 UNREALIZED CURRENCY GAIN ECL - INCOME
4004000405 UNREALIZED CURRENCY LOSS ECL - INCOME
For general information about this report, see Ledger Subledger Reconciliation Report,
Cost of Investments Rollforward Report
The Cost of Investment Rollforward report’s Show All result set includes the following tags added for ECL. The two ECL fields are pulled from the HOLDINGDBO.POSITION_COST_DETAIL / POSITION_COST_LOT tables while the remaining ones are calculated within the report procedure.
Expected Credit Loss Local/Base (ECL_LOCAL/ECL_BASE) (tags 16990/16991).
Begin Amort Cost After ECL Local/Base (tags 17275/17276). Calculated by taking the amort cost at the beginning of the report period (tags 8852/5839) – the ECL amount on the report start date.
End Amort Cost After ECL Local/Base (tags 17277/17278). Calculated by taking the amort cost at the end of the report period (tags 4601/4602) – the ECL amount on the report start date.
ECL Variance Local/Base (tags 17279/17280). This calculated field sums all the cost components including the ECL fields listed above to come up with a variance.
The following tab/report options are included for the both the Advanced and grid versions of this report. Use these reports only for the IFRS basis, as amortized cost for IFRS purposes represents amortized cost (as stored in Eagle Accounting) less expected credit loss allowances associated with the investment/lot.
Advanced report options:
Summary Local with ECL
Summary Base with ECL
Grid report tabs:
The Cost of Investment Rollforward reports include any ECL amount associated with a disposition in the adjustment column on the standard core Advanced and grid reports. For IFRS this is required because the ECL allowance associated with a disposition is used to determine disposal book value.
For general information about this report, see Cost of Investments Rollforward Report.
IFRS Disclosure Report / Statement of Other Comprehensive Income Report
The IFRS view of the Statement of Other Comprehensive Income (OCI) includes additional ledger accounts within OCI required to support the accounting for ECL for FV-OCI portfolios.
The Statement of Other Comprehensive Income report includes the following five accounts added for ECL:
3003000151 - ACCUMULATED ALLOWANCE FOR ECL - OCI
3003000309 - ACCUMULATED UNREALIZED CURRENCY GAIN/LOSS ECL - OCI
3303000307 - UNREALIZED CURRENCY GAIN ALLOWANCE ECL - OCI
3303000308 - UNREALIZED CURRENCY LOSS ALLOWANCE ECL- OCI
3005000406 - ALLOWANCE FOR ECL – OCI
3003000151 and 3003000309 are returned as part of the beginning balance of the report. The remaining accounts are listed as activity.
For general information about this report, see IFRS Disclosure Reports.
Add Comment