Currency conversion and third-party aggregation
Summarize
Summary of Currency conversion and third-party aggregation
Starting with Digital Operational Resilience Management (sndoraaccel) version 22.x.x, ServiceNow supports currency conversion and third-party expense aggregation for DORA (Digital Operational Resilience Act) reporting. These features enable users to convert and consolidate contractual expenses from multiple currencies into a single regulator-required base currency using automated daily exchange rates.
Show less
This functionality is designed to help ServiceNow customers comply with DORA regulatory requirements by providing accurate, consolidated expense reports without altering the underlying contract or third-party records.
Key Features
- Currency Conversion: Automatically converts contractual expenses from various currencies to a designated base currency using daily updated exchange rates.
- Third-Party Aggregation: Consolidates expenses across multiple contracts from the same provider into a single total, with the option to sum raw amounts before rounding.
- Independent Enablement: Currency conversion and aggregation can be enabled separately or together based on specific DORA reporting needs.
- Report Generation: Supports creation of Microsoft Excel download reports for analysis and Plain-CSV packages with Level 3 validation for regulatory submissions.
- Validation and Currency Rate Management: Administrators can maintain business validation rules and review or update currency rates, which are automatically populated daily. Default fallback rates apply if no specific date rates are available.
- Reporting Metadata: For CSV regulatory submissions, additional fields such as Competent Authority, Reference Date, and Date of Reporting are required.
Administrator Responsibilities
- Maintain the DPM business validation rules table to ensure alignment with current regulator requirements, adding new rules as needed without waiting for platform releases.
- Verify that the currency conversion rates table is populated by the daily scheduled job and add historical rates if necessary.
- Ensure fallback rates are correctly configured for dates where specific exchange rates are unavailable.
Key Outcomes
- ServiceNow customers can efficiently produce consolidated and compliant DORA reports, with clear visibility into currency conversion and aggregation success or failure.
- Automated daily exchange rates and validation rules minimize manual effort and reduce errors in financial reporting for third-party expenses.
- Flexibility to enable features independently empowers organizations to tailor reporting processes according to their regulatory obligations.
Beginning with Digital Operational Resilience Management (sn_dora_accel), version 22.x.x, currency conversion and third-party aggregation capabilities are supported for DORA reporting of third-party expenses. As a DORA application user, you can convert and aggregate contractual expenses from multiple currencies to a regulator-required designated base currency using automated daily exchange rates.
Supported capabilities
When creating an Excel download and upload request for DORA reporting, you can configure currency conversion and third-party aggregation settings to generate consolidated reports. Third-party aggregation consolidates expenses across multiple contracts associated with the same provider. You can enable both currency conversion and aggregation features independently as optional features, providing flexibility based on DORA reporting requirements.
When creating a Plain-CSV reporting package (for regulatory submission), the following fields are required in addition to the standard entity details: Competent authority (for example, "CA"), Reference date (for example, 2025-12-31), Date of reporting (for example, 2026-01-28).
Report outputs
The application generates two types of reports to support regulatory conformance. The Primary download report provides Microsoft Excel based analysis, while the CSV package is designed for regulatory submission and includes Level 3 validation. Summary reports generated with both types display conversion and aggregation success or failure details with explanatory messages when issues occur. Currency conversion and aggregation apply to generated report outputs and do not modify underlying contract or third-party records.
Currency rates and validation rules
Once you activate the instance, currency rates populate automatically via a daily scheduled job. Administrators or DORA administrators can update currency rates and validation rules to align with regulator requirements.
If specific date rates aren’t available, the system uses fallback default rates. The validation rules table must be maintained to stay current with regulatory requirements.
- DPM business validation rules table — must be kept current with regulator requirements; new rules can be added by the administrator without waiting for a platform release.
- System currency conversion rates table — populated automatically by a daily scheduled job once the instance is activated. Administrators can add historical rates via background script. If rates are unavailable for the reference date, the system falls back to default rates.
The following examples illustrate business validation rules and system currency conversion rates.
Related documentation
For information on creating a Microsoft Excel download and upload request and generating the reports, see Create Microsoft Excel download and upload request.
For steps on converting and aggregating contractual expenses to regulator-required currencies, see Convert and aggregate contractual expenses to regulator-required currencies.