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 amount used for subsequent 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 applied when expressly agreed upon by the contractual parties and permitted under the applicable laws or regulations.

The Highnix LPI Module supports both non-compounded and compounded interest calculations.

1. Note: When LPI on LPI is enabled, new Late Payment Interest (LPI) invoices generated thereafter are flagged as eligible for future LPI calculations. If such an LPI invoice remains unpaid after the applicable grace period, its outstanding amount will be included in subsequent LPI calculations, resulting in compounded interest. LPI invoices generated before LPI on LPI was enabled remain non-compounded and are not retrospectively included in future LPI calculations.

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. That means, the interest will start from the next day after the grace period (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. If there is any outstanding payment (even with after partial payment), after this additional grace period, the interest will start 1 day after the Grace Period, not after the Additional Grace Period.

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 → System and General GL

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.

---

Recurring LPI Invoice Generation

The Recurring LPI Invoice feature allows users to automatically generate Late Payment Interest (LPI) invoices on a regular basis without having to create each invoice individually. This can save a significant amount of time, particularly for MCSTs, Management Corporations and property management companies that manage a large number of property units and need to apply late payment interest to overdue payments.

Once the recurring LPI setup has been configured, the system can generate the applicable LPI invoices based on the selected date. This helps to simplify the LPI billing process and reduces the amount of manual work required.

Preparation

Before generating recurring LPI invoices, the Recurring LPI setup must first be configured.

1. Navigate to Sales > Maintenance > Recurrent LPI.
2. Set up the recurring LPI by completing the required information. This defines the rules and parameters that the system will use when generating the LPI invoices. For MCSTs or property management companies, users can select a Sales Group instead of selecting individual customers. A Sales Group allows customers with common characteristics to be grouped together for billing purposes. For example, customers may be grouped according to:
   1. Number of bedrooms, such as 2-bedroom or 3-bedroom units; or
   2. Share value, such as 100 share-values or 130 share-values.
3. Once a Sales Group is selected, all customers belonging to that group will be included and billed according to the recurring LPI setup when the recurring LPI invoice is generated.
4. Review the information entered and click Save.

Once the recurring LPI setup has been saved, the system is ready to generate the recurring LPI invoices.

Create Recurring LPI Invoices

To generate the recurring LPI invoices:

1. Navigate to Sales > Transactions > Create and Print LPI Recurrent Invoices.
2. Select the required date. This is an important step because the system will calculate and generate the LPI based on the selected date. The selected date determines which outstanding amounts are subject to LPI according to the recurring LPI settings.
3. Click the Create LPI Invoice icon on the right to generate the applicable LPI invoices.
4. The system will generate the LPI invoices based on the recurring LPI configuration and the selected date.
5. Once the invoices have been generated, users can either print the invoices for distribution or email the invoices directly to the customers.

The recurring LPI process eliminates the need to create LPI invoices individually and is particularly useful for property management operations where LPI invoices need to be generated regularly for multiple property units.

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.