Documentation
/api/financialsmetadata
This API endpoint returns the available financials metadata for a company using its Companies House registration number. It is free to call and can be used to determine which financial data fields are available for a given company before making a request to the financials endpoint to retrieve actual values. All fields in the response will be populated with either 'available' or null, depending on data availability.
Request
https://convert-ixbrl.co.uk/api/financialsMetaData?companynumber=012345678&apiversion=2
Method Type
HTTP GET
Authentication
This endpoint requires the authentication header to be supplied. See the authentication section.
Request Parameters
| Name | 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 Example (Only one year's data shown for brevity)
{
"status": "Ok",
"result": {
"company_financial_list": [
{
"end_date": "31/03/2022",
"profit_loss": {
"turnover": "available",
"cost_of_sales": "available",
"administrative_expenses": "available",
"distribution_costs": "available",
"gross_profit_loss": "available",
"operating_profit_loss": "available",
"audit_fees": "available",
"profit_loss": "available",
"retained_profits": "available",
"salaries": "available",
"other_operating_income": "available",
"other_interest_receivable_and_similar_income_finance_income": null,
"interest_payable_and_similar_charges_finance_costs": "available",
"profit_loss_on_ordinary_activities_before_tax": "available",
"tax_taxcredit_on_profit_or_loss_on_ordinary_activites": "available",
"depreciation_expense_property_plant_equipment": "available",
"comprehensive_income_expense": null
},
"balance_sheet": {
"fixed_assets": "available",
"intangible_assets": null,
"investments": "available",
"investments_fixed_assets": "available",
"investment_property": null,
"investment_property_fair_value_model": null,
"investments_in_subsidiaries": null,
"investments_in_group_undertakings": null,
"investments_in_group_undertakings_participating_interests": null,
"investments_in_subsidiaries_measured_fair_value": null,
"investments_in_joint_ventures": null,
"investments_in_associates": null,
"other_investments_other_than_loans": null,
"disposals_investment_property_fair_value_model": null,
"current_assets": "available",
"current_asset_investments": null,
"stock": "available",
"debtors_amounts_falling_due_current": "available",
"trade_debtors_amounts_falling_due_current": "available",
"debtors_amounts_falling_due_non_current": null,
"trade_debtors_amounts_falling_due_non_current": null,
"cash": "available",
"total_assets": "available",
"liabilities": "available",
"creditors_amounts_falling_due_current": "available",
"trade_creditors_trade_payables_due_current": "available",
"net_current_assets_liabilities": "available",
"creditors_amounts_falling_due_non_current": "available",
"trade_creditors_trade_payables_due_non_current": null,
"total_borrowings": "available",
"loans_from_directors": "available",
"bank_overdrafts": null,
"bank_overdrafts_current": null,
"bank_overdrafts_non_current": null,
"accrued_liabilities": "available",
"government_grants_payable": null,
"unpaid_contributions_to_pension_schemes_current": null,
"unpaid_contributions_to_pension_schemes_non_current": null,
"total_assets_less_current_liabilities": "available",
"net_assets": "available",
"shareholders_equity": "available",
"calledup_share_capital": "available",
"retained_earnings_accumulated_losses": "available"
},
"changes_in_equity": {
"opening_retained_earnings_accumulated_losses": "available",
"retained_earnings_accumulated_losses": "available",
"share_capital": "available",
"profit_loss_affecting_equity": "available",
"dividends_paid": null,
"comprehensive_income_expense": null
},
"other_notes_to_financial_statements": {
"employee_count": "3",
"wages_and_salaries": "available",
"social_security_costs": "available",
"pension_costs_defined_contribution_plan": null,
"pension_other_post_employment_benefit_costs_other_pension_costs": null,
"audit_fees_expenses": "available",
"fees_for_non_audit_services": null,
"government_grant_income": "available",
"government_grants_payable": null,
"amount_specific_advance_or_credit_made_in_period_directors": null,
"amount_specific_advance_or_credit_directors": null
},
"cash_flow": {
"interest_expense_on_bank_overdrafts": null,
"tax_taxcredit_on_profit_or_loss_on_ordinary_activites": "available",
"gain_loss_in_cash_flows_from_change_in_inventories": "available",
"gain_loss_in_cash_flows_from_change_in_debtors_trade_other_receivables": "available",
"gain_loss_in_cash_flows_from_change_in_creditors_trade_other_payables": "available",
"net_cash_generated_from_operations": "available",
"income_taxes_paid_refund_classified_as_operating_activities": "available",
"net_cash_flows_from_used_in_operating_activities": "available",
"purchase_property_plant_equipment": "available",
"proceeds_from_sales_property_plant_Equipment": null,
"net_interest_received_paid_classified_as_investing_activities": null,
"net_cash_flows_from_used_in_investing_activities": "available",
"dividends_paid_classified_as_financing_activities": null,
"net_cash_flows_from_used_in_financing_activities": "available",
"IncreaseDecreaseInCashCashEquivalentsBeforeForeignExchangeDifferencesChangesInConsolidation": "available",
"cash_bank_on_hand": "available",
"cash_bank_on_hand_at_beginning_of_year": "available"
}
}
],
"title": "Example Company Limited",
"isFreeRepeatSearch": null
},
"errorMessage": null,
"lastDataUpdatedDate": "{this will contain the date in dd/MM/yyyy format}"
}
Response Properties
| Name | Type | Nullable | Description |
|---|---|---|---|
status |
string | no |
Contains Ok if the request was successful, Error if there was an error.
|
errorMessage |
string | yes | If the request was unsuccessful, this would contain a description of the error where available |
result.company_financial_list |
array | no | An array where each element contains financial data for a single year. |
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[].changes_in_equity |
object | yes | Statement of Changes in Equity properties, if available, for the given year, shown in the sample above. |
company_financial_list[].other_notes_to_financial_statements |
object | yes | All data extracted from 'Notes to Financial Statements' section for the given year, shown in the sample above. |
lastDataUpdatedDate |
string | no | The date of last data refresh |
result |
object | yes | Contains the financial data for the company, where available |
company_financial_list[].end_date |
string | no | The financial year end date in "dd/MM/yyyy" format (e.g., 31/12/2020). |