Ledger Balances Report

The Ledger Balances report displays the ledger balances for a given entity and report date. The default report date is today's date.

To create the Ledger Balances report:

  1. From the Accounting Center window, click Reporting in the left navigation.
  2. Double click Investment Accounting, Ledger Reports, and Ledger Balances.
    You see the Ledger Balances panel.
  3. Complete the fields on the Ledger Balances 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. Grid and advanced report views available include a summary view and a detail view with ledger balances grouped by asset and share class.

Ledger Balances Panel Options

A definition of the options on the Ledger Balances panel follows.

Required Parameters

  • 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.
  • Report Date. Specifies the report date for your report results. Default is today's date.

Entity Details

  • Base Currency. Specifies the base currency for your report results.
  • Show MEMO Accounts. Allows you to show/hide Memo accounts in your report results. Default is No.
  • Show Asset Level Details. Allows you to show/hide asset level details in your report results. Default is No.

Advanced Report Options

  • Tab Selection. allows you to select additional views for your report results.
    Options include:
    –  Summary (Default Yes)
    –  Detail (Default No)
    –  Shading (Default Every Other Line)