How FirmenData maps financial statements to its figures
Last updated:
Every figure on a FirmenData company page comes from a filed annual account. This page explains which line of which statement becomes which figure, what we fall back to, and when we leave a figure out. The principle: a missing figure is better than a wrong one. We show reported values and never present an estimate as a reported value.
Principles that apply everywhere
- Reported values only. A figure is read from the company’s filed accounts. We never estimate revenue, profit or headcount and show it as if it were reported. (The few estimate-based indicators, such as industry trends, are labelled “Estimate”.) For UK companies there are no estimates at all.
- No guessing. If a figure cannot be tied to a specific line, or the statement’s own arithmetic does not add up, the figure stays empty.
- One filing per year and scope. For each financial year we use one filing; amounts from the prior-year column of the following year’s filing only fill gaps, never override the year’s own figures.
- Company vs. group. Company (entity) and group (consolidated) figures are stored apart. The company page headline uses one scope per company, so the two are never mixed in one series.
- Plausibility checks run after the mapping and drop implausible values (see below). The filing itself is kept; only the figure is withheld.
Germany: HGB (Unternehmensregister / Bundesanzeiger)
Source: annual accounts published in the Bundesanzeiger and the Unternehmensregister. The tables of the balance sheet (§ 266 HGB) and income statement (§ 275 HGB) are read, matched to a fixed HGB line schema and then aggregated per company and year.
| Figure | HGB line | Fallback order / notes |
|---|---|---|
| Revenue (Umsatz) | Umsatzerlöse (§ 275 Abs. 2 Nr. 1 / Abs. 3 Nr. 1) | Only an Umsatzerlöse line counts. Order: structured source for listed groups, the year’s own parsed filing, then the prior-year column of the next filing. There is no fallback to Rohergebnis (§ 276 HGB): small and medium companies may collapse the top lines into one Rohergebnis, which is shown separately as gross profit, never as revenue. Other operating and interest income are not added. |
| Total assets (Bilanzsumme) | Summe Aktiva | Same source order as revenue. |
| Equity | Passiva: Eigenkapital (top-level line) | Own filing, then prior-year column. Sign is kept (negative equity stays negative). A “nicht durch Eigenkapital gedeckter Fehlbetrag” is kept as a separate figure. |
| Profit / loss | Jahresüberschuss / -fehlbetrag; “Ergebnis nach Steuern”; for groups Konzernjahresüberschuss | Own filing, then prior-year column. If none of these lines is printed, the Gewinnvortrag line is used as the last fallback. |
| Cash | Kassenbestand, Bundesbankguthaben, Guthaben bei Kreditinstituten und Schecks | Own filing, then prior-year column. |
| Liabilities | Verbindlichkeiten | Own filing, then prior-year column. |
| Staff costs | Personalaufwand (income statement) | Absolute value. If the node is missing, the sum of its direct sub-lines (Löhne und Gehälter + soziale Abgaben) is used. Sub-sub-lines (“davon Altersversorgung”) are never added. |
| Employees | Not a table line: read from the notes (Anhang) text | Sentences about the average number of employees are extracted per statement. The headcount must come from a statement of the same scope as the year’s financial figures (a subsidiary’s published parent group accounts never supply its headcount). A count is rejected when known personnel cost per head is below € 5,000. |
Banks, insurers and statements split by maturity (IFRS layouts): the balance-sheet layouts of banks (RechKredV) and insurers (RechVersV) differ from § 266 HGB. We fill an HGB field from them only when the printed items add up to the printed total (for example liabilities as the sum of the debt items). Otherwise the field stays empty.
Group statements: a year with the company’s own consolidated statement uses it. A “befreiender Konzernabschluss” (§§ 291/292 HGB), which a subsidiary publishes for its parent, is the parent’s group and never counts as the subsidiary’s own financials.
Currency and scale: statements are read in euros. The unit label (EUR, TEUR, Mio., Mrd.) is detected and scaled. Tables in USD, GBP, CHF, JPY, SEK, NOK, KRW or CNY are scaled by their unit (thousands, millions) and converted to euros at the ECB annual average rate for the fiscal year (the latest earlier year until that year’s average is published). Pages show the converted euro amount. A table in a currency without a rate, for example HUF, PLN, CZK or DKK, is skipped.
Financial year: a figure belongs to the year of the statement’s balance sheet date.
Austria: UGB (Firmenbuch)
Source: annual accounts filed with the Austrian Firmenbuch (JustizOnline). About 69 % of the years since 2016 are available as structured XML (two schemas, both read), the rest as PDF.
| Figure | UGB position | Notes |
|---|---|---|
| Revenue | Umsatzerlöse (§ 231 Abs. 2 Z 1 UGB) | Gesamtkostenverfahren only. The Umsatzkostenverfahren (§ 231 Abs. 3) is not mapped, so those filings get no revenue figure. |
| Total assets | Summe Aktiva (§ 224 Abs. 2) | |
| Equity | Eigenkapital (§ 224 Abs. 3 A) | |
| Profit / loss | Jahresüberschuss/-fehlbetrag (§ 231 Abs. 2 Z 22) or Ergebnis nach Steuern (Z 30) | If both are present, the larger value is taken. |
| Cash | Kassenbestand, Schecks, Guthaben bei Kreditinstituten (§ 224 Abs. 2 B IV) | |
| Staff costs | Personalaufwand (§ 231 Abs. 2 Z 6) | The split into wages and social costs is not mapped. |
| Employees | Average number of employees where the filing states it | Small companies often do not file it. |
Units come from the filing (thousands when flagged). The size class (Kleinst/Klein/Mittel/Groß) is taken from the filing’s own header.
PDF-only statements: read by rules, no AI. A figure is written only if the statement’s arithmetic confirms it and it is printed in that column; otherwise the filing is stored without figures. Positions without a counterpart, filer-defined lines and all “davon” lines are deliberately not mapped.
Switzerland: Obligationenrecht (OR)
We publish no financial figures for Swiss companies. The commercial register (Zefix/SHAB) does not publish annual accounts, and we have no financial-statement pipeline for Swiss companies. Swiss company pages show register data only (identity, status, legal events). Figures will only be shown once there is a public source we can map line by line.
United Kingdom: UK GAAP (FRS 102, FRS 105) from Companies House
Source: the iXBRL accounts filed with Companies House (FRC taxonomy, older UK GAAP taxonomy names are translated). Companies House licence: Open Government Licence. We store reported values only.
A figure is written only if the filing’s own totals prove it. A UK balance sheet is a chain of subtotals (fixed assets + current assets − creditors due within one year = net current assets; … − creditors after one year − provisions = net assets), and each figure must close against the next subtotal within the facts’ rounding.
| Figure | Source concept (FRC core) | Proof required |
|---|---|---|
| Revenue | TurnoverRevenue | Turnover − cost of sales = gross profit; or, for costs-by-nature layouts and micro-entities, turnover + other income − raw materials − staff costs − depreciation − other charges = operating profit (or profit). |
| Gross profit | GrossProfitLoss | Turnover − cost of sales, or gross profit − distribution − administrative expenses + other income = operating profit. |
| Total assets | FixedAssets (or the sum of its parts) + CurrentAssets + prepayments + uncalled capital | Net current assets and total assets less current liabilities (and net assets) must close. |
| Equity | Net assets (chain result); Equity / NetAssetsLiabilities tags | The chain proves net assets. Capital and reserves must match; if reported equity lacks the chain, only an explicitly negative equal to net assets is kept, because a positive value may be a missing minus sign. |
| Profit / loss | ProfitLoss | Profit before tax − tax = profit (tax tagged with either sign), or the costs-by-nature chain for micro-entities. |
| Cash | CashBankOnHand | Current assets = debtors + cash + stock + current investments (or this sum closes net current assets). |
| Staff costs | StaffCostsEmployeeBenefitsExpense | Wages + social security + pensions (+ other) = staff costs, or the costs-by-nature chain. |
| Employees | Average number of employees (AverageNumberEmployeesDuringPeriod) | Not money, so no arithmetic. One value per period, not negative; with proven staff costs the cost per head must lie between £ 2,000 and £ 2 million. Years, money amounts typed into the field and large counts unsupported by staff costs or assets are dropped. |
Fallbacks: there are none across concepts. A figure either closes its identity or is left out. Across filings, a year’s own current-year column beats another filing’s comparative column; among equals the later period end and then the newer (amended) filing wins. The result does not depend on the order in which filings were processed.
Company vs. group: facts tagged as consolidated are the group’s; untagged facts are the company’s own. If a filing declares consolidated accounts but tags no consolidated fact, it cannot say whose figures they are and its scope stays unknown. The headline uses one scope per company: the one with more years since 2018, then the one reaching further, then group. Filings that belong to another company (for example a parent’s group accounts in the bundle) are rejected.
Currency: the filing’s currency is the unit of its money facts (mostly GBP). Isolated facts in another currency (at most two and under 5 %) are dropped; a filing with more is rejected. A year row keeps one currency. Amounts are shown in the filed currency; for search, filters and sorting they are converted to euros at the ECB annual average rate for the fiscal year (the latest earlier year until that year’s average is published). Pages show the native amount.
Scale: filers often report in £’000. The iXBRL scale attribute is applied. If a filing disagrees with the next filing’s comparative column for the same period by exactly 1,000×, it is rescaled to the majority of filings; if no majority exists the figures are dropped. Headcounts that were scaled by mistake are read as displayed.
Financial year: the year of a figure is the calendar year of its period end (the made-up date within one week; comparatives are the period 6 to 18 months earlier).
Plausibility checks (dropped, never corrected): amounts no UK GAAP filer can have (assets, equity, debt, cash above £ 1 trillion; revenue above £ 200 bn; profit above £ 100 bn; staff costs above £ 50 bn); vanity balance sheets (at least £ 1 bn assets, nearly all equity, no liabilities, activity or staff, typically shells with a nominal share capital of trillions); cash or equity above total assets in the same year (the worse-sourced figure goes, both when equal).
Size class: only what the filing itself claims (micro-entity, small companies regime, medium regime). Full and group accounts claim nothing, so we state no size.
Never: no estimated or modelled revenue, no revenue derived from unrelated lines, no figure whose accounting identity does not close. Companies whose accounts are filed only as PDF or in which turnover is printed but not tagged have no revenue figure.
IFRS and ESEF
Germany (live, limited): capital-market companies file ESEF reports. About ten group-level euro concepts are mapped: Revenue (or RevenueFromContractsWithCustomers) → revenue, ProfitLoss → profit, ProfitLossBeforeTax, ProfitLossFromOperatingActivities, EmployeeBenefitsExpense → staff costs, Assets → total assets, Equity, Liabilities and CashAndCashEquivalents. Only dimensionless group facts in euros are used; anything else is dropped, never guessed.
United Kingdom (live): large UK groups such as Tesco, BP, HSBC, Shell and Unilever file IFRS accounts with Companies House as PDF only; their machine-readable IFRS annual report is published as ESEF/UKSEF. Since November 2026 we read these reports from filings.xbrl.org (a mirror of the FCA National Storage Mechanism), about 374 companies. The issuer’s LEI is mapped to the Companies House number via GLEIF. Mapping: revenue = Revenue (else RevenueFromContractsWithCustomers; banks and insurers have no revenue, we leave it empty), total assets = Assets (else EquityAndLiabilities or non-current + current assets), checked by assets = equity + liabilities, equity = total Equity including non-controlling interests, profit = ProfitLoss (not the share attributable to owners), cash = CashAndCashEquivalents, staff costs = EmployeeBenefitsExpense where tagged. ESEF carries no headcount. Facts without a dimension are group figures; the separate-statements member is the company’s. Currency is the filing’s (GBP, USD or EUR), with its own plausibility limits, since an IFRS bank can have assets of USD 3 trillion. If Companies House already has iXBRL figures for the same year-end, those are kept. The mapping table is in backend/companies_house/accounts/ifrs.py.
Estimates vs. reported values
- Reported: everything in the financial tables of a company page (revenue, profit, total assets, equity, cash, staff costs, employees).
- Estimates: a few market-level indicators, such as industry trends, are estimates and say so (“Estimate”).
- UK: reported values only. We do not estimate UK revenue or headcount.
- We never show an estimated revenue as revenue, and we never replace a missing reported value with a calculated one from unrelated lines.
Sources
- Germany: Bundesanzeiger and Unternehmensregister (bundesanzeiger.de, unternehmensregister.de)
- Austria: Firmenbuch via JustizOnline (justiz.gv.at)
- Switzerland: Zefix and SHAB (register data only)
- United Kingdom: Companies House (find-and-update.company-information.service.gov.uk), Open Government Licence
- Exchange rates: European Central Bank, annual average reference rates (data-api.ecb.europa.eu)