Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version 3

changes.mady.by.user Nancy Cohn (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

  1. From the In Accounting Center window, click Reporting in in the left navigation .Double click Investment Accounting, Ledger Reports, and Ledger – Sub Ledger Reconciliation.pane, click Reports > Ledger Reports > Ledger Balance > Ledger Subledger Reconciliation Report. 
    You see the Ledger – Sub Ledger Subledger Reconciliation Report panel.
  2. Complete the fields options on the Ledger – Sub Ledger Subledger Reconciliation Report panel.
  3. Click Submit.
    You see the Submit Query dialog box.
  4. Click Advanced Report or Classic Grid Report for Under Result Options, click Grid or Advanced Report for the report view you want.
  5. Click Submit. 
    The report results appear on your desktop for the view selected.

Ledger

– Sub Ledger

Subledger Reconciliation Report Panel Options

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

OptionDescription
Search Criteria
Entity IDSpecifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.
Entity NameSpecifies a portfolio, sector portfolio, composite portfolio, or Master Fund by name of the entity.
Accounting BasisSpecifies the entity accounting basis. For example, USTAX, GAAP, or IFRS.
Report End DateSpecifies 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 DetailAllows you to show details in your report results. The default is Yes.
Show Breaks OnlyAllows you to show only breaks in your report results. The default is No.
Show Breaks OverSpecifies 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 FiltersAllows you to show/hide additional security and ledger account filters. The default is No.
Advanced Report OptionsAllows 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 OptionsAllows 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 NumberSpecifies the ledger account number to filter your report results.
Ledger Account DescriptionDisplays the ledger account description to filter your report results.
Custom Account NumberSpecifies the custom account number to filter your report results.
Custom Account DescriptionSpecifies 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)