Finding errors in PortfolioCenter

DEC 06, 2012
Financial advisers at the Technology Tools for Today, or T3, conference this month in Dallas were intrigued when told about a new product, ReportCheck, a third-party application designed to automate the process of checking for errors in Schwab's PortfolioCenter. None of the advisers had heard of ReportCheck, but those with whom I spoke said that they welcome the idea and would be interested in hearing more about it. PortfolioCenter is a product of Schwab Performance Technologies Inc., a subsidiary of The Charles Schwab Corp. The application is one of the most commonly used portfolio management programs among advisers, irrespective of what firm they use as a custodian for their client assets. But despite PortfolioCenter's widespread use, many advisers love to complain about it. One of their frequent criticisms is that they must manually review printed performance reports generated by PortfolioCenter to find errors before sending the reports to clients. Although PortfolioCenter does have some error-checking features, ReportCheck from John Norwood Consulting LLC (norwood-consulting.com) makes it easier to discern mistakes, the company says.

"EASILY INTEGRATED'

“ReportCheck is designed to automatically identify a set of common errors or potential issues that occur in PortfolioCenter and is easily integrated into your work flow,” said John A. Norwood, principal of the consultancy and a former executive at Schwab Performance Technologies. “It notes many things, from missing prices to invalid returns or outlying benchmark returns or index returns relative to absolute high and low limits, and those relative to mean return across similar accounts, missing asset class, sector or subsector assignments, missing market value on credit, debit, transfer, and receipt transactions, etc,” Mr. Norwood said. “The issues I most often run into with PortfolioCenter are in integrating its reports with the data we receive from LPL's [custodial] platform,” said Daniel Zalipski, a user of PortfolioCenter and now Report-Check. Mr. Zalipski, a technology analyst with registered investment adviser Vantage Financial Partners Ltd., was referred to me by Mr. Norwood. Vantage Financial Partners has $220 million in assets. “There are a few transaction types that are referred to differently between the two systems, and ReportCheck provides me a very easy to-use means of checking my reports on a single spreadsheet. [It] also helps a lot with identifying outliers — for example, an account reporting a 400% gain in the last year — or cash flow changes, all of which I can sort,” Mr. Zalipski said. He performs a monthly audit of 700 accounts, so it is important to be able to save time checking reports. For its part, Schwab acknowledges that ReportCheck can be a companion to PortfolioCenter.

SCHWAB RESPONSE

“There are a number of different tools in the PortfolioCenter product that help firms find and correct errors with performance calculations,” Mike Williams, a managing director at Schwab Performance Technologies, wrote in an e-mail. “Depending on the size and complexity of a firm, ReportCheck could be a nice addition to take validation to a higher level. We also continue to make enhancements and define best practices to help firms with their error-checking processes,” Mr. Williams wrote. “One of the unique benefits of using PortfolioCenter is that we are open to having third parties write these kinds of tools. Advisers who use PortfolioCenter have lots of options as to how they want to run it: on their desktop, outsourced to Schwab or through a third party,” Mr. Williams wrote. Pricing for ReportCheck is based on the number of accounts that an adviser runs through the system. An annual subscription costs $1 per account per year for the first 2,000 accounts, and scales down as the number of accounts increases to 75 cents per 4,000 or more accounts and 35 cents per for 6,000 and up. There is a minimum purchase of 1,000 accounts. * * * Among the most interesting new things I saw on the exhibitor floor at T3 were developments at MacroRisk Analytics (macrorisk.com). The application, which I first wrote about in the fall of 2010, not only has a plethora of new analysis features and measures but also several interesting integration features, including one with PowerAdvisor, a portfolio management application from Cornerstone Revolutions Inc., which I wrote about in June. In a nutshell, the integration, in the form of PowerAnalytics, combines the macroeconomic-analysis capabilities of MacroRisk with the portfolio-reporting capabilities of PowerAdvisor, a pairing that is the first of its kind, as far as I know (powerinvestmenttools.com). There are four subscription levels, beginning with the most basic, which allows users to measure the impact of thousands of economic indicators on a client portfolio. Higher levels allow an adviser to compare multiple portfolios and factor additional measures, including beta, into calculations. Pricing hasn't yet been finalized. MacroRisk Analytics itself has multiple packages available for advisers, ranging from the fairly basic Fiduciary subscription for $600 annually to the Analysis Suite, which is $5,800 annually. Over the next few weeks, I will go into more detail regarding the many new features available, as well as several other vendors I met with and sessions I attended at the T3 conference, on my blog (InvestmentNews.com/technology). [email protected]

Latest News

Advisor moves: Cetera's enterprise channel draws experienced Osaic duo in California
Advisor moves: Cetera's enterprise channel draws experienced Osaic duo in California

Meanwhile, LPL attracted a five-advisor team managing $380 million in Kansas, while a veteran with stripes from Morgan Stanley, UBS, and Fidelity has joined Prime Capital Financial.

Dynasty CEO teases 'Virtual Shirl' as RIA execs debate AI's workforce impact
Dynasty CEO teases 'Virtual Shirl' as RIA execs debate AI's workforce impact

At Goldman Sachs’ RIA conference, Dynasty’s Shirl Penney said an AI clone trained on his emails and speeches could be the first of “hundreds of digital employees.”

Captrust adds $1.25B Pennsylvania firm in latest push into private wealth
Captrust adds $1.25B Pennsylvania firm in latest push into private wealth

The top-ranked RIA by total AUM continues to scale its wealth management arm, bringing its Pennsylvania presence to five offices.

WallStreetBets takes on the SEC — and makes a surprisingly sharp case
WallStreetBets takes on the SEC — and makes a surprisingly sharp case

The Reddit trading community's formal comment letter against the proposal is drawing widespread attention across finance and tech circles.

Frustrated former advisor launches AI-powered CRM with $8B RIA client
Frustrated former advisor launches AI-powered CRM with $8B RIA client

Chicago Partners Wealth Advisors is helping shape the platform's product roadmap after switching from a legacy system.

SPONSORED Beyond wealth management: Why the future of advice is becoming more human

As technical expertise becomes increasingly commoditized, advisors who can integrate strategy, relationships, and specialized expertise into a cohesive client experience will define the next era of wealth management

SPONSORED Durability over scale: What actually defines a great advisory firm

Growth may get the headlines, but in my experience, longevity is earned through structure, culture, and discipline