All things change – even things at the SEC. Previously, investment managers could upload text (aka ASCII) files detailing their holdings to Edgar. This quarter, a change was made, requiring the file to be formatted in XML. Investors have 45 days from the end of the quarter to file their 13F reports, so Q2 reports are due today.
Some users that attempted to get these reports done earlier in Q3 expressed frustration with the XML issue and their ability to get more proactive assistance from Advent to address it. Last week, as the filing deadline approached, Advent reached out to clients, alerting them of the change and directing them to an ASCII to XML conversion tool to facilitate the process. In my own experience with Advent’s support team, I found them both helpful and knowledgeable in regard to the 13F reporting issues.
Though Advent’s documentation states that the 13F report and conversion tool requires Axys 3.8.5 or higher, the report from Axys 3.8.5 worked fine when we used it on Axys 3.7 with a client. APX users can use the same utility. The utility was simple to use and worked well; the biggest challenge for users is finding the file they need to convert.
The 13F reporting mechanism is functional, but the setup seems cryptic and disjointed. First-time users expecting a turn-key, intuitive solution will be disappointed. Fortunately, the details of what is required to produce 13F reports are well-documented in Advent’s help file.
How 13F Reporting Works…
By default, the 13F report only includes the equity asset class. It is possible to exclude individual securities through the use of the 13F.est file, but it is not possible to include individual securities. Additional asset classes may be added. Report-specific labels must be added to the 13F portfolio file to make the report work properly.
When the supporting files are properly configured, the report produces detailed holdings and simultaneously generates an inftable.txt file with the same information. This file is placed in the specific user folder (i.g. f:\axys3\users\amy) of the person running the report on the network version of Axys or the root folder of Axys on the single-user version of Axys. When users have generated a 13F report without missing data or error messages, they are ready run to the conversion utility to produce the inftable.xml file and upload the information to the Edgar site.
This quarter, running and filing 13F reports was more challenging than it has been in the past, since users were forced to correctly implement the 13F report in order to successfully generate an XML file. Based on my experience with users, this was something they had not been doing in the past. Most users would run the report to get something close to what they needed and then manually modify the text file, rather than keep all of the information updated in the 13F portfolio and 13F.est files. Going forward, the process will still require that new securities and relevant asset classes be classified specifically for the 13F report, but future report runs should be simpler.
For more info on 13F reporting, refer to the SEC’s document detailing Frequently Asked Questions (FAQ).
–
About the Author: Kevin Shea is President of InfoSystems Integrated, Inc. (ISI); ISI provides a wide variety of outsourced IT solutions to investment advisors nationwide.
For details, please visit isitc.com, contact Kevin Shea via phone at 617-720-3400 x202 or e-mail at kshea@isitc.com.
I have been talking about the evolution of investment reporting for years and telling anyone who would listen that their clients will soon have other investment reporting options. My dream or vision of the future includes me (of course) providing the interface to facilitate getting data from financial services firms to a secure data warehouse via xPort where their clients could download the data for analysis on an open reporting platform.
As I discussed this with one of my clients at a recent Schwab conference, they shared their concerns with me. I was told, “It’s basically a problem of apples and oranges.”
My long-time client and friend explained to me that they would have concerns that data they reviewed and corrected (“apples”) might be reported as uncorrected data (“oranges”).
Though data aggregators exist and have much of the data required, they won’t have it all unless advisors participate and cooperate in the process. Reconciliation needs to be performed and maintained on an ongoing basis with respect to assets under management, inception-to-date performance, and tax cost. No one is more motivated and qualified to maintain that data integrity than the advisors whose decisions, service, and bottom line are impacted by the quality of that data.
Big Brother will have access to this data too – that’s not part of my plan, but just a given eventuality and perhaps already a reality. Regulatory powers will employ predictive analytics to proactively search for potential fraud. For example, an advisor reporting the same exact composite return two years in a row is possible, but highly unlikely and worth investigating. When more scrutiny is applied to this data, one can only hope that the benefits of additional regulation will outweigh the compliance headaches.
Enter SigFig
According to their web site, SigFig was born out of the noble desire to serve the millions of investors that don’t meet typical portfolio minimums and cannot afford quality investment advice. Your clients may be using SigFig already. If you haven’t seen it, SigFig is to investment reporting what Mint is to personal financial reporting. Unfortunately for investment advisors, SigFig has a similar business model, meaning that investors do not pay for the service, but instead get solicited with offers that appear relevant to their investments; for example, “this fund is outperforming your fund “or “your investment advisor is overcharging you.”
Using SigFig, investors can view a dashboard summary of investment reporting information that looks better than what many investment advisors currently provide to their clients. However, as one familiar the details of performance calculations, client billing, and reconciliation, I am naturally concerned about possible data quality issues. The idea of replacing the sound advice of an investment professional with algorithms designed to place ads – even though those ads are intended to be unbiased – seems inherently flawed.
In my preferred vision, advisors would pay an interface fee and their participating clients would purchase SAAS reporting or a Droid/iOS app. Idyllic as it might seem, this version of the future would allow investment advisors and their clients to share views of reports created by impartial third-party reporting sources.
SigFig is a step in the right direction, and should serve as warning to investment advisors that more robust investment reporting information will be delivered to their clients whether they participate in the process themselves or allow their clients to find it on their own.
The Best Investment Reports
It makes perfect sense that your firm should want to provide the best reports possible to your clients, without incurring an unreasonable expense or maintaining an unmanageable reporting process. Unfortunately, what’s best for your firm and what’s best your client may be two different things. You want to validate your investment methodology and highlight the value continued use of your firm offers, but you also need to keep your client’s best interests in mind. More than one advisor I have worked with in the past has chosen to shy away from slick, eye-popping reports, instead favoring black-and-white reports where simple numbers alone underscore performance. In the opinion of these advisors, the relationship with a client is more important than fancy reporting and such reports can distract investors.
Call modern reports a prudent best practice or self-serving marketing effort designed to ensure your firm’s survival. The truth is that they are a little of both. Clients expect decent reporting, so substandard reports are now passé. Quarterly report packages like those I have helped clients create for twenty years are also known as presentations, and perhaps that is a better name for them. It describes what investors are really trying to do at quarter end.
Sample Client Reporting Presentation
Every quarter, advisors have an obligation and opportunity to make a presentation of how their clients’ investments are doing. Most advisors also write a quarterly letter in which they address the near-term market conditions and reasonable expectations for the future while trying to impart some relevant wisdom to their investors. Advisors are, in fact, presenting and remarketing to their clients on a quarterly basis. Good presentations typically illustrate an advisor’s general knowledge of the markets, educate clients, and show how the advisor adds value. The reports included in these presentations also present holdings analyses that provide clients with additional insight into their investments, but, most importantly, these reports provide the client with performance figures and comparative benchmarks for various time periods.
Report Development or Adoption
For some firms, proprietary custom report writing is required to meet the needs outlined above. With this requirement comes the necessity to employ staff or contract with vendors to produce and maintain the reports. The effort to produce high-quality reports can be daunting whether the project is handled internally or outsourced. Many custom reports, by definition, are in flux. In a typical quarter, custom reports may undergo additional feature enhancements and require maintenance modifications or bug fixes. In order to maintain custom reporting systems, an ongoing commitment of time and money is necessary.
Advisors may want to create distinct custom reports that are part of their brand, but given the potential complexity and cost of creating those reports – the best investment reports for those with limited funds are the ones that already exist.
–
About the Author: Kevin Shea is President of InfoSystems Integrated, Inc. (ISI); ISI provides a wide variety of outsourced IT solutions to investment advisors nationwide.
For details, please visit isitc.com, contact Kevin Shea via phone at 617-720-3400 x202 or e-mail at kshea@isitc.com.
In my role over the years as a designer and developer of client reporting packages for dozens of investment advisors, I typically work with decision-makers to facilitate the creation of new client presentations. Many of my clients already know what they want and just need help making it happen.
Though I have an excellent understanding of what is important to most investors and their clients, my opinion is seldom solicited. I speak up when an issue demands it, but most of the time I defer to advisors, listen, and do my best to create what my clients (investment managers) want. In many cases, the bulk of the project is spent on individual report exhibits with little emphasis on the way reports are organized and presented to clients.
I have worked with firms who have wanted to do the bare minimum for their clients (appraisal, and invoice) as well as clients that go above and beyond their duty to report. However, even those with the best reporting intentions can err by including a level of complexity and detail that will not benefit their clients.
On occasion, I am lucky enough to work with investment professionals who are modern thinkers and savvy marketers. The combination of these important characteristics leads to engaging projects and sophisticated report packages. These advisors apparently understand what their clients want to see, and are determined to make the desired reports a reality.
Instead of reporting only what is required, these advisors are trying to exceed the reporting expectations of their clients, and in doing so they engender trust. Their reports are comprehensive and transparent. As such, they have the possibility of highlighting poor performance, but that is a risk that needs to be taken by most advisors. The significance of disclosing this level of information is recognized by investors’ clients and should improve client communications.
In terms of presentation, reports should be bound, with a cover and/or table of contents and well-organized. When a client opens the report up, the most important things are first, and less important details follow. For example, there is a hierarchy to the way the reports are organized in the package such that the relationship is reported first and individual account reports later. You can view a full report sample illustrating this approach here. In this specific example, the physical report package opens to display pages two and three of the PDF document, which are a relationship summary. The pages that follow provide account-level information.
Reports are typically bound electronically (i.e. PDFs) for those who deliver reports through portals or encrypted email, but firms send most their reports out on paper due to low adoption rates. Paper copies should look professional, and there are cost-efficient options to make this possible whether it is done through printing report packages on 11×17 stock with a saddle stitch or via manual binding of reports after they have been printed. Some of the manual binding options are fairly quick, but shops with hundreds or thousands of reports should not bind reports manually.
Another key to producing impressive report packages is the one-page summary, which allows a client to look at a single page if that is all they want to see. Usually, it is an exhibit that shows them where their investments are, how much they are worth, how they have grown, and how they have performed over various time periods. One-page summaries are also produced to provide information about specific asset types and performance. The idea is to create an executive summary. Clients really want a concise overview of their investments, and rarely look at all the other details that get sent to them on a quarterly basis.
How will you know if your reports have made an impression?
You will hear it from your clients. Even hard-to-please clients should appreciate these types of report improvements. So get to work now, and your new report packages could be ready for next quarter.
–
About the Author: Kevin Shea is President of InfoSystems Integrated, Inc. (ISI); ISI provides a wide variety of outsourced IT solutions to investment advisors nationwide.
For details, please visit isitc.com, contact Kevin Shea via phone at 617-720-3400 x202 or e-mail at kshea@isitc.com.
Your firm has just completed its implementation of APX. All systems are go including a small collection of SSRS reports, which meet some but probably not all of your firm’s requirements. You have new reporting capabilities, and now the question is “will your firm ever use these new features?” SSRS is also known as Microsoft Reporting Services, which sounds a little less complicated. No matter what the name is, SSRS is a beast – the following issues will challenge your firm’s ability to embrace and leverage SSRS technology for the foreseeable future.
1. TOOL INSTALLATION – SSRS tools like Report Builder and Business Intelligence Development Studio (BIDS) will not be installed on most of your PCs. They are kept at an arms-length from most users, and rightfully so. Though SQL Server Manager and SSRS reporting tools can be accessed on the database server, it currently isn’t Advent Software’s policy to install the applications that give users access to these tools on all users’ PCs. Assuming you have someone at your office with relevant report-writing experience, getting their system configured to make SSRS reports and/or modifications is special request. I have worked with many APX users. By default, most of them do not have access to the tools, so they could not use them or even see them. Some firms using APX 3.x do not even have access to SSRS reports because they have not been installed.
2. ENVIRONMENTAL COMPLEXITY – Once the tools have been installed, the collection of SSRS reports is open to users’ review and modification, but the infrastructure and understanding it requires is cumbersome. Most APX users do not have the skills necessary to create SSRS reports, and very few of those who do are interested in doing it. For those unfamiliar with SSRS and other similar report-writing tools, seemingly simple reporting modifications can be a pain if datasets aren’t designed with your specific reporting needs in mind. Those writing reports need to make frequent backups. Occasionally, reports can become corrupted and cause their writers to lose hours of work.
3. TIME – Compared to creating compound reports and building reports using Advent Report Writer Pro, developing reports using SSRS and other similar report writers like Crystal takes much more time. This is the norm, but not the rule. There are specific report-writing tasks that SSRS is more efficient at performing, but overall report-writing with SSRS is exponentially more complex than using Advent’s standard report-writing tools. This is due to the fact that SSRS development and modifications are the domain of Business Intelligence (BI) professionals and other system integrators who do it for a living. Report Writer Pro and compound reporting were developed by Advent to be used by investment operations end-users with limited technical know-how. SSRS was created by Microsoft, and is not designed with these same users in mind. Some simple SSRS reports take minutes to create, but it is much more likely for users to spend hours, weeks or even months working on reports.
4. COST – Since your firm is unlikely to have BI report developer resources internally, you will need to hire outside resources to develop your reports. That sounds familiar, right? Assuming that you, like many Advent APX clients, spend somewhere around 100k to 200k annually on APX, you can expect to pay at least another 15k to 30k annually to get the reports you want and keep them maintained by qualified third-party resources. You may be able to get the work done cheaper, but anyone delivering reporting services on a platform this complex at a significantly lower price will not be in business for long.
5. AVAILABILITY OF QUALIFIED RESOURCES – Since SSRS is still relatively new to Advent users, there are very few BI resources available with specific experience working for APX users. The learning curve is steep. Significant integration and reporting work needs to be done for individual firms to fully embrace SSRS as their reporting platform, and short-term that leads to a smaller pool of available resources to do the work.
RUNNING WITH SSRS
Due to the complexity inherent in combining various data elements via SSRS and workflow automation, some APX users may still be better off using the REPLANG and compound report functionality first introduced in Axys. Standardizing your firm’s reports using SSRS on Advent’s APX platform could be tough. For many users, standardizing will mean trying to make standard (REPLANG) reports look like they were created in SSRS, or worse, completely reengineering those reports in SSRS.
Advent deserves credit for implementing SSRS. It is a progressive move aimed at satisfying the enterprise users for which APX was designed, but some firms using APX should ask themselves whether they truly are an “enterprise” before they start implementing tools designed for enterprises. (In the near future, I will be blogging on the issue of firm identity and the role it plays in the success or failure of technology implementations.)
Long-term, there is good news for many APX users. Though creating reports can be very complex, the format of SSRS reports is extremely portable, which should eventually lead to more report sharing among APX users. Unfortunately, while this may be good news for APX users, BI developers and integrators like ISITC have to be more concerned with the portability of their end product.
One could literally spend hundreds of hours developing a report and have someone walk away with it. In other stickier environments, reports might be developed at a discount, but an integrator’s sunk costs could easily be recouped through a nearly guaranteed long-term maintenance agreement. Given concerns regarding portability, you should expect to pay a premium to have SSRS reports developed for your firm.
Firms making a significant investment to develop distinctive reports in APX now should be equally concerned with maintaining those reports in the future. Advent and third parties that create reporting solutions regularly make updates to address bugs and/or add functionality to reports. Though APX users may not realize it, this environment is still fairly sticky. Those unfamiliar with specific reports can easily perform the simplest modifications, but firms will do well to retain those that write their SSRS reports to address more complex modifications in the future.
–
About the Author: Kevin Shea is President of InfoSystems Integrated, Inc. (ISI); ISI provides a wide variety of outsourced IT solutions to investment advisors nationwide. For details, please visit isitc.com, contact Kevin Shea via phone at 617-720-3400 x202 or e-mail at kshea@isitc.com.
All things change – even things at the SEC. Previously, investment managers could upload text (aka ASCII) files detailing their holdings to Edgar. This quarter, a change was made, requiring the file to be formatted in XML. Investors have 45 days from the end of the quarter to file their 13F reports, so Q2 reports are due today.
About the Author: Kevin Shea is President of InfoSystems Integrated, Inc. (ISI); ISI provides a wide variety of outsourced IT solutions to investment advisors nationwide.
