Accounting Roll Forward Report - Product Advisory

(Functional & Reporting Currency Functionality)

May 2022

Business Summary

The purpose of the Accounting Roll Forward report is to provide the user the ability to see all activity, by the various types of events during the period being reviewed, for a specific lease or the entire lease portfolio or subsets thereof. Starting with a prior closed period, which period may have been previously reviewed or audited, the report rolls forward all balance sheet accounts by the type of event including new deals, deal modifications, terminations, impairments, and other activity. The Accounting Roll Forward report, along with the Quantitative Analysis Report and the Maturity Analysis Report, are critical reports for Month-End-Close. This report is a valuable sub-ledger report in the tracking of a portfolio. It includes the ability to filter on a variety of changes and to tie balance sheet accounts to both the ERP as well as the footnote disclosures.

With the latest release, the report can now be generated in transactional, functional, or reporting currencies. Options for running the report in transactional and functional currencies include “ALL” so that a single report can be used to view balances and activities in all transacted or functional currency types for schedules in the selected ledger.

Generating the Report

To locate this report, select Reporting from the left Nav Bar. Then click on the Accounting tile. The list of Accounting Reports is ordered alphabetically in the menu on the right. This version of the report is titled Accounting Roll Forward-FX.

Note: The original version of the Accounting Roll Forward Report, which is available in transactional currency only, is targeted for retirement with the 22R3 release.

This report can now be run in functional or reporting currencies. The report considers reporting currency set at ledger level so reports can be generated in different report currencies.

Graphical user interface

Description automatically generated

Report Parameter Definitions

Parameter	Description
As At Date	This setting works the same way as the AsAt Date parameter on the Ledger Export. Default is the fiscal month-end date prior to the system date. Drop-down menu includes two future fiscal month-end dates and all prior fiscal month-end dates. This is a REQUIRED FIELD.
Starting Fiscal Year	The fiscal year that the current period belongs to. This is a REQUIRED FIELD. Not recommended to run for future periods.
Starting Period	This is combined with the Starting Fiscal Year above to define the beginning fiscal month for the report. The options include Current Month, Prior Month, Current Quarter, Prior Quarter, Q1, Q2, Q3, Q4, and all months. Note: The Current and Prior settings are in relation to the System Date when the report is generated – NOT THE ASAT DATE. Likewise, the Q# settings are based on the fiscal calendar for the selected Starting Fiscal Year. This is a REQUIRED FIELD.
# of Months of Lease Expense to Transfer	Combined with the Starting Period above, this parameter determines how many months of data will be included in the report. It is a drop-down menu with values of 1 thru 12. Note: The Starting Period selection indicates the beginning month only. If ‘Quarter’ selections are made for the above parameter, the value for this parameter should be ‘3’. This is a REQUIRED FIELD.
Ledger	Filters customer ledgers via drop-down menu. This is a REQUIRED FIELD.
Report Using	Transactional/Functional/Reporting – Selection drives the FX treatment used for the report. This is a REQUIRED FIELD with a default of Reporting. Note: If Transactional or Functional is selected, a warning will appear explaining that the “Show Deals Denominated In” field (below) must also be selected. Please refer to the “Additional Notes” section regarding these dynamic parameters.
Currency Measured In	Dynamic list of currencies available based on the “Report Using” selection. When “Report Using” is set to “Reporting Currency”, the drop-down menu will include the currency selected as Reporting Currency during ledger configuration for the selected ledger. If no Reporting Currency was configured for the selected ledger, the Reporting Currency configured at the environment level will populate the drop-down menu. When “Report Using” is set to “Functional Currency”, the drop-down menu will include the currencies assigned as functional currencies to the schedules booked into the selected ledger as well as an ALL option. When “Report Using” is set to “Transactional Currency”, the drop-down menu will include all transactional currencies for the schedules booked into the selected ledger as well as an ALL option.
Show Deals Transacted In	Drop-down list of currencies in which schedules booked into the selected ledger were transacted. When “Report Using” is set to “Transactional Currency”, this selection must be the same currency as the “Currency Measured In” selection. When “Report Using” is set to either “Reporting Currency” or “Functional Currency”, this parameter acts as a granular filter. Example: Report Using = Reporting Currency; Currency Measured In = USD, Show Deals Transacted In = EUR will select just the schedules booked to the selected ledger that were transacted in EUR but will reflect the output in USD.
Exclude Tags	Some customers apply tags to schedules such as InterCompany, Land Only, etc. This option allows the exclusion of tagged schedules for reporting purposes. Multiple tags may be included in the selection by clicking the first choice, holding down the CTRL key, and clicking the next choice.
Schedule #	Available filtering on a single or multiple specific schedule(s). The wildcard character () can be used to isolate a specific group of schedules. For example, Fin would select all schedules that begin with “Fin”.
Entity	Available filter of customer-defined entities via drop-down menu.
Business Unit	Available filter of customer-defined business units via drop-down menu.
Country	Available filter of customer-defined countries (GEOs) via drop-down menu.
Lessee	Available filter of customer-defined Lessees via drop-down menu.
Report Section	Drop-down list that will filter the output based on groups of accounts that are associated with specific sections of a standard financial statement. Example of the drop-down menu: New addition! Balance Sheet was added to allow for both Assets and Liabilities on a single report.
Account Description	Available filter of account descriptions via drop-down menu.
Filter By	Drop-down list of the Segment assignments associated with the selected Ledger. This will be the filter set at the top of the ‘AccountingRollForward’ tab described later in this document. This is a REQUIRED FIELD. This defaults to Segment 1 but best practice would be to select the segment associated with your GL Code. Example of parameter choices in which sample ledger has 11 ledger segments:
Drilldown Rows By	Drop-down list of the Segment assignments associated with the selected Ledger. This will be the attribute used in the ‘AccountingRollForward’ tab to summarize data within each account description, or further drill down to schedule level detail. This is a REQUIRED FIELD. This defaults to Segment 1 but best practice would be to select the segment associated with your GL Code. Example of parameter choices in which a sample ledger has 11 ledger segments defined:

Once the parameters have been selected, click on the Export button for the report to begin generating. (Please see the Additional Notes section below.)

When the report is complete, the standard Excel file (.xlsx) will be visible in the lower-left corner of the screen.

This report can now be scheduled. Please refer to the LeaseAccelerator Success Center website for instructions regarding scheduling functionality.

Note: Note: Currently, reports generated via the scheduling function are showing the system date of generation as the AsAt date when the “Run AsAt” field is left blank. Best practice is to select either Prior Month, Prior Quarter or Prior Year for the “Run AsAt” field which will ensure the proper fiscal month-end close AsAt date. This will aid in reconciliation between accounting reports.

Report Output

This report is comprised of three tabs:

All – Base data file for the Accounting Roll Forward report
AccountingRollForward – The main report which is a pivot table based on the All sheet
Parameters – Provides a snapshot of the selected parameters used for report generation

The “All” section is the standard Ledger Export with some additional columns as described in the table below. Note that there are additional entries on this sheet that comprise the data needed for the Opening Balance calculation.

“All” Tab Descriptions

Parameter	Description
Ledger Date	Date of record for the associated ledger entry.
FX Conversion Date	Date used for first-level functional remeasurement based on account type.
FX Rate Type	Rate type used for first-level functional remeasurement; Options include Spot or Weighted Average (where Weighted Average equates to the client default rate).
GL Segments (1 thru 11)	Customer ledger segment based on ledger configuration.
Account Description	Account Description based on standard LeaseAccelerator definition.
Transactional Currency	Currency in which the schedule was transacted.
Transactional DR	Debit entry valued in transactional currency.
Parameter	Description
Transactional CR	Credit entry valued in transactional currency.
Transactional Net	Net of the Debit (DR) and Credit (CR) entries for the specific row valued in transactional currency.
Functional Currency	Currency assigned to the schedule for functional remeasurement.
Functional DR	Debit entry including first-level functional remeasurement valued in functional currency.
Functional CR	Credit entry including first-level functional remeasurement valued in functional currency.
Functional Net	Net of Debit (DR) and Credit (CR) entries for the specific row including first-level functional remeasurement valued in functional currency.
Reporting Currency	Currency selected as Reporting Currency during ledger configuration for selection under “Ledger” parameter. If no Reporting Currency was configured for the specified ledger, Reporting Currency will refer to the environment level setting.
Reporting DR	Debit entry including the translation adjustment valued in reporting currency.
Reporting CR	Credit entry including the translation adjustment valued in reporting currency.
Reporting Net	Net of Debit (DR) and Credit (CR) entries for the specific row including translation adjustment valued in reporting currency.
Pivot Basis	Equals the “Report Using” parameter selection. This is used for generating the pivot table.
Pivot Currency	Equals the associated “XXX Currency” column associated with the “Report Using” parameter selection. Example: If “Report Using” is set to Functional Currency, this column will mirror the “Functional Currency” column. This is used for generating the pivot table.
Pivot Net	Equals the associated “XXX Net” column associated with the “Report Using” parameter selection. Example: If “Report Using” is set to Functional Currency, this column will mirror the “Functional Net” column. This is used for generating the pivot table.
Schedule	Schedule number associated with the ledger entry.
Comments	Combination of the word “Schedule” along with the schedule number and adjusting entry fiscal month/fiscal year identifier (if applicable) associated with the ledger entry.
Entry Type	Assignment of the reason, or cause, for which each line item was created. These numbered events become headers for segmenting and summarizing the Affected Components in the report’s pivot table. See Exhibit B for a list of Entry Types currently being utilized.
Affected Component	Assignment of the lease attribute for which each line item was created. These attributes become sub-headers to the Entry Type reasons/causes in the report’s pivot table. See Exhibit B for a list of Affected Components currently being utilized.
Triggering Event	Secondary assignment of type of event for which each entry was created. While this column is not used in this report’s pivot table, it is visible during additional drilldown. See Exhibit B for a list of Triggering Events currently being utilized.
Event Details	Details associated with the Triggering Event. While this column is not used in this report’s pivot table, it is visible during additional drilldown.
JE Type	High-level description for each entry. This column is used as a default filter for the pivot table. See Exhibit B for a list of JE Types currently being utilized.
Posting Code	LeaseAccelerator nomenclature related to the specific journal entry leg.
JEShortDesc	LeaseAccelerator nomenclature providing a brief explanation of the basis of the journal entry.
Parameter	Description
LedgerEntrySubId	LeaseAccelerator nomenclature related to the specific journal entry leg.
LedgerEntryId	LeaseAccelerator nomenclature related to the specific journal entry leg.
Status	Status of the journal entry relating to integration only. This is not related to the status of the schedule.
ExternalDocumentId	Document ID’s related to integration results.
Filter By	Value for the specific line item as it relates to the chosen ledger segment in the “Filter By” parameter described in the above section.
Drilldown By	Value for the specific line item as it relates to the chosen ledger segment in the “Drilldown By” parameter described in the above section.

The “AccountingRollForwardFX” section is the main report. It is a pivot table based on the data in the “All” tab. Some sections of the report are described in the table below.

“AccountingRollforwardFX” Tab Descriptions

Parameter	Description
Filter By	Pivot table filter based on the parameter selection “Filter By” described in the Report Parameter Definitions above.
JE Type	Pivot table filter based on the JE Type described in the above table.
Account Description	Account Description based on standard LeaseAccelerator definition. This is the largest subtotal category in the pivot table.
Drilldown By	Second subtotal category in the pivot table. It is determined by the parameter selection “Drilldown By” described in the Report Parameter Definitions above.
Pivot Basis Currency	Third subtotal category in the pivot table. Please see “All Tab Descriptions” above for further explanation.
Entry Type and Affected Components Columns	Drawn from the Entry Type assignments described above and in Exhibit B, this section of the pivot table groups the Affected Components by reason/cause descriptions. All pivots begin with ‘01’. Opening Balance column and end with Grand Total column generally after the ##. Closing Balance column. Each section of Entry Types will have a ‘Total’ column. EX: 01. Opening Balance Total. The numbering sequence varies based on the various types of entries included in the report output.

The pivot table operates as a standard Excel pivot table in that the user can select/unselect fields as well as move them from columns to rows. Standard drilldown capabilities also exist that enable the user to drilldown to the exact ledger entries that make up a selected value.

The Parameter tab includes the parameters selected to generate the report. The Filter By and Drilldown By selection will reflect the Segment number selected as opposed to the attribute the segment is defined as in the ledger. (Example: Segment 3 will appear instead of Lessee.)

A sample of the report output is included in Exhibit A.

Additional Notes

Some additional notes to be aware of with respect to specific situations:

A blocker is included within the report that will notify the user relatively quickly in the event the expected number of rows of data would exceed 900,000. When this occurs, the exported file will include the following message: Your request is asking to return xxxxxx journal entries. The limit is 900,000. Please refine your criteria.
Refining criteria should include applying additional parameters such as Business Unit, Report Section or any combination of the non-required parameters discussed above with the intent of reducing the number of rows of output to less than 900,000.
Depending on the selected parameters and the portfolio size, the report calculations could exceed 30 mins at which point the login screen may appear. If this occurs, the report is still generating in the background and will be available for export from the Systems Operations Console once it has completed. When an extended wait time is anticipated, clicking the Email button will take the user back to the Accounting Roll Forward-FX report screen while the report continues to run in the background. CAUTION: Associated files are quite large and may not successfully pass through many email systems. As mentioned above, once the report has been completed, it will be available for export from the Systems Operations Console whether the user waited or clicked the Email button.
Income statement accounts include prior year amounts in the Opening Balance when the report is run using the first month of the fiscal year. (Example: January or Q1 using a standard Gregorian fiscal calendar). Income statement Closing Balances are correctly reflecting the current expense activity only which results in a non-zero amount in the Grand Total column. The workaround for this is to manually override the Opening Balances for income statement accounts with a zero.
“Report Using”, “Currency Measured In” and “Show Deals Denominated In” are dynamic parameters in which the drop-down values change depending on the selected ledger. Currently, when these parameters are set prior to non-required parameters (Example: Schedule #, Report Section, etc.), they revert to the default value when the non-required parameters are entered. The current workaround is to populat

Exhibit A

Sample of report output.

Graphical user interface, application, table

Description automatically generated

Exhibit B

Entry Types

Accretion	Additions	Adjustment	Amortization	Closing Balance	Impairment	LT/ST	Opening Balance
Other	Payment	Purchase	Reallocation	Receipt	Takedown Adjustment	Variable Expense	Writeoff

Affected Components

Accrued Interest Balance	ARO	ARO Balance	Asset Purchase	Base Lease	CAMS	Deferred Rent/SPTA Balance
FX	Guaranteed Residual Value	IDC	IDC Balance	IFRS Transition Alternate Valuation	Impairment	Interim Rent
Late Fees	Lease Incentive	Net Balance	Net Writeoff	Nonremeasuring Payment Adjustment	Other Related Expense	Prepayment
Property Insurance	Purchase Option Liability	Real Estate Tax	Reduction in Scope	Refund of Deposit	Reinstated ARO Amortization	Reinstated Depreciation
Reinstated Impairment	Return/Early Termination Fee	Security Deposit	Special Deposit	Unamortized Portion of Lease Incentive	Unpaid Lease Incentive	Variable Expense
Translation Adjustment

Triggering Events

A/P Reconciliation	Buyout	Closing Balance	Functional Currency Remeasurement	Impairment
Incurred	Modification	Modification (Correcting)	Monthly Activity	Opening Balance
Original Contract Term	Original Contract Term (Correcting)	Reallocation	Reallocation (Correcting)	Remeasurement Due to Implicit Changes in Estimates
Remeasurement Due to Implicit Changes in Estimates (Correcting)	Remeasurement Due to Payment Adjustment	Remeasurement Due to Payment Adjustment (Correcting)	Renewal	Renewal (Correcting)
Reporting Currency Remeasurement	Reporting Currency Translation	Return	Return (Correcting)	Rounding Adjustment
Rounding Adjustment (Correcting)	Transition	Transition (Correcting)	Unknown (Correcting)	Unknown (Historical)

JE Types

Balance	Catch-up entry for backdated activity	Correcting entry for closed journal entries	Entry improperly backdated from subsequent period	FX Remeasurement
Month 13	Normal	Normal (Historical)	Rounding	RPT FX Translation