I built a free web tool and API to Search and Analyse UK Company Accounts IXBRL Data and Company Officers

1

Hi all

A while ago, using the Companies House bulk accounts data, I built https://convert-ixbrl.co.uk, making the IXBRL data available as JSON and also through a search portal freely. I released a significant update to it today (new features listed below) and thought I’d reshare this.

It was a rather challenging project to work on and for those who are technically minded, I have also written a convert-ixbrl on Medium -blog about it which some of you will hopefully find interesting.

Using the website or the API you can

  • Find UK companies based on an additional 50+ financial filters (turnover, netassets, liabilities, audit fee and many more)
  • Create company lists for sales lead generation or general tracking
  • Search officers based on name, ID, postcode, nationality and more
  • Search companies based on location and distance
  • Search companies using director age ranges
  • Search using Reg date, CS01 dates and accounts due dates
  • Setup email alerts for when a company’s financials change (coming soon)
  • Download Bulk data if you wish to perhaps upload it to SalesForce or Snowflake or some other similar system. Bulk data will be available in the live release.

Screenshot showing an example search result of software companies with >100K Turnover and >500K Netassets

screenshot
screenshot1880×667 85.2 KB

On both the portal and on the API, I’ve presented the data in the standard financial statements format so you get balance sheet, P&L (where available), Cashflow(where available) and Notes data…
Screenshot showing a downloadable Balance sheet

BL page
BL page1373×760 48.1 KB

It’s currently free (and I’d like to keep it free if I can, hopefully by offering optional add on paid services such as credit reports to the web portal users) but I’m subsidising the cost of running the infrastructure myself currently

You can try it out on convert-ixbrl.co.uk above. No registration needed. If you have any questions, send me a DM here or see my contact details on the website. I’d like to monetise it at some point but it has been a labour of love first and foremost.

Here is the API docs page API documentation but all the functionality that the API provides is also available through the web interface.

2

Hi
I’d love to have and be willing to pay say £10 pcm for anyone who can send me an email at 7am flagging if any of the 50 or so people I have given them a list of URLs for have been linked to a new company. Ie. I give you list of John Smith, Robert Jones and any time any of them are updated to be directors of another company I get an email

Anyone can help?
Best
Paul

1 Like
3

Hi Effahid

This is really cool. Way better than the Companies House search facility. I have tried it a few times and get a few timeouts - but when it produces the results it’s really slick and easy to comprehend.

1 Like
5

Hi Paul

Quite interesting. So at the moment you can provide a combination of first name, last name, partial date of birth and officer Id to the FindOfficers endpoint
Companies House IXBRL Accounts to Excel and JSON for company financials analysis (link to the page for documentation)

and it will return all the available matches. While technically, you could write a little script that calls the endpoint on a schedule and emails you if the returned results have changed from what was received before, it isn’t currently automated.

This is because it hadn’t occurred to me that there may be a use case for people wishing to track officers in the manner you described.

Now that I know that it could be useful, I’ll have a look into either adding it to the portal or adding an api endpoint(likely faster) where you can simply provide these parameters and setup an email alert and respond here for you and others to try out.

Also, data is currently updated weekly not daily although daily updates will be part of the live release (likely July 25)

Thanks

6

Thanks for trying it out. The demand was a bit higher than what I had expected but the cloud infrastructure was upgraded earlier today . Further optimisations are planned before the service is out of Beta(ideally around July). Please try again if you can.