Skip to content

Loan Products

Loan products define the templates for lending — interest models, repayment schedules, fee structures, and GL posting rules that apply to all loan accounts created under that product.

Navigation: Administration → Products → Loan Products

What Is a Loan Product?

A loan product is a configuration template. When a loan account is created, it inherits its behaviour from the product. Examples:

ProductInterest ModelRepaymentTerm
Personal LoanReducing balance, 18% p.a.Monthly12–36 months
Agricultural LoanFlat rate, 12% p.a.Quarterly6–24 months
Emergency LoanFlat rate, 24% p.a.Monthly1–6 months
Business LoanReducing balance, 20% p.a.Monthly12–60 months

Loan Product Table

ColumnDescription
Product NameDescriptive name
Product CodeUnique identifier
Interest TypeFlat or reducing balance
Interest RateAnnual interest rate
Min/Max AmountLoan amount range
Min/Max TermLoan term range (months)
StatusActive or inactive
Approval StatusDraft, pending, or approved

Creating a Loan Product

  1. Click Create Loan Product
  2. Fill in the product details:

Basic Information

FieldDescriptionRequired
Product NameDescriptive nameYes
Product CodeUnique codeYes
DescriptionWhat this product is forNo
CurrencyProduct currencyYes

Interest Configuration

FieldDescription
Interest TypeFLAT or REDUCING_BALANCE
Interest RateAnnual percentage rate
Interest Calculation MethodHow daily interest is calculated
Compounding FrequencyDaily, monthly, quarterly, annually

Repayment Configuration

FieldDescription
Repayment TypeHORIZONTAL (equal instalments) or VERTICAL
Repayment FrequencyMonthly, quarterly, weekly
Grace PeriodNumber of periods before first repayment
Max Arrears DaysDays overdue before arrears flag

Limits

FieldDescription
Minimum AmountSmallest loan allowed
Maximum AmountLargest loan allowed
Minimum TermShortest term (months)
Maximum TermLongest term (months)

GL Posting Rule Bindings

After creating the product, bind GL posting rules for each operation:

OperationRequired
DisbursementYes
Cash RepaymentYes (at least one repayment type)
Bank RepaymentOptional
Interest AccrualYes
Fee ChargeIf fees are configured
PenaltyIf penalties are configured
Write-offOptional

See GL Posting Rules for details on creating and binding rules.

Pricing Profile

Attach a pricing profile to define fees:

  • Processing fee
  • Origination fee
  • Insurance premium
  • Late payment penalty

Interest Models

Flat Rate

Interest is calculated on the original principal for the entire loan term:

Total Interest = Principal × Rate × Term (in years)
Monthly Interest = Total Interest ÷ Number of Payments

Reducing Balance

Interest is calculated on the outstanding balance each period:

Monthly Interest = Outstanding Balance × (Annual Rate ÷ 12)

As the principal is repaid, interest decreases each month.

Next Steps

PinkApple ERP by Stat Solutions Network