This update is part of the Payoff [U0103]
group of updates. For an introduction to Payoff and links to all the Payoff documents, refer to
Payoff [U0103].
The Termination functions, Termination and Termination Reversal, process and reverse terminations on leases or assets attached to leases. In LeasePak, a termination allows the lessee to fulfill financial obligations on the lease (or on the portion pertaining to one of its assets) and return the leased asset(s) to the lessor. These functions are options of the Payoff update, which can be accessed through the main LeasePak Updates menu, Payoff option, or by entering U0103 into Fast Menu <F2>.
When an asset is terminated, the value of the asset at termination is debited to the LeasePak Inventory G/L account, and the asset will appear on the Off Lease Asset report [R1001]. When a lease is terminated, the values of all its attached assets are debited to Inventory, and they will appear on the Off Lease Asset report as well.
This option terminates an entire lease or an asset on a lease with more than one asset.
For a lease termination, all outstanding asset and commission fee accounts payable must be disbursed. Use the New Lease update [U0101], Disburse Check option to clear these payables.
In order to perform an asset termination, the asset to be terminated must not be the only asset attached to the lease. If only one asset is attached to the lease, perform a lease termination.
If an Automatic Lease Extension record has been set up for the lease, performing an asset termination will produce a message warning the user that the Automatic Lease Extension record exists and will become obsolete if it is not adjusted following the asset termination. Obsolete Automatic Lease Extension records are not used to put a lease into Automatic Lease Extension. Instead, the lease number will appear on the Automatic Lease Extension Exception report [U0430A] and the extension, if desired, will need to be performed manually. To avoid this, use the Lease Extension update [U0108], Automatic Lease Extension option to update the Automatic Lease Extension record immediately following an asset termination. To perform a manual lease extension, use the Lease Extension update, Lease Extension option.
A Termination may be made to an asset that is attached to a lease with a MTM (month to month) status.
If the user has purchased and is using the Notes Payable module, a warning message will be displayed if an active note is attached to the asset.
To dispose of an off lease asset, use the Sale of Asset in Inventory option of the Payoff update.
This screen is used to select Termination from the Payoff options menu.
This screen is used to select the lease or asset to be terminated.
This screen is used for both lease and asset terminations, with the following exception: the field INS REFUND appears on the lease termination screen only.
The screen is used to specify parameters for the termination. If a termination quote has been established for the lease or asset using the Payoff Quote update [U0213], termination information from the Payoff Quote (RPD) file is displayed on this screen. The quote's termination parameters may be changed.
For asset terminations, the accrued to date for the lease is used as the effective date. Refer to the Accrual Section of the Lease Inquiry report [R0905] for a lease's accrued to date.
The asset status code changes to AINV (available - in inventory) after termination. The asset status code may be changed through the Asset update [U0210] if a different status is desired. Asset status codes are established through the Custom Code update [U0722].
For assets terminated from interest bearing loans, the outstanding principal for the asset must not exceed the unaccrued principal for the lease.
The matrix below shows which methods are valid for each lease type.
Lease Type | Payoff Methods | Termination Methods |
Precomputed | CF3, EBV, FIX, G12, INV, NPV, PR, PRN, PV2, PVS, PVT, RES, RV, SB, TAX, WO | EBV, G12, INV, NONE, PV2, RV, TAX, WO |
Simple Interest | EBV, PRN | NONE |
Operating | OPR | INV, NONE |
IBL | IB | IB |
Refer to the Calculations document for more information on payoff/termination methods.
Refer also to the Portfolio update, Payoff Customizations [U0212] for more information on payoff control switches.
Note: When the Vehicle Finance module is purchased, only the following Pre-Computed Payoff/Termination methods will be available: CF3, EBV, FIX,G12, NONE, NPV, PR, PV2,PVS, PVT,RV, TAX, WO.
For a lease termination, enter or change the effective date in MM/DD/YY or DD/MM/YY format, depending on the Date Format Preference field in Security [U0706].
EFFECTIVE DATE may be set to any date in the past as long as all lease payments due after the EFFECTIVE DATE are outstanding (unpaid) on the Accounts Receivable (RAR) file. LeasePak automatically reverses the lease back to the EFFECTIVE DATE entered. This means that the lease is reversed to the first payment due date on or before the EFFECTIVE DATE. For example, a lease with a payment due date of the first day of the month and a termination EFFECTIVE DATE of 11/30 reverses to 11/1.
Note: Use tax is calculated based on the current tax payment code and/or location of the asset(s). Incorrect use tax may be calculated if the location and/or tax payment code is changed during the period for which the accrual reversal process is performed.
The EFFECTIVE DATE may be set to a future date up to the accrued to date. Generally, this is the next payment due date. LeasePak processes all unpaid invoices up to and including the EFFECTIVE DATE through the clearing account.
For interest bearing loans, the termination EFFECTIVE DATE must be on or after the last payment effective date. For IBLs in NMAT (matured) status and with Capitalize Interest set to 'N', you can specify an effective date as far forward of the accrued-to date as needed. The asset payoff EFFECTIVE DATE must be on the accrued to date.
If the Last Accrued to Date is less than Payoff Effective Date but Last Accrued to Date plus one-month is more than Payoff Effective Date, LeasePak will calculate the additional interest.
Example
Current Accrued to Date | 10/1/01 |
Accrual Deferral Days | 6 |
Next Accrual | EOP on 10/07/01 |
New Accrued to Date on 10/07/01 |
Next Payment Due Date 11/01/01 |
Current Date | 10/01/01-11/01/01 (between Last Accrued to Date and next Last Accrued to Date) |
Payoff Effective Date | 10//06/01 |
Current Interest Outstanding = Additional Interest (Interest calculated for 7 days of October) + Current Payments Outstanding (Interest accrued until 10/1/01)
Changing the EFFECTIVE DATE
of a payoff for interest bearing loans has no effect on the BASE PAYOFF
calculation. However, it does affect interest calculations:
Lease Payoff
PMTS OUTSTD shows a different interest calculation.
Asset Payoff
Subsequent interest calculations for the lease reflect the new principal
based on the EFFECTIVE DATE entered.
Asset(s) are placed into inventory at the lower of the fair market value or the net book value. If the fair market value is lower, the difference between the FMV and the net book value is recorded as a loss. Therefore, it is very important that the fair market value be entered correctly. If the FMV entered is too low and the asset is placed into inventory at this low value, an incorrect loss is recorded. There is no update to increase the cost of an asset once it is placed in inventory.
Enter Y for all past due payment and assessments to be excluded from the Payoff Quote. This will allow the user to override the Base Amount and the outstanding Payment and/or assessment amount. Enter N for all past due payment and assessments to be included in the Payoff.
This screen is used for both lease and asset terminations, with the following exceptions: the fields LIFE REBATE, DIS REBATE, CHECK NUMBER, BATCH NUM, and INS REFUND appear for lease terminations only.
The screen is used to record the termination amount received and additional charges.
Cash Control module, security deposit suspense item: if the Portfolio [U0212] Payoff Customizations switch Holding Security Deposit in Payoff/Term is set to 'T' or 'B', the security deposit amount is not included in TOTAL REC'D, but placed in suspense. LeasePak will create a new suspense item using the batch and check number from the original security deposit payment. In the case where more than one security deposit payment was received, LeasePak will create individual suspense items for each of the security deposit payments, using originial batch and check numbers. The security deposit remains in suspense until applied to outstanding invoices or the number of days set in Holding Period for Security Deposit Disbursal has expired. If the termination is reversed, the security deposit is restored, unless the amount has been disbursed through the Auto Security Deposit Suspense Disbursal [U0436] and Cashier's Check Disbursal [U0117] updates.
You can create security deposit suspense items during payoff or termination for leases only. They are not available for interest bearing loans (IBLs).
Enter the amount due to the investor, including any participation in the termination gain/loss. The field defaults to match CHECK AMOUNT. It may be overridden, but cannot be greater than the CHECK AMOUNT.
Payoff Reversal backs out the amount from INVESTOR SETTLEMENT.
Note: The Rebate amount of the Credit Life Insurance 1/2, Credit Disability 1/2 may be used to reduce the payoff amount. The additional G/L accounts added calculate the difference between the rebate amount and the existing unearned amount.
If the Insurance Unearned is to zero because of the cancelled insurance, than the rebate amount must be zero in the Rebate screen of the Lease Form Code update [U0721]
The Auto Charge Off [U0440] update, displays IDC/IDR totals for Payoff.
BASE TERMIN
+ PMTS OUTSTD
+ ASSM OUTSD
+ ADDL INTEREST
+ FEE/PENALTY
Debit |
Credit |
Used Inventory (Undepreciated Amount) | Inventory |
Used Inventory (Depreciated Amount) | Accumulated Depr-Used |
New G/L entries for FIN
Debit |
Credit |
Used Inventory (Residual) | Inventory |
Monthly transactions for OPR assets are made to Adjustments for Accumulated Deprecation
Debit |
Credit |
Depreciation Expense | Used Inventory |
Note: This field is not supported when the Vehicle Finance module is purchased.
The Used
Inventory [R1001B] displays the detailed information for the terminated
asset.
Once the depreciation method or depreciation starting date has been modified
for an asset in a previous lease extension or termination, it may not be
modified again; an edit check in Change Asset
[U0120] will notify the user.
Note: This field is not supported when the Vehicle Finance module is purchased.
This screen is used for both lease and asset terminations. It is used to apply the termination receivables or place the total amount received into suspense.
This screen is used for both lease and asset terminations. It is used to indicate the distribution of the termination overage. It appears if the TOTAL RECD is greater than the TOTAL TERMINATION. The overage is displayed on the screen and is reduced by each amount that is entered.
The overage must be zero before the lease is terminated. That is, the amounts entered for GAIN ON SALE, PLACE IN SUSPENSE and REFUND CHECK must total the original PAYOFF OVERAGE.
This screen is used for both lease and asset terminations. It is used to indicate the distribution of the termination shortage. It appears if the TOTAL RECD is less than the TOTAL TERMINATION, short terminations are accepted, and the shortage is within the maximum allowable shortage for terminations. (Refer to the Payoff Customizations option of the Portfolio update [U0212]).
TERMINATION SHORTAGE is displayed and is reduced by each amount entered. The shortage must be zero before the lease may be paid off. That is, the amounts entered for LOSS ON SALE, ALLOWANCE FOR BAD DEBT, and INVOICE (RENT) must equal TERMINATION SHORTAGE.
When the Off-Lease Billing module is purchased, this field will be accessible for both lese and asset terminations/Terminations.
In order for the shortage amount to be billed, the user must enter the total amount to invoice. The default value of loss on Sale is Total Shortage amount based on LeasePak's calculated base payoff amount.
The Payoff cannot be reversed if 'P' for asset payoff or 'Q' for lease payoff type invoice is partially or fully paid. 'P' and 'Q' type invoices cannot be removed by accrual reversal and must be removed by Payoff Reversal.
The new invoice can be viewed through the Account Receivable Balancing Report [R0404] with 'P' or 'Q' in front of the lease number.
For lease Payoff, defaulted form the Payoff Quote Base Payoff reflects the amount on the invoice with type P (Asset Payoff Invoice) also included in the Outstanding Payment in Payoff if the new 'Exclude Past Due Payment and Assessment Y/N switch is set to N. The invoice generated in Payoff will calculate sales tax if the switch CALCULATE SALES TAX ON PAYOFF is set to Y in the Lease Form [U0721]. The Rent amount in 'P' and 'Q' type invoices may be waived through Payment/Principal Waiver [U0102].
The G/L for the Invoice Rent in Payoff will be calculated as follows:
Debit | Credit |
Lease Payment Receivable | Operating Lease Income (OPR Lease) |
Lease Payment Receivable | Lessor Income (FIN Lease) |
This screen is used for asset terminations only. It is used to input a new payment schedule for the lease. Information about the existing lease and its remaining payment schedule is displayed.
After payment schedule adjustments are made and RETURN is pressed, new information for the lease is calculated and displayed. This information should be verified.
For operating leases, CONTRACT RECEIVABLE, TOTAL UNEARNED and NET INVESTMENT are not calculated.
If invoices have been produced more than 30 days before their due dates and are not yet accrued, they are ignored. Replacements for such advanced invoices will be created the first time accruals are run after an asset payoff is final.
If advance payments are displayed, the placement, or occurrence, of the advance payments may be adjusted. However, the total dollar amount of advance payments in the remaining payment schedule may not be altered.
If the lease is a fixed term lease with an automatic conversion to a month-to- month lease, the NUMBER of the last payment schedule must be 999.
This screen is used for asset terminations only. It is used to display the recalculated acquisition cost, residual, etc., and to confirm processing of the termination.
This option reverses the previous termination of an asset or a lease.
In general, lease and asset terminations can be reversed as long as the transaction records for the termination are still in the Transaction (RTX) table. Running the Historical Payment/DTX Cleanup update [U0451] through End of Month will remove older transaction records.
If one of the assets on a lease has already been terminated, then the remaining lease is paid off or terminated, neither termination can be reversed.
If a lease was terminated by the Auto Charge Off/Suspended Earnings module, then the field Auto Charge Off in the Lease (RLS) file will be replaced with Y.
If an asset termination is followed any of the actions below, it cannot be reversed:
If the user has purchased and is using the Notes Payable module, a warning message may be displayed if an active note is attached to the asset.
This screen is used to select Termination Reversal from the Payoff options menu.
This screen is used to select the lease or asset whose Termination is to be reversed.
This is the first and only screen of a lease termination reversal. It displays all the information recorded for the termination.
This is the first screen of an asset termination reversal. It displays all the information recorded for the termination.
This screen is used for asset termination reversals only. It is used to input a new payment schedule for the lease after an asset termination reversal. Information about the existing lease and the payment schedule for the remaining term of the lease are displayed.
For operating leases, CONTRACT RECEIVABLE, TOTAL UNEARNED and NET INVESTMENT are not calculated.
If advance payments are displayed, the placement, or occurrence, of the advance payments may be adjusted. However, the total dollar amount of advance payments in the remaining payment schedule may not be altered.
If the lease is a fixed term lease with an automatic conversion to month-to- month, the NUMBER of the last payment schedule must be 999.
This screen is used for asset termination reversals only. It is used to confirm the new payment schedule, display the new financial information, and process the termination reversal.
CURRENT
UNEARNED
+ CHANGE IN PRINCIPAL
+ CHANGE IN SECURITY DEPOSIT
+ CHANGE IN ITC UNEARNED, IF ANY
- CHANGE IN CONTRACT RECEIVABLE
- CHANGE IN RESIDUAL
(Not applicable to operating leases.)
CURRENT
NET INVESTMENT
+
CHANGE IN TOTAL UNEARNED INCOME
-
CHANGE IN CONTRACT RECEIVABLE
-
CHANGE IN RESIDUAL
(Not applicable to operating leases.)
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.