Working Trial Balance Report

The Working Trial Balance report displays the working ledger balances for a given entity and accounting date, assuming dynamically calculated mutual fund allocations have been applied. You can group ledger balances by total fund, class, or sector.

To create the Working Trial Balance report:

In Accounting Center, in the left navigation pane, click Reports > Ledger Reports > Ledger Balance > Working Trial Balance Report.
You see the Working Trial Balance Report panel.
Complete the options on the Working Trial Balance 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.

Related content

Report on Ledger Granularity

Working Trial Balance Report Panel Options

A definition of the options on the Working Trial Balance Report panel follows.

Option	Description

Option	Description
Query Working Trial Balance
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: Sector Class Total Fund (Default)
Select Sector	Allows you to filter by sector. To use this option, you must select Sector as your view to use this option. Options include: All (Default) Individual
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: All (Default) Individual
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: Accounting Date (Default) Month End Date
Report Start Date	Specifies the start date for your report results. To use this option, you must select Accounting Date as your report type.
Report End Date	Specifies the end date for your report results. To use this option, you must select Accounting Date as your report type.
Month End Date	Specifies the month end ending date for your report results. To use this option, you must select Month End Date as your report type.
Month End Report Start Date	Specifies the month end start date for your report results. To use this option, you must select Month End Date as your report type.
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. The default is No.
Exclude Closeout MEMO Account	Allows you to include/exclude closeout MEMO accounts entries in your report results. To use this option, you must set the Show MEMO Accounts field to Yes. Options include: No (Default). If you select this option, the report returns the balance associated with closeout MEMO accounts in your report results. Yes. If you select this option, the report excludes the balance associated with closeout MEMO accounts in your report results.
Selection Criteria and Ledger Details
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: Security Cross Reference (Default). If you select this option the panel unhides the Xref Type and Xref Security ID fields for data entry. Issue Name. If you select this option, the panel unhides the Issue Name field for data entry. Primary Asset ID. If you select this option, the panel unhides the Primary Asset ID field for data entry.
Include/Exclude Closeout Entries	Allows you to include/exclude closeout entries in your report results. The default is Exclude.