Cause of Change Report - Product Advisory
Introduction
LeaseAccelerator has replaced the previous Account Cause of Change Report with a new version entitled Cause of Change. The original Account Cause of Change report tile has been removed.
The Cause of Change report shows the change in an Account Balance based on various business drivers such as normal recurring activity, additions/remeasurements, reclassifications and terminations/write-offs. It includes a summary view as well as financial statement section view that provides values at schedule level. This report is typically used to support variance analyses.
To view the new Cause of Change report tile, Power Users may need to provide access to users by selecting the report in the Access Control-Reports section of the environment.
In its current state, this report can be run in TRANSACTIONAL CURRENCY ONLY. This means that when run without the “Show Deals Denominated In” filter, the report will include all currency types present within the specified parameters.
Functional currency capabilities will be addressed in a future release.
Report Parameters:
As At Date: Determines the activity included in the report based on the accounting entries prevailing as of this date. Best practice is to use a fiscal month-end date.
Starting Fiscal Year/Starting Period: The combination of these fields determines the balances and activity to be included in the report. The “Current” and “Previous” options are based on the current system date rather than the As At date.
Schedule #: Report can be run for a single schedule or multiple schedules in a series using the wildcard character.
Set of Books: Ledger selection
Cost Center/Business Unit/Country/Lessee/Show Deals Denominated In: All filters to restrict the output based on selection
Exclude Tags: Works as the Exclude Deal Tags in other reports
Report Output:
The output as an Excel exported file consists of workbook with several tabs including Summary, Asset, Liabilities, Income, Expense, Equity and Parameters.
PDF export capabilities will be addressed in a future release.
Summary: Date range listed is based on activity dates. The Beginning Balance column reflects the account balance on the day prior to the first day in the date range. This sheet summarizes the data at account description/account number level from the subsequent sheets.
Example of Summary Information
Date Range |
01-OCT-19 to 31-OCT-19 |
|||||
|---|---|---|---|---|---|---|
Ledger Account |
Beginning Balance |
Reductions/Normal Recurring Activity |
Additions/Remea surements |
Reclassifications/ |
Terminations/Wri teoffs |
Ending Balance |
|
||||||
ARO Accumulated Amortization / (Standard-Equipme |
($471,011.59) |
($12.55) |
($471,024.13) |
|||
ARO Amortization Expense / (Standard-Equipment) |
$471,011.59 |
$12.55 |
$471,024.13 |
|||
ARO Asset / (Standard-Equipment) |
$471,417.53 |
$471,417.53 |
||||
ARO Liability / (Standard-Equipment) |
($99,512.71) |
($1.31) |
($99,514.02) |
|||
Accounts Payable - Interim Rent / (gl-coding-not-prov |
($1,500.00) |
($1,500.00) |
||||
Asset/Liability/Expense: Includes the beginning balance, multiple activity types and ending balances by account description/account number by schedule segregated by the overall account type (asset, liability, expense)
Example of Asset/Liability/Expense Information
Ledger Account |
Schedule # |
Beginning Balance |
Reductions/Normal Recurring |
Additions/ |
Reclassifications |
Terminations/ |
Ending Balance |
|---|---|---|---|---|---|---|---|
Finance Lease obligation - LT / 2600 |
8pg81 example-Capital-842 |
$0.00 |
$0.00 |
||||
Finance Lease obligation - LT / 2600 |
8ELFA example-Capital-842 |
($110,638.40) |
$97,397.20 |
$13,241.20 |
($0.00) |
||
Finance Lease obligation - LT / 2600 |
8Test 17R1 AAD |
$0.00 |
$0.00 |
||||
Finance Lease obligation - LT / 2600 |
8160022-03 |
$0.00 |
$815.61 |
($815.61) |
$0.00 |
||
Finance Lease obligation - LT / 2600 |
8160456-03 |
($991.17) |
$0.00 |
($991.17) |
|||
Finance Lease obligation - LT / 2600 |
8160483-03 |
$0.00 |
$0.00 |
$0.00 |
|||
Finance Lease obligation - LT / 2600 |
8100183-10256-01 J |
($34,567,578.84) |
$248,862.25 |
$18,632.08 |
($34,300,084.52) |
Income/Equity: Included for future expansion of account types
Parameter: Provides a snapshot of the parameters used to run the report
Note: There is a blank line between the column headers and data on the various sheets of the report. This is necessary for coding but can be deleted by the user after export to allow for additional filtering/pivot tables creation.