Ledger Subledger Reconciliation Report

The Ledger Subledger Reconciliation report reconciles the subledger accounting data and the associated ledger balances for a given entity and accounting date. The report displays breaks uncovered in Eagle Accounting for the fund. Advanced report views include Summary By Account Category with variances, Summary By Ledger Account with variances, and Variance At Long/Short Position Level.

To create the Ledger Subledger Reconciliation report:

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

  2. Complete the options on the Ledger Subledger Reconciliation Report panel.

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

  4. Click Submit.
    The report results appear on your desktop for the view selected.

Ledger Subledger Reconciliation Report Panel Options

A definition of the options on the Ledger Subledger Reconciliation 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 End Date

Specifies the ending date for your report results. The default is today's date.

Report Type

Specifies the type of date for controlling your report results.
Options include:

  • Accounting Date (Default)

  • Month End Accounting Date

Show Detail

Allows you to show details in your report results. The default is Yes.

Show Breaks Only

Allows you to show only breaks in your report results. The default is No.

Show Breaks Over

Specifies the minimum break amount that displays in your report results. To use this option, you must set Show Breaks Only to Yes.

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.

Report View Options

Allows you to show/hide additional report filters by security. Options include:

Other Filters

You can filter results using other filters.
Options include:

  • Long Short

  • Investment Type

  • Security Type

  • Processing Security Type

  • Issue Country

Ledger Details

 

Ledger Category

Specifies the ledger category to filter your report results.
Options include:

  • Asset

  • Liability

  • Capital

  • Income

  • Expense

  • Asset / Liability

  • Income / Expense

  • Asset / Liability / Capital

Ledger Account Number

Specifies the ledger account number to filter your report results.

Ledger Account Description

Displays the ledger account description to filter your report results.

Custom Account Number

Specifies the custom account number to filter your report results.

Custom Account Description

Specifies the custom account description to filter your report results.

Detail Tab Selection

Allows you to select additional views for your report results.
Options include:

  • Summary Report (Default Yes)

  • Details Report (Default Yes)

Â