The Total View Is Back
July 26th, 2010 by John Luciano No comments »Advisor Exchange’s Reconciler Solution Dramatically Reduces Manual Data Entry
March 5th, 2010 by John Luciano No comments »(Note: I am the Vice President of Business Development at Advisor Exchange)
We’ve been hard at work over the past year building out our newest solution – Reconciler. The need for a tool such as the Reconciler is required for any firm looking to pull HTML harvested (screen scraped) data into performance reporting software.
Problem One
Missing ‘Buy’ transactions in the data files - This is most often seen when clients make contributions to retirement accounts. The contribution – a cash deposit – is included the data file, but the second transaction for the purchase of the securities is not available. This is due to the financial institution website layout which will very often “wrap up” the contribution and the buy into a single line transaction. Why do they do this? To make it easier for their account holders to see the activity. But the problem is that HTML harvesting scripts have a hard time breaking this into two separate transaction. And to take that a step further, some accounting systems require three or more transactions for contributions:
- Deposit into cash account
- Sell out of cash
- Buy of securities
The advisor is left with only 1/2 the transaction in the reporting system – a whole bunch of deposits of cash with no buys. This leads to quite a bit of manual data entry on the part of the advisor or staff.
Problem Two
Missing symbol/cusip in the transaction file - The data file includes share amount, price, transaction type, total value, and description but the file does include symbol/cusip to tie the transaction back to a position in the portfolio. You can probably imagine how much manual data entry this leads to if you only have ‘Buy 500 shares at $47.87 for a total of $23,935.’ What was bought?
The Reconciler now allows advisors to create global rules to resolve both issues. The results are dramatic. Advisors are reporting that they are spending 50% – 70% less time reconciling aggregated data from Advisor Exchange as compared to the time spent pre-Reconciler.
Advisor Exchange will be holding demonstrations of the Reconciler over the the next 3 months. I will post the dates as they become available.
Neuralus Integrates CashEdge Account Aggregation
February 10th, 2010 by John Luciano No comments »Neuralus, an online budgeting software used by financial advisors that analyzes bank and credit card transactions, is now integrated with CashEdge’s AllData account aggregation solution. Another indication that the demand is growing for integrations with account aggregation providers.
You can read the press release here
WealthTouch – Account Aggregation For The Super Rich
February 3rd, 2010 by John Luciano No comments »A colleague of mine sent an email the other day with the subject “Who is WealthTouch,” along with a link to a recent FA Magazine article covering what I thought was a new entry in the account aggregation domain. After reading the article, my reply back to my friend was “I suppose it’s comparable to that solution BAA (ByAllAccounts) offers – WebPortfolio… but a much, much more sophisticated platform for the uber rich.” After a little digging, it appears that I was spot on.
WealthTouch (WT) is an account aggregation, expense management, and wealth reporting platform for Ultra-High Net Worth families. Unlike your typical HNW individual who has one or two advisors and a handful of accounts at various custodians, the WT client has great diversity across a much larger spectrum of investments and a number of different money managers watching over their finances. This client, according to WT, requires a more sophisticated platform to pull together a much more complex estate structure which consists of hedge funds, private equity, investments, and other assets — The typical WT client is a family with over $100 million in assets. » Read more: WealthTouch – Account Aggregation For The Super Rich
Yodlee Does Taxes – Forms Strategic Alliance With H&R Block
January 28th, 2010 by John Luciano No comments »Yodlee and H&R Block entered into a strategic alliance this week to integrate H&R Block’s tax preparation service with Yodlee’s account aggregation platform. This new solution will allow Yodlee users to automatically export expenses aggregated from their online accounts – banking, credit cards, utilities, etc. – into H&R Block’s online tax forms. For the consumer that uses online tax filing software, the integration will help reduce the time spent manually entering information off statements and receipts. And it can be done throughout the entire year, not compressed into the few weeks leading up to April 15th.
Mint.com already integrates with Intuit’s TurboTax, so this isn’t the first account aggregation > online tax solution integration we’ve seen. And it probably won’t be the last. Account aggregation vendors have been focused over the past decade on servicing three distinct markets – consumers, banking, and financial services providers. But the tax prep world, CPAs in particular, is untapped.
Look for the Yodlee / H&R Block integrated solution to be rolled out in time for the 2011 tax season.
You can read the CNNMoney story here.
A “Screaming Need” For Account Aggregation
January 22nd, 2010 by John Luciano 2 comments »Almost four years ago, Mint.com put online personal finance management and budgeting on the map. A flagship website in the Web 2.0 world, Mint revolutionized how this Facebook generation of users could track their finances across multiple accounts. Mint made it cool, fun and hip. Part social network, part Quicken, Mint helped their users understand where all their money went each month while providing a big picture view, a total view, of all their finances. Mint was a killer application.
Online banking, compared to Mint, was boring and limited. Sure it was revolutionary back in the 90’s, but that was so last century. Today, with the evolution of sites like Mint, Geezeo, and Wesabe, large banks are finally seeing the light and are incorporating interactive budgeting tools and account aggregation into their online banking portals.
There’s a story in the NY Times today which discusses this trend in online banking. The piece highlights some interesting points related to account aggregation which advisors may want to pay attention to. For one, large institutions now understand their clients want to see all their finances in one place. As one analyst in the story puts it,”There’s a screaming need for someone to come through and help them organize, and pull all that account data in one place.”
You can read the NY Times article here.
>>Great to see my pals over at Geezeo get a mention. I know Peter Glyman and Shawn Ward. They’re solid guys, and they’ve built an incredible platform.
ByAllAccounts Awarded Patent
January 19th, 2010 by John Luciano No comments »ByAllAccounts, a leading provider of account aggregation to financial advisors and wealth managers, was awarded a patent for their method of aggregating and downloading financial data.
According to the release:
“ByAllAccounts was awarded a patent for the company’s “Financial Portfolio Management System and Method” on December 29, 2009. The patent is directed to ByAllAccounts’ technology for retrieving financial information from various institutions by automatically logging in and downloading the data. ByAllAccounts can retrieve data from multiple institutions in multiple formats. The company’s service normalizes the retrieved financial information and generates a financial portfolio, bringing together the status and details of all of the financial accounts associated with an individual investor.”
Congratulations to James Carney and his team. You can read the press release here
As an aside, you may recall Yodlee and CashEdge settled a lawsuit in 2007 after Yodlee claimed CashEdge infringed on their data aggregation and funds transfer patents.
New Aggregation Players In 2010?
January 7th, 2010 by John Luciano 2 comments »Davis Janowski over at InvestmentNews appears to have some info on new players entering the aggregation space in 2010. Be interesting to see who jumps in. I would imagine Yodlee is coming back into the advisor space. And I’ve read in more than a few places that Intuit, remember they purchased mint.com, is going to offer a solution for financial advisors.
Account Aggregation Vendors – A Quick Guide
December 21st, 2009 by John Luciano 3 comments »Over the last year, ongoing market volatility has created a revived demand for account aggregation to help facilitate smart financial decisions for clients. So, to help shed some light on the aggregation options available to advisors, I’m going to offer you a quick overview of three of the leading account aggregation vendors in the independent advisor space – Advisor Exchange, ByAllAccounts, and CashEdge.
All three vendors offer a whole new paradigm in data aggregation and offer financial advisors a way to increase productivity, improve operational flexibility, and reduce costs. Simply, in addition to providing the dynamic account aggregation technology you need for a comprehensive view of your clients’ total portfolio, including assets that are held-away, these vendors can “push” aggregated client data into third-party applications you uses to run you business, eliminating the time spent manually collecting and entering financial account information. And that means more time in front of your clients.
The innovative, integrated approach offered by these vendors continues to win accolades from their clients, some of which are the most well-known wealth management firms in the financial services industry, for delivering innovative tools, ease of use, and flexibility to integrate the data into 3rd party applications. » Read more: Account Aggregation Vendors – A Quick Guide
Don’t Wait Until a Client Retires to Advise on Held-away Assets
December 16th, 2009 by John Luciano 1 comment »Guest Blogger: Bill Winterberg
I am excited to introduce today’s guest blogger Bill Winterberg. Bill is a CERTIFIED FINANCIAL PLANNER™ professional, technology consultant to financial advisors, and technology editor for www.advisorsforadvisors.com.
It should be no surprise to financial advisors that assets from retirement plan rollovers make up a good portion of a firm’s assets under management.
In one report from Tiburon Strategic Advisors titled Financial Advisor Target Markets: Focusing One’s Strategy, one of the data points notes that one-fifth (20%) of all financial advisors’ assets under management come from retirement plan rollovers.
For fee-only advisors, retirement plan rollovers account for nearly two-thirds of all the advisor’s assets under management! For firms that bill on assets under management (AUM), rollover assets account for a significant portion of a fee-only firm’s revenue.
Unfortunately for advisors, most prospects don’t walk in the door ready to roll over their retirement plan. Instead, prospects (who become clients) connect with an advisor at some point in the accumulation phase while looking ahead to retirement, say five or ten years down the road.
In this case, advisors prepare a retirement plan to estimate how much money needs to be saved in various accounts to best meet the retirement income needs once the client stops working. Taxable and IRA accounts are typically moved to the advisor’s custodial platform, but the qualified retirement accounts remain captive inside the client’s current employer plan…. » Read more: Don’t Wait Until a Client Retires to Advise on Held-away Assets