Flexible, scalable reconciliation solution delivers lasting value
The challenge
To better centralize and coordinate its global treasury operations, a multinational corporate decided to upgrade its core treasury platform and integrate two large regional entities into the centralized model.
To ensure synchronization between subsidiary ledgers and the enterprise-wide general ledger (GL), the company engaged SkySparc to develop an automated reconciliation process connecting the treasury platform’s accounting data with the corporate GL.
SkySparc configured OmniFi’s Reconciliation Board to support daily accounting reconciliation and month-end closing across both systems.
In any large, multi-entity organization, system migration brings complexity due to numerous interfaces and dependencies. In this project, challenges emerged around the client’s internal effort to implement and test a new interface connecting the treasury platform and the GL, threatening both scope and timeline.
Normally, a reconciliation routine serves as a control mechanism, ensuring data flows between two established systems remain synchronized and quickly highlighting discrepancies. Such routines are typically refined using historical data — but in this case, no data existed in the newly configured accounting environment because the interface was not finalized before the reconciliation deadline.
Alongside building the automated reconciliation, we also supported the interface testing — using OmniFi to identify deviations and resolve discrepancies. - Marcus Gullers, Head of Product Management, SkySparc
The solution
The reconciliation logic developed in OmniFi transformed, enriched, and mapped data between the treasury and GL systems, based on working assumptions about the new accounting configuration.
SkySparc proposed using the initial OmniFi prototype as a testing tool for the new interface before transitioning it into its permanent role as the reconciliation engine between the two platforms.
As implementation progressed, OmniFi tested the new interface and highlighted output issues, leading to adjustments in the interface, accounting data structures, and reconciliation logic. A close-knit project team, supported by SkySparc’s R&D resources, ensured delivery within tight timelines.
Typically, reconciliation routines operate between two stable systems whose entries match. Here, some entries were missing or mis-posted,” explains Gullers. “We used OmniFi not only to automate reconciliation but also to troubleshoot and validate interface performance.
To meet this expanded role, OmniFi’s Reconciliation Board was enhanced to process multi-day data sets. Unlike other systems requiring heavy technical input, these upgrades were made rapidly — without specialized development — avoiding costly delays.
“We quickly recognized the scale,” says Gullers. “OmniFi typically handled 10 000 records, but the client required 50–100 000 rows — equating to over 50 million data points.”
The unexpectedly large data volumes stemmed from two causes: limited visibility of local-level accounting data and multiple interface iterations generating additional entries and reversals.
“We engaged SkySparc R&D to deliver an enhanced Reconciliation Board capable of processing the increased volumes,” notes Gullers.
“Today, OmniFi processes millions of records — over 100 million data points — in seconds rather than minutes.” - Marcus Gullers, Head of Product Management, SkySparc
The result
Beyond its unplanned testing role, OmniFi’s Reconciliation Board delivered strong core performance. It connected seamlessly to an unfamiliar accounting platform, accessed all relevant data sources, and established reconciliation routines by transforming and mapping data with complex logic.
“Extensive enrichment and mapping were required as the systems used different accounting structures — including one-to-many and many-to-many transfers,” explains Gullers. “Pre-defined tolerances handled rounding differences, and country-specific modes ensured flexibility.”
During and after implementation, the client leveraged OmniFi’s documentation and reporting features to export reconciliation results for further analysis. These tools proved valuable for root-cause analysis and collaboration, enabling quick communication of interface issues.
“The client didn’t expect the volume of deviations we identified,” adds Gullers. “Running the first export through OmniFi allowed instant detection of mismatches and quick resolution — saving extensive manual analysis and countless hours.”
Today, the client performs fast, accurate reconciliations across high-volume, multi-entity operations. Using OmniFi’s Reconciliation Board delivers daily value and substantial time savings while significantly reducing operational risk through a robust, transparent, and scalable process.
OmniFi Reconciliation Overview
Reconciling accounting entries and financial data across systems is often complex and time-consuming. OmniFi’s Reconciliation Board enables clients to match, validate, and synchronize high-volume, business-critical data with speed, accuracy, and transparency, supporting both daily operations and month-end closings.
Quick facts
Flexibility – Supports reconciliation of any financial or operational data set, from trade and transaction details to asset or position records, across multiple systems and geographies.
Extensibility – OmniFi’s Python-based API framework allows seamless integration with on-premise and cloud data sources for real-time reconciliation at scale.
Simplicity – Designed for business users in treasury, finance, and accounting, requiring minimal IT involvement for setup and execution.
