What is Data Reconciliation?
An introduction to the Data Reconciliation extension, which compares the trades in your ETRM system with the records of exchanges, brokers and clearing banks
How it works
Trades as events, reconciliation models, matchers, rules and rule functions, and what matched, partial and unmatched mean
Setting up a trade reconciliation
Build a reconciliation model that compares ETRM trades with an exchange trade file, broker confirmations and a clearing statement
Reconciling a day
Test a reconciliation model for a trade date, save the result, resolve breaks with manual mapping and review the mappings
Dashboard and analysis
Follow the reconciliation results on the dashboard, list the trades behind each result and investigate breaks with the Data Analysis insight
Running every day
Run trade reconciliation models on a schedule or when a new exchange, broker or bank file is loaded
Reference
The reconciliation model, mapping and result formats, and the services behind the Data Reconciliation extension