Account Balance Trend Template
This template is supported by the BVAccountBalance Business View. It is a 3-page template including the account balances for a selected time period for a specified ledger at schedule level, a summary of account balances by selected reporting period (monthly, quarterly, annually), and a parameters page. This template provides the same financial data as the Portfolio Trial Balance reports but with the option to customize the output. 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.
The template does not include an AsAt date.
Monthly values operate in the same manner as other existing account balance reports in that they represent the account balance at the end of the fiscal month equivalent to a life-of-lease Journal Entries Report (aka Ledger Export) with the month-end date as the report’s AsAt date.
Deal level data such as Deal Status, Lease Classification, BU, etc., will be reported as of the system date of report generation.
This template is located under the Design Studio tile in the Reporting workspace.
Below is an example of the parameters included in the Account Balance Template.
Report Parameter Definitions – Account Balance Trend Template
Parameter |
Definition |
|---|---|
Starting Fiscal Period |
First fiscal month-end date of which the report will provide account balance values. REQUIRED FIELD. |
Ending Fiscal Period |
Final fiscal month-end date of which the report will provide account balance values. REQUIRED FIELD |
Set of Books |
Filter of client configured ledgers via a drop-down menu. Only one ledger can be selected at a time. REQUIRED FIELD. |
Reporting Period |
Parameter to determine which months within the Starting Fiscal Period/Ending Fiscal Period time period will be included in the output on both the Detail and Summary pages.
|
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. |
Report Section |
Filter to isolate output to a specific group of accounts based on financial statement placement. Drop-down list includes All, Balance Sheet, Income Statement, Assets, Liabilities, and Expenses. REQUIRED FIELD. |
Account Description |
Parameter to focus output on specific accounts based on account description. Only one account description can be selected at a time – or the All option. Note: ‘Blank’ equates to ALL as well. |
Account Code |
Freeform text field allowing for filtering by a single account code or a range of codes using the wildcard option. |
Results contain three separate pages: Summary, Detail and Parameters. You can switch between the pages by using the Go To option in the menu bar.
Note: Changes such as filters, sorting, and groupings made on one page do NOT flow to the other pages. For example, if the Detail page was filtered on Account Description = AP Clearing, the Summary page will not reflect only AP Clearing entries.
The Summary page defaults to the Balance Reporting Currency values. This can be changed to Balance Functional Currency or Balance Transactional Currency by first removing the existing values and then adding the new option while in Interactive View. An example is detailed below.
Drag the Balance Reporting Currency value out of summary crosstab from top value (represented by the ARO Accumulated Amortization 6/30/2023 amount).
Upon releasing the mouse button, this warning will appear to which you will click OK.
The resulting summary will then be blank as shown below.
Next, drag the selected values into the uppermost cell (represented by the ARO Accumulated Amortization 6/30/2023 cell).
Upon releasing the mouse button, a menu will appear allowing you to select different aggregation functions such as Count and Sum. For this Summary, select Sum.
The Summary crosstab now reflects account balances by month in functional currency.
A Total row summarizes each column at the bottom of the Summary. [The title can be changed to Grand Total or whatever customization needed by clicking the box and typing over it.]
Caution: TOTAL ROWS DO NOT AUTOMATICALLY UPDATE TO THE CHANGED CURRENCY TYPE. The Total row reflects ‘Balance Reporting Currency’ by default. Total(s) must be separately updated to the different currency balances using the steps described above.
Additional layers of summation can also be included. In the example below, the Account Code was added to become the highest level of aggregation (to the left of the existing Account Description column). Business Unit was added to the right of Account Description.
In the next example, Balance Reporting Currency was replaced by Balance Transactional Currency on the standard Summary containing Account Description only. Account Code was then added to the left of the existing Account Description column creating the highest level of aggregation. To update the Total, drag out the 73,713.46 amount appearing in the first Total row (which was the default Balance Reporting Currency amount). The Total rows will then be blank.
Next, drag the Balance Transactional Currency to the first/top Total cell and drop. This will populate all of the associated Totals with the Transactional Currency balances. Each subsequent aggregation level will require this same update.
The (sub)Totals cannot be removed as rows, but the values and the label can be ‘hidden’ which will result in blanks for those fields.