Generate Lease Transactions and Balances Report

You can view the lease transactions and balances report by using the Generate Lease Transactions and Balances Report link.

Generate Lease Transactions and Balances Report:

• Select Generate Lease Transactions and Balances Report from the side panel to run the program.

• The following parameters are available for Basic Options:

  • Action Type:

    • Lease Transactions and Balances Report: Select to generate the report.

  • Business Unit: Select the business unit for which you want to generate the report.

  • To: Select the month up to which you want to run the report.

• Oracle Lease Accounting notifies you when the process completes if you check the notify check box.

• Click Submit to run the process.

This report helps you in three areas:

• Displays the ROU/Liability balances for a Portfolio of Leases

• Displays the movement of balances for ROU/Liability

• Displays the reconciliation between scheduled and accounted balances

The report has Liability and ROU sections reporting the period ending balances lease-wise in a portfolio.

This report also displays the scheduled balances with accounted balances.

The Lease Liability section has the following scheduled transaction activity:

• Interest

• Payments

• Other movements, such as amendment adjustments and termination reductions

The ROU section has the following scheduled transaction activity:

• Amortization

• Other movements such as amendment adjustments, termination reductions, scope reductions for each of the accounting standards

  Lease Accounting displays each accounting standard number on individual rows of the report.

This report helps you to:

• View the ROU or Lease Liability balances for a portfolio of leases at business unit level

• Understand the activity in ROU and Lease Liability

• Compare the Scheduled and Accounted balances

• Understand the pending accounting transactions

Lease Accounting derives the accounting balances as closing of the latest fiscal year.

Note: Lease Accounting runs this report till the current period ends.

Note: The report works on the transactions from the beginning of the fiscal year to the selected period.

Lease Accounting derives the scheduled balances by summarizing the amounts from the transactions:

• Lease Accounting derives the Lease Liability balance by calculating the beginning balance + interest for the period - payments +/- adjustments - reductions

• Lease Accounting derives the ROU balance by calculating the beginning balance - amortization for the period +/- adjustments - reductions

The discrepancy between the scheduled and accounting balances points to pending user activities.