Warning: Undefined array key "usertype" in /home/sbimacroco/bhm-finance.sbimacro.co.tz/index.php on line 12

Warning: Undefined array key "usertype" in /home/sbimacroco/bhm-finance.sbimacro.co.tz/index.php on line 15

Warning: Undefined array key "usertype" in /home/sbimacroco/bhm-finance.sbimacro.co.tz/index.php on line 18
Microfinance ERP v1.5

Upload Loan Repayments Form Page

Member Loan repayment Upload Form

Excel File Format Required

Please ensure your Excel file follows this exact format:

Column A Column B Column C
# Name Amount
1 John Doe 1000000
2 Jane Smith 500000
Column Descriptions:
  • Column A (#): Row number (will be ignored)
  • Column B (Name): Customer full name
  • Column C (Amount):Contribution amount in numbers
Important Notes:
  • Row 1 should contain headers (will be skipped during processing)
  • Column A (#) will be ignored during processing
  • Customer names must exactly match existing records in the system
  • All amount fields should contain numbers only (no commas or currency symbols)
  • File formats supported: .xlsx, .xls, .csv
  • Not sure about the instructions above? You can click here to download an example Excel file showing the correct format.