Reillyand, Inc.
Reillyand, Inc. |
|
|
Periodic Client Portfolio Reports Problem: A Wall Street Investment firm manages 401(k) portfolios for their clients. This firm prepares Quarterly reports for each Client showing the performance of the portfolio over the previous Quarter, Year, and Three Year periods. This easily required the quarterly updating of well over 1000 charts and the collation of well over 7500 pages into final Client-by-Client reports. The process took approximately 6 weeks from the the time the data was available until the reports were able to be sent. Solution: Periodically, a database of funds that can be included in a prospective portfolio is automatically updated from syndicated data sources. (The same database as the Proposal Writer uses.) All funds including each of the 1000+ charts (including data-driven footnotes) are now automatically updated as soon as data is available in a matter of minutes. A separate Excel spreadsheet workbook is maintained with each Client's portfolio of funds. This allows a single source of controlling the Client portfolio's which can change from period to period. Each Client report is programmatically assembled and collated based on this file. Since proof-reading has also been eliminated, the completed Client Reports are programmatically sent to the printer as one batch print. Once the process starts it is only necessary to have someone restock the printer with additional paper as necessary. Finished client-ready reports are now available the day following the availability of the new data. |
|
Send mail to brian@reillyand.com with
questions or comments about this web site.
|
