Real-time monitoring and advanced analytics for overdue loans
{{ error }}
| Borrower | Loan Details | Product | Repayment Method | Payment Schedule | Expected Payment | Arrears Amount | Missed Periods | Days Overdue | Alert Level | Last Payment | Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
{{ loan.borrower_name|first|upper }}
{{ loan.borrower_name }}
{{ loan.borrower_phone|default:"N/A" }}
|
{{ loan.loan_number }}
Due: {{ loan.due_date|date:"M d, Y" }}
|
{{ loan.loan_product|default:'Unknown' }}
{% if loan.product_type == 'boost' %}
⚡ 1 Month
{% elif loan.product_type == 'boost_plus' %}
2 Months
{% elif loan.product_type == 'mwamba' %}
3 Months
{% elif loan.product_type == 'imara' %}
6 Months
{% endif %}
|
{{ loan.repayment_method|default:'Monthly'|title }}
{% if loan.repayment_method == 'daily' %}
Every Day
{% elif loan.repayment_method == 'weekly' %}
Every Week
{% else %}
📅 Every Month
{% endif %}
|
{% if loan.repayment_method == 'daily' %}
Daily: KES {{ loan.expected_payment_amount|floatformat:0 }}
{% elif loan.repayment_method == 'weekly' %}
Weekly: KES {{ loan.expected_payment_amount|floatformat:0 }}
{% else %}
Monthly: KES {{ loan.expected_payment_amount|floatformat:0 }}
{% endif %}
{% if loan.repayment_method == 'daily' %}
⏰ Due Every Day
{% elif loan.repayment_method == 'weekly' %}
⏰ Due Every 7 Days
{% else %}
⏰ Due Every 30 Days
{% endif %}
|
KSh {{ loan.expected_payment_amount|floatformat:0 }} | KSh {{ loan.arrears_amount|floatformat:0 }} |
{{ loan.missed_periods_count|default:0 }} Missed
{% if loan.repayment_method == 'daily' %}
{% if loan.missed_periods_count > 0 %}
⚠️ {{ loan.missed_periods_count }} Day{{ loan.missed_periods_count|pluralize }} Overdue
{% endif %}
{% elif loan.repayment_method == 'weekly' %}
{% if loan.missed_periods_count > 0 %}
⚠️ {{ loan.missed_periods_count }} Week{{ loan.missed_periods_count|pluralize }} Overdue
{% endif %}
{% else %}
{% if loan.missed_periods_count > 0 %}
⚠️ {{ loan.missed_periods_count }} Month{{ loan.missed_periods_count|pluralize }} Overdue
{% endif %}
{% endif %}
|
{{ loan.days_overdue }} days
{% if loan.repayment_method == 'daily' %}
{% if loan.days_overdue >= 7 %}
🔥 Critical
{% elif loan.days_overdue >= 3 %}
⚠️ High Risk
{% elif loan.days_overdue >= 1 %}
⚠️ Medium Risk
{% endif %}
{% elif loan.repayment_method == 'weekly' %}
{% if loan.days_overdue >= 21 %}
🔥 Critical
{% elif loan.days_overdue >= 14 %}
⚠️ High Risk
{% elif loan.days_overdue >= 7 %}
⚠️ Medium Risk
{% endif %}
{% else %}
{% if loan.days_overdue >= 90 %}
🔥 Critical
{% elif loan.days_overdue >= 60 %}
⚠️ High Risk
{% elif loan.days_overdue >= 30 %}
⚠️ Medium Risk
{% endif %}
{% endif %}
|
{% if loan.repayment_method == 'daily' %}
{% if loan.days_overdue >= 7 %}
🔥 CRITICAL
Daily Payment Overdue!
{% elif loan.days_overdue >= 3 %}
⚠️ HIGH ALERT
Multiple Days Overdue
{% elif loan.days_overdue >= 1 %}
⚠️ ALERT
Daily Payment Missed
{% endif %}
{% elif loan.repayment_method == 'weekly' %}
{% if loan.days_overdue >= 21 %}
🔥 CRITICAL
Multiple Weeks Overdue!
{% elif loan.days_overdue >= 14 %}
⚠️ HIGH ALERT
Weekly Payment Overdue
{% elif loan.days_overdue >= 7 %}
⚠️ ALERT
Weekly Payment Missed
{% endif %}
{% else %}
{% if loan.days_overdue >= 90 %}
🔥 CRITICAL
Multiple Months Overdue!
{% elif loan.days_overdue >= 60 %}
⚠️ HIGH ALERT
Monthly Payment Overdue
{% elif loan.days_overdue >= 30 %}
⚠️ ALERT
Monthly Payment Missed
{% endif %}
{% endif %}
|
{% if loan.last_payment_date %}
{{ loan.last_payment_date|date:"M d, Y" }}
KSh {{ loan.last_payment_amount|floatformat:0 }}
{% else %}
No payments
{% endif %}
|
|
|
✓
No loans in arrears found
|
|||||||||||