This article contains a detailed guide on how to identify and solve the issue.
The most common reason for this issue is that you have a subtotal in your Comprehensive Income Statement (CI) which isn’t found in your Statement of Changes in Equity (SOCIE), and this causes your calculation to fail.
Your calculations can be perfectly correct, but when it comes to XBRL everything is interconnected, so when you have a subtotal leading up to your comprehensive income in CI, you need that same subtotal to be represented in your SOCIE. Otherwise, this calculation error will occur in conversion.
A Quick Example of the Issue You Are Experiencing
For instance, you may have stated in your “Comprehensive Income Statement” that you calculate your “comprehensive income” as a sum of “net profit” and “other comprehensive income”.
Net profit + other comprehensive income = comprehensive income
At the same time, in your Statement of Changes in Equity (SOCIE) you may have stated, that you calculate your “comprehensive income” as a sum of “net profit”, “exchange differences” and “cashflow hedges”.
Net profit + exchange differences + cashflow hedges = comprehensive income
Both can be perfectly correct, and iXBRL is equipped to comprehend that “comprehensive income” can be calculated in different ways in different sections.
The reason you are experiencing a calculation error, is that while you have stated in one section that “comprehensive income” is a total of “net profit” and “other comprehensive income”, in the other section, you haven’t listed “other comprehensive income” as a subtotal.
This means, that your calculation is missing a subtotal, and because of this, it creates a blue warning.
Two Possible Solutions
When you experience this type of error, you have two options:
- You can disregard the calculation inconsistency. The calculation warning is not a blocking error, so you are allowed to have it in your report when you file it
- You can add “Other Comprehensive Income” as a subtotal in your Statement of Changes in Equity, thereby solving the issue.
How to Solve the Calculation Warning
To solve this issue, you first need to figure out exactly which items are causing the warning. To do this, you need to upload the zip-file containing your ESEF report to the ParsePort XBRL Inspector and follow these instructions:
First, locate the items causing the warning:
There are two ways to do this:
- In the validation page of the Inspector, scroll down to the Linkbase Check. Here you need to click the eye-icon next to the calculation error. This will take you to the relevant label in Presentation section of the viewer
- Another way is to copy the label name from the warning-message:
- Go to the Viewer tab, and in the Presentation Linkbase window to the right, you can search for the label (remember to set the language to English(“en”)):
- The highlighted sections show where this label can be found, and from there, you can press the labels to navigate between the accounts.
Note: you can also use this method to find the label in the Facts or Calculation tabs.
Investigate the issue and calculations:
- You can click the number which is causing the issue. The selected number is always highlighted in blue. If you hover over the selected number, it will show the error message, which you can use to double check that you are looking at the correct number:
- In the sidebar, it will show you both calculations that are mismatching and creating the warning:
- Under the “Calculations” subsection in the sidebar, you can see the calculations for the element. In this case both the calculation for both the Comprehensive Income and Statement of Changes in Equity will appear, as the two are connected to the same element.
Here, it is easy to compare the subtotals and see what is creating the warning.
Tip: the page numbers in the bottom of the window (e.g. “<1 of 2>”) allows you to easily navigate between elements that has the same label. - Now that you have successfully identified where the issue occurs and what caused it, it is up to you to decide between the following solutions:
Adjust your calculations in the Excel Template to make them identical and heighten transparency and comparability.
Or,
Accept the calculations as they are and ignore the warning.
If you experience any issues during this procedure, feel free to write our support team at support@parseport.com and they will help you sort the issue out.