Variable Loan Account Details

Variable Loan Account Details

Purpose

Variable Loan accounts are used to manage any loan where terms and conditions change over the life of the loan.

Common changes may be interest rates, repayment amounts or maturity dates.

Timing

Variable Loan Accounts may be viewed at any time.

Variable Loan Accounts should not be setup for a new month if the month end has not been rolled over.

Access

  1. [F2] in the Account lookup field
  2. Variable Loan | Access Variable Loan Accounts
  3.  from the main dialog

Dialog Details


Details Specific Fields

Field
Explanation
Interest Profile - Future
[F2] to display and  the Interest Profile that is to apply to the Future Ledger of this account

It will be the loan rate of interest
Interest Profile - Current

[F2] to display and  the Interest Profile that is to apply to the Current Ledger of this account


This will usually be the default rate of interest that applies to the arrears balance only

Dealer Req. Pcn.

This field allows the accrual of commission for Dealers on interest only loans

When interest is charged on an account, any additional interest charged above the rate entered will be posted to the Dealer Account associated with this account

  1. For example, if the Dealer required percent is 14% on $1,000.00 per annum, then you require $140.00 of interest
    If the Dealer has written the loan at 16% then the interest will be $160.00
    The difference of $20.00 will be posted to the current ledger of the associated Dealer Account
For this feature to work, a Dealer Commission Transaction Type must be selected on the Dealer Account Type
Payment Cycle
[F2] to display and  the Payment Cycle for this account
Interest Notified
This flag will be checked on once the Post Interest Rate Notifications Process has been run. It can be checked off to re run the process. 
Principal Accrued Interest

This is a display field only 

It shows the amount of interest that is accrued to today’s date on the future ledger balance
Accrued Facility Fee
This is a display field only
It shows the fee amount that is accrued on the Unused Facility.
This will be 0.00 where no facility fee details have been setup or the account is overdrawn.
Default Accrued Interest
This is a display field only
It shows the amount of interest that is accrued to today’s date on the current ledger balance
Facility Limit

Enter here the Facility Limit up to which this account may be drawn

This is used for revolving credit facilities

Once this limit is reached, warnings will appear in the cashbook for any withdrawals that exceed the limit

Unused Facility

This field calculates the available funds based on the facility limit

This can be set to include or exclude the current balance on the Variable Loan Account Type Setup
Next Instalment

Principal and Interest Loans Only

When a variable loan is first loaded, this will be the date the first instalment is due. Thereafter, the Post Instalments Process will update this date automatically using the Instalment Frequency / Instalment Day

  1. This date can be altered to reflect changed payment patterns by the client
  2. When a Variable Loan Account is Early Terminated, the next instalment date will be made blank so no further instalments post
Instalment Frequency

Principal and Interest Loans Only

This field determines the Frequency that instalments post

  1. The frequency can be changed during the life of the variable loan
Instalment Day

Principal and Interest Loans Only

Applies only to Monthly and Quarterly Instalment Frequencies
Instalment Amount

Principal and Interest Loans Only

Enter the amount of the fixed instalment
Interest Only %

The percentage of interest to be transferred to the current ledger should be specified here

This functionality allows the setup of a Hybrid Loan

  1. If the loan is interest only, 100% should be entered
  2. If the loan is principal and interest 0% should be entered
Maturity Date
Enter here the date the loan is due to mature
Review Date

Enter here the date that the loan is due to be reviewed

E.g. at the end of a fixed interest rate term
Mortgage Reference
The mortgage reference required for reporting loan details to the FMA may be entered here
Stop Distribution

If this flag is ticked on, when the Post Unit Fund Distribution routine is run, this account will not have its income included in the distribution

This will be used if it is believed the loan interest may not be able to be collected
Exclude from LVR
Tick this checkbox on if this loan account is to be excluded from LVR calculations

Details Specific Function Buttons

[Button]
Explanation

This dialog is used when scheduled advances (managed through the Project management module) are required

A simpler method for paying out of Variable Loans is:

  1. Payout Advances to the client / agreed third party in a Cashbook Statement batch
  2. Add Transactions directly to the Accounts for any fees or costs


The setup of the Interest dialog will determine whether the loan will be interest only, compounding, interest only repayable or principal and interest (instalment amount)


A Variable Loan has an extra section on this dialog as two interest rates can be applied to the loan

Interest Charged – amount of interest charged to the future ledger of the loan to date

Interest Paid – Should always be 0.00

Accrued Date – Date to which interest is accrued to

Accrued Amount – Total of interest charged and accrued to the value date of the last transaction on this account

Interest Profile – Interest Profile selected to the future ledger

Rate – Interest rate being applied to the future ledger


Complete detail of security over the property

Setup of the details required to charge a fee on the unused proportion of the Variable Loan facility limit








    • Related Articles

    • Payment Cycle Details

      Purpose The Payment Cycles are used to identify accounts by a user defined code and are specific to your company. These are used in the Create and Maintain Interest Rate Notifications Process. Timing Setup of new Payment Cycles or alterations to ...
    • Variable Loan Interest Charging Options

      P & I Loan Vault details dialog will have the following completed: Next Instalment Instalment Frequency Instalment Amount The Interest Action must be Reinvest Interest Calculation Tables: Interest Only - Payable Interest Action = Transfer Account ...
    • Get Account Details API

      Description Retrieve the system specific details for an account Security Logged in user has account API permissions URL GET http://exampleserver.com/api/{system}/{accountId}?calculationDate=date Parameters system: [Required, part of URL] One of (case ...
    • Variable Loan Financial Details

      Purpose Allows the entry of initial loan components. Liability entries will be posted to the account associated Dealer for Payout per the rules defined on the selected Dealer profile Access Variable Loan Account | Dialog Details Details Specific ...
    • Variable Loan Account Type Setup

      Purpose Account Types are to differentiate the types of Variable Loans provided. Examples may be: Interest only compounding Interest only repayable Principal and interest Or the distinction may be by product offering: Revolving Credit Mortgage ...