Home → Articles → How to Handle Loan Repayments in a Sacco

How to Handle Loan Repayments in a Sacco

03 Apr, 2026

Introduction

Loan repayment handling is the process of recording and allocating incoming payments from borrowers to the correct components of their outstanding loan balance. In a Savings and Credit Cooperative Organization (SACCO), each loan payment typically covers four components: penalties, fees, interest, and principal. The order in which you allocate these components, known as the recovery method or payment hierarchy, determines how quickly a borrower reduces their debt and how much interest they ultimately pay. Most SACCOs follow a specific recovery order where payments first clear any outstanding penalties, then fees, then accrued interest, and finally apply the remainder to the principal balance. Understanding this hierarchy ensures consistent treatment across all borrowers and maintains accurate loan records.

This guide shows you how to handle loan repayments in a SACCO using the standard recovery method (penalty → fees → interest → principal), with a real-life example of a Kshs 20,000 loan.

Prerequisites

Before you start handling loan repayments manually in your SACCO:

• Prepare a computer with spreadsheet software like Microsoft Excel or Google Sheets, or use physical ledger books for paper-based tracking.
• Gather each borrower's loan agreement showing the principal amount, interest rate, loan term, repayment schedule, and any applicable fees.
• Obtain the borrower's repayment history showing any outstanding penalties or unpaid fees from previous periods.
• Create a loan repayment register with columns for borrower name, payment date, payment amount, penalty allocation, fee allocation, interest allocation, principal allocation, and remaining balance.

Understand the Standard Recovery Method

The recovery method determines the order in which you apply a borrower's payment to different components of their loan balance. The standard SACCO recovery method follows this hierarchy.

Priority	Component	Description
1st	Penalties	Late payment charges from previous missed or late payments
2nd	Fees	Administrative or processing fees associated with the loan
3rd	Interest	Accrued interest on the outstanding principal since the last payment
4th	Principal	The original loan amount borrowed

1. Record the borrower's incoming payment amount.

2. Apply the payment to outstanding penalties first until penalties reach zero.

3. Apply any remaining payment to outstanding fees until fees reach zero.

4. Apply any remaining payment to accrued interest until interest reaches zero.

5. Apply any remaining payment to the principal balance.

Calculate Loan Components for the Example Loan

To demonstrate repayment handling, use a real-life example loan with the following terms.

Loan Parameter	Value
Principal amount borrowed	Kshs 20,000
Annual interest rate	12%
Monthly interest rate	12% ÷ 12 = 1% (0.01)
Loan term	1 year (12 months)
Monthly payment (calculated using standard amortization)	Kshs 1,776.98

1. Calculate the monthly payment using the standard amortization formula.

   console

   Monthly Payment = P × [r(1+r)^n] / [(1+r)^n - 1]
   Where:
   P = Principal (20,000)
   r = Monthly interest rate (0.01)
   n = Number of months (12)
   
   Monthly Payment = 20000 × [0.01(1.01)^12] / [(1.01)^12 - 1]
   Monthly Payment = 20000 × [0.01 × 1.126825] / [1.126825 - 1]
   Monthly Payment = 20000 × [0.01126825] / [0.126825]
   Monthly Payment = 20000 × 0.088848
   Monthly Payment = Kshs 1,776.98
   

2. Verify that 12 monthly payments of Kshs 1,776.98 fully repay the Kshs 20,000 principal plus all interest.

   console

   Total repaid over 12 months = 1,776.98 × 12 = Kshs 21,323.76
   Total interest paid = 21,323.76 - 20,000 = Kshs 1,323.76
   

Create a Complete Amortization Table

An amortization table shows how each monthly payment splits between interest and principal over the life of the loan. This table assumes the borrower pays exactly on time each month with no penalties or fees.

1. Set up your amortization table with the following columns for each month.

   Month	Starting Balance	Monthly Payment	Interest Portion	Principal Portion	Ending Balance

2. Calculate Month 1 values.

   console

   Starting Balance = Kshs 20,000.00
   Interest Portion = Starting Balance × Monthly Rate = 20,000 × 0.01 = Kshs 200.00
   Principal Portion = Monthly Payment - Interest Portion = 1,776.98 - 200.00 = Kshs 1,576.98
   Ending Balance = Starting Balance - Principal Portion = 20,000 - 1,576.98 = Kshs 18,423.02
   

3. Calculate Month 2 values using the ending balance from Month 1.

   console

   Starting Balance = Kshs 18,423.02
   Interest Portion = 18,423.02 × 0.01 = Kshs 184.23
   Principal Portion = 1,776.98 - 184.23 = Kshs 1,592.75
   Ending Balance = 18,423.02 - 1,592.75 = Kshs 16,830.27
   

4. Complete the full 12-month amortization table.

   Month	Starting Balance (Kshs)	Monthly Payment (Kshs)	Interest Portion (Kshs)	Principal Portion (Kshs)	Ending Balance (Kshs)
   1	20,000.00	1,776.98	200.00	1,576.98	18,423.02
   2	18,423.02	1,776.98	184.23	1,592.75	16,830.27
   3	16,830.27	1,776.98	168.30	1,608.68	15,221.59
   4	15,221.59	1,776.98	152.22	1,624.76	13,596.83
   5	13,596.83	1,776.98	135.97	1,641.01	11,955.82
   6	11,955.82	1,776.98	119.56	1,657.42	10,298.40
   7	10,298.40	1,776.98	102.98	1,674.00	8,624.40
   8	8,624.40	1,776.98	86.24	1,690.74	6,933.66
   9	6,933.66	1,776.98	69.34	1,707.64	5,226.02
   10	5,226.02	1,776.98	52.26	1,724.72	3,501.30
   11	3,501.30	1,776.98	35.01	1,741.97	1,759.33
   12	1,759.33	1,776.98	17.59	1,759.39	-0.06

   Note: The small negative balance in Month 12 (Kshs -0.06) results from rounding. In practice, adjust the final payment slightly to reach zero.

Handle On-Time Loan Repayments with No Penalties

When a borrower pays the exact monthly payment on or before the due date, you allocate the payment first to interest and then to principal because no penalties or fees exist.

1. Record the borrower's on-time payment of Kshs 1,776.98 for Month 1.

2. Calculate the accrued interest since the last payment. For Month 1, interest equals Kshs 200.00.

3. Apply the payment to interest first.

   Component	Amount (Kshs)	Payment Applied	Remaining Payment
   Payment received	1,776.98		1,776.98
   Interest (200.00)		200.00	1,576.98

4. Apply the remaining payment to principal.

   Component	Amount (Kshs)	Payment Applied	Remaining Payment
   Remaining from interest	1,576.98		1,576.98
   Principal		1,576.98	0.00

5. Update the borrower's outstanding balance.

   console

   New Balance = Old Balance - Principal Payment
   New Balance = 20,000 - 1,576.98 = Kshs 18,423.02
   

Handle Late Loan Repayments with Penalties

When a borrower pays late, you must first apply the payment to any outstanding penalties, then fees, then interest, and finally principal.

Assume the borrower for the Kshs 20,000 loan misses the Month 1 due date and pays 10 days late. Your SACCO charges a daily penalty of 0.1% on the unpaid monthly payment amount after a 3-day grace period.

1. Calculate the penalty for late payment.

   console

   Monthly payment amount = Kshs 1,776.98
   Grace period = 3 days
   Days late after grace = 10 - 3 = 7 days
   Daily penalty rate = 0.1% (0.001)
   Penalty = 1,776.98 × 0.001 × 7 = Kshs 12.44
   

2. Record the borrower's late payment of Kshs 1,776.98 (they did not pay the penalty separately).

3. Apply the payment to penalties first.

   Component	Amount (Kshs)	Payment Applied	Remaining Payment
   Payment received	1,776.98		1,776.98
   Penalties (12.44)		12.44	1,764.54

4. Apply the remaining payment to interest.

   Component	Amount (Kshs)	Payment Applied	Remaining Payment
   Remaining from penalties	1,764.54		1,764.54
   Interest (200.00)		200.00	1,564.54

5. Apply the remaining payment to principal.

   Component	Amount (Kshs)	Payment Applied	Remaining Payment
   Remaining from interest	1,564.54		1,564.54
   Principal		1,564.54	0.00

6. Compare the principal reduction between on-time and late payment.

   Scenario	Principal Paid	Remaining Balance
   On-time payment (no penalty)	Kshs 1,576.98	Kshs 18,423.02
   Late payment (with penalty)	Kshs 1,564.54	Kshs 18,435.46

   Output:

   text

   The borrower who paid late reduced their principal by Kshs 12.44 less because their payment first covered the penalty instead of going entirely to interest and principal.
   

Handle Partial Loan Repayments

When a borrower pays less than the full monthly payment, you still follow the same recovery order: penalties, fees, interest, and then principal. A partial payment may not cover all accrued interest, leaving the interest unpaid.

Assume the borrower for the Kshs 20,000 loan pays only Kshs 1,000 on time for Month 1 (shortfall of Kshs 776.98).

1. Record the partial payment of Kshs 1,000.

2. Apply the payment to interest first (no penalties or fees).

   Component	Amount (Kshs)	Payment Applied	Remaining Payment
   Payment received	1,000.00		1,000.00
   Interest (200.00)		200.00	800.00

3. Apply the remaining payment to principal.

   Component	Amount (Kshs)	Payment Applied	Remaining Payment
   Remaining from interest	800.00		800.00
   Principal		800.00	0.00

4. Track the unpaid interest and principal.

   Component	Amount Due	Amount Paid	Unpaid Balance
   Interest	200.00	200.00	0.00
   Principal	1,576.98	800.00	776.98

5. Update the borrower's outstanding balance.

   console

   New Principal Balance = Old Balance - Principal Paid
   New Principal Balance = 20,000 - 800 = Kshs 19,200
   

   Note: The borrower still owes Kshs 776.98 of the principal portion. This amount remains unpaid and will accrue interest in the next period.

Handle Repayments with Outstanding Fees

Some SACCOs charge fees such as processing fees, late filing fees, or statement fees. These fees follow penalties in the recovery order but come before interest and principal.

Assume a borrower has an outstanding fee of Kshs 500 from a previous loan modification and makes a regular monthly payment of Kshs 1,776.98.

1. Record the borrower's payment of Kshs 1,776.98.

2. Apply the payment to penalties first (assume no penalties).

   Component	Amount (Kshs)	Payment Applied	Remaining Payment
   Payment received	1,776.98		1,776.98
   Penalties (0.00)		0.00	1,776.98

3. Apply the payment to fees.

   Component	Amount (Kshs)	Payment Applied	Remaining Payment
   Remaining from penalties	1,776.98		1,776.98
   Fees (500.00)		500.00	1,276.98

4. Apply the remaining payment to interest.

   Component	Amount (Kshs)	Payment Applied	Remaining Payment
   Remaining from fees	1,276.98		1,276.98
   Interest (200.00)		200.00	1,076.98

5. Apply the remaining payment to principal.

   Component	Amount (Kshs)	Payment Applied	Remaining Payment
   Remaining from interest	1,076.98		1,076.98
   Principal		1,076.98	0.00

6. Compare the principal reduction with and without outstanding fees.

   Scenario	Principal Paid	Remaining Balance
   No outstanding fees	Kshs 1,576.98	Kshs 18,423.02
   With Kshs 500 outstanding fee	Kshs 1,076.98	Kshs 18,923.02

Create a Loan Repayment Register

A loan repayment register helps you track each borrower's payments and how you allocated them across penalties, fees, interest, and principal.

1. Create a repayment register with the following columns.

   Date	Borrower Name	Loan ID	Payment Amount	Penalty Allocation	Fee Allocation	Interest Allocation	Principal Allocation	Remaining Balance

2. Record each repayment transaction as it occurs.

   Date	Borrower Name	Loan ID	Payment Amount (Kshs)	Penalty (Kshs)	Fee (Kshs)	Interest (Kshs)	Principal (Kshs)	Remaining Balance (Kshs)
   Jan 31	John Doe	L-001	1,776.98	0.00	0.00	200.00	1,576.98	18,423.02
   Feb 10	John Doe	L-001	1,776.98	12.44	0.00	200.00	1,564.54	16,858.48
   Mar 5	John Doe	L-001	1,000.00	0.00	0.00	168.30	831.70	16,026.78

3. Calculate the remaining balance after each transaction.

   console

   For Jan 31: 20,000 - 1,576.98 = 18,423.02
   For Feb 10: 18,423.02 - 1,564.54 = 16,858.48
   For Mar 5: 16,858.48 - 831.70 = 16,026.78
   

Use a Spreadsheet Template for Loan Repayment Handling

A spreadsheet template automates the allocation of payments according to the recovery method and calculates the remaining balance after each transaction.

1. Open your spreadsheet software and create a new workbook.

2. Create the amortization table sheet with the following columns and formulas.

   Column	Header	Formula or Input
   A	Month	Input (1 to 12)
   B	Starting Balance	Input for Month 1, then =Previous Ending Balance
   C	Monthly Payment	Input (1,776.98)
   D	Interest Rate (Monthly)	Input (0.01)
   E	Interest Portion	=B2*D2
   F	Principal Portion	=C2-E2
   G	Ending Balance	=B2-F2
   H	Penalty (if late)	Input
   I	Fee (if any)	Input
   J	Adjusted Principal Payment	=F2-H2-I2

3. Create a repayment tracking sheet with the following columns.

   Column	Header	Formula
   A	Payment Date	Input
   B	Payment Amount	Input
   C	Outstanding Penalty Before	Input
   D	Penalty Paid	=MIN(C2, B2)
   E	Outstanding Fee Before	Input
   F	Fee Paid	=MIN(E2, B2-D2)
   G	Accrued Interest	Input
   H	Interest Paid	=MIN(G2, B2-D2-F2)
   I	Principal Paid	=B2-D2-F2-H2
   J	New Balance	=Previous Balance - I2

4. Test your spreadsheet with the late payment example from Month 1.

   A	B	C	D	E	F	G	H	I	J
   Jan 31	1,776.98	0	0	0	0	200	200	1,576.98	18,423.02
   Feb 10	1,776.98	12.44	12.44	0	0	184.23	184.23	1,580.31	16,842.71

   Note: The second payment shows higher principal because the penalty was paid separately from the regular payment.

Reconcile Loan Repayment Records Monthly

Monthly reconciliation ensures that your repayment records match the actual outstanding balances for each borrower.

1. Sum all payments received during the month from your repayment register.

   console

   Total payments received in January = Kshs 1,776.98
   

2. Sum all principal reductions from the same period.

   console

   Total principal reduced in January = Kshs 1,576.98
   

3. Verify that the difference equals interest, penalties, and fees collected.

   console

   Difference = Total payments - Total principal reduction
   Difference = 1,776.98 - 1,576.98 = Kshs 200.00
   
   This Kshs 200.00 represents interest collected (since no penalties or fees existed).
   

4. Compare each borrower's calculated remaining balance from your amortization table to their actual balance in your records.

   Month	Amortization Table Balance (Kshs)	Actual Balance (Kshs)	Difference (Kshs)
   1	18,423.02	18,423.02	0.00
   2	16,830.27	16,842.71	12.44 (penalty not yet paid)
   3	15,221.59	15,221.59	0.00

Automate Loan Repayment Handling with Dedicated Software

Manual loan repayment handling using spreadsheets becomes difficult as your loan portfolio grows beyond 50 to 100 borrowers. Entering each payment, calculating interest portions, applying penalties and fees in the correct order, updating outstanding balances, and reconciling records creates significant administrative work and introduces calculation errors.

Manual Spreadsheet Method	Dedicated Software Solution
Enter each borrower's payment amount and date manually	Software records payments from any channel automatically
Calculate interest portion based on outstanding balance	Software computes accrued interest instantly
Apply recovery order (penalty → fee → interest → principal) manually	Software follows configured recovery method consistently
Update each borrower's remaining balance after every payment	Software updates loan balances in real time
Reconcile repayment records at month end manually	Software generates reconciliation reports instantly
High risk of allocation errors across many loans	Consistent and accurate for every borrower and payment

The Franktek Banking Software handles loan repayments automatically using a Cron Job on Linux systems or a Background Scheduler on Windows servers. The software:

• Records incoming payments from multiple channels (cash, bank transfer, mobile money)
• Applies the standard recovery method (penalty → fee → interest → principal) to every payment
• Calculates daily or monthly penalties based on your configured rules
• Enforces grace periods before applying any penalty
• Updates each borrower's outstanding balance immediately after payment
• Produces amortization schedules for any loan amount, interest rate, and term
• Generates repayment reports showing how each payment was allocated

Conclusion

This guide shows how SACCOs handle loan repayments using the recovery order: penalties, fees, interest, then principal. For a Kshs 20,000 loan at 12% annual interest over 12 months, each payment of Kshs 1,776.98 splits between interest and principal. Late or partial payments reduce principal because penalties and fees consume part of the amount, leaving balances that accrue interest. Spreadsheets can help, but managing many borrowers manually is slow and error‑prone. Franktek Banking Software automates repayments with a scheduler to record payments, apply recovery order, calculate penalties, update balances, and generate amortization schedules without manual work.