Lease Expiration Report—Corporate Client/National Tenant

Make the following selections from the menu to display this page:

Reports—Corporate Clients Reports—Lease Expiration

This report shows national tenant leases expiring within a specified date range, sorted by tenant, for commercial properties (property type 6-Standard Commercial). It can be run by summary or detail.

Use the unique Sort ByProperty option to vary the information displayed in the report headers, columns and totals.

ClosedSelection Criteria

NoteNote

An asterisk ( * ) indicates a required field or selection.

Select Properties

Click to select properties from the Select Properties pop-up. The report runs for all selected properties.

Print Detail

Mark this radio button to print a detailed report.

Print Summary

Mark this radio button to print a summary report.

Print Type Recap

Check this box to print a type recap section.

From Date *

Enter the first date to report data for or select a date using the Calendar Button.

Thru Date *

Enter the last date to report data for or select a date using the Calendar Button.

Process Renewals

Use the drop-down to determine how lease renewals should be processed.Closed
Options

Do Not Process
Approved Renewals
All Renewals

National Tenant *

Select the National Tenant to include from the drop-down list.

Source of List: Setup—Global—National Tenants

Sort by Property

Use this option to determine if tenants should be listed on one report or broken out by property when you have tenants residing in multiple properties linked to the same National Tenant ID.

ClosedOptions

Checked—(default) the Report Name displays as the top center header, the National Tenant ID does not display in the upper right hand corner, a Natl Tenant column instead of a Property column is included, and a Grand Total column instead of a National Tenant Total column is included.

Use this option when tenants who reside in multiple properties are linked to the same National Tenant and you want to print one report per property that only includes tenants who reside within that property.

Unchecked—the National Tenant Name displays as the top center header, the National Tenant ID displays in the upper right hand corner as National Tenant ID: XXX, a Property column instead of a Natl Tenant column is included, and a National Tenant Total column instead of a Grand Total column is included.

Use this option when tenants who reside in multiple properties are linked to the same National Tenant and you want to print one report that includes all tenants regardless of where they reside.

ClosedReport Details

Note Note

This topic provides report details for commercial properties only; that is, properties with the property type set to 6-Standard Commercial.

Sort By Property = Checked

Natl Tenant

The National Tenant ID.

Bldg-Ste

Identifies the building and suite number.

Type

Identifies the suite type, as defined in —Setup—Property—Suite Types.

Status Flag

Identifies the national tenant's lease status as: Current, Previous or New. This is based on the Report Select Date entered on the Select Properties Grid.

Useable Sq Ft

Suite useable square footage.

Market Rent

Displays the current market rent amount in dollars and cents. Market Rent is the amount of rent the suite is currently being leased for. This amount may or may not be equal to the actual amount being billed to the tenant.

Lease Rent

Total amount of active recurring charges where Income Code type = (R) Rent

Rent Conc.

Total amount of active recurring charges where Income Code type = Concessions

Other Charges

Total amount of active recurring charges where Income Code type is not Rent or Concessions

Total Charges

Sum of Lease Rent + Rent Concessions + Other Charges

Term

Term of lease.

Lease Expires

Lease Expiration Date

Expected Move Out

If applicable, the date the tenant is expected to vacate the suite.

Previous Change

Difference between Lease Rent and total amount of most recently expired recurring charges where Income Code type = Rent

Property Totals

Totals are listed per property.

Sort By Property = Unchecked

Property

The property ID.

Bldg-Ste

Identifies the building and suite number.

Type

Identifies the suite type, as defined in —Setup—Property—Suite Types.

Status Flag

Identifies the national tenant's lease status as; Current, Previous or New. This is based on the Report Select Date entered on the Select Properties Grid.

Useable Sq Ft

Suite useable square footage.

Market Rent

Displays the current market rent amount in dollars and cents. Market Rent is the amount of rent the suite is currently being leased for. This amount may or may not be equal to the actual amount being billed to the tenant.

Lease Rent

Total amount of active recurring charges where Income Code type = (R) Rent

Rent Conc.

Total amount of active recurring charges where Income Code type = Concessions

Other Charges

Total amount of active recurring charges where Income Code type is not Rent or Concessions

Total Charges

Sum of Lease Rent + Rent Concessions + Other Charges

Term

Term of lease.

Lease Expires

Lease Expiration Date

Expected Move Out

If applicable, the date the tenant is expected to vacate the suite.

Previous Change

Difference between Lease Rent and total amount of most recently expired recurring charges where Income Code type = Rent

National Tenant Totals

Totals are listed per National Tenant.

ClosedTo Display the Corporate Clients Lease Expiration Report

  1. From the eSite menu, select ReportsCorporate Clients ReportsLease Expiration.
  2. Click Select Properties. Select the properties for which you want to print the report and click Done.
  3. Select the information you want to see on the report (refer to the Selection Criteria for this report).
  4. Select a Report Format option: Acrobat Reader (default), Crystal Viewer, Excel.
  5. Click Display. If you selected the printing option, Excel, you are prompted to open or save the report Excel file. Otherwise, the report opens in your preferred format.

Note Note

This menu item name is based on the User Corporate Clients/National Tenants Name value on the global policies Names tab. For example, if the value is "National Tenants," the name of this menu item is "National Tenants." The default is Corporate Client.

See Also

Corporate Client Reports Overview

Corporate Housing Overview

Reports Overview

Report Printing Options

Select Properties

 

Copyright © 2018 Infor. All rights reserved. www.infor.com.