Investment Schedule Cross Calc

Rule function

This rule is intended to identify those cases where the company has misused elements in the investment schedule showing the difference in amortized cost and fair value. The rule checks that the investment schedule that shows the difference between amortized cost and fair value is calculated correctly. This rule has two components.

The rule takes the components and calculates each line as a separate iteration, for each dimension member. The rule operates once for amounts including accrued interest and once for amounts excluding accrued interest. Both rules should not fire for the same filing as filers are required to report either the values including accrued interest or excluding accrued interest. The fair value and amortized cost concepts must be present for the rule to fire.

Component 1

Identifies the investment schedule rows are calculated correctly where the company includes accrued interest in the reported value for investments.

This component checks that amortized cost less any credit losses and accumulated gains and losses is equal to the fair value of the investment. The rule will operate on any dimensions used. The calculation is defined as follows:

AvailableForSaleDebtSecuritiesAmortizedCostBasis or
(DebtSecuritiesAvailableForSaleAmortizedCostCurrent +
DebtSecuritiesAvailableForSaleAmortizedCostNoncurrent)

If the amortized cost value before credit loss is not reported then the following elements are used:
DebtSecuritiesAvailableForSaleAmortizedCostAfterAllowanceForCreditLoss or
(DebtSecuritiesAvailableForSaleAmortizedCostAfterAllowanceForCreditLossCurrent +
DebtSecuritiesAvailableForSaleAmortizedCostAfterAllowanceForCreditLossNoncurrent)

Component 2

Identifies the investment schedule rows are calculated correctly where the company excludes accrued interest in the reported value for investments.
This component checks that amortized cost less any credit losses and accumulated gains and losses is equal to the fair value of the investment. The rule will operate on any dimensions used.
The calculation is defined as follows:

DebtSecuritiesAvailableForSaleAmortizedCostExcludingAccruedInterestBeforeAllowanceForCreditLoss or
(DebtSecuritiesAvailableForSaleAmortizedCostExcludingAccruedInterestBeforeAllowanceForCreditLossCurrent +
DebtSecuritiesAvailableForSaleAmortizedCostExcludingAccruedInterestBeforeAllowanceForCreditLossNoncurrent)

EQUALS
DebtSecuritiesAvailableForSaleExcludingAccruedInterest or
(DebtSecuritiesAvailableForSaleExcludingAccruedInterestCurrent +
DebtSecuritiesAvailableForSaleExcludingAccruedInterestNoncurrent)

If the amortized cost value before credit loss is not reported then the following elements are used:
DebtSecuritiesAvailableForSaleAmortizedCostAllowanceForCreditLossExcludingAccruedInterest or
(DebtSecuritiesAvailableForSaleAmortizedCostAllowanceForCreditLossExcludingAccruedInterestCurrent +
DebtSecuritiesAvailableForSaleAmortizedCostAllowanceForCreditLossExcludingAccruedInterestNoncurrent)

Problem solved by the rule

The rule ensures that the correct elements are used in the investment schedule. Specifically it ensures that consistent elements are used for including and excluding accrued interest elements in the investment disclosure. If the company has a credit loss a consistent XBRL calculation cannot always be defined. This rule helps to ensure that this calculation can be checked reliably if no calculation linkbase is defined.

Example rule message

Component 1

The reported fair value of Available For Sale Debt Securities Securities of 10,000,000 does not match the calculated value of 11,000,000. This is comprised of the following:

Amortized Cost of 10,000,000
Gain on Securities 3,000,000
Loss on Securities of 0
Credit Loss on Securities of 2,000,000

Period: 2021-12-31
Dimensions: FinancialInstrumentAxis=MortgageBackedSecurities
Unit: USD

Rule Element ID: 9861
Rule version: 19.0.0

Component 2

The reported fair value of Available For Sale Debt Securities Securities excluding interest of 10,000,000 does not match the calculated value of 11,000,000. This is comprised of the following:

Amortized Cost of 10,000,000
Gain on Securities 3,000,000
Loss on Securities of 0
Credit Loss on Securities of 2,000,000

Period: 2021-12-31
Dimensions: FinancialInstrumentAxis=MortgageBackedSecurities
Unit: USD

Rule Element ID: 9862
Rule version: 19.0.0

For Developers

The Global Rule Logic document contains general guidelines for implementation of rules.

The rule message template contains text and parametric reference to arguments of the rule operation, using the syntax ${parameter} to indicate that insertion of a parameter’s value is to occur.

Message template

Component 1

The reported fair value of Available For Sale Debt Securities Securities of {$fairValue} does not match the calculated value of {$fairValueCalc}. This is comprised of the following:
Amortized Cost of {$AmortCost}
Gain on Securities {$gain}
Loss on Securities of {$loss}
Credit Loss on Securities of {$creditLoss}

Period: {$fairValue.period}
Dimensions: {$fairValue.dimensions.join(', ','=')}
Unit: {$fairValue.unit}\n

Rule Element ID: {$ruleId}
Rule version: {$ruleVersion}

Component 2

The reported fair value of Available For Sale Debt Securities Securities excluding interest of {$fairValue} does not match the calculated value of {$fairValueCalc}. This is comprised of the following:
Amortized Cost of {$AmortCost}
Gain on Securities {$gain}
Loss on Securities of {$loss}
Credit Loss on Securities of {$creditLoss}

Period: {$fairValue.period}
Dimensions: {$fairValue.dimensions.join(', ','=')}
Unit: {$fairValue.unit}\n

Rule Element ID: {$ruleId}
Rule version: {$ruleVersion}

Rule element ID index

The rule element id is used to identify unique elements or combinations of elements tested in the rule.