Investment data management services
Map sources, account and security identifiers, historical records, and approval checks into a dependable portfolio dataset.
Review the requirements
CSSI Data Services
Portfolio data migration, reconciliation, cleanup, and recovery.
CSSI helps investment firms migrate, merge, restore, and reconcile portfolio data. We handle the work between the source file and a target system the team can trust.
- System migrations and acquired-book merges
- Historical transactions and performance
- Cost basis and private-equity data
- Custodian feeds and daily reconciliation
How the work moves
From the old system to a verified cutover
- 01
Source data
History, accounts, and securities
- 02
Map and convert
Accounts, identifiers, and transactions
- 03
Validate
Balances and history reconciled
- 04
Cutover
Accepted, documented, and live
Plan the work
Choose the workflow your firm needs to improve
Use a requirements checklist and a representative example to prepare for a defined CSSI project.
Multi-custodian data aggregation
Get custodian and trust-system data into one portfolio system with daily feeds, account and security mapping, reconciliation, and combined reports.
Review the requirementsIBOR vs ABOR
What IBOR, ABOR and PBOR mean, why their timing differs, and the reconciliation work that keeps them in agreement.
Review the requirementsData services overview
Make the source and destination agree
Successful data work preserves the history and relationships behind each record.
CSSI analyzes, transforms, merges, and reconciles investment data across portfolio systems. We help firms preserve history, align securities and accounts, rebuild missing detail, and validate the result before the new workflow becomes operational.
The engagement can cover an entire migration or a focused problem such as cost basis, private equity transactions, classifications, or a difficult source feed.
Selected project work
Data work measured by what survived the move.
Judge the move by its historical depth, account coverage, and reconciliation quality.
2,000 accounts
Four years of Tamarac transaction and performance history migrated into APX.
7,000 accounts
Twelve years of transactions, securities, prices, and tax lots restored from custodian files.
Private equity
Transactions created from source workbooks and reconciled against client statements.
Cost basis
Tax lots initialized, transactions reposted, and an ongoing maintenance process established.
Classifications
Securities mapped to GICS sectors and historical performance data restructured.
Where we enter
One difficult dataset or the whole conversion
Start with the part of the project that carries the most risk. CSSI can own the work or support the team already leading it.
Conversions and merges
Move the history without inheriting the disorder
Migration planning, execution, or focused project support.
CSSI has spent more than 15 years completing system merges into Axys, APX, and other platforms, along with moves away from Axys and APX. Smaller conversions can be completed in weeks, while larger acquired books may require a staged project over several months.
We can manage the complete conversion, perform the technical work inside your project plan, or support the internal team handling the move.
Conversion workflow
The work between extraction and sign-off
A successful conversion accounts for the dependencies that sit around the raw transaction file.
- Extract transactions, prices, performance, and custom data
- Compare security masters across source and target systems
- Create missing securities and establish initial positions
- Post historical transactions through the current period
- Reconcile accounts against present-day custodian data
- Convert and post daily and historical prices
- Preserve performance history where the target system allows it
- Move demographics, account attributes, and custom fields
Planning a conversion?
Bring us the source, target, history, and deadline.
Direct feeds
Give the portfolio system dependable data every day
The system is only useful when the data arrives accurately and on time.
CSSI maintains direct-feed capabilities and works with established aggregation partners to connect custodian data with the portfolio management systems firms already use.
Feed options
Choose the path that fits the custodial footprint
CSSI utility
TrevPort Utility
A flexible CSSI data utility for prices, positions, transactions, and other source files available to the firm.
Built by CSSIAggregation partner
ByAllAccounts
Thousands of direct and indirect feeds that can be delivered into the portfolio management environment.
Custodian connectivity
WealthTechs
Broad custodian relationships with flexible custom-development support for less standard requirements.
ByAllAccounts
Connect aggregation with daily operational review
One source for the data feed and the reconciliation work around it.
CSSI's ByAllAccounts BackOffice service combines aggregated custodian data with reconciliation support. It can cover a selected set of accounts or the complete book of business.
Included work
Keep the feed aligned with the portfolio system
The service covers the recurring tasks that turn incoming data into usable portfolio records.
- Daily cash and position reconciliation
- Monthly and quarterly performance updates
- Splits, symbol changes, name changes, and reorganizations
- Daily price and index updates from the firm's pricing sources
- Basic security setup including type, CUSIP, and symbol
Commercial structure
Through CSSI's relationship with ByAllAccounts, clients do not pay the annual Custodial Integrator fee. Clients pay for the ByAllAccounts feeds and reconciliation services used by active accounts.
Adjacent service paths
What support may your portfolio data project need next?
Data Services
Every data service and migration path
Data Services Insights
Stay up to date with the latest insights and updates related to this topic.
Start with the data you have
Need help with a migration or a dataset nobody trusts?
Tell us what system the data is leaving, where it needs to go, and what has already gone wrong.
