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:
- Trial Balance. These views display summary, detail, and asset detail views of ledger balances for assets, capital, income, and expense accounts.
- NAV. This view displays the shares outstanding and the NAV per share, grouped by share class.
To create the Trial Balance report:
- From the Accounting Center window, click Reporting in the left navigation.
- Double click Investment Accounting, Ledger Reports, and Trial Balance.
You see the Trial Balance panel. - Complete the fields on the Trial Balance panel.
- Click Submit.
You see the Submit Query dialog box. - Click Advanced Report or Classic Grid Report for the report view you want.
The report results appear on your desktop for the view selected.
Trial Balance Panel Options
A definition of the options on the Trial Balance 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:
|
0 Comments