Loans

Interest

Loan amortization schedule

Open the Loan payment schedule for the loan.

• Turn on Manual - options are Yes or No.
• Amortization Schedule tab
  • Pmt Nbr: Specifies the number assigned by the system, for the payment, based on total terms for the loan.
  • Due date: Specifies the date the payment is due.
  • Beg loan amount: Amount in monetary standard (national currency)
  • Principal Issued: Specifies the principal amount of the original loan.
  • Interest: Specifies the amount of interest that is to be repaid for the payment due date.
  • Principal: Specifies the amount of the original issue that is to be repaid for the payment due date.
  • Escrow: Amount in monetary standard (national currency)
  • **Paid add principal: Specifies an amount paid in addition to the scheduled payment, that has been applied directly to the principal owed.
  • End loan amount: Amount in monetary standard (national currency)
  • Unpaid Principal: Specifies the amount of principal that remains due after a payment has been posted for the payment date.
  • Unpaid Interest: Specifies the amount of interest that remains due after a payment has been posted for the payment date.
  • Unpaid Late Interest: Specifies the amount of interest that remains due after a payment has been posted for the payment date.
  • Unpaid Late Interest on Interest:
  • Unpaid Late Fee: Specifies the amount of late interest, calculated on the principal, that remains due after a payment has been posted for the payment date.
• Actual schedule tab
  • Paid date: Specifies the date the payment was made.
  • Prin Beg Amt: Specifies the loan amount, principal only, as of the paid date.
  • Prin End Amt: Specifies the loan amount, principal only, after principal paid has been deducted.
  • Paid add principal: Specifies an amount paid in addition to the scheduled payment, that has been applied directly to the principal owed.
  • Prin Paid Reg TD: Specifies the amount of principal paid based on the transaction date.
  • Prin WO: Specifies the amount of principal that has been adjusted on the loan. This amount will not be paid.
  • Prin Issued: Specifies the amount of the loan given, to the borrower, or by the lender.
  • Prin Capitalized: Specifies an amount of interest previous capitalized and added to the balance of the loan.
  • Interest: Specifies the amount of interest that was paid on the payment date.
  • Interest WO: Specifies the amount of interest that has been adjusted on the loan. This amount will not be paid.
  • Interest Capitalized: Specifies an amount of interest that is capitalized.
  • Late Fee Paid: Specifies the amount paid for fees/charges/assessments/expenses added to the loan due to a payment not being made on time.
  • Late Fee WO: Specifies the amount of late fees/charges/assessments/expenses that has been adjusted on the loan. This amount will not be paid.
  • Late int on int paid: Specifies the amount being paid for interest that has been calculated on a late interest payment.
  • Late Int on Int WO: Specifies the amount of late interest that has been adjusted on the loan. This amount will not be paid.
  • Escrow Paid: Specifies the amount of paid escrow.
  • Escrow WO: Specifies the amount of escrow that has been adjusted on the loan. This amount will not be paid.
  • Charges paid: Specifies the amount paid for fees/charges/assessments/expenses on the loan.
  • Charges WO: Specifies the amount that has been adjusted for fees/charges/assessments/expenses on the loan. This amount will not be paid.
  • Int on Charges WO: Specifies the amount being paid for interest on fees/charges/assessments/expenses on the loan.
  • Fee paid: Specifies the amount paid for fees/charges/assessments/expenses on the loan that are not principal or interest.
  • Fee WO: Specifies the amount that has been adjusted for fees/charges/assessments/expenses on the loan. This amount will not be paid.
  • Pen Int Paid: Specifies the amount paid for interest that was charged on fees/charges/assessments/expenses on the loan.
  • Pen Int WO: Specifies the amount of fees/charges/assessments/expenses interest that has been adjusted on the loan. This amount will not be paid.
  • Total: Specifies the sum of all amounts on the line.
• Owed Schedule tab
  • Pmt Nbr: Specifies the number assigned by the system, for the payment, based on total terms for the loan.
  • Due date: Specifies the date the payment was made.
  • Principal: Specifies the loan amount, principal only, after principal paid has been deducted.
  • Fee: Amount in monetary standard (national currency)
  • Late Fee: Amount in monetary standard (national currency)
  • Penalty Interest: Amount in monetary standard (national currency)
  • Interest: Amount in monetary standard (national currency)
  • Late Interest: Amount in monetary standard (national currency)
  • Escrow: Amount in monetary standard (national currency)
  • Charges: Amount in monetary standard (national currency)
  • Int on Int: Amount in monetary standard (national currency)
  • Owed total: Amount in monetary standard (national currency)

Loan transactions

• Transaction date: Specifies the date of the transaction shown
• Payment type: Specifies the payment type of the transaction shown.
• Transaction amount: Specifies the transaction amount of the transaction shown.
• Transaction description: Specifies the transaction description of the transaction shown.
• Batch number: Specifies the batch number for the transaction shown.

Totals

• Transaction description: Specifies the transaction description of the transaction shown.
• Month to date amount: Specifies the total activity for the current month for this transaction type.
• Year to date amount: Specifies the total activity for the current calendar year through today for this transaction type.
• Last year total: Specifies the total activity for the last calendar year for this transaction type.
• Life to date: Specifies the total activity for the life of the loan through today for this transaction type.
• Date of last trans: Specifies the date of the last entry for this transaction type.
• Amount of last trans: Specifies the amount of the last entry for this transaction type.

Ownership

• Loan: Specifies the loan we are displaying ownership for.
• Lender/Borrower: Specifies the lender or borrower for this loan.
• Owner code: Specifies an owner of the loan who has a financial share in the proceeds.
• % Ownership: Specifies the percent of ownership of the loan this owner has for their share. The total ownership for all owners must be 100%.

Post to AP

Posts the transaction to the Accounts Payable. Loan must be in an ACTIVE status for posting to AP.

Payment

Loan payments

• Loan number: Specifies the number for a loan.
• Type: Specifies the loan type code.
• Customer: Specifies a customer ID for a receivable loan.
• Vendor: Specifies a vendor ID for a payable loan.
• Name: Specifies the name of the borrower or lender associated with the loan.
• Status: Specifies the status of the loan.
• Relation: Specifies the status of the loan.
• Created By: Specifies the User ID that created the record.
• Created date and time: Specifies the date and time the record was created.
• Modified by: Specifies the User ID that last modified the record.
• Modified date and time: Specifies the date and time the record was last modified.