Ledger - Sub Ledger Reconciliation Report

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

The Ledger to Sub Ledger 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 – Sub Ledger Reconciliation report:

  1. From the Accounting Center window, click Reporting in the left navigation.
  2. Double click Investment Accounting, Ledger Reports, and Ledger – Sub Ledger Reconciliation.
    You see the Ledger – Sub Ledger Reconciliation panel.
  3. Complete the fields on the Ledger – Sub Ledger Reconciliation 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.

Ledger – Sub Ledger Reconciliation Panel Options

A definition of the options on the Ledger – Sub Ledger Reconciliation panel follows.

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)