...
To create the Financial Reporting Date – Working Trial Balance report:
- From the In Accounting Center window, click Reporting in in the left navigation .Double click Investment Accounting, Ledger Reports, and pane, click Reports > Ledger Reports > Ledger Financial > Financial Reporting Date – Working Trial Balance Report.
You see the Financial Reporting Date – Working Trial Balance Report panel. - Complete the fields options on the Financial Reporting Date – Working Trial Balance Report panel.
- Click Submit.
You see the Submit Query dialog box. - Click Advanced Report or Classic Grid Report for 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 by ledger account and detail by ledger account and asset views.
Financial Reporting Date – Working Trial Balance Report Panel Options
A definition of the options on the Financial Reporting Date – Working Trial Balance Report panel follows.
| Option | Description |
|---|---|
| Query Accounting Journal | |
| Master Fund ID | Specifies a Master Fund by the entity ID of the entity. |
| Master Fund | Specifies a Master Fund by name of the entity. |
| Accounting Basis | Specifies the entity accounting basis. For example, USTAX, GAAP, or IFRS. |
| Select View | Allows you to filter the entity view for your report results. Options include:
|
| Select Sector | Allows you to filter by sector. To use this option, you must select Sector as your view. Options include:
|
| Sector ID | Allows you to filter by sector ID. To use this option, you must select Individual as your sector selection. |
| Sector | Allows you to filter by sector name. To use this option, you must select Individual as your sector selection. |
| Report Type | Specifies the type of report. Options include:
NOTE: If you select this option, the panel unhides the Security ID field for data entry. |
| Report Start Date | Specifies the start date for your report results. |
| Report End Date | Specifies the end date for your report results. |
| Query Ledger Account Options | |
| Ledger Accounts | Allows you to filter by ledger profile or range of accounts. Options include:
|
| Account Category | Specifies the ledger account category to filter your report results. To use this option, you must filter by Ledger Account Range. Options include:
|
| From Ledger Account Code | Specifies the starting ledger account number for your report results. To use this option, you must filter by Ledger Account Range. Default is the lowest account number in the specified Account Category. |
| To Ledger Account | Specifies the ending ledger account number for your report results. To use this option, you must filter by Ledger Account Range. Default is highest account number in the specified Account Category. |
| Select Ledger Profile | Specifies the ledger profile for your report results. To use this option, you must filter by Ledger Profiles. Options include:
|
| Security ID | Allows you to filter by security identification. To use this option, you must select Detail Ledger Account & Asset as your report type.
NOTE: If you select this option, the panel unhides the Report Filters section for data entry. |
| Report Filters | |
| Filter Security By | Allows you to show/hide additional report filters. Options include:
|