The Unsettled Transactions report displays the open cash activity for a given entity and date range. You can display all unsettled transactions, unsettled trades, unsettled income, and approved margin transactions.
To create the Unsettled Transactions report:
In Accounting Center, in the left navigation pane, click Reports > Investment Accounting Reports > Cash > Unsettled Transactions Report.
You see the Unsettled Transactions Report panel.- Complete the option on the Unsettled Transactions Report panel.
- Under Result Options, click Grid or Advanced Report for the report view you want.
- Click Submit.
The report results appear on your desktop for the view selected. Grid and advanced report views include summary views and detailed market value and currency gain/loss views.
Unsettled Transactions Report Panel Options
A definition of the options on the Unsettled Transactions 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. |
| Report Type | Specifies the type of date for controlling your report results. Options include:
|
| Transaction Type | Allows you to filter by transaction type. Options include:
|
| Report Date | Specifies the ending date for your report results. The default is today's date. |
Include/Exclude Shareholder Activity | Allows you to include shareholder activity. The default is Exclude. |
| Include/Exclude Forward Transactions | Allows you to include forward transactions. The default is Include. |
| URGL on Cash Based Div Income | Indicates whether the report output reflects cash dividends that recognize dividend income on a cash settlement basis rather than on an ex-date basis. For more information, see Recognize Dividend Income on a Cash Settlement Basis. Options include:
|
| 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. |
| Filter Security By | Allows you to show/hide additional report filters. Options include:
|
| Other Filters | You can filter results using other filters. Options include:
|
0 Comments