recent commits & change log

Mar 5, 2025 - Merge for v26.0.0 Approved (#8...

Feb 10, 2025 - Update copyright on documentat...

Jan 17, 2024 - Merge for v23.0.0 Approved (#7...

DQC approved for US GAAP.
Initial release: v19.0.0.
See Rule element ID index below for details.
View public exposure version & comments.

Investment Schedule Cross Calc

Rule ID: DQC_0140
Status: Final
Release date: September 21, 2022
Effective date: December 1, 2022

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:

(DebtSecuritiesAvailableForSaleAmortizedCostCurrent +  
DebtSecuritiesAvailableForSaleAmortizedCostNoncurrent)
MINUS 
DebtSecuritiesAvailableForSaleAllowanceForCreditLoss or  
(DebtSecuritiesAvailableForSaleAllowanceForCreditLossCurrent +  
DebtSecuritiesAvailableForSaleAllowanceForCreditLossNoncurrent)
PLUS
AvailableForSaleDebtSecuritiesAccumulatedGrossUnrealizedGainBeforeTax
MINUS
AvailableForSaleDebtSecuritiesAccumulatedGrossUnrealizedLossBeforeTax
EQUALS
AvailableForSaleSecuritiesDebtSecurities or  
(AvailableForSaleSecuritiesDebtSecuritiesCurrent +  
AvailableForSaleSecuritiesDebtSecuritiesNoncurrent)

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)
MINUS 
DebtSecuritiesAvailableForSaleAmortizedCostAllowanceForCreditLossExcludingAccruedInterest or  
(DebtSecuritiesAvailableForSaleAmortizedCostAllowanceForCreditLossExcludingAccruedInterestCurrent +  
DebtSecuritiesAvailableForSaleAmortizedCostAllowanceForCreditLossExcludingAccruedInterestNoncurrent)
PLUS
AvailableForSaleDebtSecuritiesAccumulatedGrossUnrealizedGainBeforeTax
MINUS
AvailableForSaleDebtSecuritiesAccumulatedGrossUnrealizedLossBeforeTax
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.

General 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.

Rule Element ID Elements
DQC.US.0140.9861 AvailableForSaleSecuritiesDebtSecurities
DQC.US.0140.9862 DebtSecuritiesAvailableForSaleExcludingAccruedInterest

© Copyright 2016 - 2025, XBRL US, Inc. All rights reserved.
See License for license information.
See Patent Notice for patent infringement notice.


View public exposure version & comments.Terms and Conditions