Comparison · IFR/IFD
IFR capital and reporting: four ways to do it, compared
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
| Criterion | Spreadsheet in-house | Reporting-only tool | Outsourced returns | Integrated risk engine |
|---|---|---|---|---|
| K-NPR / K-TCD calculation | Built and maintained by you; workable for small books, fragile as positions grow | Not included: you supply the figures | Depends on the provider; often based on summaries you send | Computed from trades and positions, with drill-down to each one |
| Data effort | Manual exports and copy-paste each period | Same calculation effort, plus mapping into templates | Preparing and explaining data packs for the provider | Highest at setup (connecting trade and position data), lowest each quarter after |
| Validation before filing | Usually only at the authority's portal | EBA validation rules built in, typically | Done by the provider | EBA validation rules run on the file before you file |
| Audit trail | Weak: versions of workbooks, little lineage | Good for the template, none for the calculation | Provider's working papers; limited access to the detail | From reported cell back to inputs, parameters and run |
| Cost profile (qualitative) | Low licence cost, high staff time and key-person risk | Moderate licence; calculation cost stays with you | Recurring fee per return or per year | Licence plus setup; most efficient when K-factors are material |
| Time to first return | Fast if you already have the workbook | Fast once figures exist | Depends on onboarding and data quality | Longest initial setup of the four |
| Changes in the rules (FRTB 2027, EBA releases) | You rebuild | Vendor updates templates; you update calculations | Provider absorbs, at a price | Vendor updates both calculation and templates |
Qualitative assessment by category. Individual products and providers vary; check each one on these criteria.
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Does it compute K-NPR and K-TCD from our positions and trades, or does it expect the results?
- Which approach does it support for K-NPR from 2027, and how will it handle the open questions on CRR3 scaling factors?
- Does it produce xBRL-CSV for the module version of each reference date, and validate it against the EBA rules before filing?
- Can we trace every reported figure back to inputs and parameters?
- 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.
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