Account Activity Trend Template
This template is supported by the BVAccountActivity Business View. It is a 3-page template including the account activities for a selected time period for a specified ledger at schedule level, a summary of account activities by selected reporting period (monthly, quarterly, annually), and a parameters page. This template provides the same financial data as the Account Activity Trend 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 activity reports in that they represent the account activities occurring within the fiscal month based on the 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., is 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 Activity Template.
Report Parameter Definitions – Account Activity Trend Template
Parameter |
Definition |
|---|---|
Starting Fiscal Period |
First fiscal month-end date of which the report will provide account activity values. REQUIRED FIELD. |
Ending Fiscal Period |
Final fiscal month-end date of which the report will provide account activity values. REQUIRED FIELD |
Ledger |
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 Summary page. (Detail page will include all months within the selected date range.)
|
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 Activity Reporting Currency values. This can be changed to Activity Functional Currency or Activity Transactional Currency by first removing the existing values and then adding the new option while in Interactive View. An example, with the Reporting Period set to Quarter, is detailed below.
Drag the Activity Reporting Currency value out of summary crosstab from top value (represented by the Accounts Payable – Interim Rent Q4-2022 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 Accounts Payable-Interim Rent Q4-2022 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 activity summations by quarter in transactional 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.]
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, Activity Reporting Currency was replaced by Activity Functional 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 3,164.41 amount appearing in the first Total row (which was the default Activity Reporting Currency amount). The Total rows will then be blank.
Next, drag the Activity Functional Currency to the first/top Total cell and drop. This will populate all of the associated Totals with the Functional Currency activity totals. 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.