The purpose of the Unrealized Gain/Loss Report is to see the gain or loss of a position that has not yet been sold.
To access this report, open a transactional account from the top menu, click on Reports, Portfolio, and then Unrealized Gain/Loss.
Note: This report can also be generated from the client level as an aggregated or segregated report for all accounts within the client. Additional options are available when generated from the client level.
Click the drop-down menu and select Yes or No to include a Cover Page.
Set the As of Date for the report. The date can be typed into the field or use the drop-down calendar to select a date.
From the drop-down menu, choose Consolidate Individual Lots to show one line item for each holding, or select Display by Lot to show each lot as a separate line item.
Select Mask Account Number to limit the amount of an account number that is displayed on the report. This inserts a level of security when reports are e-mailed to clients or uploaded to the Web via the Client Web Portal. Click here to see how the masked account number will be represented (based on the number of characters in the account number).
Select the Less Dividend Reinvestment from Cost Calculation option to exclude the cost of Distribution Reinvests from the Total Cost calculation.
Check the box to select the Less Capital Gain Reinvestment from Cost Calculation option to exclude the cost of Capital Gain Reinvests from the Total Cost calculation.
Select Group by Super Asset Class and Security Type to group securities by super asset class and then by security type. If not selected, the report defaults to grouping by security type only.
The Group by Equity Sector or Category Asset Class option works in conjunction with the Group by Super Asset Class and Security Type option, and can only be selected when the price is also selected. Choose this option to also show equity sectors and/or category asset classes.
Select the Remove Cost Columns option to remove the Unit Cost and Total Cost columns from the report.
If you select Display Stock Option Strategies, the report will contain open option positions that Morningstar can match with other open positions to form an option trading strategy. For example, a short call option matched with a long position in the underlying security is a covered call strategy.
Note: The option security has to have the underlying security symbol listed for this information to populate. To verify or add this information, go into the Definition Master, User Defined Securities, Securities page. Find the security in the grid, then right-click on it, and select Edit. Click ont he Detail tab at the top ofthe security record, enter the Underlying Security Symbol, and then click Save and Close.
If you choose to include a Cover Page, you can also use the option to Add disclosure to cover page. Click here for more information.
When selected along with using a cover page, the Add blank 2nd page option inserts a blank page between the cover page and first page of the report.
When the Report Accounts Aggregated option is selected, the program combines all the client's accounts and treats them as one account. If the Report Accounts Segregated option is selected, all of the client's accounts are displayed individually within one PDF. The options can both be selected and will generate two separate reports.
Click here for a report sample.
The information below describes each column of the report.
Account Name - This heading changes based on the selected account type. It will be the account name if the report is for a single account, "account aggregates for 'client name'" if the report is for account aggregates, or "client aggregates for 'client name'" if the report is for client aggregates.
Security Name - The security name for all holdings in the account.
Acquisition Date - The purchase date, which is pulled from the transaction for the holding. Click here for the corresponding field on the transactional record.
Note: The word Various will be listed if there are multiple lots with different acquisition dates and the Consolidate Individual Lots option was selected. To see the acquisition date for each lot, select the Display by Lot option.
Quantity - The amount of shares held within the portfolio for the specific holding.
Market Value - The total market value of each holding in the account as of the report date. Calculations vary based on the type of investment. Click here for calculations.
Total Cost - The total amount of all purchases made + commissions and fees. This may not be an exact unit cost x units due to rounding.
Unit Price - The price of each holding on the as of date of the report.
Unit Cost - The original cost per share of each holding.
Short Term Unrealized G/L – Short term is for any security held in the account for at least one year or less. Unrealized gain/loss is the unrealized gains and losses based on the original cost of open positions on the report date.
Long Term Unrealized G/L – Long term is for any security held in the account for more than one year. Unrealized gain/loss is the unrealized gains and losses based on the original cost of open positions on the report date.
% G/L – The holding’s gain/loss represented as a percentage of total gain/loss in the account. Note: This column will display a dash (-) if there is not enough data to populate this field (i.e. missing Total Cost).
Note: If no price for a security is provided, then the purchase price is used. If there has been no purchase price provided, then, for cash and cash equivalent securities, the price of 1 is used. For all other security types, the price of 0 is used.