Creating a Lease Schedule

With finance leasing, you can use the Finance Lease Entry window to create a lease invoice schedule from an unposted sales order invoice, or a posted sales/invoice, debit memo, or service/repair document. You can select the interest rate, payment frequency, as well as enter the final invoice value and other information when you create a scheduled payment.

When you release a lease payment schedule from an unposted or posted document, the payment schedule is not posted but you can create the series of scheduled invoices and installments of the scheduled payments. Once the original document is posted, it is recommended that you process the schedule to create the credit memo. 

To process (post) the lease payment schedule, if the originating document is unposted, that document must first be posted. When you process a scheduled payment from a posted document, a credit memo is created for the remaining amount on the original document. The credit memo is applied automatically to the original document and a series of scheduled invoices, installments of the scheduled payment, are created to replace the original document.

The final invoice is printed from the Finance Lease Entry window. all the lease payments must be posted before printing this invoice. For more information on lease payments, see Creating a Lease Invoice.

To create a lease schedule:

1. Open the Finance Leasing Scheduled Payments Entry window. Go to Transactions > Equipment > Finance Lease Entry.
2. The next schedule number will auto-populate.
3. Enter a description (optional).
4. Select or enter the original document number. In the original document lookup window, the default display is set to show all posted and unposted documents. You can select to display only sales order invoices (unposted), posted documents, or all.
5. Verify the date in the Schedule Document Date field. The default entry comes from the original invoice and is the General Ledger posting date.
6. Enter the schedule amount. The default entry in this field is the total schedule amount, and it is equal to the amount remaining on the original invoice.

7. Mark either compound or simple interest. 

   

   Simple interest is calculated from the first payment rather than the schedule date. If a payment schedule is created from an existing invoice, the interest is calculated from the date of the original invoice.

8. Enter the rate in the Schedule Interest Rate field. The default value is 0.0000%.
9. Enter the number of payments for the schedule.
10. Enter or select the payment frequency. This field is used to define how often payments will be made.
11. The calculated payment amount will auto-populate after you select Calculate.
12. Select the First Invoice Document Date and the First Invoice Due Date.
13. Enter the final invoice value. The amount entered is the amount displayed on the final invoice the customer receives. This amount is not included in the interest calculation.
14. Verify and enter the accounts for the schedule. The default entries are from the original document.
15. Select the Calculate button to create the payment amounts and an amortization schedule. To view the amortization schedule, select the Amortization button.
16. Select from the following buttons to complete the schedule:
    • Release - Allows you to create lease payments without posting the schedule. The originating document can be posted or unposted, however, a credit memo for the original document amount is not created until you process the schedule.
    • Process - Posts the schedule. The originating document must be posted.
    • Save - Saves the schedule.