The Trial Balance report displays the ledger balances for a given entity and accounting date. You can group ledger balances by total fund, class, and sector.
Grid and advanced report views include:
...
To create the Trial Balance report:
- From the In Accounting Center window, click Reporting in in the left navigation .Double click Investment Accounting, Ledger Reports, and Trial Balance.pane, click Reports > Ledger Reports > Ledger Balance > Trial Balance Report.
You see the Trial Balance Report panel. - Complete the fields options on the 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.
Trial Balance Report Panel Options
A definition of the options on the Trial Balance Report panel follows.
Option | Description |
---|---|
Query Trial Balance | |
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. |
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. |
Select Share Class | Allows you to filter by share class. To use this option, you must select Class as your view. Options include:
|
Share Class | Allows you to filter by share class. To use this option, you must select Individual as your share class selection. |
Detailed Class View | Indicates whether to include additional share class details. The default is No. |
Report Type | Specifies the type of date for controlling your report results. |
Options include:
| |
Report Date | Specifies the effective date for your report results. |
General Ledger Currency | Specifies the currency for the general ledger results. |
Show MEMO Accounts | Allows you to show/hide Memo accounts in your report results. |
Selection Criteria | |
Report Filters | Allows you to show/hide additional security filters. The default is No. |
Show Asset Level Details | Allows you to include asset level details in your report results. The default is No. |
Filter Security By | Allows you to show/hide additional report filters. |
Options include:
|