Everything you need to set up and run quarterly prudential reporting to De Nederlandsche Bank. From XBRL taxonomy mapping to pre-submission validation — built for IFR/IFPR investment firms operating under Dutch supervision.
Distilled from 28+ years of regulatory reporting engagements, this toolkit replaces months of setup work with production-ready templates that reflect current DNB expectations and DLR portal requirements.
30-minute onboarding call included. Questions? Get in touch.
Interactive preview of the 7 deliverables. Each component is provided as an editable Excel workbook with pre-built formulas, conditional formatting, and documentation tabs.
| DNB Field | XBRL Tag | Data Type | Source System | Mapping Logic | Validation |
|---|---|---|---|---|---|
| C 01.00 r010 c010 | ei:OwnFundsAmount | Monetary | GL / Subledger | SUM(CET1 items) per Art. 26 CRR | ≥ 0; matches C 04.00 |
| C 01.00 r010 c020 | ei:Tier1CapitalAmount | Monetary | GL / Subledger | CET1 + AT1 per Art. 25 CRR | ≥ CET1; matches C 04.00 |
| C 02.00 r010 c010 | ei:RiskWeightedExposure | Monetary | Risk Engine | SUM(RWA) per Art. 92(3) CRR | Cross-check vs C 07.00 |
| C 03.00 r010 c010 | ei:CapitalRatioPercent | Percentage | Calculated | Own Funds / Total REA | 4.5% ≤ CET1 ≤ 100% |
| C 04.00 r010 c010 | ei:CommonEquityTier1 | Monetary | GL / Subledger | Share capital + reserves − deductions | Matches C 01.00 r010 |
| C 06.00 r010 c010 | ei:CreditRiskExposure | Monetary | Risk Engine | EAD per standardised approach | ≥ 0 |
| C 07.00 r010 c010 | ei:CreditRiskRWA | Monetary | Risk Engine | EAD × Risk Weight per CRR | Feeds into C 02.00 |
| C 09.01 r010 c010 | ei:LargeExposureAmount | Monetary | Risk Engine | Exposure to single counterparty | ≤ 25% own funds |
Quarterly prudential reporting to DNB is a recurring obligation that most Dutch investment firms underestimate in complexity. The IFR/IFPR framework introduced new capital and liquidity requirements specifically for investment firms, yet the XBRL taxonomy and DLR portal mechanics remain poorly documented beyond formal EBA guidelines.
This toolkit distills the practical knowledge from dozens of reporting implementations into structured, reusable templates. Instead of spending months building your reporting infrastructure from scratch, you get production-ready workbooks that reflect current DNB expectations, validation rules, and filing procedures.
Complete mapping of 188+ reporting fields to internal data sources. Covers own funds (COREP), capital adequacy, large exposures, liquidity, and K-factor templates with field-level guidance on data sourcing, formatting, and conditional logic.
Excel-based validation suite with 48 automated checks. Covers threshold validations, cross-template consistency, summation rules, and prior-period variance analysis. Flags issues as pass/warning/fail before you submit to the DLR portal.
Step-by-step checklist covering pre-filing data quality checks, DLR portal navigation and upload procedures, and post-submission archiving and notification tasks. Designed for operational teams running the quarterly cycle.
Comprehensive catalogue of EBA and DNB-specific validation rules with plain-language explanations. Covers blocking errors vs. warnings, common root causes, and remediation steps for each error code.
Pre-built calendar with task assignments, deadlines, and dependencies for each quarterly cycle. Includes RACI matrix, escalation procedures, and buffer periods for exception handling and management sign-off.
Seven core controls with frequency, ownership, and evidence documentation requirements. Covers four-eyes review, automated validation, GL reconciliation, variance analysis, management attestation, access review, and taxonomy change management.
Anonymised XBRL instance files showing correct structure, formatting, and taxonomy references. Use as templates for your own submissions or as reference when troubleshooting DLR portal validation errors.
This toolkit is built for Dutch investment firms subject to IFR/IFPR prudential reporting via DNB's DLR portal. It's particularly valuable for firms setting up their first quarterly reporting cycle, firms transitioning from outsourced to in-house reporting, and compliance teams looking to systematise and document their existing reporting process.
The toolkit covers the core IFR/IFPR reporting templates: own funds (COREP C 01–C 04), capital adequacy (C 06–C 09), K-factor calculations (C 34), large exposures, leverage ratio, and liquidity templates. It does not cover AIFMD-specific or UCITS reporting — those are separate regulatory regimes.
No. The validation tool runs entirely in Microsoft Excel using standard formulas and conditional formatting. No VBA macros, no external dependencies, no special plugins. It works in Excel 2016+ and Microsoft 365.
The field mapping templates reference the current EBA XBRL taxonomy applicable to IFR investment firms. When EBA publishes taxonomy updates (typically annually), the toolkit's taxonomy version column and change notes help you identify which mappings need attention. We aim to publish mapping update guidance within 30 days of major EBA taxonomy releases.
Absolutely. The toolkit covers the templates and process framework; for firm-specific data mapping, GL integration, or first-cycle hand-holding, we offer advisory engagements alongside every pack. Get in touch to discuss your requirements.
No, but we strongly recommend it. The 30-minute call covers how to adapt the field mappings to your chart of accounts, how to configure the validation tool for your firm's specific reporting scope, and practical DLR portal tips that aren't in the official documentation.