Landing Dashboard

Download Document

This guide covers navigation, panel descriptions, parameter configuration, and drill-through functionality for the Landing Dashboard.

The Landing Dashboard provides a real-time, consolidated view of your lease portfolio. Accessible directly from the Home screen, it displays seven analytical panels covering lease status, classification, financial balances, expenses, and end-of-term activity. Many panels support interactive drill-through reporting to allow deeper analysis without leaving the dashboard.

With the initial release of the new functionality, non-classified schedules will not be included in the resulting data. An update to include non-classified schedules (for applicable panels) is scheduled for a future release.

Note: The Landing Dashboard has been transitioned to the v2 reporting platform. As a result, all drill-through reports include the same export options available in other v2 reports.

Getting Started

Accessing the Dashboard

From the Home screen, the Landing Dashboard loads automatically, displaying all panels based on your current parameter selections. The dashboard defaults to the same ledger settings used with the Deal Summary screen.

Dashboard Parameters

Three parameters at the top of the dashboard control the data displayed across all panels.

After making selections, click Submit to refresh all panels.

Note:

• Business Unit and Entity drop-down options are not dynamically filtered based on the Ledger selection. All configured values are always available for selection.
• The Ledger, Business Unit, and Entity dropdowns do not support in-dropdown search in this release. To locate a value, scroll through the list. This will be addressed in a future release.

Dashboard Panels

The dashboard contains seven panels. Each section below describes the panel's purpose, the data it displays, and how to use its drill-through functionality, if applicable.

Lease Status

Displays a bar graph showing the count of lease schedules by status as of the current system date.

Statuses Shown

The panel includes all applicable statuses in your data set. Labels only appear for statuses with at least one schedule. Statuses include:

• Active
• Defunct (Rolled Back)
• Disposed
• Evergreen
• Renewed
• Terminated

Drill-Through

Click any status bar to open a drill-through report. The report includes the following fields:

• Deal ID
• Schedule Number
• Deal Status
• Lease Classification
• Lease Start Date
• Effective End Date

The drill-through report header reads: Drill through on: Lease Status = [selected status]

Lease Classification

Displays a donut chart showing the count of lease schedules by classification as of the current system date.

Classifications Shown

The panel maps accounting classifications to portfolio classifications as follows:

Drill-Through

Click any classification bar to open a drill-through report. The report includes the following fields:

• Deal ID
• Schedule Number
• Deal Status
• Lease Classification
• Lease Start Date
• Effective End Date

The drill-through report header reads: Drill through on: Lease Classification = [selected classification]

NBV of ROU – NBV of Liabilities/Expense

Displays three financial figures derived from the Account Balance Trend and Account Activity Trend reports. All values are shown in the reporting currency configured at the ledger level.

NBV of ROU (Top Box)

Shows the net book value of Right-of-Use assets as of the current fiscal month-end, sourced from the Account Balance Trend report filtered on Report Section = Assets.

Drill-through surfaces the Account Balance Trend report with:

• Starting and Ending Fiscal Period set to the current fiscal month-end
• Ledger set to the selected ledger
• Reporting Period defaulted to Monthly
• Report Section filtered to Assets

The drill-through report header reads: Account Balance Trend – NBV of ROU

NBV of Liabilities (Middle Box)

Shows the net book value of lease liabilities as of the current fiscal month-end, sourced from the Account Balance Trend report filtered on Report Section = Liabilities.

Drill-through surfaces the Account Balance Trend report with:

• Starting and Ending Fiscal Period set to the current fiscal month-end
• Ledger set to the selected ledger
• Reporting Period defaulted to Monthly
• Report Section filtered to Liabilities

The drill-through report header reads: Account Balance Trend – NBV of Liabilities

Expense (Bottom Box)

Shows two expense figures: Year-to-Date (YTD) and Month-to-Date (MTD), both in reporting currency.

• YTD is sourced from the Account Balance Trend report filtered on Report Section = Expenses.
• MTD is sourced from the Account Activity Trend report filtered on Report Section = Expenses.

Both drill-through reports use the current fiscal month-end as the Starting and Ending Fiscal Period and default Reporting Period to Monthly. A date/timestamp appears beneath each report title.

Total Expense vs. Evergreen Expense

Displays two expense figures to help assess the proportion of monthly lease rental expense attributable to evergreen schedules. All values are shown in reporting currency.

Monthly Lease Rental Expense (Top Box)

Shows the current month’s total lease rental expense, sourced from the Account Activity Trend report. The value represents the sum of Lease Rental Expense and Lease Rental Expense–CapOp Depreciation for the current fiscal month-end.

Spent Monthly Towards Evergreen (Bottom Box)

Shows the portion of monthly lease rental expense attributable to schedules currently in evergreen status, along with a calculated percentage.

Percentage formula:

• Spent Monthly Towards Evergreen ÷ Monthly Lease Rental Expense × 100
• Displayed as a percentage with two decimal places

Source: Account Activity Trend report filtered on Lease Rental Expense for schedules in evergreen status as of the system date.

End-of-Term within 6 Months

Displays a bar graph showing the number of lease schedules whose Effective End Date falls within each of the next six calendar months. Evergreen status deals are excluded from all totals. Dates are based on calendar months, not fiscal months.

Drill-Through

Click any monthly bar to open a drill-through report for that month. The report includes:

• Deal ID
• Schedule Number
• Lease Start Date
• Effective End Date
• Current Rent (Transactional)

The drill-through report header reads: Drill through on: EOT within 6 months = [selected month]

Balance Sheet Analytics

Displays a comparison grid of balance sheet account balances. Use the MoM/YoY parameter in the center of the dashboard to toggle between Month-over-Month and Year-over-Year views. All values are shown in reporting currency.

Month-over-Month (MoM) – Default View

Compares account balances for the two most recent fiscal month-end dates. The grid includes a delta (difference between the two periods) and a % Change column.

Source: Account Balance Trend report filtered on Report Section = Balance Sheet.

Year-over-Year (YoY)

Compares account balances for the same fiscal month-end date across two consecutive years. The grid includes a delta and % Change column.

Source: Account Balance Trend report filtered on Report Section = Balance Sheet.

Income Statement Analytics

Displays a comparison grid of income statement account activity. Use the same MoM/YoY parameter as the Balance Sheet Analytics panel to toggle views. All values are shown in reporting currency.

Month-over-Month (MoM) – Default View

Compares account activity for the two most recent fiscal month-end dates. The grid includes a delta and % Change column.

Source: Account Activity Trend report filtered on Report Section = Income Statement.

Year-over-Year (YoY)

Compares account activity for the same fiscal month-end date across two consecutive years. The grid includes a delta and % Change column.

Source: Account Balance Trend report filtered on Report Section = Income Statement.

Exporting the Balance Sheet & Income Statement Analytics

While other panel drill-through reports are individually exported, the Balance Sheet & Income Statement grids are exported as a set by utilizing the standard export icon in the menu bar. As such, the date and timestamp will not appear in the exported version of the grids.

In addition, formatting retains shape more accurately when selecting the Report Format option while exporting to Excel.

Quick Reference