Overdue

Overdue lists schedule instalments past their due date and still unpaid - the front edge of delinquency. Officers use it to triage arrears by days-past-due, which determines PAR bucket and the appropriate collection action.

Workflow

Group by days-past-due to band arrears into PAR buckets.
Prioritise the oldest and largest overdue instalments.
Trigger penalties or collection actions from the linked loan.
Escalate aged arrears to demand letters or the collections workflow.
Track resolution as overdue instalments are settled.

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, overdue and unpaid.
Days-past-due drives PAR 30/60/90 classification.
Feeds Penalties, Demand Letters and Collection Actions.

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