Versions Compared

Key

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

...

To create the Accounting Journal report:

  1. In Accounting Center, in the left navigation pane, click Reports Ledger

...

  1. Reports > Ledger Balance >

...

  1.  Accounting Journal Report. 
    You see the Accounting Journal Report panel.

  2. Complete the option on the Accounting Journal 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.

Accounting Journal Report Panel Options

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

Option

Description

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)