Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

This topic provides an overview of Ledger reports.

Ledger – Sub Ledger Reconciliation Report

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.

Content on this page:

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)

Trial Balance Report

The Trial Balance report displays the ledger balances for a given entity and accounting date. You can group ledger balances by total fund, class, and sector. Grid and advanced report views include:

  • Trial Balance. These views display summary, detail, and asset detail views of ledger balances for assets, capital, income, and expense accounts.
  • NAV. This view displays the shares outstanding and the NAV per share, grouped by share class.

To create the Trial Balance report:

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

Trial Balance Panel Options

A definition of the options on the Trial Balance panel follows.

Query Trial Balance

  • 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.
  • Select View. Allows you to filter the entity view for your report results.
    Options include:
    –  Sector
    –  Class
    –  Total Fund (Default)
  • Select Sector. Allows you to filter by sector. To use this option, you must select Sector as your view.
    Options include:
    –  All (Default)
    –  Individual
  • Sector ID. Allows you to filter by sector ID. To use this option, you must select Individual as your sector selection.
  • Sector. Allows you to filter by sector name. To use this option, you must select Individual as your sector selection.
  • Select Share Class. Allows you to filter by share class. To use this option, you must select Class as your view.
    Options include:
    –  All (Default)
    –  Individual
  • Share Class. Allows you to filter by share class. To use this option, you must select Individual as your share class selection.
  • Detailed Class View. Indicates whether to include additional share class details. The default is No.
  • Report Type. Specifies the type of date for controlling your report results.
    Options include:
    –  Accounting Date (Default)
    –  Month End Date
  • Report Date. Specifies the effective date for your report results.
  • General Ledger Currency. Specifies the currency for the general ledger results.
  • Show MEMO Accounts. Allows you to show/hide Memo accounts in your report results.

Selection Criteria

  • Report Filters. Allows you to show/hide additional security filters. The default is No.
  • Show Asset Level Details. Allows you to include asset level details in your report results. 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.

Working Trial Balance Report

The Working Trial Balance report displays the working ledger balances for a given entity and accounting date, assuming dynamically calculated mutual fund allocations have been applied. You can group ledger balances by total fund, class, or sector.

To create the Working Trial Balance report:

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

Working Trial Balance Panel Options

A definition of the options on the Working Trial Balance panel follows.

Query Working Trial Balance

  • Master Fund ID. Specifies a Master Fund by the entity ID of the entity.
  • Master Fund. Specifies a Master Fund by name of the entity.
  • Accounting Basis. Specifies the entity accounting basis. For example, USTAX, GAAP, or IFRS.
  • Select View. Allows you to filter the entity view for your report results.
    Options include:
    –  Sector
    –  Class
    –  Total Fund (Default)
  • Select Sector. Allows you to filter by sector. To use this option, you must select Sector as your view to use this option. Options include:
    –  All (Default)
    –  Individual
  • Sector ID. Allows you to filter by sector ID. To use this option, you must select Individual as your sector selection.
  • Sector. Allows you to filter by sector name. To use this option, you must select Individual as your sector selection.
  • Select Share Class. Allows you to filter by share class. To use this option, you must select Class as your view.
    Options include:
    –  All (Default)
    –  Individual
  • Share Class. Allows you to filter by share class. To use this option, you must select Individual as your share class selection.
  • Detailed Class View. Indicates whether to include additional share class details. The default is No.
  • Report Type. Specifies the type of date for controlling your report results.  Options include:
    –  Accounting Date (Default)
    –  Month End Date
  • Report Start Date. Specifies the start date for your report results. To use this option, you must select Accounting Date as your report type.
  • Report End Date. Specifies the end date for your report results. To use this option, you must select Accounting Date as your report type.
  • Month End Date. Specifies the month end ending date for your report results. To use this option, you must select Month End Date as your report type.
  • Month End Report Start Date. Specifies the month end start date for your report results. To use this option, you must select Month End Date as your report type.
  • General Ledger Currency. Specifies the currency for the general ledger results.
  • Show MEMO Accounts. Allows you to show/hide Memo accounts in your report results.

Selection Criteria and Ledger Details

  • Report Filters. Allows you to show/hide additional security filters. The default is No.
  • Show Asset Level Details. Allows you to include asset level details in your report results. 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.
  • Include/Exclude Closeout Entries. Allows you to include/exclude closeout entries in your report results. Default is Exclude.

Accounting Journal Report

The Accounting Journal report displays ledger balances for a given entity and accounting date or date range. The report shows ledger activity for each ledger balance within the dates requested. The report is available with several different account viewing options, including by account, by post ID, by asset and account, by asset and post ID, and by event ID for base/non base and all manual entries.

To create the Accounting Journal report:

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

Accounting Journal Panel Options

A definition of the options on the Accounting Journal panel follows.


Query Accounting Journal

  • Master Fund ID. Specifies a Master Fund by the entity ID of the entity.
  • Master Fund. Specifies a Master Fund by name of the entity.
  • Accounting Basis. Specifies the entity accounting basis. For example, USTAX, GAAP, or IFRS.
  • Select View. Allows you to filter the entity view for your report results.
    Options include:
    –  Sector
    –  Class
    –  Total Fund (Default)
  • Select Sector. Allows you to filter by sector. To use this option, you must select Sector as your view.
    Options include:
    –  All (Default)
    –  Individual
  • Sector ID. Allows you to filter by sector ID. To use this option, you must select Individual as your sector selection.
  • Sector. Allows you to filter by sector name. To use this option, you must select Individual as your sector selection.
  • Select Share Class. Allows you to filter by share class. To use this option, you must select Class as your view.
    Options include:
    –  All (Default)
    –  Individual
  • Share Class. Allows you to filter by share class. To use this option, you must select Individual as your share class selection.
  • Detailed Class View. Indicates whether to include additional share class details. The default is No.
  • Report Type. Specifies the type of date for controlling your report results.
    Options include:
    –  Accounting Date (Default)
    –  Month End Date
  • Begin Date. Specifies the start date for your report results. To use this option, you must select Accounting Date as your report type.
  • End Date. Specifies the end date for your report results. To use this option, you must select Accounting Date as your report type.
  • Month End Date. Specifies the month end ending date for your report results. To use this option, you must select Month End Date as your report type.
  • Month End Report Start Date. Specifies the month end start date for your report results. To use this option, you must select Month End Date as your report type.
  • Net Rollback/Replay Entries?. Specifies whether to new rollback/replay entries in your report results. Default is Yes.
  • Show MEMO Accounts. Allows you to show/hide Memo accounts in your report results.
    Options include:
    –  Yes. Displays itemized balances.
    –  No (Default). Displays rolled up balances.

Entry Lookup Results

  • Portfolio Currency. Specifies the currency for your report results.

Query Ledger Account Options

  • Ledger Accounts. Allows you to filter by ledger account.
    Options include:
    –  All Ledger Accounts (Default)
    –  Ledger Account Range
    –  Single Ledger Account
  • From Ledger Account. Specifies the starting ledger account number for your report results. To use this option, you must select Ledger Account Range or Single Ledger Account as your ledger account option.
  • To Ledger Account. Specifies the ending ledger account number for your report results. If you select Single Ledger Account for the Ledger Accounts option, the ending ledger account value is assumed the same value as the starting value.
  • Security ID. Allows you to filter by security identification.
    Options include:
    –  All Securities (Default)
    –  Individual Security
  • Filter Security By. Allows you to show/hide additional report filters. To use this option, you must select Individual Security as your security identification.
    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.
  • Default Values. Allows you to select the detail views for your report results.
    Options include:
    –  Account (Default Yes)
    –  Post ID (Default Yes)
    –  Asset and Account (Default Yes)
    –  Asset and Post ID (Default Yes)
    –  Event ID (Default Yes)
    –  Base/Non Base (Default Yes)

Statement of Changes Report

The Statement of Changes report displays a financial statement which shows how a mutual fund's net assets have changed between reporting periods. Net investment income and realized gains which come from operations and shares sold and reinvested are added to net assets. Dividends paid and shares redeemed are subtracted from net assets.

To create the Statement of Changes report:

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

Statement of Changes Panel Options

A definition of the options on the Statement of Changes panel follows.

Query Statement of Changes in Net Assets

  • Master Fund ID. Specifies a Master Fund by the entity ID of the entity.
  • Master Fund. Specifies a Master Fund by name of the entity.
  • Accounting Basis. Specifies the entity accounting basis. For example, USTAX, GAAP, or IFRS.
  • Select View. Allows you to filter the entity view for your report results.
    Options include:
    –  Sector
    –  Class
    –  Total Fund (Default)
  • Select Sector. Allows you to filter by sector. To use this option, you must select Sector as your view.
    Options include:
    –  All (Default)
    –  Individual
  • Sector ID. Allows you to filter by sector ID. To use this option, you must select Individual as your sector selection.
  • Sector. Allows you to filter by sector name. To use this option, you must select Individual as your sector selection.
  • Select Share Class. Allows you to filter by share class. To use this option, you must select Class as your view.
    Options include:
    –  All (Default)
    –  Individual
  • Share Class. Allows you to filter by share class. To use this option, you must select Individual as your share class selection to use this option.
  • Report Type. Specifies the type of date for controlling your report results.
    Options include:
    –  Accounting Date (Default)
    –  Month End Date
  • Report Start Date. Specifies the start date for your report results.
  • Report End Date. Specifies the end date for your report results.
  • General Ledger Currency. Specifies the currency for the general ledger results.
  • Month End Date. Specifies the month end ending date for your report results.
  • Month End Report Start Date. Displays the month end start date for your report results.

Statement of Operations Report

The Statement of Operations report displays the working ledger balances for a given entity and accounting date, assuming dynamically calculated mutual fund allocations have been applied. You can group ledger balances by total fund, class, or sector.

To create the Statement of Operations report:

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

Statement of Operations Panel Options

A definition of the options on the Statement of Operations panel follows.

Query Statement of Operations

  • Master Fund ID. Specifies a Master Fund by the entity ID of the entity.
  • Master Fund. Specifies a Master Fund by name of the entity.
  • Accounting Basis. Specifies the entity accounting basis. For example, USTAX, GAAP, or IFRS.
  • Select View. Allows you to filter the entity view for your report results.
    Options include:
    –  Sector
    –  Class
    –  Total Fund (Default)
  • Select Sector. Allows you to filter by sector. To use this option, you must select Sector as your view.
    Options include:
    –  All (Default)
    –  Individual
  • Sector ID. Allows you to filter by sector ID. To use this option, you must select Individual as your sector selection.
  • Sector. Allows you to filter by sector name. To use this option, you must select Individual as your sector selection.
  • Select Share Class. Allows you to filter by share class. To use this option, you must select Class as your view.
    Options include:
    –  All (Default)
    –  Individual
  • Share Class. Allows you to filter by share class. To use this option, you must select Individual as your share class selection.
  • Report Type. Specifies the type of date for controlling your report results.
    Options include:
    –  Accounting Date (Default)
    –  Month End Date
  • Report Date. Specifies the effective date for your report results.
  • General Ledger Currency. Specifies the currency for the general ledger results.
  • Month End Date. Specifies the month end ending date for your report results.

Ledger Balances Report

The Ledger Balances report displays the ledger balances for a given entity and report date. The default report date is today's date.

To create the Ledger Balances report:

  1. From the Accounting Center window, click Reporting in the left navigation.
  2. Double click Investment Accounting, Ledger Reports, and Ledger Balances.
    You see the Ledger Balances panel.
  3. Complete the fields on the Ledger Balances 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. Grid and advanced report views available include a summary view and a detail view with ledger balances grouped by asset and share class.

Ledger Balances Panel Options

A definition of the options on the Ledger Balances panel follows.


Required Parameters

  • 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 Date. Specifies the report date for your report results. Default is today's date.

Entity Details

  • Base Currency. Specifies the base currency for your report results.
  • Show MEMO Accounts. Allows you to show/hide Memo accounts in your report results. Default is No.
  • Show Asset Level Details. Allows you to show/hide asset level details in your report results. Default is No.

Advanced Report Options

  • Tab Selection. allows you to select additional views for your report results.
    Options include:
    –  Summary (Default Yes)
    –  Detail (Default No)
    –  Shading (Default Every Other Line)

OTTI Impairments Report

The Other Than Temporary Impairments (OTTI) report for debt securities provides the beginning and ending balances of impairments for non-credit losses recognized in other comprehensive income (OCI), impairments recognized in income, amortization of non-credit losses, and non-credit losses reversed from OCI due to: (a) sales, (b) intent to sell, (c) more likely than not required to sell.

To create the OTTI Impairment report:

  1. From the Accounting Center window, click Reporting in the left navigation.
  2. Double click Investment Accounting, Ledger Reports, and OTTI Impairment.
    You see the OTTI Impairment panel.
  3. Complete the fields on the OTTI Impairment 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. Grid and advanced report views include summary and detail views, with beginning and ending balances of OTTI impairments for non-credit losses, amortization of non-credit losses, and the OTTI non-credit losses reversed from OCI.

OTTI Impairment Panel Options

A definition of the options on the OTTI Impairment 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 Detail. Specifies the level of detail for the report.
    Options include:
    –  Summary (Default)
    –  Detail
  • Report Period. Specifies the date type or date range for your report.
    Options include:
    –  Fiscal Year to Date (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.

Selection Criteria

  • Report Filters. Allows you to show/hide additional report filters. The default is No.
  • Advanced Report Options. Allows you to show/hide advanced report 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.

Manual Ledger Adjustment Report

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. From the Accounting Center window, click Reporting in the left navigation.
  2. Double click Investment Accounting, Ledger Reports, and Manual Ledger Adjustment.
    You see the Manual Ledger Adjustment panel.
  3. Complete the fields on the Manual Ledger Adjustment panel.
  4. Click Submit and then click Advanced Report or Classic Grid Report for the report view you want.

Manual Ledger Adjustment Panel Options

A definition of the options on the Manual Ledger Adjustment 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 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.

Financial Reporting Date – Working Trial Balance Report

The Financial Reporting Date – Working Trial Balance report generates a working trial balance using a financial reporting date derived as the lesser of post date or monthly accounting date. You can filter results by ledger account range and ledger profile.

To create the Financial Reporting Date – Working Trial Balance report:

  1. From the Accounting Center window, click Reporting in the left navigation.
  2. Double click Investment Accounting, Ledger Reports, and Financial Reporting Date – Working Trial Balance.
    You see the Financial Reporting Date – Working Trial Balance panel.
  3. Complete the fields on the Financial Reporting Date – Working Trial Balance 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. Grid and advanced report views include summary by ledger account and detail by ledger account and asset views.

Financial Reporting Date – Working Trial Balance Panel Options

A definition of the options on the Financial Reporting Date – Working Trial Balance panel follows.

Query Accounting Journal

  • Master Fund ID. Specifies a Master Fund by the entity ID of the entity.
  • Master Fund. Specifies a Master Fund by name of the entity.
  • Accounting Basis. Specifies the entity accounting basis. For example, USTAX, GAAP, or IFRS.
  • Select View. Allows you to filter the entity view for your report results.
    Options include:
    –  Sector
    –  Total Fund (Default)
  • Select Sector. Allows you to filter by sector. To use this option, you must select Sector as your view.
    Options include:
    –  All (Default)
    –  Individual
  • Sector ID. Allows you to filter by sector ID. To use this option, you must select Individual as your sector selection.
  • Sector. Allows you to filter by sector name. To use this option, you must select Individual as your sector selection.
  • Report Type. Specifies the type of report. Options include:
    –  Summary by Ledger Account (Default)
    –  Detail Ledger Account & Asset
    NOTE: If you select this option, the panel unhides the Security ID field for data entry.
  • Report Start Date. Specifies the start date for your report results.
  • Report End Date. Specifies the end date for your report results.

Query Ledger Account Options

  • Ledger Accounts. Allows you to filter by ledger profile or range of accounts. Options include:
    –  Ledger Profiles
    –  Ledger Account Range (Default)
  • Account Category. Specifies the ledger account category to filter your report results. To use this option, you must filter by Ledger Account Range.
    Options include:
    –  Asset
    –  Liability
    –  Capital (Default)
    –  Income
    –  Expense
    –  Asset / Liability
    –  Income / Expense
    –  Asset / Liability / Capital
    –  Memo
    –  All
  • From Ledger Account Code. Specifies the starting ledger account number for your report results. To use this option, you must filter by Ledger Account Range. Default is the lowest account number in the specified Account Category.
  • To Ledger Account. Specifies the ending ledger account number for your report results. To use this option, you must filter by Ledger Account Range. Default is highest account number in the specified Account Category.
  • Select Ledger Profile. Specifies the ledger profile for your report results. To use this option, you must filter by Ledger Profiles.
    Options include:
    –  All Ledger Accounts Except URGL Accounts
    –  Realized Gain/Loss Accounts Only
    –  Default Trial Balance Profile

  • Security ID. Allows you to filter by security identification. To use this option, you must select Detail Ledger Account & Asset as your report type.
    Options include:
    –  All Securities (Default)
    –  Individual Security

    If you select this option, the panel unhides the Report Filters section for data entry.

Report Filters

  • 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.

Financial Reporting Date – Balance & Activity Report

The Financial Reporting Date – Balance & Activity report generates a trial balance using a financial reporting date derived as the lesser of post date or monthly accounting date. You can filter results by ledger account range or ledger profile.

To create the Financial Reporting Date –Balance & Activity report:

  1. From the Accounting Center window, click Reporting in the left navigation.
  2. Double click Investment Accounting, Ledger Reports, and Financial Reporting Date – Balance & Activity.
    You see the Financial Reporting Date – Balance & Activity panel.
  3. Complete the fields on the Financial Reporting Date – Balance & Activity 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. Grid and advanced report views available include summary by ledger account and detail by ledger account and asset views.

Financial Reporting Date – Balance & Activity Panel Options

A definition of the options on the Financial Reporting Date – Balance & Activity panel follows.

Query Accounting Journal

  • Master Fund ID. Specifies a Master Fund by the entity ID of the entity.
  • Master Fund. Specifies a Master Fund by name of the entity.
  • Accounting Basis. Specifies the entity accounting basis. For example, USTAX, GAAP, or IFRS.
  • Select View. Allows you to filter the entity view for your report results.
    Options include:
    –  Sector
    –  Total Fund (Default)
  • Select Sector. Allows you to filter by sector. To use this option, you must select Sector as your view.
    Options include:
    –  All (Default)
    –  Individual
  • Sector ID. Allows you to filter by sector ID. To use this option, you must select Individual as your sector selection.
  • Sector. Allows you to filter by sector name. To use this option, you must select Individual as your sector selection.

  • Report Type. Specifies the type of report.
    Options include:
    –  Summary by Ledger Account (Default)
    –  Detail Ledger Account & Asset   

    If you select this option, the panel unhides the Security ID field for data entry.

  • Report Start Date. Specifies the start date for your report results.
  • Report End Date. Specifies the end date for your report results.

Query Ledger Account Options

  • Ledger Accounts. Allows you to filter by ledger profile or range of accounts.
    Options include:
    –  Ledger Profiles
    –  Ledger Account Range (Default)
  • Account Category. Specifies the ledger account category to filter your report results. To use this option, you must filter by Ledger Account Range.
    Options include:
    –  Asset
    –  Liability
    –  Capital (Default)
    –  Income
    –  Expense
    –  Asset / Liability
    –  Income / Expense
    –  Asset / Liability / Capital
    –  Memo
    –  All
  • From Ledger Account Code. Specifies the starting ledger account number for your report results. To use this option, you must filter by Ledger Account Range. Default is the lowest account number in the specified Account Category.
  • To Ledger Account. Specifies the ending ledger account number for your report results. To use this option, you must filter by Ledger Account Range. Default is highest account number in the specified Account Category.
  • Select Ledger Profile. Specifies the ledger profile for your report results. To use this option, you must filter by Ledger Profiles.
    Options include:
    –  All Ledger Accounts Except URGL Accounts
    –  Realized Gain/Loss Accounts Only
    –  Default Trial Balance Profile

  • Security ID. Allows you to filter by security identification. To use this option, you must select Detail Ledger Account & Asset as your report type.
    Options include:
    –  All Securities (Default)
    –  Individual Security     

    If you select this option, the panel unhides the Report Filters section for data entry.

Report Filters

  • 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.

Ledger Granularity Reclass Report

The Ledger Granularity Reclass report allows you to track changes to ledger granularity rules and the effect of ledger account reclassifications on ledger balances.

To create the Ledger Granularity Reclass report:

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

A definition of the options on the Ledger Granularity Reclass 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 Period.  Specifies the date range or a particular date for your report.
    Options include:
    –  Daily Activity (Default)
    –  Date Range. If you select this option, the panel unhides Report Start Date.
  • Report Begin Date. Specifies the starting date for your report results. 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 today's date.

Selection Criteria

  • Report Filters. Allows you to show/hide additional security and other filters. The default is No.
  • Filter Security By. Allows you to show/hide additional report filters.
    Options include:
    –  Issue Name. If you use this option, the panel unhides the Issue Name field for data entry.
    –  Primary Asset ID (Default). If you use this option, the panel unhides the Primary Asset ID field for data entry.
  • Asset Currency. Allows you to filter report results by the asset currency.
  • Security Type. Allows you to filter report results by the security type.
  • Processing Security Type. Allows you to filter report results by Processing Security Type (PST).
  • No labels