Field mapping
Connect source columns and document fields to the reporting model, including one-to-many and conditional mappings.
Between raw source data and a finished report sits a layer of mappings, calculations and conventions. In most organisations that layer lives in spreadsheets and scripts. In Datox it is configuration: inspectable, versioned and reused every period.
Connect source columns and document fields to the reporting model, including one-to-many and conditional mappings.
Standardise currencies, dates, identifiers, counterparty names, asset classes and jurisdiction codes across providers.
Apply the arithmetic your report requires, exposures, ratios, weightings, fees, performance and derived measures.
Roll data up by fund, entity, share class, region, strategy or any dimension the output needs.
Resolve ISINs against an integrated Security Master, append governed reference attributes and classifications, then carry the enriched record into downstream mapping and calculations.
Learn morePackage a set of transformations once and apply it across similar funds, entities or reporting periods.
Every transformation applied to a value can be inspected from the output side. When a reviewer or auditor asks why a figure looks the way it does, the answer is in the platform rather than in someone's spreadsheet.
Reporting changes are constant, and each one that requires an engineering ticket adds delay and risk. Datox lets the people who own the report adjust mapping and calculation logic within their permissions, while keeping the change controlled.
Provider asset-class labels mapped to the taxonomy required by the report.
Multi-currency positions converted at the correct period rate and reported in base currency.
Gross and net exposures derived from positions, notionals and instrument data.
Investor-level records aggregated by group, jurisdiction or share class for disclosure.