Investment Tracking
Module Sample Reports
Investment Tracking Module
Graphic Report Features
The CDS Graphic Report feature allows you to present your client investment data in 3-dimensional charts
and graphs. Clean and precise pie and bar charts add visual clarity to your consolidated investment
statements and portfolio reports.
Graph and Report Features:
4 Include all investment, policy, or portfolio position values. You can also filter down to any
combination of accounts, portfolios, policies, or investments and then represent this data graphically.
4 Create any title and disclaimer text.
4 Pie charts can show data in slices by dollar value or percentage.
4 Bar charts display data by dollar value.
4 Print reports and graphs together or separately, if desired.
Effective Investment and Portfolio Report Supplement:
The assets you select for the investment report are also applied to the chart, giving you an effective
supplement to any consolidated statement or portfolio report presentation.
You Get Six Basic Graph Sorting Options:
Standard Category: Stocks, Bonds, Mutual Funds, etc.
Asset Class: Growth, Equity, Large Cap, etc.
Investment Name: Coca Cola, IBM, MFS Growth Fund, etc.
How Held: Directly Owned, IRA, 401K, etc.
Owner: Client, Spouse, Joint, Community Property, etc.
By Account or Policy Number
Investment Performance
Reports
Investment Performance on these reports are time-weighted and
geometrically linked on a monthly basis using the Modified Dietz method
as described in the AIMR Performance Presentation Standards Handbook,
2nd Edition, 1997 version. What it means in simple English is that a return
is calculated for each month based on the transactions, and then multiplied
or chain linked to derive at a return for a specified period.
Investment Performance
Report Setup
Run reports for any monthly date range, for any or all portfolios, by sector
or asset class, or for a specific investment within a portfolio.
Performance calculations can also be viewed by ad hoc categories such as
by industry, fund family, fund objective, how held, owner, etc.
Performance Report Descriptions
• Portfolio Performance Report shows the overall performance of a selected portfolio
with time-weighted returns given a user-specified date range or from inception.
• Portfolio Performance Summary shows the monthly market valuations, monthly
returns, contributions and withdrawals, and cumulative returns for a selected portfolio
or position (including variable annuity sub-account) with or without income.
• Performance Valuation Summary shows in detail the market valuations and returns
based on the transactions summarized for a portfolio or position (including variable
annuity sub-account).
• Portfolio Performance by Standard Category/Asset Class shows the current value,
percent of portfolio, and cumulative and annualized returns of each category (sector)
or asset class. A total return (return for the entire portfolio) is also shown.
• Portfolio Performance by Standard Category/Asset Class – Detail shows all of the
investments under each category (sector) or asset class. Three levels of returns are
shown: a return for each position, sector or asset class, and total return (return for the
entire portfolio).
• Period-to-Date Returns Report can be shown by standard category (sector) or asset
class with or without income for the following periods: Last Month, Last 3 Months,
Quarter-to-Date, Year-to-Date, Last 12 Months, and Inception-to-Date.
• Top 10 Holdings Report shows the ten best-performing investments in the portfolio.
Among the top ten, holdings can be sorted by returns from highest to lowest, by
current value from largest to smallest, by shares from most shares to the least, or by
alphabetical order.
Position-Based Consolidated
Client Statements and Reports
Consolidated statements and reports provide ongoing investment tracking to support
investment and financial planning decisions. There are a variety of flexible,
understandable investment statements available from the system. These reports were
designed for the clients to understand. These reports can also be run for any performance
or family portfolio.
The annualized return reports in this section are dollar-weighted, meaning transactions
and position values involving large dollar amounts affects the ROR calculation more than
transactions and position values involving relatively smaller dollar amounts.
Position-Based
Client Statement & Report Setup
Run reports for any as-of-date or date range, for any or all clients, for any
or all security types, by any combination of how held and owner, for any
or all accounts or investment positions. User can create and select from
any number of user-specified disclaimers.
Position-Based Client Statement and Report
Descriptions
• The Consolidated Position Statement offers a great deal of flexibility and is designed
to appeal to a wide range of planning styles and client investment strategies.
Investments can be sorted by standard categories, asset class, retirement and non-
retirement investments, and additional options for calculating cost, tax basis, etc.
• The Position Summary report lists the client’s investment holdings by standard
categories or asset class. The Loan Balance column shows if there are any liabilities
associated with the individual investment. This report is designed for planners and
advisors, but is clear enough for clients to see and understand.
• The Asset Allocation report shows each asset as a percentage of the position. This
report can be printed by asset class or standard categories. This statement allows the
planner and client to respond to allocation issues and monitor rebalancing of
positions.
• Dollar-Weighted Returns From Inception or by Date Range shows the current
compounded annual rate of return for all investments held from inception to date or
from inception to the end of a holding period. The report is designed to show how an
investment or investments have performed during this holding period, and gives the
option to include or exclude liquidated investments. The statement shows an annual
compounded rate of return for each investment and an aggregate return for all
investments listed on the report.
• Balance Sheet – Bank Style prints your client’s assets and liabilities in the Federal
Reserve format used for loan reviews and decisions by most banks and financial
institutions.
• Balance Sheet – Investment Style allows you to review all of a client’s personal assets
and liabilities on a single statement sorted by liquidity. All assets are identified as to
owner, how held, and account number.
Transactions and Compliance Reports
The reports in this section help satisfy NASD and Broker/Dealer compliance and
record keeping requirements. These reports can also be used to assist in verifying
the calculation of investment cost and tax basis and performance returns. All
transaction reports are printed in landscaped mode.
Transactions & Compliance Report Setup
Each report can be run for:
• Any given date range for any or all clients
• Any selected portfolio or account
• Any selected security type
• Any selected transaction type
• Any selected advisor
• By ownership and how held
• For a specific security or policy
Transactions and Compliance Report Descriptions
• Transactions by Security report is also called the Cross Index or Posting report.
This is run by investment name for any specified date range. Transactions are
listed by investments in date order. This is an SEC compliance type of report.
• Transaction Report is also called Brokers Book report. This report is run by client
name for any specified date range. Transactions are listed for all types of
investments in date order. This is an SEC compliance type of report.
• Daily Blotter Report is also called a Securities Blotter. This report is run
for any specified date range. Transactions are listed for all types of
investments in date order and can be listed by account or tax ID. This is
an SEC compliance type of report.
