Journal Entries Report Template
This template is supported by the BVLedgerExport Business View. It is intended to provide the same journal entries available in the original Ledger Export with the option to customize. Please refer to the Data Dictionary for more information regarding the individual data elements included in the business view.
Download a PDF version of the Design Studio guide.
This template is located under the Design Studio tile in the Reports workspace.
Below is an example of the parameters included in the Journal Entries Report Template.
Report Parameter Definitions – Journal Entries Report Template
Parameter |
Definition |
|---|---|
As At |
Fiscal month-end date for which journal entries are effective. Activities recorded with the ledger date on or before this date will be included. Activities recorded with effective ledger date after this date will not be included. Defaults to the fiscal month-end date prior to the current system date. REQUIRED FIELD. |
Starting Fiscal Year |
First fiscal year of journal entries to be included in the report. Entries with ledger dates occurring in the Fiscal Year/Starting Period/# of months combination will be included in the report output. REQUIRED FIELD. |
Starting Period |
First fiscal period for which journal entries will be included in the report. Entries with ledger dates occurring in the Fiscal Year/Staring Period/# of months combination will be included in the report output. Available options are Prior Quarter, Current Quarter, Prior Month, Current Month, Q1 thru Q4, and 12 named months. Note that the ‘Quarter’ options reflect the first month of each quarter. See note regarding ‘Quarter’ in the # of Months of Lease Expense to Transfer parameter below. REQUIRED FIELD |
# of Months of Lease Expense to Transfer |
Number of months of journal entries to be included in the report. Entries with ledger dates occurring in the Fiscal Year/Starting Period/# of months combination will be included in the report output. Note that selecting a ‘Quarter’ option in the Starting Period parameter will require a ‘3’ in this field for a full quarter worth of entries to render. REQUIRED FIELD. |
Level of Detail |
While the standard ledger export provides options for Asset level or Portfolio level journal entries, this template currently focuses on the Schedule level of detail (which is the default). REQUIRED FIELD. |
Deal Status |
Includes or excludes entries for schedules integrated with the Real Estate Manager application or entered when the Segregation of Duties workflows are turned on. Options in the drop-down menu include Exclude Incomplete Only, Exclude Incomplete and Pending Approval, Exclude Pending Approval Only, Include All, and Include Pending Approval Only. Default is Exclude Incomplete and Pending Approval. REQUIRED FIELD. |
Include Adjusting Entries |
Filter used to determine which (if any) adjusting entries are included in the report calculations. Adjusting Entries are entries noted with [FY/FM…] text in the Comments section and relate to true-up entries or accounting corrections. Options in the drop-down menu include All, Post-Transition Only, Current Fiscal Year Only, and None. Default is All. REQUIRED FIELD. |
Schedule # |
Available filtering on a single or multiple specific schedule(s). The wildcard character (*) can be used to isolate a specific group of schedules. |
Entity |
Available filter of client -defined Entities via drop-down menu. Only one Entity can be selected at a time. |
Business Unit |
Available filter of client -defined Business Units via drop-down menu. Only one Business Unit can be selected at a time. |
Set of Books |
Filter of client configured ledgers via a drop-down menu. Only one ledger can be selected at a time. REQUIRED FIELD. |
Aggregation Level |
Determines the level of granularity for journal entries. While future options will be expanded to allow for more granularity, the only current option is the default of Standard. REQUIRED FIELD. |
Round Value |
Ability to apply additional rounding logic to the journal entries. Options include No, Yes, Modified. No means the debit and credit values are raw numbers with whatever decimal precision has been formatted. [The DR and CR data elements are defaults used with the No option.] Yes rounds a leg of the journal entry to allow the full journal entry to balance at two decimal places. The cumulative differences applied to any given account as part of the rounding process are reversed in a single entry at the end of the report with a ‘999’ Posting Code. Modified provides the two decimal rounding balances like the Yes option but without the ‘999’ Posting Code journal entries. [The DRCR and Posting Amount data elements are defaults used with the Yes or Modified option.] REQUIRED FIELD. An example is below. |
Round Value Example:
Rounding adjustments are generally applied to the leg of the journal entry with largest expense first. If no leg of the entry is to an expense account, the largest leg of the journal entry would receive the rounding adjustment.
In this example, setting the Round Value parameter to Yes or Modified would decrease the Accounts Payable Clearing entry by 0.01 so that the full journal entry balanced.
With a Yes setting, the cumulative differences applied to Accounts Payable Clearing over the term of the report (only 0.01 in this example) would be reversed as an entry to Rounding Expense with a ‘999’ Posting Code at the end of the report to bring the Accounts Payable Clearing account to its correct balance.
With a Modified setting, no reversing entries to Rounding Expense with a ‘999’ Posting Code are created. In this example, the Accounts Payable Clearing balance over the term of the report would reflect 0.01 lower than the actual balance.