Convert and aggregate contractual expenses to regulator-required currencies

Convert and aggregate contractual expenses to regulator-required currencies and generate consolidated reports for reporting submissions. Beginning with Digital Operational Resilience Management (sn_dora_accel), version 22.x.x, these currency conversion and third-party aggregation capabilities are supported for DORA reporting.

Before you begin

Role required: sn_oper_res.admin, sn_oper_res.manager

About this task

Two download types are supported: (1) Excel master template — for internal review and analysis; does NOT require Competent Authority, Reference Date, or Date of Reporting fields. (2) Plain-CSV reporting package — for regulatory submission; requires Competent Authority, Reference Date, and Date of Reporting; includes Level 3 DPM validation on generation. Currency conversion and aggregation settings are available for both types.

Once the instance is activated, currency rates populate automatically via a daily scheduled job. To align with regulator requirements, administrators or DORA administrators can update currency rates and validation rules at All > Digital Operational Resilience Management > Digital Resilience Choices or DPM Business Validation Rules. For more information, see Currency conversion and third-party aggregation.

Procedure

1. Navigate to Workspaces > Operational Resilience Workspace > Digital resilience third-party registers > Excel download/upload requests and select Excel master template as the Type.

   The example shows the Excel template form.

   
2. Fill in the entity details including the LEI (Legal Entity Identifier), entity name, country, and type of entity and set the report type to Consolidated.
3. To enable currency conversion, select Yes and specify the base currency (for example, EUR).
4. To enable third-party total expense aggregation, select Yes.
   When both currency conversion and aggregation are enabled, aggregation operates on the already-converted base-currency amounts. Raw converted values are summed first; the total is rounded to the nearest whole unit afterward (for example, 94 + 94 = 188 → 189 EUR).
5. Enter the reference date and reporting date and select Save to save a request in the Draft state.

   The Reference date defaults to the last day of the prior calendar year; Date of reporting defaults to today's date. Both can be manually overridden before saving.

   After selecting Save, the request is created in Draft state (number format: REQ000XXXX).

   The reference date and reporting date are shown in the example.

   
6. Verify configuration settings on the Details tab.
7. On the Contractual arrangements tab, review and select relevant contracts.

   Review the contracts that will be included in the export as shown in the example.

   
8. To download third-party information register, select the Export info register action, enter a file name in the export dialog, and select Save.
   The Export info register dialog prompts for a file name. The file name is used as the workbook name in the downloaded Excel file.
9. Download the generated Microsoft Excel file containing the entity information in Digital Operational Resilience Act (DORA) template format.
   
10. Download the "Consolidated_Reports.zip" file from the Attachments section after the system processes and generates the consolidated reports package.
    For the Excel master template type, the ZIP contains two summary CSVs: Currency_Conversion_Summary.csv and Third_Party_Aggregation_Summary.csv.
11. Extract the ZIP file to access the "Currency_Conversion_Summary.csv" and Third_Party_Aggregation_Summary.csv reports and review the "Currency Conversion Summary report" to verify conversion details and amounts.
    
12. To generate a Comma-Separated Values (CSV) reporting package for regulatory submission, create an Excel Upload/Download request and select the Plain-CSV reporting package type.

    The Plain-CSV reporting package type is shown in the example.

    
13. Fill in the entity configuration with the currency conversion and aggregation settings, then save the CSV package request to initiate asynchronous processing.
    

    On Save, an info banner displays: "Plain-csv reporting package generation initiated. Processing time varies based on data volume." No page refresh is needed.

14. Monitor the Result section for processing status, including validation and package generation and download the generated attachments — "Consolidated_Reports.zip" and the main CSV reporting package file once processing completes.

    The Attachments panel displays the generated report files. Download the reporting package and submit it to the regulator. The package contains three CSV files: Currency_Conversion_Summary, Level3_DPM_Validation_Summary, and Third_Party_Aggregation_Summary. The DPM validation report lists each data point, the number of records checked, the number of records that passed, and any rule violations identified before submission.

    The Result > Messages section displays timestamped log entries, for example: [2026-01-28 12:07:06] Plain-csv reporting package generation initiated. [2026-01-28 12:07:19] Level 3 DPM validation completed successfully. [2026-01-28 12:07:19] Consolidated reports (Third-party total expense aggregation, Level 3 DPM validation) have been generated and attached to this request. [2026-01-28 12:07:19] Plain-csv reporting package generated successfully.

15. Open the CSV file and review the structured data formatted for regulatory reporting.
    Note:

    The CSV file is comma-delimited. Opening it in Excel may trigger a data-loss warning. For review, open directly in a text editor or CSV viewer to preserve formatting fidelity.

    The example shows the CSV file with structured currency data.

    

    When selecting Plain-CSV reporting package type, these additional fields are required: Competent authority (for example, "CA"), Reference date (defaults to last day of prior year, for example, 2025-12-31), and Date of reporting (defaults to today, for example, 2026-01-28). These fields do not appear on the Excel master template request form.

    Note:

    If any providers were ineligible for aggregation, the aggregation summary and detail reports identify those providers and explain the reason they were skipped.