Versions Compared

Old Version 5

changes.mady.by.user Nancy Cohn

Saved on

compared with

New Version 6

changes.mady.by.user Nancy Cohn

Saved on

Key

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

...

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.


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)