Versions Compared

Key

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

...

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

...

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

...

  1.  Financial Reporting Date – Working Trial

...

  1. Balance Report. 
    You see the Financial Reporting Date – Working Trial Balance Report panel.

  2. Complete the options on the Financial Reporting Date – Working Trial Balance 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. Grid and advanced report views include summary by ledger account and detail by ledger account and asset views.

Financial Reporting Date – Working Trial Balance Report Panel Options

A definition of the options on the Financial Reporting Date – Working Trial Balance 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

  • 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

NOTE: 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.