CODEWITHSUNDEEP
c#xsdxbrl
LePrinceDeDhump
LePrinceDeDhump

Reputation: 486

How do I determine which report section a value or label belongs to in an IXBRL/XBRL File?

I'm trying to build a model for filed company accounts using html/ixbrl files publicly available from UK CompaniesHouse website. The problem I have is that the label values in each taxonomy reports( Income statement, director report, audit report etc) are not unique across the taxonomy. Many values appear in multiple reports and given an ix Node in the screenshot further below this, I'm not sure how to determine which one it is.

For example Bank borrowings and overdrafts appears four times across different report in the taxonomy. ( Taxonomy on my github along with a sample ixbrl file here https://github.com/MangoCrusher/xbrldemo1 )

Referring to the screenshot below, how do I determine which report of the taxonomy the highlighted Current Assets node belongs to?

enter image description here

This is what my taxonomy dictionary looks like so far looks like which I have been able to populate with values extracted from various xsds and xmls found in the taxonomy bundle ( item 0 to 14 are various sections that may be found in a typical report). The idea is to match the ixnodes to the dictionary keys and recreate the financial statement in full, if I could figure out how to take an ixnode and tell which report the item belongs to. Using the uk-core attribute I cannot get to the specific xsd file in the taxonomy but not to the actual report .

model image

Thank you

Upvotes: 0

Views: 147

Answers (1)

LePrinceDeDhump
LePrinceDeDhump

Reputation: 486

It has been a while since I posted this question. I solved this by using a combination of looking at the associated dimension data and lots and lots of analysis of other IXBRL files.

I wanted to do this because I was building a Companies House IXBRL to JSON API which I've managed to release now https://convert-ixbrl.co.uk .

Thanks

Upvotes: 0

Related Questions