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 Documentation Suite
©
by NetSol Technologies Inc. All rights reserved.
The information contained in this document is the property of NetSol Technologies Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NetSol Technologies 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 NetSol Technologies Inc. is prohibited.