Overview
Creating a loan in Agatabo is a structured 5-step process that captures borrower information, loan terms, interest rules, securities, and bank details. Agatabo automatically calculates the installment schedule and disburses funds when the loan is created. Use this when: A member applies for a loan and you need to formalize the loan agreement with specific terms.Before You Begin
Prerequisites:
- You have
loans:writepermission - The borrower exists as an organization user with a member role
- You know the loan amount, term, and interest rate
- You understand which interest calculation type and installment structure to use
- Organization has sufficient cash to disburse the loan
The 5-Step Loan Creation Process
Overview of Steps
| Step | What You’ll Do | Time Required |
|---|---|---|
| 1. Basic Information | Select borrower, enter amount, period, and start date | 2 minutes |
| 2. Loan Rules | Configure interest, installment type, payment allocation, and fees | 3-5 minutes |
| 3. Securities | Add guarantors, collateral, or savings lien | 2-3 minutes |
| 4. Bank Details | Select bank account and enter bank charges (if any) | 1 minute |
| 5. Review & Submit | Review all details and create the loan | 1-2 minutes |
Step 1: Basic Information
Navigate to Loan Creation
Enter Basic Loan Details
| Field | Description | Required | Example |
|---|---|---|---|
| Organization User | Member receiving the loan | Yes | John Mugisha |
| Principal Amount | Loan amount to disburse | Yes | 500,000 RWF |
| Period | Loan period in months | Yes | 12 |
| Start Date | Date loan starts (funds released) | Yes | 2026-06-08 |
| Purpose | Reason for the loan | No | Small business capital |
First payment date: Agatabo automatically calculates the first payment date as one month after the start date. For a loan starting on 2026-06-08, the first payment will be due on 2026-07-08.
Example: Basic Information for a Business Loan
Understanding Loan Period
Loan period = duration in months.- 12 months = 12 monthly payments
- 24 months = 24 monthly payments
- 6 months = 6 monthly payments
Step 2: Loan Rules (Most Important)
This step defines how interest is calculated and how payments are structured. Understanding these options is critical to creating the right loan type.Interest Configuration
| Field | Description | Options | Example |
|---|---|---|---|
| Interest Rate | Percentage rate charged | Any positive number | 5 |
| Interest Rate Type | How the rate is interpreted | MONTHLY, YEARLY | MONTHLY |
| Interest Calculation Type | How interest is computed | SIMPLE, COMPOUND, REDUCING_BALANCE | REDUCING_BALANCE |
| Interest Payment Timing | When interest is paid | IN_ADVANCE, WITH_INSTALLMENTS | WITH_INSTALLMENTS |
Interest Rate Type
- MONTHLY: Rate applies each month (5% monthly = 5% × 12 = 60% annual effective)
- YEARLY: Annual rate divided across installments (12% yearly = 1% per month)
Common practice: Most tontines use MONTHLY rates for simplicity. Members understand “5% per month” more easily than annual percentage rates.
Interest Calculation Type
- SIMPLE
- COMPOUND
- REDUCING_BALANCE (Most Common)
Interest calculated on original principal only, doesn’t compound.Formula:
Total Interest = Principal × Rate × TermExample: 100,000 RWF at 5% monthly for 12 months- Interest = 100,000 × 0.05 × 12 = 60,000 RWF
- Total repayment = 160,000 RWF
Interest Payment Timing
-
IN_ADVANCE: Interest deducted upfront (from savings or disbursement)
- Example: 100,000 RWF loan with 12,000 RWF interest → interest paid from member’s savings before disbursement
- Installments repay principal only
- Common in microfinance
-
WITH_INSTALLMENTS (default): Interest included in each payment
- Example: 100,000 RWF loan → member receives full 100,000 RWF
- Each installment includes principal + interest
- Standard commercial loan structure
Installment Configuration
| Field | Description | Options | Example |
|---|---|---|---|
| Installment Type | How payments are structured | EQUAL_PRINCIPAL, EQUAL_TOTAL | EQUAL_TOTAL |
| Payment Allocation Order | How payments are split | INTEREST_FIRST, PRINCIPAL_FIRST, PROPORTIONAL | INTEREST_FIRST |
Installment Type
- EQUAL_PRINCIPAL
- EQUAL_TOTAL (Most Common)
Each payment has the same principal amount, but interest decreases over time.Example: 120,000 RWF loan for 12 months at 5% reducing balance
- Principal per payment: 120,000 ÷ 12 = 10,000 RWF
- Month 1: 10,000 principal + 6,000 interest = 16,000 total
- Month 2: 10,000 principal + 5,500 interest = 15,500 total
- Month 12: 10,000 principal + 500 interest = 10,500 total
Payment Allocation Order
When a member makes a payment, how should it be split between principal and interest?-
INTEREST_FIRST: Pay interest fully, then principal
- Most common, ensures interest revenue is collected
- Example: 10,000 RWF payment with 3,000 interest due → 3,000 to interest, 7,000 to principal
-
PRINCIPAL_FIRST: Pay principal fully, then interest
- Reduces outstanding balance faster
- Example: 10,000 RWF payment with 7,000 principal due → 7,000 to principal, 3,000 to interest
-
PROPORTIONAL: Split payment based on the ratio of principal to interest
- Fair allocation for partial payments
- Example: 10,000 RWF payment with 7,000 principal + 3,000 interest due → 7,000 to principal, 3,000 to interest (70/30 split)
Recommended for most loans: Use REDUCING_BALANCE interest calculation with EQUAL_TOTAL installments and INTEREST_FIRST payment allocation. This creates standard amortized loans that members understand.
Disbursement Fees (Optional)
Configure if your organization charges a loan disbursement fee:| Field | Description | Options |
|---|---|---|
| Disbursement Fee Type | How the fee is calculated | PERCENTAGE, FIXED_AMOUNT |
| Fee Amount/Percentage | Fee value | 2% or 5,000 RWF |
| Deduct from Savings | Where fee is deducted from | Checked/Unchecked |
- Deduct from cash: Fee deducted from loan disbursement amount (member receives less cash)
- Deduct from savings: Fee deducted from member’s savings balance (full disbursement amount released)
Configure all loan rules
Select interest calculation, installment type, payment allocation, and disbursement fees
Step 3: Securities
Securities protect the organization in case of default. Add one or more securities to meet the coverage requirement (total security value must cover the loan amount minus any deductions).Types of Securities
- Guarantors
- Collateral
- Savings Lien
Personal guarantees from other organization users.
- Select one or more guarantors from the member list
- Guarantors commit to repaying if borrower defaults
- Typically family members, friends, or business partners
Adding Securities
Enter details
- Guarantor: Select organization user and enter guaranteed amount
- Collateral: Enter description, value, and upload documents
- Savings: Enter amount of borrower’s savings to pledge
Securities are informational in Agatabo - they document the agreement but don’t automatically enforce collection. Your organization’s policies determine how securities are used in case of default.
Step 4: Bank Details
Select which bank account will disburse the loan and enter any bank charges:| Field | Description | Required |
|---|---|---|
| Bank Account | Account from which funds will be disbursed | Yes |
| Bank Charge Amount | Transaction fees charged by the bank (if any) | No |
Bank charges: If your bank charges a fee for the transfer (e.g., mobile money fees, wire transfer fees), enter that amount here. It will be recorded as a bank charge expense.
Step 5: Review & Submit
The final step displays a comprehensive summary of the loan for your review.What’s Displayed
The review page shows:- Borrower details: Name, email, account number, current savings balance
- Loan terms: Principal, period, start date, purpose
- Interest configuration: Rate, calculation type, installment type, payment allocation
- Disbursement fees: Fee type and amount (if configured)
- Securities: All added guarantors, collateral, and savings liens
- Bank details: Selected account and bank charges
- Calculated totals:
- Total interest
- Total repayment amount
- Amount member will receive (after fees)
Review all details carefully
This is your last chance to catch errors - most settings cannot be changed after creation
What Happens Next
When you create the loan, Agatabo automatically:- Generates installment schedule: Calculates all monthly payment amounts and due dates
-
Creates journal entries:
- Dr LOAN_RECEIVABLE: Principal amount (asset)
- Dr INTEREST_RECEIVABLE: Total interest (if paid with installments)
- Cr CASH: Principal amount minus fees (if deducted from cash)
- Cr INTEREST_INCOME: Total interest recognized
- Cr DISBURSEMENT_FEE_INCOME: Fee amount (if charged)
- Dr BANK_CHARGE_EXPENSE / Cr CASH: Bank charges (if applicable)
-
Deducts from savings (if configured):
- Disbursement fee (if “deduct from savings” enabled)
- Advance interest (if interest paid IN_ADVANCE)
- Creates member’s loan ledger account: Tracks the outstanding balance
- Records in audit trail: Logs all loan details with timestamp and user
- Sends notification (if enabled): Borrower receives loan confirmation
- Updates analytics: Dashboard shows updated Portfolio Outstanding
Viewing the Created Loan
Learn how to view loan details →
Common Scenarios
Creating a Loan Larger Than Member’s Savings
Some tontines have rules like “maximum loan = 3× member’s savings balance.”Loan eligibility validation:
- Agatabo enforces the max loan percentage rule (if configured in Settings → Rates)
- If you try to create a loan exceeding the maximum, you’ll get an error
- Check member’s current savings balance in Organization Users → User Details
- Example: If max loan = 3× savings and member has 100,000 saved, maximum loan is 300,000
Creating a Loan with Irregular Payment Schedule
If the member needs to skip certain months or has a custom schedule:- Create the loan with standard monthly installments
- After creation, modify individual installment due dates or amounts
- Navigate to the loan details page and adjust the schedule
Creating a Grace Period Loan
If the member should not pay for the first N months:- Create the loan normally (first payment will be 1 month after start date)
- After creation, modify the first N installments by pushing their due dates forward
- Example: For 3-month grace, move installments 1-3 to months 4-6
- Interest will still accrue during grace period (depending on calculation type)
Common Issues
'Insufficient cash to disburse' error
'Insufficient cash to disburse' error
Cause: Organization doesn’t have enough cash to release the loan amount.Solution:
- Check Bank Accounts for current cash balance
- Ensure recent deposits have been recorded
- Verify no pending disbursements that haven’t cleared
- Consider reducing the loan amount
'Borrower not eligible' error
'Borrower not eligible' error
Cause: The organization user doesn’t have member role or doesn’t meet lending criteria.Solution:
- Verify the user has been assigned a member role in Organization Users
- Check if the member has any delinquent loans (some orgs block new loans until existing loans are current)
- Consult lending policy requirements
Installment schedule looks wrong
Installment schedule looks wrong
Cause: Incorrect loan rules (interest type, calculation method, or installment structure).Solution:
- Before creating: Go back to Step 2 and review all settings
- After creating: Loans cannot be deleted, only modified. Contact accountant for guidance.
- Consult Loan Rules Explained for expected outcomes
Cannot select disbursement date in the past
Cannot select disbursement date in the past
Cause: Disbursement date falls in a closed accounting period.Solution:
- Use today’s date or a date in the current open period
- If backdating is absolutely necessary, contact your accountant about period reopening (not recommended)
Best Practices
Loan creation tips:
- Use REDUCING_BALANCE with EQUAL_TOTAL for standard commercial-style loans
- Use INTEREST_FIRST allocation to ensure interest revenue is prioritized
- Set First Payment Date exactly one month after disbursement for monthly loans
- Always add at least one security (guarantor or collateral) for loans over a threshold
- Document unusual terms or special agreements in the Notes field
- Print or export the installment schedule to give to the borrower
- Verify member’s phone number and email for automatic payment reminders
Related Operations
After creating a loan, you may need to:Record Loan Payments
Track member repayments and update balances
View Loan Details
Review installment schedule and payment history
Apply Penalties
Charge late fees for overdue payments
Loan Analytics
Monitor portfolio health and arrears
Need Help?
Loan Rules Explained
Detailed examples of interest calculations and installment types
Understanding Loan Terms
Definitions of all loan-related terminology
Loan Disbursement Workflow
Complete checklist for loan processing
Common Errors
Troubleshooting guide for loan creation issues