This update is part of the New Lease [U0101]
group of updates. For an introduction to New Lease and links to all the New Lease documents, refer to
New Lease [U0101].
Quick Book Lease is an option of the New Lease update, which can be accessed through the main LeasePak Updates menu, New Lease option, or by entering U0101 into Fast Menu <F2>.
The Quick Book Lease option is used to take an application, previously setup in the Application tabs (part of Application Tracking, a separately purchased module in LeasePak), and book it, usually after using Quick Add Asset. In order to use Quick Book Lease, the following requirements must be met:
The following audit reports will be generated after booking a lease. For report layouts, please refer to Lease Inquiry report [R0905] options:
The following audit report will also be generated.
The New Lease Invoice Status report [U0101B] is at the lease level and provides the following information for each lease booked:
INVOICE NOT REQUIRED is displayed if no new invoice is created by the accrual process for the new lease. INVOICE REQUIRED is displayed if an invoice is created by the accrual process for the new lease. If the invoice is required, the Cycle Invoicing update [U0302] should be used to interactively create an invoice for the lease.
This screen is used to select Quick Book Lease from the New Lease options menu.
This screen is used to enter the number of the application to be booked.
For Vertex O users Only: To book a lease switch Vertex O must be set to Y so that while booking a lease, LeasePak can identify whether or not to process tax charges at lease level. A lease can only be a vertex O lease if it has an asset attached with TAID type of asset.
Vertex O users: Vertex O does not supports AFM leases and Tax Credit Trade In.
Credit Bureau Reported lease numbers are not allowed to reuse. A lease number cannot be reused to book a lease that has been reported as a credit bureaus. The following error message appears when user reuses a credit bureau reported lease number to book a lease.
This screen is used to show which amounts due at lease commencement have actually been received. Amounts which may be due at commencement are:
If amounts have not been received, they may be invoiced to the lessee, or the payable to the vendor may be reduced. The latter method assumes that the vendor collects and retains the amounts.
If Vertex O switch is turned on, LeasePak process invoices for assets with TAID is differently as compare to non-Vertex assets on lease(s). A vertex O lease must have TAID assets attached to it. Vertex O lease having asset with TAID will determine at lease level to calculate and process tax through Vertex O. When lease has an asset with TAID LeasePak process and calculate the tax charges or fees, which are actually due at lease commencement through Vertex O interface.
Note: If the Partial Deductions module is purchased, an alternate screen will be displayed. See below for information on the Partial Deductions screen.
Tax amounts for advance payment(s), down payment, and interim rent are automatically calculated unless a recurring charge with the special type of T (tax) is in effect on the lease commencement date. If a type T recurring charge exists, the tax amounts are zero and the tax is included in the amount shown for the tax recurring charge.
Note: Recurring charge tax type is not supported in combination with the Sales Tax on Assessment module. Only one or the other may be active.
There is a maximum of 3 recurring charges. If the Extended Recurring Charges module is purchased, then up to 15 types of recurring charges can be established. However, the total number of other assessments and recurring charges that may be defined on the lease is limited to 10, which is the maximum number of assessments allowed on an invoice. Two of the maximum 10 assessments are reserved for Use Tax (STAX) and Late Charges (LTCH). In addition, the following assessments, if defined on a lease, will limit the number of recurring charges allowed:
This screen also displays miscellaneous calculated amounts which may be checked against the lease agreement.
LeasePak will store the check number in the Check Payment Master (RPM) file and Check Payment Detail (RPN) file. A trace reference will be created based on the Payment Origination code: 'LPBK' for Book Lease [U0101]. The trace reference will be displayed in the Cash Control Payment History [R0926] report.
AP Accounts payable to the vendor is reduced. This method assumes that the vendor collects and retains the payment and that the check for payment to the vendor should be issued net of the amounts collected.
INVL The lessee is invoiced for the amount. An accounts receivable item due as of the lease COMMENCEMENT DATE is created.
ORIGINAL
ACQUISITION COST
+
OTHER CHARGES
-
DOWN PAYMENT
+
DOCUMENTATION FEE
+
BROKER FEE
BROKER FEE is included only if it is capitalized. This calculation is informational only. It appears on the New Lease Audit report [U0101B], but is not stored on file.
The total is calculated as follows:
LEASE TERM * AVERAGE MONTHLY RENTAL INCOME
(NUMBER
OF PAYMENTS * PAYMENT AMOUNT)
+ GUARANTEED RESIDUAL
+ INTERIM RENT
(if Pro-Rate Income switch is N for the portfolio)
(MIN
LSE PMTS: LESSOR- CAPITALIZED COST+ UNGUARANTEED RESIDUAL)
/ LEASE
TERM
Capitalized cost is calculated as follows:
ORIGINAL
ACQUISITION COST
+ OTHER CHARGES
+ DOCUMENTATION FEE
+ BROKER
FEE
- DOWN PAYMENT
BROKER FEE is included only if it is capitalized.
(CAPITALIZED
COST- RESIDUAL)
/ LEASE TERM
Available methods of IDC calculation are:
FIX A fixed amount of initial direct cost is used.
PER A percentage of unearned income, original cost, or contract receivable is used.
CLA A fixed amount is used if the asset is a vehicle (i.e., CLASS code starts with V). Otherwise, a percentage of unearned income, original cost, or contract receivable is used.
Refer to the LeasePak Initial Direct Cost/Revenue document for more information about initial direct costs.
Not applicable to month-to-month leases.
All zeroes appear if lease is subject to value added tax only on the interest portion of payments.
TOTAL
LEASE PAYMENTS (including advance payments)
+ TAX
ON LEASE PAYMENTS (including advance payments)
+ RESIDUAL
+ DOWN PAYMENT
+ TAX ON DOWN PAYMENT
+ INTERIM RENT
+ TAX ON INTERIM
RENT-
ORIGINAL
ACQUISITION COST
- DOCUMENTATION
FEE
No use tax is included in this amount if a recurring charge with the special type T (tax) is in effect for any period over the life of the lease.
All zeroes appear if lease is subject to value added tax only on the interest portion of payments.
This amount is zero if a recurring charge with the special type T (tax) is in effect for any period over the life of the lease. It is also zero if lease or loan is subject to value added tax only on the interest portion of payments.
The total use tax payable through the lease term, including tax on the advance payments, is displayed. This amount is zero if a recurring charge with the special type T (tax) is in effect for any period over the life of the lease.
This total will include any sales tax on recurring charges if the Sales Tax on Assessment module is purchased.
All zeroes appear if lease is subject to value added tax only on the interest portion of payments.
If the Partial Deductions module is purchased, this screen is used to show how the amounts due at lease commencement are to be processed. Any portion of the amounts due may be received, invoiced, reduce the accounts payable to the vendor, or any combination of the three. If an overpayment occurs (both lessor and vendor received a check, for example) a partial amount may be placed into suspense.
Tax amounts for advance payment(s), down payment, and interim rent are automatically calculated unless a recurring charge with the special type of T (tax) is in effect on commencement. If type T recurring charge exists, tax amounts are zero and the tax is included in the amount shown for the Tax recurring charge. Amounts which may be due at lease commencement are:
There is a maximum of 3 recurring charges.
If the Extended Recurring Charges module is purchased, then up to 15 types of recurring charges can be established. However, the total number of other assessments and recurring charges that may be defined on a lease is limited to 10, which is the maximum number of assessments allowed on an invoice. Two of the maximum of 10 assessments are reserved for Use Tax (STAX) and Late Charges (LTCH). In addition, the following assessments will limit the number of recurring charges allowed:
SECD Security Deposit
CAPR Down Payment
PROR Interim Rent
DREC Dealer Receivable
Recurring charge descriptions, MAINTENANCE, INSURANCE, and OTHER, can be customized through the Assessment Customizations option of the Portfolio update [U0212]. Names established for each recurring charge are displayed in lieu of MAINTENANCE, etc.
This screen also displays miscellaneous calculated amounts which may be checked against the lease agreement calculations. Refer to the documentation for the screen without Partial Deductions for further information on these display only, informational fields.
Click on Help arrow for a list of
valid bank codes.
LeasePak will store the check number in the Check Payment Master (RPM) file and Check Payment Detail (RPN) file. A trace reference will be created based on the Payment Origination code: 'LPBK' for Book Lease [U0101]. The trace reference will be displayed in the Cash Control Payment History [R0926] report.
The suspense item will be created in the lease's Portfolio/Company/Region/ Office, but not attached to the lease.
This screen is used to specify how the total A/P reduction is to be allocated among the assets. This screen will appear if the Partial Deductions module is purchased and A/P amounts were specified on the previous screen. Without Partial Deductions, LeasePak would automatically reduce the asset's A/P balance first-come first-served. By using this screen the user may allocate A/P to the asset(s) desired and for the amount(s) desired.
Note: This update will read the set of subventions entered by the user during application booking and book the both IBL and non-IBL leases. LeasePak will create a general ledger entry to record the total amount for each of the set or record of subventions for both IBL and non-IBL leases. LeasePak uses these subvention amount field to produce these entries.
Note: The U0101 - Quick Book Lease totals the amount of dealer bonus on the assets and process these total dealer bonus amount on the lease when user books a lease.
LeasePak produces the following general ledger entries to book a lease. LeasePak stores the amount of dealer bonus at asset level and roll it up to the lease level. Leasepak stores the amount of lease level amount to record to produce general ledger entry. LeasePak will only produce these GL entries when user books a lease.
If the transaction is pre-computed LeasePak will produce the following General Ledger transactions:
General Ledger Account | Amount |
DR IDC6 - UNAMORT D/L DEALER BONUS | Amount - New lease amount |
CR IDC6 - D/L DEALER BONUS PAYABLE |
If the transaction is operating lease LeasePak will produce the following General Ledger transactions:
General Ledger Account | Amount |
DR IDC6 - UNAMORT O/L DEALER BONUS | Amount - New lease amount |
CR IDC6 - O/L DEALER BONUS PAYABLE |
If the transaction is interest bearing loan lease LeasePak will produce the following General Ledger transactions:
General Ledger Account | Amount |
DR IDC6 - UNAMORT DEALER BONUS | Amount - New lease amount |
CR IDC6 - DEALER BONUS PAYABLE |
NOTE: Lease totals the dealer reserve amounts on the assets and process that total dealer reserve amount on the lease at the time of booking.
The check type of DRES can disburse dealer reserves amount on check disbursal screen. LeasePak will not perform the automatic check disbursal at the time of batch booking.
Credit Bureau Extract users: RCM (cerdit bureau extract client modification) recod changes apply to lessee (Client type 'L'), co-lessee(s) (Client type 'C'), and guarantor(s) (Client type 'G') only. User Defined Clients (Client type 'U') are not supported for credit bureau reporting.
Note: All clients on the lease must be unique across all relationships. For example, the same client (same client ID) cannot be both a lessee and a guarantor on the lease or be both a co-lessee and a user-defined client in the lease.
The following warning message appears if all the clients on the lease are not unique across all relationships.
This screen is used to disburse funds for the lease, if applicable. Funds may be disbursed at a later date through the Check Disbursal option of the New Lease update [U0101]. However, titling tax entered on screen 11 of this update must be disbursed at initial booking.
This screen may be used to disburse as many checks as necessary for this lease by answering Y to DO YOU WISH TO DISBURSE ANOTHER CHECK (Y/N)? The default is Y until the TOTAL ACCTS PAYABLE is zero.
If no more checks are to be disbursed, change the code to N.
If the lease is tied to an insurance asset, LeasePak will perform the proper edit checks to disallow the check to be disbursed for the insurance asset at the time the lease is booked. LeasePak will automatically perform the proper transactions to book the lease. The Daily Transaction Journal [R0405] will display all transaction listings for the lease.
SUM OF ACCOUNTS PAYABLE FOR ALL ASSETS
+ BROKER FEE
+ TITLING TAX
+ FUNDING INTEREST
+ IDC1
+ IDC
2
FUNDING INTEREST PAYABLE increases the total accounts payable and FUNDING INTEREST EARNED decreases it.
COMM
Used to disburse commission fee to broker. This type may be entered only if
a BROKER FEE is entered and if the total commission fee is not already disbursed.
COMV
Used to disburse some or all of BROKER FEE to vendor or broker. This type may
be entered only if a BROKER FEE is entered and if the total broker fee is not
already disbursed. Vendor or broker name and address which corresponds to number
entered in BROKER/ VENDOR field defaults as payee.
MANL
The asset must have a vendor number associated with it. ACH fields on the vendor
are not required. Check Disbursal [U0117] will not process any checks nor assign
check numbers for disbursements with this code. An external program can be used
to pick up these disbursements and pass them to a wire transfer or A/P system.
WIRE
The asset must have a vendor number associated with it. ACH fields on the vendor
are not required. Cashier's Check Disbursal [U0117] will not process any checks
with this code type, but the system will assign the check number as with other
codes (except MANL). An external program can be used to pick up these disbursements
and pass them to a wire transfer or A/P system.
NEWA
Check to the vendor is to be disbursed by Vendor ACH module which runs as
part of the daily end of period. The asset must have a vendor number associated
with it and the vendor's ACH fields must be coded. Check Disbursal [U0117] will
not process any checks with this code type. The Vendor ACH [U0424] will
pick up these disbursements and create a standard ACH bank file.
NEWD
Check to the vendor is to be disbursed. The name and address of the vendor
specified for the asset (through the Add Asset option of the New Lease update
[U0101]), is automatically defaulted as the PAYEE NAME and address. It may be
changed if the check is disbursed before the lease booking date.
NEWL
Check to payee other than that entered on Add Asset. The PAYEE NAME and address
must be entered.
NEWI Payment will be disbursed to an internal account instead of to an external party. No check will be generated. Ad hoc reports can be generated to complete the internal accounting for NEWI disbursements.
TITL
Used to disburse titling tax. The PAYEE NAME and address must be entered. No general
ledger accounting is performed.
IDC
1
Payment for INSURANCE PREMIUM or other, customized IDC charge will be
disbursed to the broker whose code was entered on the lease's financial information
screen.
IDC2 Payment for NOTARY FEE or other, customized IDC charge will be disbursed to the broker whose code was entered on the lease's financial information screen.
Note: For locations where states do not exist, a "free form" code of FF may be entered. When addresses using FF are printed on invoices or reports, the state is blank.
This alternate Disburse Check screen is used when the Custom General [U0712] switch ALTERNATE A/P CHECK SCREEN is set to Y. This screen displays the accounts payable amount asset by asset. After processing all assets, payments are disbursed for commission fees, funding interest payable, and other non-asset payables. Blank screens continue to display until the lease's total A/P amount is disbursed, or until the user answers N to the prompt DO YOU WANT TO DISBURSE ANOTHER CHECK (Y/N)?
Note: If any Dealer Alert switches are turned on in Vendor [U0201], the owed amount will not be disbursed. If the Suspense Override Date is populated, the owed amount will be disbursed only up to the specified date.
Note: if you have disbursed all checks or set DO YOU WISH TO DISBURSE ANOTHER CHECK to N, clicking on OK or pressing <Enter> books the lease and automatically produces the New Lease Audit report group [U0101A-E].
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.
This message should disappear within 5-15 seconds, depending on the size of the document and the speed of your connection to the Documentation Suite.
If you can still see this message after 20 seconds, try clicking the Refresh or Reload button on your Web browser.
If your document still does not load, refer to Document Load Troubleshooting for instructions on how to fix possible problems with either your Documentation Suite installation or Web browser setup.
If you do not have read access to the parent docsuite directory, you will not be able to load the Document Load Troubleshooting document. In this case, contact your network administrator for assistance.