How to clear XBRL diagnostic warning "At least 1 value does not sum up to it's total"

Published: 16/05/2023

How to clear XBRL diagnostic warning "At least 1 value does not sum up to it's total"

User-added image

Instructions:

It is important to distinguish between errors that prevent export and warnings that do not. This is a warning that will not prevent export. As explained in the Extended information, this may cause your XBRL document to be out of balance.

The following will provide guidance the warning and an example to work through:

Click on Correct | the XBRL instance Preview will launch.

In the example below the preview goes to the statement of financial position but no values are displayed at first. Only upon selecting the correct context do figures display:

Tip: Should the context default to prior period, correct the context in the case of the balance sheet to end date of prior period. Should it default to active period, in the case of the balance sheet correct it to end date of active period. It is important to know that the context will always default to either active or prior period and because of the specific nature of the statement of financial position in that it discloses balances at the end date of the period, the context must be changed to reflect this.

User-added image

Once the balances are displayed, your interest should be in the line items for which the given value is different from the calculated value. In the example below, it is equity attributable to owners of the parent.

User-added image

When we review tags, we do not see this line item on the face of the statement of financial position. Only when we are editing enabled do we see that the line item is not set to print and consequently the tag will not export.

User-added image

There are two factors to consider:

Firstly, by default Caseware will not print this line in the case of single entity (or separate) financial statements because it does not apply. There is no parent nor subsidiary, therefore Non-controlling interesting is nil and all equity is attributable to the same equity holders. Caseware there deems it redundant to state this line. The “given value” therefore as referred to in the iXBRL Instance Preview is nil for this reason and will not export to the iXBRL file.
Secondly, the tag is not required by CIPC in separate financial statements for the above reason. But because the validations are the same for all files, it will run and come up as a warning. This is for you to consider and continue to export as it would not apply here.

Should you prefer the line item to export to balance the iXBRL file (This is however not required), you can switch on the line in design mode. This way the “given value” will then equal the “calculated value” as is shown below:

User-added image

This will apply to all similar line items in the financial statements. Tthe example provided is for the balance sheet and you may check all statements by selecting this from the Calculation roles dropdown with the appropriate Context for that statement.

Please Note this warning also occurs when there are debit and credit amounts as is the case on the income statement. The given value accounts for signage and subtracts the debits (expenses) from the credits (income) to give profit. The calculated value adds the debits and (expenses) and credits (income) disregarding signage. This is shown in the picture below:

User-added image