Trial Balance Report

Owned by Former user (Deleted)
Oct 27, 2016
2 min read

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:

  1. From the Accounting Center window, click Reporting in the left navigation.
  2. Double click Investment Accounting, Ledger Reports, and Trial Balance.
    You see the Trial Balance panel.
  3. Complete the fields on the Trial Balance panel.
  4. Click Submit.
    You see the Submit Query dialog box.
  5. 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.

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:
    –  Sector
    –  Class
    –  Total Fund (Default)
  • Select Sector. Allows you to filter by sector. To use this option, you must select Sector as your view.
    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 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:
    –  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.