
Case Study
Portfolio Management System Conversions: Three Costly Mistakes to Avoid
A portfolio system conversion is not just a data move. The decisions made before go-live determine whether an RIA protects its reporting history, operating model, and client relationships.
- Focus
- Portfolio system conversions
- For
- RIAs and wealth managers
- Perspective
- Nearly three decades of conversion work
The decisions made before go-live determine how the firm operates for years afterward.
You have made the decision. Maybe you are moving to a new portfolio management system. Maybe your firm just acquired another one, and now two systems have to become one. Either way, the meeting is on the calendar, the vendor has been selected, and the clock is already running. What happens over the next few weeks will shape how your firm operates for years. Get it right, and you come out faster, cleaner, and stronger. Get it wrong, and you live with the consequences far longer than anyone warned you.
That gap, between getting it right and getting it wrong, is the whole story. It is a tale of two conversions. And the difference is rarely which system you land on. It is whether someone in the room is protecting your interests while the decisions get made.
That is what you get from CSSI Solutions. Fewer surprises after go-live. A conversion or merger that lands on time and on budget. Client relationships, accounts, and historical performance carried over intact. Decisions made on purpose instead of by default. And a partner who takes the time to learn how your firm actually runs, which is the one thing the vendor never will. We have done this since 1997, starting the day our first client asked us to move data out of their trust and customer relationship management (CRM) systems and into a brand new Advent Axys platform. Nearly three decades later, the tools have changed. The stakes have not.
A Conversion and a Merger Are Not the Same Thing
It is easy to lump them together. They are not the same, and treating them the same is the first mistake, the kind that costs you money you never saw coming.
A conversion is usually a comparison. You are moving from one portfolio management system to another, and the questions are about functionality. Does the new system do what the old one did? Where are the gaps? Those gaps matter more than they look, because where the new system cannot do something the old one did, you are left with a workaround, or worse, you quietly give up the very thing that set your firm apart. A conversion is complicated, but it is contained.
A merger is something else. When one firm buys another, you are not just merging data. You are merging processes, culture, and people. Someone is losing their identity in that deal. So ask yourself a hard question. As the buyer, does it make sense to strip out the very things that made the other firm worth acquiring? A merger is not about buying a business and throwing away the intangibles you hoped would drive your next stage of growth. Handled well, it becomes a catalyst that lifts both firms to a higher level and protects the clients and the revenue you paid for. Handled poorly, it drives out the value, and you are left holding assets that no longer stick.
A conversion compares systems. A merger combines systems, processes, culture, and people.
Where Conversions Go Wrong, and What It Costs You
Here is how the trouble usually starts. The decision has been made, the vendor is chosen, and the implementer schedules the onboarding meeting. A lot gets decided quickly in that room, often before anyone in it understands what those decisions touch downstream.
The reason is not anyone's fault. The implementer's focus is the software, not the hundred small things that make your firm run the way it does, and no one can absorb all of that in a single kickoff call. That is exactly why you want someone in the room who already knows your business. The trouble hides in the parts nobody thinks to raise: billing structures, client relationships, reporting entities and their substructures, models, benchmarks, and performance. Any of them can send a conversion sideways, and the bill usually arrives after go-live, when it is hardest to fix.
Let me get specific. Out of the many places a conversion runs into trouble, here are three we see over and over, and none of them look urgent until they bite.
- 01
Closed accounts
It is easy to treat a closed account as dead weight and leave it behind, then regret it the week you go live. That account may sit inside a relationship that is still open, holding the history the relationship reporting depends on. It may belong to a composite, so dropping it means your performance numbers and your testing no longer tie out. It may be part of a group that is not whole without it. A closed account is not always finished doing work for you.
- 02
The account list
Knowing exactly which accounts to bring over sounds simple and almost never is. A lot of firms cannot cleanly separate the accounts they manage from the ones they only aggregate for reporting. Miss that line before the conversion and you will either carry over accounts that do not belong on the new system or leave behind ones that do, and you tend to find out when someone goes looking for an account that is not there.
- 03
Security definitions
Your new system keeps its own security master, and your securities may be described differently inside it than they were before. Change a definition and you change more than a label. Asset classes can shift, security types can change, pricing can come through wrong, and performance moves along with all of it. One security defined the wrong way in the master can quietly distort the numbers in every portfolio that holds it.
The Decisions Hidden Inside the Data
Here is the thread that runs through all three. Two systems are almost never built the same way, so your data has to be constructed or deconstructed to fit the one you are moving to. Big words, but the plain version is simple. Someone makes a long series of choices about how your data is formatted, linked, and priced, and not one of them is trivial. Made carelessly, the damage sits quietly in your numbers for years, and it is expensive to unwind once the firm is live and running.
This holds whether you are coming off Advent Axys, Advent Portfolio Exchange (APX), Schwab PortfolioCenter, or Tamarac. Cost basis, reconciliation, historical performance, the way a security is priced: each one deserves a decision made on purpose. Making those decisions on purpose, and making them the first time, is the work we do.
What You Get When You Bring Us In Early
The good news is the part most firms miss. Almost every issue can be solved once someone catches it. The trick is catching it early, and that is worth real money to you. Find a problem up front and it is a five minute conversation. Find it after go-live and it is a delivery delay and a bigger invoice. That is the entire economics of a conversion in one sentence, and catching it early is the first thing working with us puts in your favor.
Here is what that looks like in practice. While you pilot and refine the decisions that drive the conversion or the merger, we stay locked on your system and how it has to run day to day, so your team can keep its focus on clients. You decide how involved you want us to be. We can run the entire project, do the hands-on work ourselves, or back up your own people where you simply need an extra set of experienced hands. Either way, you get people who have lived through the culture and process work that comes with a merger and know how to lower the friction while protecting the value that made two firms worth combining in the first place.
Working checklist
Before You Convert: A Short Checklist
Before you sign off on a conversion, make sure you have settled each of these:
- Which closed accounts you still need, for open relationships, composites, and groups, before any of them are marked to drop.
- The full account list, with the accounts you manage clearly separated from the ones you only aggregate for reporting.
- How each security is defined in the new security master, checked for asset class, type, and pricing.
- How cost basis, reconciliation, and historical performance will carry over, decided on purpose rather than by default.
- How your billing structures, reporting entities and substructures, models, and benchmarks will map to the new system.
- Who in the room already knows your business well enough to catch these before go-live.
Status Quo, or the Opportunity in Front of You?
The tale of two conversions is really a choice between two outcomes. One is the status quo, where decisions get made fast, value leaks out, and you spend the next few years cleaning up. The other is the opportunity that a new system or a well-run merger actually offers, a firm that comes out the other side in better shape than it went in, with its clients and its numbers intact.
You get to choose which one. When you are ready to come out faster, cleaner, and stronger, let us talk before the onboarding meeting, not after.

About the author
Who You Will Be Working With
The conversions and mergers in this piece are the work Diane Herrera has built her career on. As the founder and president of CSSI Solutions, she has led the firm's consulting practice for nearly three decades, on a foundation few in this field can match.
She is a Phi Beta Kappa graduate of Baylor University with a bachelor's and a master's in mathematics, she began her career advising banks on their software systems at Coopers and Lybrand, and she went on to technical training and product support work at IBM. She has spoken at a number of Advent user group meetings and at Schwab IMPACT on custom reporting, which is exactly where so many conversions come apart.
Talk before the onboarding meeting, not after.
Start the conversion with the decisions that protect your clients, reporting history, and operating model.
