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:
- From the Accounting Center window, click Reporting in the left navigation.
- Double click Investment Accounting, Ledger Reports, and Accounting Journal.
You see the Accounting Journal panel. - Complete the fields on the Accounting Journal panel.
- Click Submit.
You see the Submit Query dialog box. - 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.
| 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:
|
| Select Sector | Allows you to filter by sector. To use this option, you must select Sector as your view. Options include:
|
| 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.
|
| 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:
|
| 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:
|
| 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:
|
| 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:
|
| 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:
|
| Default Values | Allows you to select the detail views for your report results. Options include:
|
Add Comment