Collection Efficiency

Collection Efficiency measures how much of what fell due was actually collected, the key operational indicator of repayment discipline, computed from scheduled-versus-received amounts. Low efficiency is an early warning of rising arrears before they show up in PAR.

Workflow

Group by period, officer or branch to compute the collection ratio.
Compare amount due against amount collected per group.
Flag officers or branches below the efficiency target.
Drill into shortfalls to find unpaid instalments.
Export the trend for management review.

Fields reference

Every field on this screen, drawn from the live data model.

Field	Type	Required	Description
Loan `loan_id`	Link → mfi.loan	Yes	Loan
# `installment_number`	Number	Yes	#
Due Date `due_date`	Date	Yes	Due Date
Status `state`	Choice: Pending, Partially Paid, Paid, Overdue, Waived	Yes	Status
Member `member_id`	Link → mfi.member	—	Member
Branch `branch_id`	Link → mfi.branch	—	Branch
Currency `currency_id`	Link → res.currency	—	Currency
Principal Due `principal_amount`	Money	—	Principal Due
Interest Due `interest_amount`	Money	—	Interest Due
Total Due `total_due`	Money	—	Total Due
Principal Paid `principal_paid`	Money	—	Principal Paid
Interest Paid `interest_paid`	Money	—	Interest Paid
Total Paid `total_paid`	Money	—	Total Paid
Balance Due `balance_due`	Money	—	Balance Due
Opening Balance `opening_balance`	Money	—	Opening Balance
Closing Balance `closing_balance`	Money	—	Closing Balance
Paid Date `paid_date`	Date	—	Paid Date
Days Overdue `days_overdue`	Number	—	Days Overdue
Company `company_id`	Link → res.company	—	Company

Status lifecycle

Records on this screen move through these statuses:

Pending → Partially Paid → Paid → Overdue → Waived

Notes & rules

Model: mfi.loan.schedule.
Efficiency = collected / scheduled due.
Leading indicator ahead of PAR deterioration.
PDF version under Print Reports.

Technical model: mfi.loan.schedule · Record: Loan Repayment Schedule