Troubleshooting Reports - Product Advisory

April 2019

Introduction

This information is to assist users in troubleshooting reports to better understand potential issues. While these tips may not resolve all potential issues, users may be able to resolve these issues without LeaseAccelerator Support involvement. If the issues persist, please contact t Support and include the results of your troubleshooting with the request. This will allow technical resources to focus their analysis.

Reporting Helpful Hints

I am seeing this:	Possible issues and actions:
Blanks in fields that should have currency-related values (FX issue)	Run the Booked Schedules List report for the specified ledger and confirm that schedules in question have a functional currency assigned. Verify that both weighted average and spot exchange rates have been loaded for the specific currency covering all periods back to lease inception. Review FX Reporting Product Advisory from Dec. 2018 for proper usage of FX-related reporting parameters for both legacy (Excel) and BI reports
Missing schedules on reports	Check the schedule’s attributes based on the report parameters; remember, if the schedule does not meet the combination of all selected parameters, the schedule is not included in the report: As At Date: Did renewal take place after date? Was LSD after date? Ledger: Is schedule booked into the specific ledger? (Booked Schedules List) Transactional/Functional: Is schedule currency aligned to these parameters? (Booked Schedules List) Verify lease has been classified (not Non-Lease): Is Product Category/Lessee combination configured? If reclassifying, make sure to repop the deal; be mindful of the reclass effective date entered in the application. Verify that exchange rates have been loaded from lease inception. Verify that the on-screen error related to no evergreen doesn’t exist: Running Booked Schedules List with Terminated deals; Deal will show as Terminated
Missing entries on Ledger Export	Check for gaps/overlaps in the fiscal calendar for missing periods (Anomalies Report). If the error is received when running for schedule-level report, try running at asset-level (single schedule): If asset-level provides data, the sweep stalled. Try to resweep the individual schedule.
On the ASC 842 Maturity Analysis and Quantitative Analysis Reports the Classification shows Short Term	If the schedule was entered with a classification override of “Operating” for ASC 842, the schedule will be included as Short Term REGARDLESS OF TERM LENGTH. See the 18R2.4 Release Notes for more information on classification overrides.
On the ASC 842 Maturity Analysis and Quantitative Analysis Reports, there is an ERROR tab	Please review the ledger list and the number of ledgers to which the schedules are booked. If a schedule is recorded to more than 10 ledgers, consult your CSM or Implementation team.
Quantitative Analysis Report shows 2 rows for the same schedule	This may be expected behavior. Did the schedule’s status change to evergreen during the reporting period: Evergreen-related costs should render in the Operating classification line, while the in-term lease costs should render in the non-Operating classification line. Liability and Remaining Term on line representing the interim period should be zero.
Quantitative Analysis Report shows Low Value Columns	LeaseAccelerator supports both ASC 842 and IFRS 16 accounting standards. The report is designed to include all the required data for both standards, regardless of the ledger selected and its particular configuration. For ASC 842, this column will be blank. For IFRS 16, the report will include the appropriate information.

Parameter Selection Recommendation

The below are helpful hints on selecting the correct parameters to generate the Maturity Analysis Report and the Quantitative Analysis Report.

Maturity Analysis Report parameters: The Starting Period parameter is designed to select remaining payment data based on the beginning of the period selected. This may cause some user confusion since this is a forward-looking report. Additionally, liability balances represent the ending balance of the period immediately before the Starting Period. It is recommended that users select the Starting Period as the month when future payments should begin to be included.

Maturity Analysis Report example: Run the Maturity Analysis for 1^st Quarter 2019 disclosures:

Fiscal Calendar Configuration: Gregorian Calendar, 12/31 Year End
Report should include future payments starting at 4/1/19
Liability Balance as of 3/31/19 Select the following parameters:
Select the As At = 3/31/2019
Select the Starting Period Parameter of April

If the Q1 parameter was selected, the report would include payments starting with January. The liability balance would represent the balance at 12/31. In the transition year, this causes confusion because the Capitalized Operating Leases are created as of 1/1/19; therefore, the liability balance at 12/31/18 is zero

Quantitative Analysis Report parameters: The parameters are designed to select the information as it existed for the comparative periods selected. Unlike the Maturity Analysis Report, the Quantitative Analysis Report captures actual information for the selected reporting periods.

Quantitative Analysis Report example: Run the Quantitative Analysis Report for 1^st Quarter 2019 disclosure:

Fiscal Calendar Configuration: Gregorian Calendar, 12/31 Year End
Report should include information for the Jan.-March period 2019 and the comparative information (as it was reported) for Jan.-March 2018.

Select the following parameters:

Previous As At of 3/31/2018
Current As At of 3/31/2019
Fiscal Year 2019 and Period of Q1

The results will include activity for the Jan.-March periods. Liability balances will be the 3/31 period end balance for the appropriate year. Remaining terms will be as of 3/31.

Transition Policy Elections Hints

The below are helpful hints to better understand your transition policy elections which may lead to unexpected results.

Policy Elections	Helpful Hints
The last Ongoing Policy Election ASC 840 and IAS 17 refers to the Term used for accounting Note: This election is critical to enabling the system to generate consistent expense recognition for Capitalized Operating leases before and after the effective date. As previously discussed, some customers may have used reasonably assured periods and end-of-term options in their ASC 840 accounting and others may not. This election ensures that the same term and options are used through the transition (until a modification is recorded in the post-effective date period).	This election allows customers to configure the system to apply or not to apply the reasonably assurance guidance when determining Future Minimum Lease Payments for ASC 840 and IAS 17. This is particularly important for ASC 842 accounting because the guidance for leases transitioning to the new standard is to apply the same term as used to determine the holding period and contractual obligations disclosure. When checked: Indicates that the customer chooses to use original lease term and not recognize RCHP. ASC 840 accounting does NOT apply the RCHP or RCEOT. ASC 842 transition accounting will also NOT apply the RCHP or RC-EOT. This applies ONLY to leases that exist prior to the effective date. (NOTE: New takedowns and new modifications with starting date after the effective date are unaffected by this policy election and apply RCHP and RC-EOT as required.) IAS17 accounting does NOT apply the RCHP or RC-EOT. IFRS 16 accounting will apply the RCHP or RC-EOT to all leases regardless of starting date. When not checked: Indicates that the customer chooses to use recognize RCHP in the lease term. ASC 840 accounting applies the RCHP or RC-EOT. ASC 842 transition accounting will also apply the RCHP or RCEOT. This applies ONLY to leases that exist prior to the effective date. Leases that begin after the effective date will always be accounted for using RCHP and RC-EOT. IAS 17 applies the RCHP and RC-EOT. IFRS 16 accounting is applied to all leases (i.e., those that exist prior to the effective date as well as those that begin after the effective date).
IBR Policy	The IBR transition election determines the IBR term to use for transition accounting. This election is applied only to ASC 842 transition accounting: IBR is always the IBR effective at the date of transition. Exception: If a rate is not explicitly listed on the Lessee Rate Default Table or cannot be interpolated because a top or bottom term is not included on the table, in order to complete the transition process, LeaseAccelerator will use a schedule’s original IBR. The election determines whether the IBR at the transition date is based on the original lease term or the remaining term at the effective date. NOTE: If the original lease term is selected, then this term is based on the RCHP election discussed above. Checked box indicates that the selected IBR term is for the remaining lease term at transition date. Unchecked box indicates that the selected IBR term is for the original term.

Policy Elections

Helpful Hints

The last Ongoing Policy Election ASC 840 and IAS 17 refers to the Term used for accounting

Note: This election is critical to enabling the system to generate consistent expense recognition for Capitalized Operating leases before and after the effective date. As previously discussed, some customers may have used reasonably assured periods and end-of-term options in their ASC 840 accounting and others may not. This election ensures that the same term and options are used through the transition (until a modification is recorded in the post-effective date period).

This election allows customers to configure the system to apply or not to apply the reasonably assurance guidance when determining Future Minimum Lease Payments for ASC 840 and IAS 17. This is particularly important for ASC 842 accounting because the guidance for leases transitioning to the new standard is to apply the same term as used to determine the holding period and contractual obligations disclosure. When checked:

Indicates that the customer chooses to use original lease term and not recognize RCHP.
ASC 840 accounting does NOT apply the RCHP or RCEOT. ASC 842 transition accounting will also NOT apply the RCHP or RC-EOT. This applies ONLY to leases that exist prior to the effective date. (NOTE: New takedowns and new modifications with starting date after the effective date are unaffected by this policy election and apply RCHP and RC-EOT as required.)
IAS17 accounting does NOT apply the RCHP or RC-EOT. IFRS 16 accounting will apply the RCHP or RC-EOT to all leases regardless of starting date.

When not checked:

Indicates that the customer chooses to use recognize RCHP in the lease term.
ASC 840 accounting applies the RCHP or RC-EOT. ASC 842 transition accounting will also apply the RCHP or RCEOT. This applies ONLY to leases that exist prior to the effective date. Leases that begin after the effective date will always be accounted for using RCHP and RC-EOT.
IAS 17 applies the RCHP and RC-EOT. IFRS 16 accounting is applied to all leases (i.e., those that exist prior to the effective date as well as those that begin after the effective date).

IBR Policy

The IBR transition election determines the IBR term to use for transition accounting. This election is applied only to ASC 842 transition accounting:

IBR is always the IBR effective at the date of transition.
Exception: If a rate is not explicitly listed on the Lessee Rate Default Table or cannot be interpolated because a top or bottom term is not included on the table, in order to complete the transition process,
LeaseAccelerator will use a schedule’s original IBR.
The election determines whether the IBR at the transition date is based on the original lease term or the remaining term at the effective date. NOTE: If the original lease term is selected, then this term is based on the RCHP election discussed above.
Checked box indicates that the selected IBR term is for the remaining lease term at transition date.
Unchecked box indicates that the selected IBR term is for the original term.

Troubleshooting Reports - Product Advisory

Introduction

Reporting Helpful Hints

Parameter Selection Recommendation

Transition Policy Elections Hints

Was this article helpful?