Why Is Client Reporting So Difficult?
Why do portfolio management systems offer so little in the way of flexibility when it comes to their reports. Instead of using Crystal Reports (or something similar), they build their own proprietary solutions, making it much harder for firms to do anything more than stick their logo on the reports.
Wall Street & Technology magazine did an informal survey among their readers and found something astonishing:
…nearly half the firms reported that they use an enterprise solution that is a combination of a proprietary solution and a vendor-supplied solution for client reporting. Most said they use Business Objects’ (San Jose, Calif/Paris) Crystal in combination with proprietary solutions… Significantly, however, about 80 percent of the firms that participated in the survey said their platforms do not meet all of their periodic and ad hoc reporting needs.
I assume that by “platforms” they’re talking about portfolio management software, which uniformly lack good reporting solutions. How hard would it be to rewrite your client reports using Crystal, and let your clients edit them? (Ok, probably pretty hard.)
In the case of Techfi, we consciously avoided Crystal because we despised their technology , but regretted the decision almost immediately after releasing our own custom report writer–any minor quibbles with Crystal tech were far outweighed by the complexity of creating our own report writer. I suspect that Advent’s reasons stem from a “we build everything ourselves” mindset, and in the case of Centerpiece/PortfolioCenter, they probably have an existing library of reports in DB4 or whatever their original software was written in.
So the end result is that clients find it extremely difficult to write custom reports, which is something most large advisors would love to do. You can’t easily go in and move fields around, change fonts, colors, or add a graph here and there. Let alone build one from scratch that has a new calculation. Most advisors become dependent on the professional service departments of their PMS vendor.
The Wall Street & Technology article mentioned something called SS&C Pages, which I’d never heard of before. Here’s how SS&C describes the product:
Pages… generates customized client statements automatically. Pages helps you enhance client service by producing impressive client statements that automatically assemble data from your portfolio management, CRM, performance measurement and other investment systems.
So it’s an overlay on top of your existing portfolio management solution. Their stock reports certainly look good (compared to Advent, Centerpiece and Techfi at any rate):
But I still feel this quality of reporting is something that should be a standard feature in a portfolio management system. The fact that there’s an entire market built around substandard portfolio management reporting means there’s a lot of room for improvement.
Alan said,
March 30, 2008 at 7:31 am
The PMS systems market indeed doesn’t cover this aspect of the asset management business very well, but my experience of the market has also found that most mid to large asset managers keep and client reporting departments away from [backoffice] operations which seems to match the way the software providers seem to work.
The article relating to SS&C Pages highlights one of the few provider companies that has addressed this issue - Pages is part of a larger suite that SS&C have been providing for years - but Pages is seen as old world and itself has been seen in less than a welcoming light by anyone who has developed or used it…. but it is the dominant provider simply because it’s been around for years now.
However, there is light at the end of the tunnel for best of breed providers focusing on the client report generation market - notably FundWorks (www.fundworks.com) and Vermilion Software (www.vermilionsoftware.com) whos offerings focus mostly on the Factsheets market (FundWorks) and the Valuation and Investment Performance reports market (Vermilion).
There are also a number of other more generic providers including BiSam, Docucorp/Skywire and Desknet - all with their own specialist aspects (Desknet only supports Quark), Skywire and BiSam are more generic reporting tools - for these and the full market I’d recommend typing “client reporting software” (with the quotes) into Clusty.com.
One thing to note with your comments on editability and customisation for clients - all of these providers can no doubt add a client logo and client branding to their outputs - but only SS&C (Pages) and VermilionSoftware (VRS) can provide pure MS-Word/MS-PowerPoint output that can allow desktop changes where necessary (care is required to differentiate between .rtf and .doc formats as some providers claim these MS- formats but only the two noted above will allow you to edit content - along with inserting new pages or edit MS-Draw charting - and still have a table-of-contents and page numbers working after the edit)
Matt Abar said,
April 18, 2008 at 8:14 am
Alan, I just noticed this–thanks for a couple great links. Vermilion and FundWorks both look interesting, I may do a follow up post on them.