SimCorp Reconciliation Workflows: Keeping Custodian and Internal Books in Sync

Reconciliation is often described as a back-office function, but its consequences reach every part of an investment organisation. A break between internal position records and custodian holdings does not just create accounting uncertainty. It delays NAV production, undermines performance attribution accuracy, and introduces settlement risk if uncorrected trades are sent to market based on incorrect positions.

For asset managers running large portfolios across multiple custodians, position reconciliation software and the workflows that govern break management are fundamental to maintaining operational integrity.

Why Custodian and Internal Books Diverge

Internal investment books and custodian records represent the same underlying holdings from different operational perspectives. The internal IBOR captures trade-date positions, accrued income, and pending settlement transactions in real time. The custodian’s book operates on a settlement-date basis, reflecting only those transactions that have fully settled. This timing difference means that on any given day, the two books will differ by the value of trades pending settlement, and those differences are expected and manageable.

The problem arises when differences appear that are not explained by settlement timing. Corporate action adjustments that the custodian has applied but the internal system has not yet processed, pricing differences for illiquid assets, FX rate rounding discrepancies, and income accrual differences all generate breaks that require investigation. Left unresolved, these breaks compound over time, creating an increasingly inaccurate picture of portfolio holdings that affects every downstream process that depends on position data.

The NAV reconciliation process is typically where these accumulated breaks become visible, because NAV calculation requires reconciled positions to produce a number that investors and regulators can rely on.

SimCorp’s Reconciliation Architecture

SimCorp One consolidates all reconciliation processes into a single operational environment. Rather than running separate reconciliation tools for positions, transactions, and cash flows, the platform provides a unified Reconciliation Manager that matches internal records against custodian data, prime broker reports, and other external sources simultaneously. The Reconciliation Manager, introduced in SimCorp Dimension 5.9, serves as a central hub for all reconciliation processes and fully integrates with the IBOR to efficiently resolve breaks and exceptions. This integration with the IBOR is the key architectural advantage.

When SimCorp resolves a reconciliation break by applying a custodian position adjustment, the correction flows directly into the IBOR and propagates to all downstream systems, including risk analytics, compliance monitoring, and performance reporting. There is no manual re-entry of corrections, no risk of different teams working from inconsistent versions of position data, and no delay between break resolution and updated analytics.

Core Components of SimCorp’s Reconciliation Workflows

Automated Position Matching

The best practices for reconciliation automation in SimCorp begin with automated position matching that compares internal holdings against custodian records at configurable frequencies. The system matches on ISIN, quantity, and settlement currency, flagging positions where quantities differ by more than a defined tolerance threshold.

For large portfolios, this automated matching eliminates the manual comparison of custodian statements that historically consumed significant operations team time at the start of each business day.

Ascenteum designs and implements high-performance SimCorp reconciliation frameworks that reduce break volumes, accelerate exception resolution, and deliver the audit-ready controls today’s regulators and investment managers expect. Strengthen your investment operations with our expert business transformation services.

Cash Reconciliation and Intraday Cash Management

Cash reconciliation operates alongside position reconciliation, comparing internal cash balance records against custodian nostro account statements. SimCorp’s IBOR manages cash balances intraday, updating projections when settlement occurs and reflecting pending corporate action cash flows in cash forecasts.

Cash breaks are categorised by source, whether settlement timing, fee deductions not yet reflected, or dividend receipts pending processing, and managed through structured exception queues that direct each break type to the appropriate operations team.

Static Data Reconciliation

A separate reconciliation module within SimCorp handles static data differences, covering security master attributes such as the maturity date of a bond or expected dividend amounts. When custodian reference data for a security differs from the internal security master, the static data reconciliation workflow flags the discrepancy and routes it to the data management team for investigation.

Incorrect static data can cause seemingly inexplicable position breaks, and having a dedicated reconciliation layer for this data type accelerates break identification significantly.

Daily Reconciliation Workflow Management

The daily operations cycle for reconciliation workflow investment in SimCorp follows a structured sequence that begins with importing custodian files in standardised formats, running automated matching, generating break reports, and routing exceptions to responsible teams.

For firms managing multiple custodians across different time zones, SimCorp schedules these processes to align with custodian file delivery times, ensuring that reconciliation results are available to operations teams at the start of their working day rather than mid-morning after manual file processing.

IBOR and ABOR Reconciliation

Investment Book of Record and Accounting Book of Record alignment is a specific reconciliation requirement that SimCorp addresses through its parallel book maintenance architecture. The IBOR supports real-time investment visibility with trade-date positions, while the ABOR maintains settlement-date accounting records aligned with official financial reporting.

Exception Management and Break Resolution

Reconciliation breaks in SimCorp are managed through a structured exception workflow that categorises each break by type, age, and assigned resolution owner. The system tracks break ageing and escalates unresolved exceptions to supervisors based on configurable thresholds. This structured approach ensures that long-standing breaks receive management attention before they affect NAV calculations or regulatory reporting. For US and Canadian firms subject to SEC or OSFI examination, the ability to demonstrate a documented and disciplined reconciliation process is both an operational and a regulatory requirement.

Conclusion

Reconciliation in SimCorp is not a single process but a layered set of workflows covering positions, cash flows, static data, and book alignment that together maintain the accuracy of the investment book of record. When these workflows are correctly configured, they reduce the operational overhead of exception management, accelerate NAV production, and provide the data quality foundation on which all downstream analytics and reporting depend. For investment managers in the US, Canada, and the UK managing large and complex portfolios, this reconciliation discipline is a non-negotiable component of operational excellence.

If you need to improve operational efficiency, data integrity, and performance, Ascenteum helps investment managers build scalable, auditable reconciliation frameworks across multiple custodians and asset classes as their business grows. Simplify complex reconciliation processes with our proven SimCorp implementation expertise!

Recent Posts

BlackRock Aladdin Trade Cost Analysis Configuring TCA Benchmarks for Execution Quality

BlackRock Aladdin Trade Cost Analysis: Configuring TCA Benchmarks for Execution Quality

Transaction cost analysis enables investment teams to assess trading costs and execution quality using benchmarks suited to different trading objectives, market conditions, and asset classes. BlackRock Aladdin TCA supports benchmark-based evaluation of execution performance, including implementation shortfall, VWAP, TWAP, arrival price, and pre-, intraday, and post-trade measures to strengthen best-execution oversight and trading decisions.

Read More »
SimCorp Data Migration Building UAT Test Cases for Multi-Fund Structures

SimCorp Data Migration: Building UAT Test Cases for Multi-Fund Structures

Multi-fund SimCorp migrations require thorough UAT to validate shared data, fund-specific configurations, accounting calculations, compliance rules, and settlement processes. A structured testing programme helps identify data and configuration issues before go-live, while clear ownership across business, technology, and specialist teams supports reliable validation and informed sign-off.

Read More »
SimCorp Vendor Evaluation Checklist What to Ask During RFP and Demo Stages

SimCorp Vendor Evaluation Checklist: What to Ask During RFP and Demo Stages

A structured SimCorp vendor evaluation helps investment managers compare implementation partners across experience, data migration, staffing, regulatory requirements, support, and commercial terms. A disciplined RFP and demo process helps teams test real operational scenarios, identify delivery risks, and select a partner suited to their implementation requirements.

Read More »
BlackRock Aladdin Go-Live Readiness A Position Reconciliation Checklist Before Cutover

BlackRock Aladdin Go-Live Readiness: A Position Reconciliation Checklist Before Cutover

A structured Aladdin go-live readiness process centers on reconciling positions, NAV calculations, security data, compliance rules, and system integrations before cutover. Documented validation, defined acceptance criteria, and clear ownership provide the evidence needed for a controlled go/no-go decision while reducing the risk of unresolved data or operational issues after migration.

Read More »
Picture of Shan Hussain
Shan Hussain
Shaan Hussain leads Business Consulting at Ascenteum, partnering with Investment Banks and Asset Managers to deliver specialist transformation across the Sell-Side operating model. With over 25 years’ experience in capital markets technology, Shaan focuses on providing high-calibre consultants and SMEs across SimCorp Dimension and Aladdin. Ascenteum supports IBOR and ABOR design, performance and accounting transformations, data migrations, and large-scale platform implementations through targeted staff augmentation and project collaboration.