Metadata-driven mapping
Business analysts and accountants supplied mapping metadata in spreadsheets that Avato converted into reusable transformation assets.
Avato in Practice · Financial Services
A major Canadian Schedule 1 financial institution needed to modernize its general-ledger environment across multiple banking entities and core systems while preserving accurate mapping, balancing and reporting.
Situation
The environment included multiple core banking systems and vendors. The new general ledger required consolidated account information, remapping across companies, cost centres and segments, and business rules governing how ledger records were grouped and balanced.
Avato's role
Business analysts and accountants supplied mapping metadata in spreadsheets that Avato converted into reusable transformation assets.
Avato mapped source banking information into the target general-ledger structures and interfaces required by the new platform.
Inverse transformations supported downstream reporting needs in representations aligned with the original accounting mappings.
Conversion through the real interface
Rather than create an entirely separate conversion mechanism, the implementation prioritized the real-time interfaces and used them to process historical information into the new ledger environment. Historical loading therefore contributed directly to testing and validating the interfaces intended for ongoing operation.
Why it matters
The implementation demonstrates configuration-driven transformation where accounting mappings, grouping rules, system interfaces and reporting requirements all had to remain understandable and maintainable.