All Schedules

All Schedules lists every amortisation instalment row across the portfolio, each carrying its due date and the principal, interest, penalty and balance components. These rows are the contractual obligation against which repayments and arrears are measured and PAR is computed.

Workflow

Filter to a loan or product to inspect its instalment plan.
Review the breakdown of principal versus interest per instalment.
Use calendar view to see due dates spread across a period.
Identify partially paid or unpaid instalments.
Drill into a row to see linked repayments.

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.
Columns: due date, principal due, interest due, penalty, balance, paid status.
Generated at disbursement from the product's interest method.
Basis for arrears aging and PAR.

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