Celebrating 31 Years of Client Service

Call
Two portfolio data structures converging into a unified validated system
Back to Insights

Case Study

Portfolio Management System Conversions: Three Costly Mistakes to Avoid

Every decision in a portfolio system conversion can affect an RIA’s reporting history, operating model, and client relationships long after go-live.

July 15, 2026
By Diane Herrera
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. The system matters less than having someone in the room protect your interests while the decisions get made.

CSSI protects the details that determine how the firm operates after go-live. We learn the reporting relationships, account history, and operating decisions that have to survive the move. We have done this work since 1997, when our first conversion moved trust and CRM data into Advent Axys. The tools have changed since then. The cost of a missed decision has 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, data, processes, culture, and people all come together. 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? The intangibles you hoped would drive your next stage of growth deserve as much protection as the assets on paper. Handled well, a merger 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.

Conversion mistakes surface after go-live

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.

  1. 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.

  2. 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.

  3. 03

    Security definitions

    Your new system keeps its own security master, and your securities may be described differently inside it than they were before. A changed definition can shift asset classes, alter security types, disrupt pricing, and move performance 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.

The same risks apply to moves involving Advent Axys, Advent Portfolio Exchange (APX), Schwab PortfolioCenter, or Tamarac. Cost basis and historical performance each need an explicit conversion decision, as do reconciliation and security pricing. Making those decisions correctly the first time is the work we do.

Early decisions prevent expensive cleanup

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 comes down to two outcomes. A rushed conversion leaves the firm cleaning up for years. A well-run conversion protects the client relationships and numbers while giving the firm a cleaner operating model.

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.

Diane Herrera, Founder and President of CSSI Solutions

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.

Start the conversation