Asset leasing reports

This article lists and briefly describes the reports that are available in Asset leasing. Most reports display by completing these steps or steps that are very similar, as noted).

• To view most Asset leasing reports, go to Asset Leasing > Inquiries and reports > Lease reports and then select a report to view. For the reports that require a different selection path, the steps to open the report are included with that report's description.
• When you select a report to print, a parameters page will open that lets you filter the information that's included on the report. Enter filter criteria, and then select OK to generate the report. The generated report will show information that falls within the filters that you specified.

Asset movement

The Asset movement report serves as a rollforward report for the right-of-use asset balances for each lease. This report lets you view the asset transactions of a lease during a specified period. The report includes the following fields.

Report fields	Description
Commencement date	The commencement date of the lease’s earliest version.
Lease term	The current version of the lease term.
Short term Lease	If the lease is classified as a short-term lease will show as Yes.
Low value Lease	If the lease is classified as a low-value lease will show as Yes.
Initial right of use asset	The original value of the right-of-use asset from the initial recognition journal entry.
Beginning balance	The net book value of the right of use asset as of the From date.
Period depreciation expense	The amount of depreciation expense taken within the date range defined for the report.
Accumulated depreciation	The amount of accumulated depreciation as of the From date.
Impairment	The amount the asset was impaired within the date range defined for the report.
Modifications	The amount of adjustments to the right of use asset between date parameters.
Net book value	The ending net book value of the right of use asset, which is the net of accumulated depreciation as of the To date.

Differences report

The Differences report shows the differences between information loaded into the Lease import framework and the information that's currently in the system. This lets you compare what was adjusted, updated, or added through the Lease import framework.

The values in the report will vary based on the selected lease. The report will only show those fields that differ from what is currently in the system and what is in the staging tables. The old value is what is either currently in the system or what was previously in the system, depending on whether the import process has run. The new value shows the value that's in the staging table that will replace the old value.

Five-years undiscounted payment forecast

The Five-years undiscounted payment forecast report shows the projected undiscounted lease payments to be paid over the next five years from the date specified on the report parameters. The report includes the following fields.

Report fields	Description
Lease Description	The lease description from the lease header.
Lease ID	The unique lease ID.
Book	The lease book associated to the book ID.
Classification	The classification of the lease.
Posting Layer	The layer to which this lease is posting.
Currency	The currency of the lease.
Current	The sum of all lease payments payable within the next 12 months from the reporting date.
13-24 Months	The sum of all lease payments payable between 13 and 24 months from the reporting date.
25-36 Months	The sum of all lease payments payable between 25 and 36 months from the reporting date.
37-48 Months	The sum of all lease payments payable between 37 and 48 months from the reporting date.
49-60 Months	The sum of all lease payments payable between 49 and 60 months from the reporting date.
Thereafter	The sum of all lease payments payable on or after 61 months from the reporting date.

GAAP cash flows report

The GAAP disclosures report satisfies the US GAAP disclosure requirement specified in 842-20-50-4(g)(1). To view this report, go to Asset Leasing > Inquiries and reports > Disclosures > GAAP – cash flows.

Report fields	Description
From date To date	Defines a range of dates that's used to restrict the information included in the report.
Legal Entity	The legal entity tied to the leases.
Lease Type	The classification of the lease as either finance or operating.
Lease ID	The unique lease ID.
Lease Description	The lease description from the lease header.
Lease Book	The lease book for which the line is referring to.
Posting Layer	Each book that is attached to a fixed asset is set up for a particular posting layer that has an overall depreciation objective.
Lease Group	The group which the lease is tied to.
Currency	The abbreviation for the transactional currency used. All reports will convert the transactional currency to the reporting currency.
Finance Leases – Operating Cash Flows	The sum of the total posted variable payments and the total interest payments posted from the amortization schedule between the date parameters.
Finance Leases – Finance Cash Flows	The sum of the total principal payments from the amortization schedule between the date parameters.
Operating Leases – Operating Cash Flows	The sum of all posted lease payments and posted variable payments between the date parameters.

Lease balances forecast

The Lease balances forecast lists information directly from the liability amortization schedule and asset depreciation schedule. The report shows forecasted amounts of the projected lease liability, and right-of-use assets over a period of time, including all projected expenses for those leases. The report includes the following fields.

Report fields	Description
Beginning balance	The beginning balance in the lease’s amortization schedule for the period containing the start date of the report.
Initial recognition	If the commencement date of the lease falls within the date range defined for the report, this column will display the liability account value of the initial recognition journal entry.
Payments	The sum of the lease’s payments that fall within the date range defined for the report.
Interest	The sum of the lease’s interest expenses that fall within the date range defined for the report.
Ending balance	The liability balance of the lease as of the To date.
Short-term liability	The short-term liability amount in the lease’s amortization schedule as of the To date.
Long term liability	The long-term liability amount in the lease’s amortization schedule as of the To date.
Beginning Net Book Value	The “Beginning Net Book Value” in the lease’s asset depreciation schedule for the period containing the start date of the report
Initial recognition	If the commencement date of the lease falls between the report’s date parameters, this column will display the asset account value of the initial recognition journal entry.
Depreciation expense	The sum of the lease’s depreciation expenses that fall within the date range defined for the report.
Ending balance	The asset balance as of the lease as of the To date.
Equity adjustment	The beginning balance minus the beginning net book value.

Lease commencements report

The Lease commencements report shows all leases that have commenced within a specified date range including the initial liability and right-of-use asset balances. The report includes the following fields.

Report fields	Description
Commencement Date	The date of the initial recognition journal entry that was posted for that lease version.
Initial liability amount	The liability amount from the initial recognition journal entry.
Initial asset amount	The asset amount from the initial recognition journal entry.

Lease modification report

The Lease modification report shows all leases that have been modified within a specified date range. The report also shows the user who adjusted the lease, and the total amount of liability adjusted. The report includes the following fields.

Report fields	Description
Adjusted by	The username of the person who modified the lease.
Adjustment fate	The date on which the adjustment journal entry was posted.
Adjustments	The amount for any adjustment journal entry posted to the lease’s liability account between the date parameters. Credits will appear positive, while debits will be negative.
Gain (loss) amount	The amount for any adjustment journal entry posted to the lease’s gain/loss account between the date parameters. Credits will appear positive, while debits will be negative.
Retained earnings	The amount for any adjustment journal entry posted to the lease’s retained earnings account between the date parameters.
Ending liability balance	The resulting liability balance as of the adjustment date of the lease.

Lease movement report

The Lease movement report serves as a rollforward report for the lease liability balances for each lease. This report allows the user to view the liability transactions of a lease during a specified period.

Report fields	Description
Commencement date	The commencement date of the lease’s earliest version.
Lease term	The lease term of the lease’s earliest version.
Payments remaining	The number of payments that have not yet been posted for the lease.
Beginning balance	The sum of all transactions affecting the lease’s liability that occurred before the report’s start date.
Initial recognition	The amount of any initial recognition transaction for the lease that was posted within the date range defined for the report.
Payments	The sum of the lease’s payment transactions that have been posted within the date range defined for the report. The values in this column will appear as negative amounts as the payments are decreasing the lease’s liability balance.
Interest	The sum of the interest accruals that have been posted against the lease within the date range defined for the report.
Adjustments	The sum of the lease’s posted adjustment transactions within the date range defined for the report.
Ending balance	The balance of all the lease’s liability transactions that have been posted as of the To date of the report.

Lease transactions report

The Lease transactions inquiry shows all the journal entries that have been generated by Asset leasing. Each journal entry is linked with the book ID it was originated from. This lets you easily associate the journal entry with corresponding lease. The Lease transactions inquiry functions in a manner that's similar to the Voucher transactions page in General ledger.

Weighted-average discount rate report

The Weighted-average discount rate report satisfies the US GAAP disclosure requirement specified in ASC 842-20-50-4(g)(4) for a weighted-average discount rate. To view this report, go to Asset Leasing > Inquiries and reports > Disclosures > Weighted-average discount rate. The report includes the following fields.

Report fields	Description
As of date	This report will include all leases that have commenced on or before the As of date parameter. This report should be run as of the last day of the period to be disclosed.
Legal entity	The legal entity that is tied to the lease.
Lease ID	The unique lease ID.
Lease description	The lease description from the lease header.
Book	The specific book type of the displayed lease.
Posting layer	Each book that is attached to a fixed asset is set up for a particular posting layer that has an overall depreciation objective.
Lease group	The group to which the lease belongs.
Discount rate	The rate used to discount lease payments.
Currency	The abbreviation for the transactional currency used. All reports will convert the transactional currency to the reporting currency.
Lease payments remaining	The total amount of unpaid lease payments from the payment schedule remaining from the As of date.
Weighted payments remaining	The lease payments remaining multiplied by the discount rate used.