Comparison · IFR/IFD

IFR capital and reporting: four ways to do it, compared

Investment firms meet the same IFR obligations in very different ways. This page compares four categories of approach, not vendors, on the criteria that matter for a Class 2 firm with a trading book.

Last reviewed

Short answer

  • If only fixed overheads and client K-factors matter, a spreadsheet plus a reporting-only tool is often enough.
  • If K-NPR or K-TCD are material, the hard part is the calculation, not the template. Use an engine that computes them from trades and positions, or an outsourced provider that does.
  • Since reference date 31 March 2026 the EBA accepts only xBRL-CSV on its platform, while your national authority sets the format and timetable it collects from firms. Confirm its instructions and the applicable validation rules.

The four categories

  • Spreadsheet in-house. The finance or risk team computes the requirements in workbooks and keys the results into a filing tool or the authority's portal.
  • Reporting-only (templating) tool. Software that maps already-calculated figures into the IF templates, validates and produces the XBRL file.
  • Outsourced managed returns. An external firm prepares the return from data you send, and may submit it.
  • Integrated risk engine. Software that loads trades, positions and activity data, computes the K-factors and generates reporting outputs from the same calculation. Everix prepares all 44 active EBA template codes.

Comparison

Qualitative assessment by category. Individual products and providers vary; check each one on these criteria.

K-NPR / K-TCD calculation
Spreadsheet in-house
Built and maintained by you; workable for small books, fragile as positions grow
Reporting-only tool
Not included: you supply the figures
Outsourced returns
Depends on the provider; often based on summaries you send
Integrated risk engine
Computed from trades and positions, with drill-down to each one
Data effort
Spreadsheet in-house
Manual exports and copy-paste each period
Reporting-only tool
Same calculation effort, plus mapping into templates
Outsourced returns
Preparing and explaining data packs for the provider
Integrated risk engine
Highest at setup (connecting trade and position data), lowest each quarter after
Validation before filing
Spreadsheet in-house
Usually only at the authority's portal
Reporting-only tool
EBA validation rules built in, typically
Outsourced returns
Done by the provider
Integrated risk engine
EBA validation rules run on the file before you file
Audit trail
Spreadsheet in-house
Weak: versions of workbooks, little lineage
Reporting-only tool
Good for the template, none for the calculation
Outsourced returns
Provider's working papers; limited access to the detail
Integrated risk engine
From reported cell back to inputs, parameters and run
Cost profile (qualitative)
Spreadsheet in-house
Low licence cost, high staff time and key-person risk
Reporting-only tool
Moderate licence; calculation cost stays with you
Outsourced returns
Recurring fee per return or per year
Integrated risk engine
Licence plus setup; most efficient when K-factors are material
Time to first return
Spreadsheet in-house
Fast if you already have the workbook
Reporting-only tool
Fast once figures exist
Outsourced returns
Depends on onboarding and data quality
Integrated risk engine
Longest initial setup of the four
Changes in the rules (FRTB 2027, EBA releases)
Spreadsheet in-house
You rebuild
Reporting-only tool
Vendor updates templates; you update calculations
Outsourced returns
Provider absorbs, at a price
Integrated risk engine
Vendor updates both calculation and templates

Which one fits?

  • Advisers and portfolio managers with no trading book (K-AUM, K-COH, maybe K-CMH): spreadsheet or reporting-only tool. Use the K-factor calculator to check whether the K-factor requirement ever binds.
  • Firms that want no reporting staff at all: outsourced returns, provided the provider understands your trading book.
  • Dealers, market makers and commodity or energy trading firms with material K-NPR and K-TCD: an integrated engine, or a provider that runs one. The FRTB date of 1 January 2027 makes this more pressing for K-NPR (see the FRTB tracker).

Questions to ask any option

  1. Does it compute K-NPR and K-TCD from our positions and trades, or does it expect the results?
  2. Which approach does it support for K-NPR from 2027, and how will it handle the open questions on CRR3 scaling factors?
  3. Does it produce xBRL-CSV for the module version of each reference date, and validate it against the EBA rules before filing?
  4. Can we trace every reported figure back to inputs and parameters?
  5. Who updates it when the EBA publishes a new release, and how quickly?

Where Everix stands today

  • Available

    All nine K-factors, max(PMR, FOR, K), SNI test, ratios and liquidity

    One C# engine, shared by Everix Cloud IFR and the installed product. FX and commodity K-NPR are calculated in the engine. Debt, equity and K-CON amounts are figures you attest. K-CMG needs competent-authority permission.
  • Available

    All 44 active EBA template codes, framework 4.2

    Class 2, Class 3 and the group test, including prudential consolidation. Checked with Arelle, EBA filing rules v5.8, the EBA validation rules and a completeness check. This is not authority acceptance.
  • Available

    ACPR reporting

    ACPR reporting calendar and French national file checks.
  • Not offered

    UK MIFIDPRU

    Everix covers EU IFR/IFD.
  • Early access

    FRTB-SA for K-NPR (GIRR, FX, commodities)

    Sensitivities-based method for GIRR, FX and commodities; other risk classes with a design partner.
We compare categories, not named products, on purpose. If you are evaluating specific vendors, use the questions above with each of them, including us.

FAQ

Is a spreadsheet acceptable for IFR reporting?+

The IFR does not prescribe tools. Many small firms start with spreadsheets, especially when only the fixed overheads requirement and a few client-related K-factors apply. The risks grow with K-NPR and K-TCD, which need position and trade-level calculations, and with the move to xBRL-CSV, which needs a correctly structured file validated against the EBA rules.

What does a reporting-only tool do and not do?+

Reporting-only or templating tools take figures you have already calculated and turn them into the regulatory file, usually with validation against the EBA rules. They do not compute K-NPR or K-TCD from your trades and positions, so the calculation still happens elsewhere.

Can we outsource the whole IFR return?+

Yes. Accounting and regulatory reporting firms prepare and sometimes submit returns for investment firms. You still provide the data and remain responsible for the figures, so the quality of the inputs and the provider's understanding of your trading book matter.

When does an integrated risk engine make sense?+

When K-NPR or K-TCD are material, when you need the same numbers for internal risk management and the regulatory return, or when the trading book is large or changes often. The engine computes the K-factors from trades and positions and produces the return from the same run, at the cost of a heavier initial setup.

Related on everix.io

Not sure which route fits your firm?

Thirty minutes on your K-factors, your data and your reporting calendar. We'll tell you if an engine is overkill.