Late Payment Interest

Late Payment Interest (LPI) Module User Guide

Introduction

The Late Payment Interest (LPI) Module is designed to help organizations automatically calculate and bill interest on overdue customer balances.

The module is suitable for organizations that are legally or contractually entitled to charge interest on outstanding amounts, including:

• Management Corporations (MCST) in Singapore
• Management Corporations and Joint Management Bodies (JMB) in Malaysia
• Property management companies
• Service providers with contractual late payment clauses
• Any business that charges interest on overdue receivables

The module automates the calculation of Late Payment Interest (LPI) and Additional Payment Interest (API), ensuring consistent and accurate billing of overdue accounts.

---

Understanding Late Payment Interest

What is Late Payment Interest (LPI)?

Late Payment Interest (LPI) is an interest charge imposed on overdue amounts when payment is not received within the specified grace period.

LPI may arise from:

Statutory or By-Law Provisions

Certain legislation and by-laws permit organizations to charge interest on overdue payments.

Examples include:

• Management Corporation Strata Title (MCST) entities in Singapore
• Management Corporations (MC) and Joint Management Bodies (JMB) in Malaysia

These organizations are generally permitted to impose interest on overdue maintenance fees, sinking fund contributions, and other charges when payment remains outstanding after the prescribed grace period.

Contractual Agreements

Businesses may also impose interest on overdue invoices when such charges are expressly stated in a contract, service agreement, sales agreement, or terms and conditions accepted by the customer.

Such charges are commonly referred to as:

• Late Payment Interest (LPI)
• Additional Payment Interest (API)
• Finance Charges
• Interest on Overdue Accounts

---

Non-Compounded Interest Requirement

In many situations, interest is expected to be calculated on a simple (non-compounded) basis unless the parties have expressly agreed otherwise.

This means:

• Interest is calculated only on the original overdue principal amount.
• Previously charged interest is not included in subsequent interest calculations.

Example:

Outstanding Amount: $1,000

Month 1 Interest: $10

Month 2 Interest: Still calculated on $1,000 only.

The previous $10 interest is not included in the interest calculation.

---

Compounded Interest

Compounded interest occurs when previously charged interest becomes part of the balance used for future interest calculations.

Example:

Outstanding Amount: $1,000

Month 1 Interest: $10

Month 2 Interest is calculated on $1,010 instead of $1,000.

Because compounded interest has legal and contractual implications, it should only be used when explicitly agreed upon and permitted by applicable regulations.

The Highnix LPI Module supports both methods.

---

Configuring Late Payment Interest Terms

Before generating Late Payment Interest transactions, the interest terms must be configured.

Navigate to:

System Setup → Late Payment Interest Terms

Under this setup screen, define the following:

Interest Rate

The annual interest rate to be charged on overdue balances.

Example:

• 10% per annum
• 12% per annum

Grace Period

The number of days after the invoice date during which no interest is charged.

Example:

If the grace period is 30 days, interest begins only after the invoice remains unpaid for more than 30 days.

Additional Grace Period

An optional additional period before interest calculations commence.

This allows organizations to provide further flexibility to customers before interest charges are applied.

Interest Calculation Basis

Select whether interest should be calculated:

• Daily Basis
• Monthly Basis

The form is self-explanatory and allows administrators to configure the organization's preferred interest charging policy.

---

Defining the Late Payment Interest Item

Late Payment Interest is billed using a dedicated service item.

Default Item

Highnix provides a predefined service item:

Item Code:

late_pmt_interest

Description:

late_pmt_interest

This item is automatically available after installation.

Changing the LPI Item

If a different item code or description is preferred, users may create a new service item and designate it as the official Late Payment Interest item.

Navigate to:

System Setup → Forms and Docs Reference Number

Select the desired item code from the available list and save the setting.

All future Late Payment Interest transactions will use the selected item.

---

Configuring Compounded Interest for a Customer

The system supports customer-specific control over compounded interest calculations.

By default:

LPI on LPI = No

This means interest is calculated using the standard non-compounded method.

Enabling Compounded Interest

If a customer has contractually agreed to compounded interest, enable the setting as follows:

Navigate to:

Sales Management → Maintenance → Add and Edit Customer Records

Locate the customer profile and change:

LPI on LPI = Yes

Save the customer record.

Subsequent Late Payment Interest calculations will then include previously charged LPI amounts in future interest computations.

---

Mixing LPI with Normal Invoice Items

Late Payment Interest transactions are treated differently from normal sales transactions.

Because future interest calculations depend on the nature of the transaction, combining Late Payment Interest items with normal sales items may lead to incorrect interest calculations.

Therefore, the system automatically enforces the following rules:

Non-Compounded Interest Customers

When:

LPI on LPI = No

The system does not allow Late Payment Interest items to be mixed with normal sales items within the same invoice.

This ensures compliance with standard non-compounded interest principles.

Compounded Interest Customers

When:

LPI on LPI = Yes

The system permits Late Payment Interest items and normal sales items to coexist within the same transaction.

This supports customers who have expressly agreed to compounded interest arrangements.

Examples of Late Payment Interest Calculation

The following examples illustrate the difference between non-compounded and compounded Late Payment Interest (LPI) calculations.

Example 1: Non-Compounded Interest

Assumptions:

• Outstanding invoice amount: $10,000
• Interest rate: 12% per annum
• Interest calculated monthly
• Monthly interest rate: 1%
• Customer setting: LPI on LPI = No

Month 1

Outstanding principal: $10,000

Interest charged:

$10,000 × 1% = $100

Total outstanding:

$10,000 + $100 = $10,100

Month 2

Outstanding principal used for interest calculation: $10,000

Interest charged:

$10,000 × 1% = $100

Accumulated outstanding:

$10,100 + $100 = $10,200

Month 3

Outstanding principal used for interest calculation: $10,000

Interest charged:

$10,000 × 1% = $100

Accumulated outstanding:

$10,200 + $100 = $10,300

In this example, interest is always calculated based on the original overdue amount of $10,000.

Although previous LPI charges remain unpaid, they are not included in subsequent interest calculations. This is known as non-compounded interest or simple interest.

Example 2: Compounded Interest

Assumptions:

• Outstanding invoice amount: $10,000
• Interest rate: 12% per annum
• Interest calculated monthly
• Monthly interest rate: 1%
• Customer setting: LPI on LPI = Yes

Month 1

Outstanding amount subject to interest: $10,000

Interest charged:

$10,000 × 1% = $100

Total outstanding:

$10,000 + $100 = $10,100

Month 2

Outstanding amount subject to interest: $10,100

Interest charged:

$10,100 × 1% = $101

Total outstanding:

$10,100 + $101 = $10,201

Month 3

Outstanding amount subject to interest: $10,201

Interest charged:

$10,201 × 1% = $102.01

Total outstanding:

$10,201 + $102.01 = $10,303.01

In this example, previously charged LPI becomes part of the amount used for future interest calculations. This is known as compounded interest or interest on interest.

Important Note

In many jurisdictions, Late Payment Interest is generally calculated on a non-compounded basis unless otherwise permitted by law or expressly agreed between the parties.

For this reason, Highnix defaults the customer setting "LPI on LPI" to "No". Users should only enable "LPI on LPI = Yes" when compounded interest is legally permissible and has been contractually agreed by the relevant parties.

---

Recommended Practice

To ensure accurate and compliant interest calculations:

1. Configure the organization's LPI Terms before generating interest charges.
2. Verify that the correct LPI service item has been selected.
3. Use non-compounded interest unless compounded interest is legally permitted and contractually agreed.
4. Enable "LPI on LPI" only for customers with documented approval for compounded interest.
5. Review generated LPI transactions before posting them to customer accounts.

Following these guidelines will help ensure accurate calculation and proper management of overdue receivables using the Highnix LPI Module.