Companies House IXBRL Accounts to Excel and JSON for company financials analysis

Version and Endpoint

Version 2 (current) Version 1

Development Note

You can use the test API key during development to build your integration at no cost.

Request

https://convert-ixbrl.co.uk/api/financials?companynumber=012345678&apiversion=1

This endpoint requires authentication headers. See Authentication documentation.

Authentication

This endpoint requires the authentication header to be supplied. See the authentication section.

Request Parameters

companyNumber	Type	Optional	Description
apiVersion	string	No	API Version
companyNumber	string	No	Companies House registration number

HTTP Response codes

Status Code	Description
`200`	Successful requests with results
`204`	Successful requests with no results
`400`	Authorisation error for when the secret key header is missing or is invalid
`429`	Request throttled for exceeding rate limits

Response JSON (Sample, extracted from a real result)

{
    "status": "Ok",
    "lastDataUpdatedDate": "30/12/2025",
    "result": {
        "company_financial_list": [
            {
                "end_date": "30/12/2025",
                "profit_loss": {
                    "turnover": "89566019.0",
                    "consolidated_accounts": null,
                    "cost_of_sales": "78531652.0",
                    "export": null,
                    "gross_profit": "11034367.0",
                    "directors_emoluments": null,
                    "operating_profits": "3642221.0",
                    "depreciation": null,
                    "audit_fees": null,
                    "interest_payments": null,
                    "pre_tax": null,
                    "tax_on_profit": "574525.0",
                    "profit_loss": "2849447.0",
                    "post_tax": null,
                    "dividends_payable": null,
                    "retained_profits": "20590718.0",
                    "salaries": null
                },
                "balance_sheet": {
                    "intangible_assets": "3000.0",
                    "tangible_assets": "1315963.0",
                    "fixed_assets": "1449501.0",
                    "current_assets": "31491683.0",
                    "stock": "15003821.0",
                    "debtors_amounts_falling_due_within_one_year": "12144967.0",
                    "debtors_amounts_falling_due_after_one_year": null,
                    "creditors_amounts_falling_due_within_one_year": "11889105.0",
                    "creditors_amounts_falling_due_after_more_than_one_year": null,
                    "cash": "4342895.0",
                    "net_current_assets_liabilities": "19602578.0",
                    "total_assets": null,
                    "total_assets_less_current_liabilities": "21052079.0",
                    "total_current_liabilities": null,
                    "liabilities": null,
                    "net_assets": "20595293.0",
                    "working_capital": null,
                    "shareholders_equity": "20595293.0",
                    "calledup_share_capital": "1902.0",
                    "retained_earnings_accumulated_losses": "20590718.0"
                },
                "cash_flow": {
                    "cash_generated_from_operations": "-63280.0",
                    "net_interest_paid_received_classified_as_operating_activities": "-218249.0",
                    "income_taxes_paid_refund_classified_as_operating_activities": "-600000.0",
                    "net_cash_flows_from_used_in_operating_activities": "754969.0",
                    "purchase_property_plant_equipment": "-552471.0",
                    "proceeds_from_sales_property_plant_equipment": "-76715.0",
                    "proceeds_from_sales_other_longterm_assets_classified_as_investing_activities": "7000.0",
                    "net_cash_flows_from_used_in_investing_activities": "482756.0",
                    "increase_decrease_in_cash_cash_equivalents_before_foreign_exchange_differences_changes_in_consolidation": "1237725.0",
                    "cash_cash_equivalents_cash_flow_value": "4342895.0"
                }
        "title":"Company Name Limited"
    },
    "errorMessage": null
}

Response Properties

Name	Type	Nullable	Description
status	string	no	Contains Ok if the request was successful, Error if there was an error.
lastDataUpdatedDate	string	no	Date when the company financial data was most recently updated, in dd/MM/yyyy format.
result[]	array	yes	Contains the company_financial_list array. Each item in this array contains a single financial year's data, ordered latest year first.
company_financial_list[].end_date	string	yes	Contains the financial year end date string in "dd/MM/yyyy" format. This is null when the company has not filed iXBRL accounts yet (PDF-only filers).
company_financial_list[].profit_loss	object	yes	If the company has submitted P&L as part of the IXBRL accounts, this will contain the fields shown against the profit_loss object in the sample above.
company_financial_list[].balance_sheet	object	yes	Balance sheet properties, if available, for the given year, shown in the sample above.
company_financial_list[].cash_flow	object	yes	Cash flow statement properties, if available, for the given year, shown in the sample above.
company_financial_list[].allAvailableXBRLConceptsAndValues	array	yes	The raw xbrl tag data is not sent across anymore. Instead, from v2 of the API, the values available have been added to the available financial statements objects directly for ease of access.
company_financial_list[].value	string	no	The value of the XBRL tag, for example the monetary value of an Equity tag
title	string	no	Name of the company as it appears on Companies House register
errorMessage	string	yes	Error message text, if available