The Good, the Bad and Ugly of Account Aggregation

Oct 24, 2013

The following is a guest blog post by Raef Lee, Managing Director for the SEI Advisor Network. In addition to writing tips Raef-Leefor advisors on technology, Raef is responsible for exploring new services and markets for the SEI Advisor Network. Connect with him on LinkedIn now or follow him on Twitter: @SEIRaefL.

A long time ago, a younger Raef would avidly wait for the next version of Intuit’s Quicken Personal Finance software and then happily spend an inordinate amount of time with his 128 kbps modem downloading transactions from his (few) bank accounts and (many) credit cards. I spent much time categorizing transactions and creating budget reports in those days. I even chose my credit cards by whether or not they supported a Quicken download format. I did all of this to get a view of where the family’s cash was (no investments in those days) and how we were spending. My wife thought I was bonkers and took pleasure in dismissing with an eye roll any report I proudly presented. Little did she realize that I was ahead of my time.

Fast forward to today: My moment has come. Aggregation of assets to give an investor or their advisor a holistic view is now more important than ever.

Aggregation Basics

A quick review of how aggregation works:

Aggregation Components

Aggregation is the pulling together of account information from the different record-holding systems. Data sources can include the main advisor custodians (for example Schwab, Fidelity), insurance companies (for annuities and other insurance with a cash value), and other ‘held away” investor account types (401k, 529, credit cards, banking checking and savings accounts).

There are other data sources (not shown), such as the multiple systems within a custodian or bank, called internal aggregation. There are also systems which have no technical interface, which require manual data entry from a statement.

The key is to pull a client’s complete holdings from all these sources to provide a holistic client view of their net worth.

There are several methods of pulling all this data together, including: direct feeds (a unique data feed between the custodian and the aggregator), a network (such as DTCC or DST), and “screen scraping.” Screen scraping is a program that mimics a user interacting with a computer screen. It knows where buttons and text entry fields are and “scrapes” the data that is shown on the screen.
Once all this disparate data is pulled together, it is reconciled, scrubbed and then mapped to a single data schema, typically in a portfolio management system.

If the data has been well-scrubbed, and transaction information has been collected from the data sources, it can be run through a performance system to provide a comprehensive report for the whole client portfolio, as well as for individual accounts.
The account information is then presented to the advisor and the investor through a client reporting package, financial planning software or more recently a CRM.

The Good (Clint Eastwood)
It is a triumph for the client and their advisor when custodians provide client data to aggregators and other portfolio management programs. It’s surprising that aggregation is even possible. In the UK for instance, this collaboration between custodians is in its infancy and it is next to impossible to see a client’s aggregated holdings.

Here are some of the good services allowed by aggregation:

  • Client View. The bedrock aggregation capability is for an advisor to show clients their full financial picture (assets and liabilities) in one place, and then be able to advise their clients on why it looks like that and what their options are.
  •  Performance. Advisor can now show their clients performance on their entire holdings—both assets they manage and those they do not. Clients can quickly see what parts of a portfolio are doing well, and which are not. Benchmarks allow a more objective discussion of the portfolio. Only recently has the quality of aggregated data allowed performance figures to be calculated over a client’s complete holdings. With it, an advisor can use this discussion as a way to bring more of their clients’ assets under their management.
  • Client Reporting. Today’s sophisticated client reporting enables an advisor to generate flexible, good-looking, and timely client reports at the click of a button. With a well integrated system, an advisor’s client service representative no longer needs to spend a day creating a folder full of relevant paper reports for a client review.

In general, as shown in the diagram, the value of the information to the client is increased each step of the way from account-level aggregation through performance to easy-to-explain reporting.

The Bad (Lee Van Cleef)
The benefits of aggregation are clear, so why isn’t everyone doing it? There are two main reasons:

  • Quality of Data. A holistic view is only useful if the advisor and client trust the data. Good aggregated data is difficult to create. The data has to be pulled together and then put into a single data structure. However what one custodian calls a dividend another might call a buy. Some information, like an asset price, may be missing. This leads to complex mapping and a data scrubbing factory. From an advisor perspective, the first thing is to outsource this type of work; doing data scrubbing is not why you became an advisor! Choose an aggregation partner who can explain their process and give you confidence in the integrity of the data that they are providing you.
  • Cost. With some account-level aggregation systems the cost for an advisor can be around $40 to $60 per year per account. With clients having multiple accounts, costs can quickly rack up. In the diagram, the cost of the aggregated data increases as you move from left to right across the data sources. The most inexpensive solution is if everything is custodied in one place. The cost goes up as data is aggregated from other custodians and then moves higher as data is screen-scraped from the held-away accounts. The most inexpensive solution for an advisor is a partner who provides not only account-level aggregated data, but bundles the performance and the client reporting as well.

The Ugly (Eli Wallach)
Client frustration with the ‘screen scrape’ model is the Achilles’ heel for aggregation. To ensure that the right accounts are linked together and that an advisor complies with the custody rule, SEC Rule 206(4)-2, it is up to the client to enter their username and password to allow the aggregation linkage. These links sometimes break, due to tightening security and website redesigns and require maintenance. It is the advisor who is then in the position of chasing down their client to ensure that the system is working. Advisors do not like being the nudge in the process as they are blamed for the rickety technology, and confidence decreases in planning decisions made as a result.

Aggregation Trends
However as the systems mature, the good is winning out over the bad and ugly. As fee-based advice continues to advance and sophisticated financial planning tools are the norm, the need for aggregation only becomes more important. Here are some of the trends:

  • Due to issues with screen scraping there is a drive to replace it with either direct feeds or network access. Aggregators are constantly adding to the custodians that they can access directly.
  • Advisors have historically not charged for advice on assets that they do not manage (such as 401k assets). With good reporting, this is changing as clients are realizing that there is value in a holistic view of their finances. Some advisors are charging half of their regular advisory fee on held away assets; others are going whole hog and charging the full fee. A key question for a potential aggregation partner: can they provide billing information on held away assets?
  • As the integration of systems continues, more aggregated information is being passed into financial planning systems and CRMs. Some financial planning companies (such as eMoney Advisor) think that this is so important that they do the aggregation for you. This allows an advisor to see a holistic client view, whichever one of their applications they are working in.
  • One of the key values of and the Robo-advisors (see previous post) is that they are providing account-level aggregation bundled into their services. It is an inexpensive way for an investor to access aggregation. This will increase client expectations and advisors will be pushed to provide holistic reporting.
  • Due to the headaches of maintaining aggregation systems for the advisor, many only provide aggregated information to their top clients. As the systems become more reliable and easy to maintain, there will be a move to offer the service to a broader client base.

The good is winning out. Aggregation is winning over aggravation. Even my wife admits that I was ahead of my time, albeit with her normal eye roll.


Share Button
Raef Lee

Raef Lee

Raef Lee is the technology contributor for Practically Speaking and also serves as a managing director for the SEI Advisor Network.

Learn More About Raef Lee

  • I don’t share your sentiment that aggregation is winning.

    We are no closer to a universal aggregation solution for all advisers then we were five years ago.

    The aggregation market is still a niche among financial services, and just a handful of providers have a defacto monopoly on the service.

    • raeflee

      I’m more optimistic.
      I agree that the same ‘basic’ providers: ByAllAccounts, Yodlee and CashEdge are involved in one way or another with most aggregation offerings. This has not changed.
      However many other ‘broader’ providers such as Envestnet, BlueLeaf, eMoney, and Orion have brought to market offerings that often includes the basic providers. In nearly all cases though the ‘broader’ providers are adding more and more direct feeds to enhance the offerings of the ‘basic’ providers, By doing so they reduce the amount of data provided by the ‘basic’ providers and hence can reduce the cost to their clients.
      The ‘broader’ providers have also built out rich suites of services to use the aggregated data in ever more sophisticated ways. As an example I would point to the much better client reporting (of aggregated data) that is available today from these firms, that was not four years ago.
      I would also add that we see that advisors are much more aware of the desire of their clients for aggregation and are using it more effectively and to a broader audience in their financial planning processes.
      Nearly all of the robo-advisors are also including it in their offerings, reaching another, typically new, market (the Gen X / Y wealth accumulator set).
      So, I agree it is a niche; but one that has broadened significantly over the last few years.

      • Sue Glover

        Many advisors that are interested in providing the service for their clients but don’t understand the technology behind it or do not want to pay the cost of services are aggregating via Excel or manually entering the account information into their portfolio management software for consolidation. These firms are providing the service for some of their clients, not all. Some advisors doing it in this manner have no problem with continuing this way. The interest in the technology is there until they see the cost.

  • I bounce back and forth from joy to disappointment with aggregation and its outlook. I started in the industry in the mid-90s and was customer number 2 on Statement One (now Albridge) while with ING. My optimism is driven by continuing to see standards evolve and with T+1 tightening up – those standards should ultimately make the recon side of the equation for aggregators better. Also in seeing custodians invest heavily in extending their platforms through integration with a wide number of third party tech providers. My disappointment (perhaps like Bill) is that from 1999 to now I’ve not seen much in an advancement. It still feels clunky, data standards are hard to get wide agreement upon and many still believe the holy grail of one system one solution will come from somewhere.

    • raeflee

      I remember the excitement of seeing the OFX standard emerging in the late ’90s and being amazed at how far it went. It was one of the best examples of an industry collaborating in a space that overlaps with aggregation.

      I’ve been upbeat on my comments about aggregation in general, but I’m downbeat on the holy grail / one solution coming to fruition.

    • Marie Swift

      Check out Quovo – they are in the process of integrating their “smart data aggregation” solution with several well known companies in the financial services industry. Joel Bruckenstein just wrote about Quovo. See his assessment here:

  • Bob Lloyd

    Another issue I have experienced with aggregation is asset classification. If a particular fund comes through as one class (Bond ETFs are often wrong) and the system isn’t flexible enough for the user to change it, the downstream impact makes the aggregation useless. This is especially true when you hit the planning systems and how they project future returns using their capital market assumptions. I agree with Bill, we have not seen advances in the technology. We have seen a need and desire from the consumers (advisors and end-clients) which has only been answered by better marketing from the vendors.

    • raeflee

      Asset classification is a big problem with aggregation. We get around it in our TAMP model, by having one classification for our clients. It is not as flexible but it allows you to have a clean shot (nicely packaged solution) from financial planning to client reporting without the glitches that occur with custom asset classification.

  • Stephen P

    Hi, Raef – great article! A quick question for you. Any experience with SEI investments and Quicken today? I use Quicken for all our transactions. I see that thru Quicken, you can sync with SEI. Also, you can download from SEI’s website. They work differently but seem to get the job done. Any opinion on which method is better: download from SEI to Quicken or sync thru Quicken up to SEI?
    By the way – my wife feels the same way! I get the eye roll a lot……..

    • raeflee

      Stephen – Good to hear from you. There is little difference between the methods and the data is the same. Do whatever is easiest for you…



Follow Us on Facebook

Recent Tweets