Author
Francis Ndungu
On this Page
How to Configure Loan Products Correctly in a Core Banking System
06 Apr, 2026
Introduction
Loan products are the backbone of any SACCO or microfinance institution's revenue model. Configuring these products correctly in your core banking system determines how the system calculates interest, processes payments, assesses penalties, and generates repayment schedules. A misconfigured loan product leads to incorrect client balances, lost interest income, and audit exceptions. Key parameters include interest rate type (flat or reducing), calculation method, fee structures, and penalty rules. Whether you use the best SACCO software available or a custom solution, proper loan product setup ensures accurate loan management from disbursement to full repayment.
This guide explains how to configure loan products correctly in a core banking system.
Prerequisites
Before you configure loan products:
- Request a SACCO software free demo from your vendor to test configurations without affecting live data. A company like Franktek, offers a demo version of the software to test loan configurations.
- Document your institution's loan policies including interest rates, fee structures, and grace periods for each product type.
- Assign a system administrator with rights to create and modify loan product settings.
Understand Loan Product Components
A loan product contains several configurable components that work together. Each component affects how the system processes loans under that product.
| Component | Description | Example Values |
|---|---|---|
| Product name | Unique identifier for the loan type | "Emergency Loan", "School Fees Loan" |
| Interest rate type | Flat or reducing balance | Flat rate, Declining balance |
| Annual interest rate | Base rate for interest calculation | 12%, 18%, 24% |
| Repayment frequency | How often the client pays | Monthly, Weekly, Quarterly |
| Loan term | Maximum duration of the loan | 6 months, 12 months, 24 months |
| Grace period | Days after due date before penalty applies | 7 days, 14 days |
| Late penalty rate | Additional charge for overdue payments | 1% per month, $5 fixed fee |
| Processing fee | One-time fee at disbursement | 2% of loan amount, $10 fixed |
| Insurance fee | Premium deducted from loan | 1.5% of loan amount |
Configure Interest Rate Type
The interest rate type determines how the system calculates interest charges over the loan life.
Flat Rate Configuration
Flat rate interest calculates on the original principal amount for the entire loan term. Set this parameter when your institution uses flat rate loans.
- Select the interest calculation method as Flat Rate in the loan product settings.
- Enter the annual flat rate percentage.
- Define the repayment frequency.
The system calculates monthly interest by multiplying the original principal by the annual flat rate, then dividing by 12 months. For a $1,000 loan at 12% flat rate over 12 months, the monthly interest is $10 regardless of the outstanding balance.
Reducing Balance Configuration
Reducing balance interest calculates on the remaining principal after each payment. Set this parameter when your institution uses declining balance loans.
- Select the interest calculation method as Reducing Balance or Declining Balance.
- Enter the annual reducing balance rate percentage.
- Define the repayment frequency.
The system calculates interest each period based on the outstanding principal. As the client pays down the principal, the interest portion decreases. For a $1,000 loan at 12% reducing balance over 12 months, the first month's interest is $10, but the final month's interest is less than $1.
Configure Loan Fees
Loan fees include processing fees, insurance premiums, and other charges deducted at disbursement or added to the loan balance.
Set Up Processing Fees
Processing fees cover administrative costs of originating the loan. Configure this fee as a percentage of the loan amount or a fixed amount.
- Navigate to the fee configuration section under the loan product.
- Select Processing Fee as the fee type.
- Choose the calculation method: Percentage of principal or Fixed amount.
- Enter the percentage value or fixed amount.
- Define when to collect the fee: Deduct at disbursement or Add to loan balance.
For best results with the best SACCO software, set processing fees to deduct at disbursement so the client receives the net amount. A $1,000 loan with a 2% processing fee gives the client $980.
Set Up Insurance Fees
Insurance fees cover loan protection in case of borrower death or disability. Configure this fee as a percentage of the loan amount.
- Select Insurance Fee as the fee type.
- Enter the percentage rate for insurance coverage.
- Define the calculation basis: Percentage of principal or Percentage of outstanding balance.
- Select the collection timing: Upfront at disbursement or Monthly with repayment.
Most institutions deduct insurance fees upfront at disbursement. A $1,000 loan with 1.5% insurance fee deducts $15, leaving $965 for the client.
Configure Late Payment Penalties
Late payment penalties encourage timely repayment and compensate the institution for delayed cash flow. Configure both grace periods and penalty rates.
Set Grace Period
The grace period defines how many days after the due date a client can pay without facing a penalty.
- Locate the penalty configuration section.
- Enter the grace period in days. Common values are 7 days or 14 days.
- Define what happens after the grace period expires.
A 7-day grace period means a payment due on the 1st of the month incurs no penalty if paid by the 8th. Payments made on the 9th trigger the penalty.
Set Late Penalty Rate
The penalty rate determines how much extra the client pays for overdue payments.
- Choose the penalty calculation method: Percentage of overdue amount or Fixed fee.
- Enter the penalty percentage or fixed amount.
- Define how often to apply the penalty: One-time or Recurring each overdue period.
A 1% monthly penalty on a $100 overdue payment adds $1 to the client's balance each month until they pay. A $5 fixed fee adds $5 once regardless of how long the payment stays overdue.
Configure Loan Term and Repayment Schedule
The loan term and repayment frequency determine how many payments the client makes and the amount of each payment.
Set Loan Term
- Enter the maximum loan term in months or weeks.
- Define whether clients can choose shorter terms within this maximum.
- Set minimum and maximum loan amounts for this product.
A 12-month maximum term with a $500 minimum and $5,000 maximum gives clients flexibility while maintaining product boundaries.
Set Repayment Frequency
- Select the repayment frequency: Monthly, Weekly, Bi-weekly, or Quarterly.
- Define the day of the month or week when payments are due.
- Set the system to generate repayment schedules automatically at loan approval.
Monthly frequency with due dates on the 5th of each month works well for salary earners. Weekly frequency suits clients with daily or weekly income streams.
Configure Disbursement and Repayment Accounts
Loan products must map to the correct general ledger accounts for accurate accounting.
Set Disbursement Account
- Select the asset account that receives loan disbursements.
- Ensure this account appears on the balance sheet as Loans Receivable.
- Verify the account is active and not closed.
All loan disbursements credit the member's savings or cash account and debit the Loans Receivable account.
Set Income Accounts
- Map interest income to the Interest Income account.
- Map processing fee income to the Loan Fee Income account.
- Map late penalty income to the Penalty Income account.
Each income type must go to a separate income account for accurate financial reporting.
Sample Loan Product Configuration
The table below shows a complete configuration for a typical emergency loan product.
| Parameter | Configured Value |
|---|---|
| Product name | Emergency Loan |
| Interest rate type | Reducing balance |
| Annual interest rate | 12% |
| Repayment frequency | Monthly |
| Maximum loan term | 6 months |
| Minimum loan amount | $100 |
| Maximum loan amount | $2,000 |
| Processing fee | 2% of principal (deduct at disbursement) |
| Insurance fee | 1.5% of principal (deduct at disbursement) |
| Grace period | 7 days |
| Late penalty | 1% of overdue amount per month |
| Disbursement account | Loans Receivable (Asset) |
| Interest income account | Loan Interest Income |
| Fee income account | Loan Fee Income |
| Penalty income account | Late Penalty Income |
Test the Loan Product Configuration
Before offering a new loan product to members, test the configuration using a SACCO software free demo environment.
- Create a test member profile in the demo system.
- Apply for a loan using the newly configured product.
- Approve the loan and process disbursement.
- Verify the disbursement amount matches your calculation.
- Review the generated repayment schedule for accuracy.
- Simulate an on-time payment and verify the interest calculation.
- Simulate a late payment and verify the penalty assessment.
- Run a loan statement and check all figures.
Common Configuration Mistakes to Avoid
- Setting flat rate when you intend reducing balance. This error overcharges clients by thousands of dollars.
- Forgetting to deduct fees at disbursement. Fees added to the balance increase the client's debt and reduce your income recognition.
- Setting a grace period but no penalty rate. Late payments never incur charges, encouraging slow repayment.
- Mapping all income to a single account. You cannot track which products generate which income streams.
- Configuring a product but never testing it. Errors only appear when real members take loans.
- Allowing loan terms longer than the maximum defined. Use system controls to enforce limits.
Conclusion
You have learned how to configure loan products by setting interest rate types (flat or reducing balance), processing fees, insurance fees, grace periods, late penalties, loan terms, repayment frequencies, and general ledger account mappings. Testing configurations in a SACCO software free demo environment before live deployment prevents costly errors. After configuring your loan products correctly, you can now disburse loans with accurate repayment schedules, assess penalties automatically, and generate reliable loan portfolio reports using the best SACCO software for your institution.
