Instructions

1. Prepare an Excel file (.xlsx or .xls) with the following format:
2. Column A: Name (Full name of the client) - Required
3. Column B: Phone Number (Phone number in any format: 0XXX, +255XXX, or 255XXX) - Required
4. Column C: Loan Amount (Loan amount in TZS, must be a valid number) - Required
5. Column D: Tenure (Number of repayments/installments, must be a valid number, e.g., 12) - Required
6. Column E: Loan Type (watumishi or non-watumishi, defaults to non-watumishi if empty) - Optional
7. Column F: Loan Date (Date in YYYY-MM-DD format, defaults to today if empty) - Optional
8. Column G: Paid Amount (Amount already paid, defaults to 0 if empty) - Optional
9. The first row should contain headers (Name, Phone Number, Loan Amount, Tenure, Loan Type, Loan Date, Paid Amount)
10. Each subsequent row represents one client
11. Columns A-D are required, columns E-G are optional
12. If a client with the same phone number already exists, their information will be updated instead of creating a duplicate
13. Each installment is 30 days apart (first installment due 30 days from loan date)
14. Maximum file size: 10MB