Overview
Recording loan payments is a critical daily operation that updates member loan balances, tracks arrears, and ensures accurate financial reporting. When members make loan repayments, the payment is deducted from their savings balance and allocated between principal, interest, and penalties. Use this when: A member wants to pay toward their loan from their savings balance (full installment, partial payment, or extra payment).Before You Begin
- You have
loans:writepermission - The loan exists and is in active status (not fully repaid or written off)
- The member has sufficient savings balance to cover the payment amount
- You know the exact payment amount and date
Step-by-Step Instructions
Step 1: Navigate to the Loan
Open Loans section
Find the loan
- Use the search bar to find the borrower’s name
- Or browse the active loans list
- Click on the loan to open details
Open payment dialog
Step 2: Enter Payment Details
The payment recording dialog contains the following fields:Example: Recording a Full Installment Payment
Step 3: Review Payment Allocation
Before submitting, Agatabo displays how the payment will be allocated: Example allocation for 50,000 RWF payment:- INTEREST_FIRST: Pays interest fully, then principal
- PRINCIPAL_FIRST: Pays principal fully, then interest
- PROPORTIONAL: Splits based on ratio of principal to interest
Step 4: Submit Payment
Verify allocation
Check remaining balance
Click 'Save' or 'Record Payment'
What Happens Next
When you record a loan payment, Agatabo automatically:- Validates savings balance: Checks that the member has sufficient savings to cover the payment
- Deducts from member’s savings: The payment amount is deducted from their savings balance
- Allocates the payment between interest, principal, and penalties based on the loan’s payment allocation order
- Updates the loan balance: Reduces the outstanding principal and marks installments as paid
-
Creates a journal entry:
- Debit: Savings (member’s account, -50,000 RWF)
- Credit: Loan Receivable (-38,000 RWF)
- Credit: Interest Receivable (-12,000 RWF)
- Marks installments as paid: If the payment covers one or more installments, they’re marked as “Paid”
- Updates arrears: If the loan was overdue, arrears are recalculated
- Records in audit trail: Logs payment with user ID, timestamp, and all details
- Sends notification (if enabled): Borrower may receive payment confirmation
Example Journal Entry Created
For the payment above (50,000 RWF payment with 38,000 principal and 12,000 interest), Agatabo creates:Common Scenarios
Recording a Full Installment Payment
When a member pays exactly the scheduled installment amount:Enter the installment amount
Verify full allocation
Submit
Recording a Partial Payment
When a member pays less than the scheduled installment:Enter the actual amount received
Review allocation
- If INTEREST_FIRST: 20,000 goes to interest, leaving 24,500 interest unpaid
- Principal remains unchanged
Note arrears
Recording an Extra Payment (Overpayment)
When a member pays more than the scheduled installment:Enter the full amount received
Review allocation
- Current installment paid in full (44,500)
- Excess (55,500) applies to future installments or principal
Check new schedule
Member Needs to Deposit First
If a member wants to make a loan payment but doesn’t have sufficient savings:Member deposits cash
Then record loan payment
Backdated Payment (Past Date)
If recording a payment that occurred in the past:Check period status
Select correct payment date
Add explanatory note
Viewing Payment History
After recording, you can verify the payment:Check loan details
Check installment schedule
Check journal entries
Handling Payment Errors
Recorded Wrong Amount
Before period closing
Before period closing
- Navigate to Loans → [Loan] → Payment History
- Find the incorrect payment
- Click Edit (if available based on permissions)
- Correct the amount
- Save changes
After period closing
After period closing
- Record a reversal payment (negative amount) in the current period to cancel the error
- Record the correct payment with proper amount
- Document both transactions clearly in notes
- Consult with accountant to ensure proper handling
Recorded Payment to Wrong Loan
Before period closing
Before period closing
- Delete the incorrect payment (if deletion is enabled)
- Navigate to the correct loan
- Record the payment properly
- If deletion is not enabled, contact your accountant for reversal process
After period closing
After period closing
- Reversal entries on the wrong loan
- Correcting entries on the right loan
- Full documentation of the correction
Common Issues
'Insufficient savings balance' error
'Insufficient savings balance' error
- Check member’s current savings balance in Organization Users → User Details
- If member is bringing cash, first record a deposit to increase their savings
- Then record the loan payment
- Navigate to Savings → Deposit History → Record Deposit
'Loan not found' error
'Loan not found' error
- Verify the loan exists in Loans section
- Check loan status - you cannot record payments on closed loans
- If loan is fully repaid, no additional payments are needed
'Insufficient permissions' error
'Insufficient permissions' error
loans:write permission.Solution:- Contact your administrator to request payment recording permissions
- If you have
loans:writewith SELF scope, you can only record payments for your own loans
'Invalid payment date' error
'Invalid payment date' error
- Ensure the date is in the current open period
- Payment date cannot be after today
- Check Advanced → Period Closing for period status
Payment allocation looks wrong
Payment allocation looks wrong
- Review the loan’s Payment Allocation Order in loan details
- INTEREST_FIRST pays all interest before principal
- PRINCIPAL_FIRST pays all principal before interest
- PROPORTIONAL splits based on ratio
- This cannot be changed after loan creation
Payment not reducing arrears
Payment not reducing arrears
- Check the arrears breakdown in loan details
- Larger payment may be needed to clear overdue amounts
- Contact accountant if arrears calculation seems incorrect
Best Practices
- Ensure member has sufficient savings balance before recording payment
- If member brings cash, first record it as a deposit, then record the loan payment
- Verify the borrower’s name and loan ID before submitting
- For large payments, double-check the amount before submitting
- Upload payment receipts or proof using the Document field
- Record payments promptly to keep arrears accurate
- Check the payment allocation preview before submitting
Understanding Payment Impact
Effect on Loan Balance
Each payment reduces the outstanding loan balance:Effect on Arrears
- On-time payment: Clears current installment, no arrears added
- Partial payment: Unpaid portion becomes arrears, may trigger late fees
- Overpayment: Reduces arrears, may prepay future installments
Effect on Financial Reports
- Member savings decreases: Borrower’s savings balance is reduced
- Loan receivable decreases: Portfolio outstanding reduces
- Interest receivable decreases: Recognized interest revenue is collected