Versions Compared
compared with
Key
- This line was added.
- This line was removed.
- Formatting was changed.
The Portfolio Valuation report displays the position records for a given entity and date. You can select position level or lot level information.
To create the Portfolio Valuation report:
- In Accounting Center, in the left navigation pane, click Reports > Investment Accounting Reports > Positions > Portfolio Valuation Report.
You see the Portfolio Valuation Report panel. - Complete the options on the Portfolio Valuation Report panel.
- Under Result Options, click Grid or Advanced Report for the report view you want.
- Click Submit.
The report appears on your desktop for the view selected.
Advanced report views available for this report include:
- Summary.
- Detail 1.
- Detail 2.
- Detail 3.
- Futures. Displays the notional values for futures.
- Custody Cash Details. Reports the currency balance and under it the cash account balance details that make up the balance. Used with cash segregation.
- Detail 1 with ECL. Displays additional Expected Credit Loss related fields.
- Summary LSL. Displays sub-ledger balances for ledger reconciliation.
- Detail LSL. Displays underlying sub-ledger details broken out at the position or lot level.
Portfolio Valuation Report Panel Options
A definition of the options on the Portfolio Valuation Report panel follows.
Option | Description |
---|---|
Search Criteria | |
Entity ID | Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity. |
Entity Name | Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by name of the entity. |
Accounting Basis | Specifies the entity accounting basis. For example, USTAX, GAAP, or IFRS. |
Detail Selection | Specifies the level of the holdings. Options include:
|
Report Type | Specifies the type of date for controlling your report results. Options include:
|
Report Date | Specifies the ending date for your report results. The default is today's date. |
Display Zero Holdings | Allows you to filter zero holdings. The default is No. |
Report View | Allows you to select the report view for your report results. Options include:
|
Report Base Currency | Specifies the base currency for your report results. |
Selection Criteria | |
Report Filters | Allows you to show/hide additional report and security filters. The default is No. |
Advanced Report Options | Allows you to show/hide advanced report, group, sort, and format options. The default is No. |
Report Filters / Security Filter | |
Filter Security By | Allows you to show/hide additional report filters. Options include: |
Security Cross Reference (Default) | If you select this option the panel unhides the Xref Type and Xref Security ID fields for data entry. |
Issue Name | If you select this option, the panel unhides the Issue Name field for data entry. |
Primary Asset ID | If you select this option, the panel unhides the Primary Asset ID field for data entry. |
Other Filters | You can filter results using other filters. Options include:
|
Related content