Reconciliation for complex financial transformation
EasyRec helps financial institutions validate migrations, upgrades and data transformations by reconciling millions of records across heterogeneous sources, and explaining every difference before sign-off.
From data comparison to break resolution
One framework to compare, analyse and monitor data across systems, environments and deliveries.
- 01
Connect
Read data directly where it lives, from databases, CSV, Excel, XML or JSON files. No ETL, no copies.
- 02
Reconcile
EasyRec suggests keys, mappings and tolerances for you, then compares millions of records in seconds to minutes.
- 03
Analyse
Drill down, classify breaks, assign root causes and validate them in a shared workflow.
- 04
Monitor
Re-run after every delivery, compare runs and track KPIs until sign-off, then keep running in BAU.
Reconciliation as a delivery accelerator, not a bottleneck
When reconciliation is slow, manual or dependent on a few experts, it becomes the delay. EasyRec turns it into a repeatable control.
Less project effort
One reusable configuration replaces hundreds of manual Excel checks, cycle after cycle.
Shorter validation cycles
Re-run the full scope immediately after each delivery, not weeks later.
Lower go-live risk
Full-population evidence instead of samples, with every difference explained, and no disruption to ongoing business.
Business in control
Business users configure and analyse reconciliations themselves, without waiting for IT.
Audit-ready by design
Every comment, validation and root cause is time-stamped and exportable for steering and audit.
Minimal implementation cost
Plug and play on existing infrastructure, priced per user and never by data volume.
One platform, from project to production
Platform & Murex upgrades
Prove the upgraded platform produces the same results, patch after patch.
Learn more →Data migrations
Keep cash flows and P&L constant at trade level from source to target.
Learn more →Non-regression testing
Separate expected changes from regressions on every release.
Learn more →Configuration & CI/CD
Compare configurations across environments and deployment pipelines.
Learn more →Operational controls
P&L, payments, nostro, risk, finance and regulatory reconciliations.
Learn more →From reconciliation to continuous monitoring
Programmes are not validated in one run. EasyRec follows the whole journey to sign-off, delivery after delivery.
- Batch dashboard: the status and match rate of every reconciliation in a run, at a glance
- Run-to-run comparison: see what a patch fixed, and which regressions it reintroduced
- Dynamic templates: one template loops over hundreds of reports and tables, with dynamic columns, conditional keys and tolerances
- Steering exports: scope coverage and progress for steering committees
From hours of configuration to immediate productivity
EasyRec profiles your data and proposes the reconciliation for you, then helps explain the breaks, so teams focus on decisions instead of mappings and spreadsheets.
- Automatic discovery of reconciliation keys
- Automatic column correspondence across naming conventions
- Detection of columns to ignore (timestamps, technical IDs…)
- Detection of column types, date formats and data structures
- Quick Compare: reconcile files in any format in a few clicks
- Global Pattern Analysis: recurring patterns highlighted across all breaks, not one break at a time
- Root cause identification: breaks automatically linked to their root causes
- User comments: every analysis and validation recorded with a full audit trail and versioning
| Before | With EasyRec |
|---|---|
| Manual column mapping | Automatic column matching |
| Manual key identification | Smart key discovery |
| Trial-and-error setup | One-click setup |
| Time-consuming configuration | Immediate productivity |
| Break-by-break investigation | Global Pattern Analysis |
| Root causes found by hand | Automatic RCA identification |
| Comments lost in e-mails and Excel | Audited, versioned user comments |
Compare every environment at once
Configuration drift is a major source of migration and release failures. EasyRec compares DEV, UAT, MASTER and PROD simultaneously in a single reconciliation run, and highlights exactly where environments diverge.
The same engine reconciles one dataset over different periods, or different datasets across up to four sources.
| Setting | DEV | UAT | MASTER | PROD |
|---|---|---|---|---|
| Curve | EUR-OIS | EUR-OIS | EUR-OIS | EUR-OIS |
| Rounding | 2 | 2 | 2 | 4 (differs) |
| Cut-off | 18:00 | 18:00 | 17:30 (differs) | 17:30 (differs) |
| Settlement | T+2 | T+2 | T+2 | T+2 |
Any source against any source
CSV against a database, Excel against XML. Data is read in real time from where it lives and exposed as SQL tables, so you can join, filter and transform with standard SQL.
Reconciliation is not only a number of breaks
Business users want to see the impact. EasyRec gives them the analytics to find the root cause, not just the mismatch.
Pivot analysis
Analyse differences by aggregated position with drill-down to the detail, in real time, on large data.
OLAP cube reconciliation
When a migration by position changes the number of rows, one-to-one matching fails. The cube reconciles aggregated and detailed figures in the same view, with user-defined formulas.
Break validation workflow
Categorise, prioritise, assign and validate breaks: Not analysed, In progress, Accepted, Rejected. Bulk updates, force match, versioning and a full audit trail.
Root cause assignment
Assign root causes automatically with best-matching rules and Excel decision tables, and create comments from business rules instead of one break at a time.
Everything a reconciliation project needs
Matching & tolerances
- One-to-one, one-to-many, many-to-many
- Relative and percentage tolerances
- Rules-based tolerances per currency or business area
- Date tolerances (e.g. “2d 12h”) for holiday calendars
- Numeric, string, XML and JSON tolerances, on any column, keys included
Mappings & transformations
- Mappings between different naming conventions
- SQL, decision table, CSV, XML or properties mappings
- Groovy user-defined actions for specific needs
- Java plugin API for complex transformations
Reporting & KPIs
- Excel reports with native formulas
- PowerPoint dashboards for steering committees
- CSV, HTML and database exports
- KPIs from match ratios to breaks per user and category
Large data
- Millions of rows per run
- Lazy mode that streams to disk
- Automatic split into sub-reconciliations
- Scalable number of reconciliation engines
Automation
- Headless batch mode, no GUI required
- Scheduler integration: cron, Jenkins, Control-M, Autosys
- Scriptable, usable as an API
- Automatic report e-mailing
Governance
- Read-only access to source systems
- Audit trail by user, date, time and action
- Configurations stored as XML, versioned in Git
- No data copied or duplicated
- ISO/IEC 27001:2022 certified vendor
Measured, not promised
“EasyRec was selected as the strategic solution for the Bank, providing control, reliability and increasing quality of deliverables.”
Make reconciliation a control, not a bottleneck
See how EasyRec can secure your migration, upgrade or transformation programme, on your own data.