# Missing Line Items in iXBRL data

**URL:** <http://forum.companieshouse.gov.uk/t/missing-line-items-in-ixbrl-data/5985>\
**Category:** Bulk Data Requests\
**Created:** [March 3, 2023, 3:03pm UTC](http://forum.companieshouse.gov.uk/t/missing-line-items-in-ixbrl-data/5985 "2023-03-03T15:03:09Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jason.gaituah](http://forum.companieshouse.gov.uk/user_avatar/forum.companieshouse.gov.uk/jason.gaituah/32/1436_2.png) [@jason.gaituah](http://forum.companieshouse.gov.uk/u/jason.gaituah)\
**Post date:** [March 3, 2023, 3:03pm UTC](http://forum.companieshouse.gov.uk/t/missing-line-items-in-ixbrl-data/5985/1 "2023-03-03T15:03:10Z")

</div>

Hi,

I noticed when parsing the data of a few companies that certain line items were missing from the iXBRL data versus the accounts when viewed as html.

For example, when looking at filing Prod223\_3379\_00138114\_20220531.html (found in [http://download.companieshouse.gov.uk/Accounts\_Bulk\_Data-2023-02-24.zip](http://download.companieshouse.gov.uk/Accounts_Bulk_Data-2023-02-24.zip)), balances for ‘Current Assets’ or ‘Prepayments and accrued income’ appear:

 ![image](http://discourselive.s3.dualstack.eu-west-1.amazonaws.com/original/2X/9/9acbd6295c7512278cab68ffd937f48888262af9.png)

However, when looking at the iXBRL data, only the following line items are present:

Creditors  
NetCurrentAssetsLiabilities  
TotalAssetsLessCurrentLiabilities  
NetAssetsLiabilities  
AverageNumberEmployeesDuringPeriod

Please could someone advise why this is the case?

Thanks,  
Jason

---

<div class="post-metadata">

**Author:** ![effahid](http://forum.companieshouse.gov.uk/user_avatar/forum.companieshouse.gov.uk/effahid/32/2045_2.png) [@effahid](http://forum.companieshouse.gov.uk/u/effahid)\
**Post date:** [November 11, 2024, 10:02pm UTC](http://forum.companieshouse.gov.uk/t/missing-line-items-in-ixbrl-data/5985/2 "2024-11-11T22:02:13Z")

</div>

My theory is that it is either human error or the software used to prepare the IXBRL files. There are plenty of white label IXBRL solutions available, each with varying levels of quality.

I had the pleasure of reading through a boat load of IXBRL files when I was building [https://convert-ixbrl.co.uk](https://convert-ixbrl.co.uk), which is an API to convert Companies House IXBRL to Excel and JSON and to find UK companies based on IXBRL data.

The file you have referred to does look a bit unusual in terms of its xhtml content, making me think it is the latter, i.e. it was created and was ‘valid enough’ to pass the validation tool check but missing certain pieces of data. I also had a look through the Feb 24 which looks fine.

---

<div class="post-metadata">

**Author:** ![kkhaninbox](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/k/4af34b/32.png) [@kkhaninbox](http://forum.companieshouse.gov.uk/u/kkhaninbox)\
**Post date:** [December 9, 2024, 5:03pm UTC](http://forum.companieshouse.gov.uk/t/missing-line-items-in-ixbrl-data/5985/4 "2024-12-09T17:03:10Z")

</div>

Did you find some open source library to parse the ixbrl data?

---

<div class="post-metadata">

**Author:** ![effahid](http://forum.companieshouse.gov.uk/user_avatar/forum.companieshouse.gov.uk/effahid/32/2045_2.png) [@effahid](http://forum.companieshouse.gov.uk/u/effahid)\
**Post date:** [December 10, 2024, 10:03pm UTC](http://forum.companieshouse.gov.uk/t/missing-line-items-in-ixbrl-data/5985/5 "2024-12-10T22:03:40Z")

</div>

I did look into the available libraries but then ended up having to build my own (reasons in my medium post [How I built an IXBRL Converter for Companies House | by Hasham @ Convert-IXBRL.co.uk | FastUKCompanySearch | Nov, 2024 | Medium](https://medium.com/@fastukcompanysearch/how-i-built-an-ixbrl-converter-for-companies-house-e79be613d9dc))

---

<div class="post-metadata">

**Author:** ![kkhaninbox](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/k/4af34b/32.png) [@kkhaninbox](http://forum.companieshouse.gov.uk/u/kkhaninbox)\
**Post date:** [December 11, 2024, 12:01pm UTC](http://forum.companieshouse.gov.uk/t/missing-line-items-in-ixbrl-data/5985/6 "2024-12-11T12:01:15Z")

</div>

Ye i would hate having to write my own parser, would be a lot of work to maintain.

Luckily i did come across an open source library which is active. Will have to wait and see if i come across any issues