Salesperson Commission [R0204]

The Salesperson Commission report [R0204] provides a listing of the leases booked for each salesperson, sorted and totaled by vendor. It may be used to determine the commission amounts due to each salesperson. The Salesperson Commission report [R0204] shows lease booking information for each salesperson as well as total information of leases booked by vendor for each salesperson.

The report may be accessed through the Operational Management report menu [R02].

The report may be selected interactively for:

• all leases booked on or before a specified date
• all leases booked on or after a specified date
• all leases booked on or between two specified dates

The report may be automatically generated for all salespersons for each portfolio at the end of the month through the End of Period update [U0401]. Use the End of Period MODULES AND REPORTS screen under the End of Period Customizations option of the Portfolio update [U0212] to specify whether the report is created.

Salesperson Commission Selection

• BOOKING DATE START
  Enter the beginning date in MM/DD/YY or DD/MM/YY format, depending on the Date Format Preference field in Security [U0706]. All new leases booked on or after this date are selected. If both a BOOKING DATE START and a BOOKING DATE END are entered, all new leases booked on or between these dates are selected. Leave BOOKING DATE START blank to report on all new leases booked on or before a BOOKING DATE END. However, at least one date must be entered.
  
  
• BOOKING DATE END
  Enter the ending date in MM/DD/YY or DD/MM/YY format, depending on the Date Format Preference field in Security [U0706]. All new leases booked on or before this date are selected. If both a BOOKING DATE START and a BOOKING DATE END are entered, all new leases booked on or between these dates are selected. Leave BOOKING DATE END blank to report on all new leases booked on or after a BOOKING DATE START. However, at least one date must be entered.

Salesperson Commission Report

• 

 

The Salesperson Commission report [R0204A] reports at the lease level (sorted by vendor) and provides the following information:

• VENDOR
  The number of the vendor is displayed. All leases not associated with a vendor, if any, are reported first and no vendor number is displayed.
  
  
• NAME
  The name of the vendor is displayed. 'NONE' is displayed if reporting for leases not associated with a vendor.
  
  
• LEASE
  The lease number is displayed.
  
  
• LESSEE NAME
  The short name of the lessee is displayed.
  
  
• NEW BOOKINGS - LSE DATE
  The lease date is displayed in MM/DD/YY or DD/MM/YY format, depending on the Date Format Preference field in Security [U0706].
  
  
• NEW BOOKINGS - BK DATE
  The system booking date of the lease is displayed in MM/DD/YY or DD/MM/ YY format, depending on the Date Format Preference field in Security [U0706].
  
  
• NEW BOOKINGS - ACQ COST
  The original acquisition cost of the lease is displayed.
  
  
• NEW BOOKINGS - YIELD%
  The yield of the lease is displayed. For precomputed interest type leases (e.g., level yield, rule of 12/78ths, straight line), the calculated internal rate of return (IRR) of the lease is displayed. For simple interest leases (e.g., precomputed simple, simple floating, etc.), the fixed rate or the add-on rate for floating rate leases is displayed.
  
  
• NEW BOOKINGS - NPV
  The net present value of the payment stream, as calculated during the lease booking process, is displayed. Refer to the Calculations document for information on the calculation of the Net Present Value.
  
  
• NEW BOOKINGS - COMMISSION
  The salesperson commission for the lease is displayed. It is calculated as follows:
  

COMMISSION RATE PERCENTAGE * NPV

The commission rate percentage is entered on the second screen of the Miscellaneous Customizations options of the Portfolio update [U0212].

• TOTALS
  Page totals for all dollar amounts and a weighted average for the yield are shown by salesperson.
  
  

Additional Information

LeasePak currently offers one commission calculation, as described above in the CONTENT section for the Salesperson Commission report [R0204]. This calculation may not conform to a lessor's own commission calculations. However, the information and selection criteria of the report are general enough that it may be useful if commissions are calculated using another formula.

If there are multiple salespersons on the same lease, the commission will be split among the salespersons. However, the acquisition cost of the lease on the grand totals report page will be double counted.

 

LeasePak  Reference Guide

©  by McCue Systems Incorporated. All rights reserved.

The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of McCue Systems, Inc. is prohibited.