Manual Ledger Adjustment Report

Owned by Copy Page Tree (Unlicensed)
Last updated: Oct 04, 2023 by Nancy Cohn (Deactivated)
2 min read

The Manual Ledger Adjustment report displays the details about the entries stored in the ESTAR_LEDGER_POST table. You can select pure manual entries as well as other manual ledger entries that are not otherwise identified as manual.

To create the Manual Ledger Adjustment report:

  1. In Accounting Center, in the left navigation pane, click Reports > Ledger Reports > Ledger Balance > Manual Ledger Adjustment Report. 
    You see the Manual Ledger Adjustment Report panel.

  2. Complete the options on the Manual Ledger Adjustment Report panel.

  3. Under Result Options, click Grid or Advanced Report for the report view you want.

  4. Click Submit.

Manual Ledger Adjustment Report Panel Options

A definition of the options on the Manual Ledger Adjustment Report panel follows.

Option

Description

Option

Description

Search Criteria

 

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 Type

Specifies the reported date type. Options include:

  • Accounting Date (Default)

  • Month End Date

  • Post Date

Report Period

Specifies the date or date range for your report. Options include:

  • Daily Activity (Default)

  • Date Range

Report Start Date

Specifies the start date for your report results. The default is first day of the current month. To use this option, you must select Date Range as your report period.

Report End Date

Specifies the ending date for your report results. The default is the last day of the current month.

Entries Type

Specifies the type of manual ledger in the report. Options include:

  • Pure Manual (Default). Selects entries with ACCT_CATEGORY = 'M' and MESSAGE_TYPE = 'SINGLE' values.

  • Other Manual. Selects entries with MESSAGE_TYPE = MISCINC, FEERECLASSBST, SINGLE, MISCEXP, or FEERECLASSICST.

  • All. Selects all entries.

Selection Criteria

 

Report Filters

Allows you to show/hide additional security and ledger account filters. The default is No.

Advanced Report Options

Allows you to show/hide advanced report detail tab selection, group, sort, and format options. 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.

Other Filters

Allows you to filter report results. Options include:

  • Asset Currency

  • Security Type

  • Processing Security Type

Query Ledger Account Options

 

Ledger Accounts

Allows you to filter by ledger account number. Options include:

  • All Ledger Accounts

  • Ledger Account Range

  • Single Ledger Account

From Ledger Account

Specifies the starting ledger account number for your report results.

To Ledger Account

Specifies the ending ledger account number for your report results. To use this option, you must filter by Ledger Account Range.

Advanced Report Options

 

Detail Tab Selection

Allows you to select Manual Ledger Adjustment as an additional view for your report results. Default is Yes.

Â