Bulk Loan Request Upload
Back to Loan Requests
Instructions
- Upload an Excel (.xls, .xlsx) or CSV file with loan requests
- File must have a header row with these columns (case-insensitive):
- MemberId (required) - Member ID
- LoanCode (required) - Loan product code (e.g., GOLD_LOAN)
- Amount (required) - Loan amount
- InterestRate (optional) - Overrides product default
- Duration or Tenor (optional) - Overrides product default (months)
- Missing optional fields will use the loan product's default values
- Each row creates a loan request with status "Pending" for approval workflow
- Target Month/Year - All loans will use this as their request date (defaults to current month)
Sample Template
| MemberId | LoanCode | Amount | InterestRate | Duration |
|---|---|---|---|---|
| MEM001 | GOLD_LOAN | 500000 | 5.5 | 12 |
| MEM002 | GOLD_LOAN | 750000 | 18 | |
| MEM003 | GOLD_LOAN | 1000000 | 6.0 |