Toggle navigation
Getting Started
Customer Success Services
Knowledge Base
Product Updates
Login
Search
Home
Knowledge Base
How to clear XBRL diagnostic warning "At least 1 value does not sum up to it's total"
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"
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.
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
.
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.
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:
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:
Rate this article:
|vote=None|
Processing...
(Popularity = 0/100, Rating = 3.0/5)
Related Articles
XBRL Lite | How to create a new file when using XBRL Lite
Release notes for IFRS XBRL Lite 2022.05.01 and SME XBRL Lite 2022.04.01
#GetAhead | Webinar Recordings - Week 1
XBRL Lite Latest Release Version number (IFRS) 2023.05.01 & (SME) 2023.04.01
view all...
Didn't find what you were looking for?
Watch a video
Check out our helpful video guides
Contact Support
Contact our support team
Caseware and the Caseware logo, are registered trademarks of Caseware International Inc. and are licenced for use to Caseware Africa and Adapt IT. © 2023. All rights reserved.
For more information, visit
www.casewareafrica.com
If you would like to keep up to date with the latest Caseware Africa news:
Help
FAQs
How to Guides
User Manuals
Video Guides
Error Codes
Webinar Recordings
Release Notes
Getting Started
Quick Links
Customer Success Services
Knowledge Base
Product Updates
About the Community
Contact Support
Terms of Service, EULAs and other relevant policies
Copyright © 2024 | All Rights Reserved