Creating and Maintaining Leases

This chapter provides an overview of leases, lists prerequisites and common elements, and discusses how to:

Click to jump to parent topicUnderstanding Leases

PeopleSoft Real Estate Management is an integrated solution that effectively manages the entire life cycle of a corporate real estate lease, from lease execution and financial processing through lease expiration and termination.

A lease is an agreement between a lessee (tenant) and a lessor (owner, landlord, or property manager) that defines terms of the rental, such as the period of time and rent amount for a property or multiple properties. The lease is the basis for invoices or vouchers and receipts or payments. You create a lease to enable processing for an invoice or payment for recurring rent and operating expenses for that lease.

You can process everything from a single invoice or payment to the most complex recurring invoices or payments as required by the lease. You can perform cost allocations, rent escalations, and capacity planning for your organization, and establish critical date alerts to notify you when you must take action on or make a decision about a particular lease.

Before you create a lease, you must determine the type. There are two types of leases: payables leases and receivables leases. Your role—landlord or tenant—determines the type of lease that you create.

This section discusses:

Click to jump to top of pageClick to jump to parent topicPayables Leases

Payables leases enable a tenant (lessee) to manage and report on rent, operating expenses, and miscellaneous rents. You can set up recurring payment schedules to facilitate the lease. You can set up percent rent terms based on sales reported by tenant. You can capture specific lease clauses and lease options, and set up critical date alerts for important events related to the lease, such as lease expiration. You can also audit operating expenses, comparing with previous years to ensure continuity of spending.

You create a payables lease when your organization is the tenant (or lessee) and you are issuing rent payments to a landlord (or lessor) for space that you are occupying. You enter the lease terms from your signed lease agreement as a payables lease and set it up for payment processing through PeopleSoft Payables. As a result, the majority of your transactions are payables transactions or payments that you are issuing through PeopleSoft Payables to be paid to your landlord.

When you enter the lease, you can establish recurring rent payments that the system processes on a periodic basis of your choosing. When processing rent payments, the system generates transactions with PeopleSoft Payables as the transaction destination. Even manual payments, which include ad-hoc entries, security deposits, operating expense audits, and percent rent sales reports, can be sent through PeopleSoft Payables with their associated accounting ChartFields, as determined by the transaction routing code and accounting rule setup. You can also send through PeopleSoft Payables (first as a negative reversal entry of the originating transaction and then as a new entry for the revised payment amount) any adjustment entries caused by changes in security deposits, operating expense audit adjustments, or percent rent sales reports.

For payables leases, the integration points to consider for processing are PeopleSoft General Ledger (for straightline accounting), Payables, and Asset Management (for the Asset Repository). Since PeopleSoft Billing integration is not needed for payables leases, any adjustment transactions are sent through PeopleSoft Payables as negative voucher entries.

See Defining Transaction Routing Codes.

See Understanding PeopleSoft Real Estate Management Accounting Rules.

Click to jump to top of pageClick to jump to parent topicReceivables Leases

Corporate real estate management sometimes requires landlord billing capabilities for leasing owned property and subleasing leased property. Accounting for all costs and lease income associated with lease management is critical to a landlord (lessor). Receivables leases enable you to collect rent, manage your expenditures, and allocate them proportionately to the departments or other entities.

When you create a receivables lease, you set up recurring invoices that generate automatically in the frequency defined in the lease. You can track lease clauses and options, and set up critical dates to remind you of important events related to the lease, such as lease expiration. You can also set up simple to complex rent terms, track percent rent schedules, and upload percent rent sales reports to determine the percent increase to bill for monthly rent.

You create a receivables lease when your organization is the landlord (or lessor) and you are submitting rent bills to a tenant (or lessee). For a receivables lease, you enter the lease terms from your signed lease agreements and set up the terms for processing as the landlord. As a result, the majority of your transactions are billing transactions or bills that you are issuing through PeopleSoft Billing to your tenant.

When entering the lease, you can establish recurring rent bills that the system processes on a periodic basis of your choosing. When processing rent invoices, the system generates transactions with PeopleSoft Billing as the transaction destination. Even manual bills, which include ad hoc entries, security deposits, operating expense reconciliations, and percent rent sales reports, are sent through PeopleSoft Billing with their associated accounting ChartFields, as determined by the transaction routing code and accounting rule setup. You can also send through PeopleSoft Billing (first as a negative reversal entry of the originating transaction and then as a new entry for the revised payment amount) any adjustment entries caused by changes in security deposits, operating expense audit adjustments, or percent rent sales reports.

Security deposit refund processing, which is available on receivables lease processing (outside of the lease component) can potentially divert the security deposit refund to PeopleSoft Payables if, during lease expiration, the refund has not been depleted by sufficient deductions to cover the remaining amount outstanding and money is owed back to the tenant.

For Receivables leases, the integration points to consider for processing are PeopleSoft General Ledger (for straightline accounting), Billing, and Asset Management (for the Asset Repository). Although, for the most part, any adjustment transactions are sent through PeopleSoft Billing as negative invoice lines, a PeopleSoft Payables integration is also available (and potentially necessary) to handle security deposit refund processing during lease expiration.

See Understanding Transaction Routing Codes.

See Understanding PeopleSoft Real Estate Management Accounting Rules.

Click to jump to top of pageClick to jump to parent topicProcess Flow Overview for Creating a Lease

The high-level business process flow for creating a lease consists of these steps:

  1. Define the general lease information.

  2. Enter the lease timetable and lease administration information.

  3. Add the property information.

  4. Define the financial terms of a lease.

  5. Add base rent.

  6. Add the operating expenses.

  7. Add miscellaneous rent.

  8. Define percent rent information.

  9. Enter security deposits.

  10. Add lease clauses.

  11. Establish options and set critical dates.

  12. Add and attach pertinent notes.

  13. Define internal and external contacts for the lease.

  14. Validate and activate lease.

See Establishing Operating Expenses for a Lease, Setting Up Percent Rent Terms, Setting Up Security Deposits, Setting Up Options and Critical Dates, Understanding Real Estate Management Contacts.

Click to jump to parent topicPrerequisites

Before creating leases, you must:

See Adding New Vendors, Adding General Customer Information.

See Pages Used to Define Common Journal Definitions.

See Also

Structuring Leases

Click to jump to parent topicCommon Elements Used in This Chapter

Commencement

Enter the begin date that the lease goes into effect.

Lease Actions

A lease can change significantly throughout the course of its typically long life cycle. With the Lease Administration feature, you can change the lease status throughout this life cycle using lease actions within the lease component. The list of available actions changes based on the current state of the lease and what can be processed against the lease. For example, you can put an active lease into a dispute status if there is a dispute between the landlord and tenant. If a lease is in dispute, you can hold it from any financial processing. Any transactions in the transaction queue is also put on hold. When the dispute is resolved, you must manually approval the transactions put on hold to enable processing.

Select from the list of values below:

  • Activate Lease

  • Add to My Portfolio

  • Cancel Lease

  • Close Lease

  • Copy From Existing Lease

  • Delete Lease

  • Dispute Lease

  • Expire Lease

  • Holdover Lease

  • Manage Amendments

  • Resolve Dispute

  • Submit for Review

  • Validate Lease

  • View Lease Abstract

See Understanding Leases.

Go to Error

Click to view and resolve validation and/or activation error. The icon works in conjunction with the highlighted field for visual clue.

Landlord and Tenant

Select the name of the landlord or tenant.

This field changes depending on your role (landlord or tenant) and the navigation that you use.

Note. The landlord must be set up as a vendor on the vendor table, and the tenant must be set up as a bill to customer on the customer table with the Primary Bill-To check box selected.

See Adding New Vendors.

Lease Type

Select the Sub Lease or Reporting lease type. If you select Sub Lease, you must enter the parent lease number associated with that sub lease.

See Defining Lease Types.

Location

Select the geographical site identifying a city, state, or office. This location code is based on the vendor or customer master and is not established in the Lease Administration feature.

Payables Lease or Receivables Lease

Displays the lease number. This field is dynamic and changes depending on the type of lease (payables or receivables) and the navigation you use. You can either enter a lease number when you create a new lease or let the system generate it from the next available number. If you enter a lease number, it can both letters and numbers.

Region

Select the geographical site that identifies a group of locations, such as Midwest or Northeast. You must enter a region before you validate or activate a lease.

Reference

Specify sections within a lease where the term of the lease is defined. For example, when adding a base rent, you can use the Reference field to specify the section in the lease where the rent terms are located.

Straightline Accounting

Select to specify straightline accounting for rent. When selected, the system applies straightline accounting rules to the rent.

See Understanding Straightline Accounting.

Termination

Enter the end date of the lease. The end date is used to define when the lease expires.

Click to jump to parent topicDefining General Lease Information

This section provides an overview of general lease information and discusses how to define general information for a lease.

Click to jump to top of pageClick to jump to parent topicUnderstanding General Lease Information

Defining lease terms and property information is the first step in setting up a new lease. You can create a new lease or copy from an existing lease.

You can associate a one-to-many relationship between a lease and leased properties. For example, a lease can include multiple properties or a single property with multiple floors, areas, or space. To define the property information, populate the property grid. The property summary provides the calculation for total area for all properties listed on the lease.

Note. After the lease is activated, you must create an amendment to change the property information.

Before you create a lease, you need to understand the underlying actions of some of the fields and how they affect the overall processing of the lease. This section provides an overview of:

Lease Actions

You can specify various actions for a lease. The Action field is dynamic and works in conjunction with the lease Status field, enabling you to change the status of a lease at various stages.

For example, to activate a lease, you select Activate Lease from the Actions field (if you have user authority). After the lease status is Active, the only available actions are Cancelled, Expired, and Dispute.

The available values are:

Lease Status

The lease status is a system-defined value that provides a visual indicator of the lease status within the lease life cycle. The lease status also controls what processing can occur against the lease. When creating a lease, the status is set to Pending. You can save a lease with only the description; however, you cannot activate the lease until you enter and validate all fields. Use lease amendments to create changes against an active lease.

The available values are:

As the lease moves through various stages and as the status is updated, it triggers certain events in other areas of the application. Lease statuses determine the financial progress of a lease. Statuses also determine the various actions that you can take on a lease.

This table lists available actions and statuses that you can select for a lease based on the lease's current status listed in the left column:

Current Lease Status

Available Actions

Available Lease Statuses

Pending

Activate

Add to My Portfolio

Cancel Lease

Copy From Existing Lease

Delete Lease

Submit for Review

Validate Lease

View Lease Abstract

Active: All data entry is complete and successfully passes validation edits.

Cancelled: You can cancel a lease if there are no existing manual Payables payments associated with the lease.

Active

Add to My Portfolio

Manage Amendments

Cancel Lease

Note. You cannot cancel a lease if active transactions exist.

Dispute Lease

Expire Lease

View Lease Abstract

Cancelled: You can cancel a lease if there are no existing manual payments associated with the lease.

Expired: A lease can expire through the course of the normal lease cycle where the end date lapses. You can also manually expire a lease for early termination.

Dispute: Stops all processing until a lease amendment is created.

Cancelled

Delete

None: You can only delete the lease.

Expired

Manage Amendments

Close Lease

Dispute Lease

View Lease Abstract

Holdover: The lease administrator can manually set a lease to holdover status if negotiations are in process or a tenant extends the lease term beyond the expiration date at a higher previously negotiated rent.

Closed: A lease has expired and has not been renewed.

Dispute: A lease can go into dispute if holdover terms are unclear or negotiations are in process.

Holdover

Manage Amendments

Expire Lease

Dispute Lease

View Lease Abstract

Active: If a lease in holdover status is amended so that the lease termination is more than 6 months into the future it can be set to active.

Dispute: A lease can go into dispute if holdover terms are unclear or negotiations are in process.

Dispute

Manage Amendments

Expire Lease

Resolve Dispute

View Lease Abstract

Active: You can set the lease back to active status when the dispute is resolved.

Expired: A lease can be expired if the dispute is resolved.

Holdover: A lease can be in holdover status only if it was previously in holdover status and the dispute is resolved.

Closed

Manage Amendments

View Lease Abstract

None: No further processing allowed.

Click to jump to top of pageClick to jump to parent topicPages Used to Define General Information

Page Name

Definition Name

Navigation

Usage

Create New Lease - General Information

RE_LS_GENERAL

  • Real Estate Management, Lease Administration, Payables Leases, Create New Lease, General Information

  • Real Estate Management, Lease Administration, Receivables Leases, Create New Lease, General Information

  • Real Estate Management, Lease Administration, Payables Leases, Maintain Lease, General Information

  • Real Estate Management, Lease Administration, Receivables Leases, Maintain Lease, General Information

Select to create a payables lease or receivables lease.

Maintain Lease - General Information

RE_LS_GENERAL

  • Real Estate Management, Lease Administration, Payables Leases, Maintain Lease, General Information

  • Real Estate Management, Lease Administration, Receivables Leases, Maintain Lease, General Information

Select to maintain a payables lease or a receivables lease.

Property Search

RE_LS_PPTY_SRCH

Click the Select Property button on the General Information page.

Search for and select properties from a hierarchical display to associate with leases.

Click to jump to top of pageClick to jump to parent topicDefining General Information

Access the Create New Lease - General Information page (Real Estate Management, Lease Administration, Payables Leases, Create New Lease, General Information).

Note. This page displays an example of validation and/or activation errors the system detected. To view and resolve the error, click the Go to Error link. Resolve by entering or replacing the values highlighted in red.

Lease Timetable

Commencement

Select the lease start date. Any changes to this date after lease activation requires an amendment. Any financial term start date must not be before this date.

 

Termination

Select the lease end date. Any changes to this date after lease activation requires an amendment. Any financial term end date must not be after this date.

Lease Signed

Select the lease signed date. This date must occur on or before the commencement date.

 

Lease Term

Displays the total number of months for this lease.

Remaining Term

Displays the number of months remaining on this lease.

Lease Administration

Lease Administrator

Enter the individual who manages and administers this lease. The lease administrators available in this list are set up under Lease Administration User Roles.

See Defining Role Types.

Portfolio Manager

Select the manager of the lease administrator. Depending on your organization, this role may be the same as the lease administrator. The portfolio managers available in this list are set up under Lease Administration User Roles.

See Defining Role Types.

Parent Lease

Select the lease number. If the value in the Lease Type field is Sub Lease, select the parent lease number associated with the sub lease.

Note. If the lease type is sublease then you must enter the value, otherwise it is optional.

Property Information

Unit of Measure

Displays the unit of measure (UOM) for the property. This value defaults from business unit setup, but you can override it for a specific lease.

Change UOM (change unit of measure)

Click the button to change the unit of measure for the property. This toggles between square feet and square meters.

Prorata Share

Displays the proportion of the property that the tenant is occupying. You can also use this field to assist with calculating the share of operating expense for the tenant, which you can enter on the Financial Terms page.

Select Property

Click to access the Property Search page where you can search for and select properties to associate with this lease. You should enter the commencement and termination dates before you select properties. The properties available for selection on the lease depends on these dates.

Property List

The Property List grid lists the properties that you select on the Property Search page.

Total Area

Displays the total size of the property, including all open and shared space. The property information is stored in the Asset Repository.

Usable Area

Enter the usable size of the property. This does not include shared and open space. This cannot be greater than the total area.

Rentable Area

Enter the rentable size of the property for the lease. This field controls what gets billed or paid for this lease. This cannot be greater than the total area.

Occupancy Date

Enter the date which the property will be occupied.

Primary Property

Select the property address for this lease. This field is used only for display purposes when viewing a lease.

Combined Total Area

Displays the total combined size of the properties listed on this lease.

Combined Usable Area

Displays the total sum of combined usable size of the properties on this lease.

Combined Rentable Area

Displays the total sum of combined rentable size of the properties on this lease.

Click to jump to parent topicDefining Lease Financial Terms

This section provides an overview of the lease financial terms and discusses how to:

We cover security deposit financial terms in the Setting Up Security Deposits chapter in this PeopleBook.

See Setting Up Security Deposits.

We cover operating expenses in the Setting Up Operating Expenses chapter in this PeopleBook.

See Setting Up Operating Expenses.

We cover percent rent in the Setting Up and Calculating Percent Rent chapter in this PeopleBook.

See Setting Up and Calculating Percent Rent.

Click to jump to top of pageClick to jump to parent topicUnderstanding Lease Financial Terms

Setting up the financial terms on a lease is critical to the overall processing of the lease. You can define the billing or payment frequency of rent, operating expenses, and miscellaneous rent. Establish recurring payments or invoices and specify the specific date that payments or invoices should be processed.

You can establish rent escalations that increase at specific date intervals throughout the life cycle of the lease. When adding base rent, you can set up a recurring invoice or payment. You can create rent escalations using a predefined index or standard stepped increase. The index escalation method typically can use the Consumer Price Index (CPI) or any other index to help determine the rent increase. Escalations usually occur on an annual basis with an optional defined maximum limit capacity.

With operating expenses, you can set maximum increases by amount or percent. As a tenant, you can audit those expenses annually to ensure continuity of spending. As a landlord, you can reconcile the operating expenses and bill or credit the difference to your tenants.

You can also set up a recurring schedule for miscellaneous rent. Recurring miscellaneous rent can include such items as monthly parking fees, administrative fees, and storage fees. You can establish a recurring schedule to reduce data entry redundancy.

You may have leases that are set up on a percent rent schedule, where the monthly rent is reduced in exchange for a portion of the tenant's sales. With percent rent schedule, you can upload tenant sales reports to determine the variable monthly rent the tenant pays.

See Setting Up and Calculating Percent Rent.

Proration Methods

PeopleSoft Real Estate Management enables you to calculate the prorated amount for recurring charges when the start date or end date of the recurring charges do not coincide with the calendar period start date or end date. PeopleSoft Real Estate Management supports two proration methods: 365 Days and 360 Days.

The system applies these rules to the proration methods:

For example, if base rent starts on January 11, 2007, the calendar is monthly and the schedule for payment is monthly (starting on the 15th each month). The term start date (January 11, 2007) does not correspond with the calendar period start date (January 1, 2007). The system performs proration for a period of 21 days (January 31 – January 11 = 21 days). The systems generates a bill for 21 days on January 15, 2007. At the end of the lease term for that recurring rent, if the end date also does not correspond with the calendar, then the system prorates the last payment.

The proration method applies to all recurring terms of the lease. The proration method defaults onto the lease from the business unit setup and you can change the method when the lease is in pending status. After you activate the lease, you must create an amendment to change the proration method.

When a financial term is defined with an escalation, the system considers the escalation only when the schedule date is greater than or equal to an escalation date. When calculating the prorated amount at end date of the financial term, the system first calculates the term schedule amount including any escalation and related boundaries, and then applies the proration ratio to deduct the prorated amount.

The calculation of the financial term schedule dates and related amounts is essentially the same as for activating a new term as it is for an amendment. The difference is in assessing what constitutes the true start date of the term. When an amendment is activated, the system finds the date of the last schedule generated to the transaction queue, deletes all existing schedules whose date is greater than that last generated date, and if the start date of the amended version of the term is greater than the end date of the calendar period for which transactions are already generated, then the new schedule is generated exactly like for a new term with possible application of the proration rule at term start date and term end date. If the start date of the amended version of the term is less than the end date of the calendar period for which transactions are already generated, the real start date of the amendment is the first day after the calendar period for which transactions are already generated schedule date greater than the last generated schedule date. Proration at start date is not applied but proration for the end date may be applied. If both the start and end dates of the amended term are prior to the last generated schedule date, then no new schedule is generated.

Click to jump to top of pageClick to jump to parent topicPages Used to Define Financial Terms

Page Name

Definition Name

Navigation

Usage

Create New Lease - Financial Terms

RE_LS_TERMS

  • Real Estate Management, Lease Administration, Payables Leases, Create New Lease, Financial Terms

  • Real Estate Management, Lease Administration, Receivables Leases, Create New Lease, Financial Terms

  • Real Estate Management, Lease Administration, Payables Leases, Maintain Lease, Financial Terms

  • Real Estate Management, Lease Administration, Receivables Leases, Maintain Lease, Financial Terms

Define lease financial terms.

Financial Terms - Base Rent Details

RE_LS_TRM_SEC

Click the Add Base Rent button on the Financial Terms page.

Enter base rent details, rent escalation, and escalation schedules for the lease.

Financial Terms - Operating Expense Details

RE_LS_TRM_SEC

Click the Add Operating Expense button on the Financial Terms page.

Enter operating expense details, select operating expense categories, and establish billing frequency.

Financial Terms - Miscellaneous Rent Details

RE_LS_TRM_SEC

Click the Add Miscellaneous Rent button on the Financial Terms page.

Enter miscellaneous rent details, rent escalations, and escalation schedules for the lease.

Financial Terms - Security Deposit

RE_DEPOSIT_SEC

Click the Security Deposit Details link on the Financial Terms page.

Enter the security deposit type, amount, and guarantor for the lease.

Financial Terms - Percent Rent

RE_LS_PCT RENT_SEC

Click the Percent Rent Details link on the Financial Terms page.

Enter the sales estimation method, sales categories, and breakpoints.

See Understanding Percent Rent Terms.

Accounting Distribution

RE_LS_TRM_DST_SEC

  • Click the Accounting Distribution link on the Base Rent Details page.

  • Click the Accounting Distribution link on the Operating Expense Details page.

  • Click the Accounting Distribution link on the Miscellaneous Rent Details page.

  • Click the Accounting Distribution link on the Percent Rent Details page.

  • Click the Accounting Distribution link on the Security Deposit Details page.

Override business unit accounting distribution values for the specific financial terms. If the financial term follows the business unit default accounting rule, this page can be ignored.

Click to jump to top of pageClick to jump to parent topicDefine Financial Terms

Access the Create New Lease - Financial Terms page (Real Estate Management, Lease Administration, Payables Leases, Create New Lease, Financial Terms).

Financial Summary

Lease Currency

Enter the lease currency for this lease. Invoices and payments are processed using this base currency. The default currency comes from the business unit level.

Warning! This field cannot be changed after the lease is activated.

 

Prorata Share

Enter the prorata share, which is a percentage indication of how much space the tenant is occupying in the building. Prorata share can assist with calculation of operating expenses and what share each tenant should bear. This field is informational only.

 

Combined Rentable Area

Displays the total sum of the combined rentable size of the properties on this lease. The information is calculated from the property information on the General Information page.

 

Current Est Monthly Payment (current estimated monthly payment)

Displays the estimated monthly payment or invoice amount. The system calculates the estimated monthly payment by totalling the amounts defined in the Schedule of Recurring Billing and Schedule of Recurring Rent fields.

 

Exclude Base Year

Select to indicate if operating expenses for a base year should not be charged. You can specify the base year and the base year amount to exclude. This is informational only; these fields are used to record the base year exclusion terms from your lease, but the system does not include these terms in the operating expense reconciliation/audit processes.

Proration Method

Select from three available values: No Proration, 365 Days, or 360 Days. The system populates these values by default from the business unit level, but you can override them here. If you select 365 Days, then the system prorates the base rent for the first and last transaction if the start and end dates do not match the frequency start and end dates. The 365-Day method supports weekly, monthly, quarterly and annual frequencies. The 360-Day method supports only monthly frequency

See Defining Real Estate Management Business Units.

 

Max Op.Ex. Increase/Year (maximum operating expenses increase/year)

Select Amount or Percent, and enter the maximum amount or percent that operating expenses can increase per year.

Note. The Amount and Percent fields are used as a guideline and for information only; there is no system processing behind them.

Max Lease Rent Escalation

Select Amount or Percent, and enter the maximum amount or percent that the rent can escalate over the life span of the lease. These options are for information only, the system does not perform any processing based on these options.

See Understanding the Transaction Generator.

Add Base Rent

Click to add base rent for the lease. You must have at least one base rent defined before you can activate the lease.

Add Operating Expense

Click to add operating expense details for the lease.

See Understanding Operating Expenses.

Add Miscellaneous Rent

Click to add miscellaneous rent details for the lease. You must enter the rent type, which appears on an invoice or payment.

Percent Rent Details

Click this link to enter percent rent details, such as sales categories and breakpoint amounts.

See Setting Up and Calculating Percent Rent.

Security Deposit Details

Click this link to enter security deposit details.

See Setting Up Security Deposits.

Schedule of Recurring Rent

Rent Type

Displays the rent type for miscellaneous rent.

Note. This field applies only to miscellaneous rent; otherwise, it is blank.

Amount

Displays the current amount for the recurring payment or invoice.

Frequency

Displays the recurring frequency for payment or invoice.

Indicates that straightline accounting applies to the schedule or recurring rent for the financial term row on which the icon appears.

Indicates that a rent escalation applies to the schedule of recurring rent for the financial term row on which the icon appears.

Click to jump to top of pageClick to jump to parent topicAdding Base Rent

Access the Financial Terms - Base Rent Details page (click the Add Base Rent button on the Financial Terms page).

Start Date

Enter the date on which the base rent becomes effective. You must enter a date that occurs after the lease commencement date and before the end date. The default date is the lease commencement date.

End Date

Enter the date on which the base rent expires. You must enter a date that occurs after the start date and before the lease termination date. The default date is the lease termination date.

Payee

Enter the entity who receives the rent payments. The default value is the landlord from the lease. This field appears for only payables leases.

Ship To

Enter the vendor ship to location. This location will be used for VAT and SUT calculations by PeopleSoft Payables Voucher Build application. Applicable only for payables leases. If this is left blank, Voucher Build will populate the default ship to location for the vendor.

Payor

Enter the entity who makes the rent payments. The default value is the tenant from the lease. This field appears for only receivables leases.

Accounting Distributions

Click this link to access the Accounting Distributions page and override the business unit accounting rules distributions.

Amount

Enter the base rent amount that is charged periodically. You cannot enter a value that is 0.

Schedule

Select a value to specify how frequently rent transactions are generated. If the start and end date of the selected frequency differ from the start and end date of the base rent transaction, the system can optionally calculate a prorated transaction for the beginning and end of the term. The values that you have to select from, such as Monthly and Weekly, come from the Schedule component.

See Understanding General Lease Information.

Terms Calendar

Enter the terms calendar, which determines the start date and end date of billing periods for the base rent. The calendar ID from the business unit definition appears by default. You can override this value, but the frequency of the schedule and terms calendar must be the same. This is a required field.

Rent Escalation

PeopleSoft Real Estate Management enables you to establish a lease with a base rent and rent escalations using two different calculation methods: stepped or index. The stepped method refers to setting up static increases in the rent at set dates, while the index method is based on the CPI or any other indexes that you define. By selecting these fields, you can establish the maximum amount or percentage that the base rent can escalate. Usually on a monthly basis, you can update the actual index values when the index reporting authorities change the values, thus affecting the variable index escalation.

The system calculates the escalation starting with the base rent amount that is valid for the date the calculation is being run. Then searches for any escalations on this base rent row. Then the system takes the most recent non-future row based on the escalation date, which provides which index to use. Lastly, the base rent amount is added to the percentage value of the index (Base Rent + (Base Rent × Index)). If the escalation (Base Rent × Index) exceeds the minimum and maximum specified for that row, then substitute those values (use Minimum if it has not been reached, use Maximum if it has been exceeded).

Escalation Type

Specify the escalation type for rent increases. The options are:

Index: Specifies rent increases based on a particular index. These increases are variable and can change depending on the values established during product related setup.

See Understanding Economic Index Values.

See Defining Market Rates.

Stepped: Specifies a fixed rent increase. You can define multiple escalation schedules monthly, quarterly, or annually for the duration of the lease.

Note. The fields in the Rent Escalation Schedule grid vary based on your selection.

Base Index

Select the index to use as the first reference point for rent escalations when using the escalation type of Index. This index compares the subsequent index values entered in the escalation schedule.

Add Escalation

Click to insert a new escalation schedule.

Rent Escalation Schedule – Escalation Type: Index

When you select Index in the Escalation Type field, define the following fields:

Index

Specify an alternate index to use in lieu of the base index.

Calc Method (calculation method)

Select the calculation method for the rent escalation schedule. The available methods are:

Base: Specifies this escalation schedule to use the base index as the calculation method for the rent escalation. This method compares index values on the escalation date and the start date of the lease term and applies the escalation amount to the actual base rent amount.

Last: Specifies this escalation schedule to use the prior index defined on the previous row. If there is no previous escalation row then it applies it to the index on term start date. This method compares index values on the escalation date and the last (prior) escalation date and applies the escalation amount to the prior escalated rent.

Minimum Amount

Enter the minimum escalation amount for base rent.

Maximum Amount

Enter the maximum escalation amount for base rent.

Min Percent (minimum percentage)

Enter the minimum percentage escalation for the base rent.

Max Percent

Enter the maximum percentage escalation for the base rent.

Rent Escalation Schedule – Escalation Type: Stepped

The stepped method enables you to establish multiple rent escalations throughout the life cycle of the lease. You can insert multiple rows of data. Upon the new start date, the new rent amount becomes the effective date. The escalation amount is added to the base rent upon the new start date; the escalation amount is not cumulative.

For example, the base rent is $5000.00, and the stepped rent escalations for 5 years is set at $500.00 per year. To set up the rent escalation schedule, you insert 5 rows: the first row escalation amount is $500.00; the second row beginning the second year is $1000.00 (first year $500.00 + second year $500.00 = second year escalation amount $1000.00); the third year, the amount is $1500.00; and so on (see table below).

Here's an example of a stepped rent escalation (base rent = $5000.00, rent increase $500.00 per year for 5 years):

Start Date

Escalation Amount

Base Rent

01/01/2001

$500.00

$5500.00

01/01/2002

$1000.00

$6000.00

01/01/2003

$1500.00

$6500.00

01/01/2004

$2000.00

$7000.00

01/01/2005

$2500.00

$7500.00

Warning! The Escalation Amount is not cumulative. You must adjust the amount incrementally for every year.

When you select Stepped in the Escalation Type field, define the following fields:

Escalation Amount

Enter the fixed escalation amount for base rent.

Click to jump to top of pageClick to jump to parent topicAdding Miscellaneous Rent

Access the Financial Terms - Miscellaneous Rent Details page (click the Add Miscellaneous Rent button on the Financial Terms page).

Many of the fields on the Miscellaneous Rent Details page are the same as the fields on the Base Rent Details page This section contains the additional field.

Rent Type

Enter the type of miscellaneous rent. You can select from only active miscellaneous rent types.

See Defining Miscellaneous Rent Types.

Click to jump to top of pageClick to jump to parent topicOverriding Accounting Distributions

Access the Accounting Distributions page for each financial term (Click the Accounting Distributions link on the Base Rent Details, Operating Expense Details, Miscellaneous Details, Percent Rent Details or Security Deposit Details pages.

The Accounting Distribution pages for each of the financial terms are identical.

The fields on this page differ depending upon the distribution selected. When you select a value other than None, the ChartField values become available for edit.

Distribute By

Select either:

  • Percentage: Select this value to change the accounting distribution by percentage for each financial term.

  • Area: Select this value to change the accounting distribution by area for each financial term.

  • Amount: Select this value to change the accounting distribution by amount for each financial term.

  • None: Select this option to use the accounting distribution set up at the business unit level.

Add Distribution

This button appears if you select Percentage, Area or Amount for the distribute by value.

Click this button to insert a new distribution row.

Delete Distribution

This button appears if you select Percentage, Area or Amount for the distribute by value.

Select a row and click this button to delete it from this page.

Select

This checkbox appears if you select Percentage, Area or Amount for the distribute by value.

This checkbox is used to delete the distribution rows. Users can select all the distribution rows that they want to delete and click the Delete Distribution button to delete them.

Percentage

This field appears if you select Percentagefor the distribute by value.

Enter a percentage amount for this distribution line.

Area

This field appears if you select Areafor the distribute by value.

Enter the area for this distribution line.

Amount

This field appears if you select Amountfor the distribute by value.

Enter the amount for this distribution line.

Valid

Select this checkbox to validate this row.

Click to jump to parent topicDefining Lease Clauses

This section provides an overview of lease clauses, lists a prerequisite, and discusses how to define lease clauses.

Click to jump to top of pageClick to jump to parent topicUnderstanding Lease Clauses

A lease agreement contains an enormous amount of data that is relevant to the lease administrator, such as financial terms, special clauses, options, and legal terms. Because of the numerous varieties of data, efficient capture of these important terms is difficult.

Lease clauses typically represent legal terms in the lease agreement that provide certain rights to either the tenant or the landlord. You must keep this information easily accessible because you are likely to use it frequently over the course of the lease. Although clauses are meant to capture all of your lease agreement information not otherwise stored in the Lease Administration feature, there is no processing on any of the data that you enter here. It is provided for reporting purposes. Changes to a clause or additional clauses on an active lease require an amendment.

With lease clauses, you can select the clause types and clause sub types to capture and track this information and enter additional related information in a free-form text field. Clause types and sub types enable you to reduce data entry redundancy and also logically categorize the information that you capture. For example, if you have a clause type of Parking and a clause sub type of Allocated Spaces, you can further define the clause with the actual number of parking spaces allocated to the lease. You can also incorporate specific sections of a lease in the Reference field for each clause that you enter, enabling quick reference to the actual terms within a lease.

Note. User defined fields appear on this page to capture additional information unique to your organization. You must first set up these field in the setup component.

See Understanding User-Defined Fields.

Click to jump to top of pageClick to jump to parent topicPrerequisite

Before adding lease clauses, you must set up the clause types.

See Defining Clause Types.

Click to jump to top of pageClick to jump to parent topicPages Used to Define Lease Clauses

Page Name

Definition Name

Navigation

Usage

Create New Lease - Clauses

RE_LS_CLAUSES

  • Real Estate Management, Lease Administration, Receivables Leases, Create New Lease, Clauses

  • Real Estate Management, Lease Administration, Payables Leases, Create New Lease, Clauses

  • Real Estate Management, Lease Administration, Receivables Leases, Maintain Lease, Clauses

  • Real Estate Management, Lease Administration, Payables Leases, Maintain Lease, Clauses

Define lease clauses.

Clause Details

RE_LS_CLAUSES_SEC

  • Click the Add Clause button on the Clauses page.

  • Click the link under Clause Type on the Clauses page.

Add or maintain lease clauses.

Click to jump to top of pageClick to jump to parent topicDefine Lease Clauses

Access the Clauses page (Real Estate Management, Lease Administration, Payables Leases, Create New Lease, Clauses).

Clause Type

Click the link under Clause Type to display the clause details previously defined in lease maintenance.

User Defined Fields

Enter the data you want captured for reporting purposes. These fields are defined during implementation to enable you to capture additional information specific to your organization.

See Understanding User-Defined Fields.

Click to jump to top of pageClick to jump to parent topicAdd Clause Details

Access the Clauses - Clause Details page (click the link under Clause Type on the Clauses page).

Clause Type and Clause Subtype

Enter the clause type and subtype. You can select only the subtype associated with the clause type that you define.

Note. The clause type and clause subtype has a parent-child relationship. You cannot enter a clause subtype without first entering a clause type.

Track Compliance

Select this checkbox to track the compliance of this clause.

Status

Specify the status of this clause:

  • Complete

  • In Progress

  • Incomplete

Deadline

Enter the deadline for terms to be met.

Action

Select what action should be taken if terms are not met:

  • Notify Only

  • Notify and Dispute Lease

  • Notify and Hold Transactions

Click to jump to parent topicAdding Notes and Attachments

Over the life of a lease, there may be many conversations and correspondences that relate to the lease. The Notes tab within the lease provides a mechanism to record activity history on this lease, similar to a call log. You can record notes at anytime against a lease, except when the lease is cancelled or closed . When adding notes, you can optionally attach files into the database. You can use this feature to attach a soft copy of the lease agreement itself, an amendment, and other related documentation. After you save a note, you cannot amend it.

This section discusses how to add notes and attachments to a lease.

Click to jump to top of pageClick to jump to parent topicPages Used to Add Notes and Attachments

Page Name

Definition Name

Navigation

Usage

Create New Lease - Notes

RE_LS_NOTES

  • Real Estate Management, Lease Administration, Receivables Leases, Create New Lease, Notes

  • Real Estate Management, Lease Administration, Payables Leases, Create New Lease, Notes

  • Real Estate Management, Lease Administration, Receivables Leases, Maintain Lease, Notes

  • Real Estate Management, Lease Administration, Payables Leases, Maintain Lease, Notes

Add notes and attach document files, such as letters, spreadsheets, or drawings, or view or delete already attached files.

Notes - Note Detail

RE_LS_NOTES_SEC

  • Click the Add Notes button on the Notes page.

  • Click the link under Show Note Details on the Notes page.

Enter a new note for a lease or view an existing note.

Click to jump to top of pageClick to jump to parent topicAdd Notes and Attachments

Access the Notes page (Real Estate Management, Lease Administration, Payables Leases, Create New Lease, Notes).

Search for Notes

You can add new notes to a lease or use the Search for Notes group box to locate a specific note already recorded against this lease. This is because over the life of a lease there is a chance that there could be hundreds of notes recorded.

Note. You cannot use the search fields when creating a new lease.

Date Range From and To

Enter a from date and a to date to search for a lease note within the time range defined.

Title

Select from the list of values and enter a full or partial lease title in the adjacent field to limit the volume of values returned. The values are:

Begins with: Select to search by the beginning of a lease title.

Contains: Select to search for a lease title that contains the text that you enter.

Is equal to: Select to search for the exact lease title that you enter.

Created By

Enter the name of the user whose note you want to view. You can sort the notes by user. For example, you can enter your name to search for notes that you created.

Note Type

Select the note type that you want to view. The values are:

All: Select to view all notes entered in the lease.

System Note: Indicates that the note are recorded automatically by the system, such as when a lease is auto-expired.

User Entered Note: Select to view notes that are user defined.

Search

Click to search for notes matching the search criteria that you entered in the search fields.

Notes Group Box

Displays notes that you entered throughout the lease life cycle. You can only view the list of notes previously created.

Date

Displays the date that the note was created.

Created By

Displays the user name that created the lease note.

Click to jump to top of pageClick to jump to parent topicAdd Note Details

Access the Notes - Note Detail page (click the Add Notes button on the Notes page).

Load Attachment

Click this button to upload documents, letters, or drawings associated with this note. Once an attachment is loaded you can delete it or view it.

See Defining an FTP Server for Document Attachments.

Click to jump to parent topicReviewing Basic Lease Information

This section discusses how to review leases.

Click to jump to top of pageClick to jump to parent topicPages Used to Review Basic Lease Inquiries

Page Name

Definition Name

Navigation

Usage

Basic Lease Information

RE_LEASE_INQ

  • Real Estate Management, Lease Administration, Receivables Lease, Lease Inquiry

  • Real Estate Management, Lease Administration, Payables Lease, Lease Inquiry

Review basic lease information such as lease terms, lease administration, and financial summary.

Click to jump to top of pageClick to jump to parent topicReviewing Leases

Access the Basic Lease Information page (Real Estate Management, Lease Administration, Payables Lease, Lease Inquiry).

This page provides a simple online inquiry of basic lease information for a reviewing a lease. This inquiry page provides you with a summary of the lease terms and financial summary of that lease.

Click to jump to parent topicManaging My Lease Portfolio

This section discusses how to manage my lease portfolio.

PeopleSoft Real Estate Management provides a personalized page for viewing all leases assigned to you, as lease administrator or portfolio manager. You can add additional leases, not assigned to you, to your portfolio by clicking on the Add to My Portfolio link.

Click to jump to top of pageClick to jump to parent topicPage Used to Manage My Lease Portfolio

Page Name

Definition Name

Navigation

Usage

My Lease Portfolio

RE_MYPRTFL

Real Estate Management, Lease Administration, My Lease Portfolio

Use to review or manage your leases.

Add to My Lease Portfolio

RE_PRTFL_ADD

Click the Add to My Lease Portfolio link on the My Lease Portfolio page

Add additional leases, not assigned to you, to your portfolio.

Click to jump to top of pageClick to jump to parent topicManaging My Lease Portfolio

Access My Lease Portfolio page (Real Estate Management, Lease Administration, Payables Lease, Lease Inquiry).

Add to My Lease Portfolio

Click to add additional leases to your portfolio. You can add additional leases that are not assigned to you to your portfolio to help in managing workload for the other lease administrators or portfolio managers.

 

Remove from My Lease Portfolio

Click to remove a selected lease from your portfolio.

Note. You cannot remove a lease from your portfolio if you are named the Lease Administrator or Portfolio Manager on the lease.

Click to jump to top of pageClick to jump to parent topicAdding Leases to My Portfolio

Access the Add to My Portfolio page (click the Add to My Lease Portfolio link on the My Lease Portfolio page).

Go Back to My Lease Portfolio

Click to go back to your lease portfolio page.