=== KPI Verification Test ===

KPI CALCULATIONS:
=================

1. Total Approved Loans: 16
2. Total Amount (TZS): 102,703,891.37
3. Successfully Disbursed: 0
4. Disbursed Amount (TZS): 0.00
5. Pending Disbursement: 6
6. Rejected Disbursements: 9
7. Failed Disbursements: 13


DETAILED BREAKDOWN:
===================

Status Distribution:
  - disbursement_pending: 3
  - REJECTED: 3
  - DISBURSEMENT_FAILED: 10
  - CANCELLED: 7
  - APPROVED: 4
  - DISBURSED: 6
  - PENDING: 1
  - DISBURSEMENT_REJECTED: 9
  - SETTLED: 1

Recent Rejected Loans:
  - Loan #138 (App: ESS1757583962229)
    Reason: Insufficient funds for disbursement. Please try again later.
    Date: 2025-09-11 10:44:19

  - Loan #131 (App: ESS1757567819024)
    Reason: Insufficient funds for disbursement. Please try again later.
    Date: 2025-09-11 10:06:04

  - Loan #64 (App: ESS1756992812152)
    Reason: Account verification pending. Please contact our customer support for further assistance.
    Date: 2025-09-11 09:16:42

  - Loan #77 (App: ESS1757400063194)
    Reason: Insufficient funds. Please contact our customer support for further assistance.
    Date: 2025-09-09 07:29:13

  - Loan #59 (App: ESS1756980114413)
    Reason: Account verification in progress. Will notify once complete.
    Date: 2025-09-09 05:29:38


Disbursement Statistics:
  - pending: 12 loans, Total: 66,364,350.78 TZS
  - failed: 42 loans, Total: 237,678,886.75 TZS

=== KPI Summary ===
The KPIs are calculated based on:
✓ Approved loans with final employer approval
✓ Excludes cancelled loans
✓ Tracks disbursement status (pending, success, failed, rejected)
✓ Provides accurate counts and amounts for decision making

KPI Display in Dashboard:
- Main KPIs: Total Approved, Disbursed, Pending, Total Amount
- Additional KPIs: Rejected and Failed (shown when > 0)
- Filter options: All, Ready to Disburse, Disbursed, Failed, Rejected

=== Test Completed Successfully ===