Realized Gain Loss Report
The Realized Gain Loss report displays realized security and currency gains and losses on close lot activity. Eagle Accounting stores the gain and loss values on the TRADES and ESTAR database tables for different security and activity types, including: the TRADE_DETAIL table, the DISPOSAL_LOTS table, and the ESTAR_TRADED_CASH_ACTIVITY table.
To create the Realized Gain Loss report:
In Accounting Center, in the left navigation pane, click Reports > Investment Accounting Reports > Trade > Realized Gain Loss Report Report.Â
You see the Realized Gain Loss Report panel.Complete the options on the Realized Gain Loss 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 Realized Gain Loss Local and Realized Gain Loss Local Base, with total gain loss and 988 currency gain loss information.
Realized Gain Loss Report Panel Options
A definition of the options on the Realized Gain Loss 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 controlling your report results. Options include:
|
Report Type Source | Specifies the source of the date controlling your report results. Options include:
|
Report Period | Specifies the time period, date range, or particular date for your report. The time period may be entity specific or security specific, such as fiscal year. Options include:
|
Report Start Date | Specifies the start date for your report results. The default is first day of the current month. To use this option, you must select Date Range as your report period. |
Report End Date | Specifies the ending date for your report results. The default is today's date. |
Include/Exclude Cancels | Allows you to include cancel events. The default is Exclude. |
Display Zero Gain/Loss | Allows you to display zero gain/loss amounts. Default is No. |
Syncsend Engine Router | (Hidden) Indicates whether the system uses the Accounting engine or a report service to process the report results. 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 detail tab selection and format options. The default is No. |
Filter Security By | Allows you to show/hide additional report filters. Options include:
|
Other Filters | Allows you to filter report results. Options include:
|
Detail Tab Selection | Allows you to select additional views for our report results. Options include:
|
Â