MPESA Loan Disbursals Functional Spec
MPESA Import Loan Disbursals and Loan Fees
Release | 2.1 |
Current Owners: | Jacinta, Marie, Kay |
Status: | Stable |
- 1 MPESA Import Loan Disbursals and Loan Fees
- 2 Introduction
- 2.1 User Stories
- 2.2 Goals
- 2.3 Non-Goals
- 2.4 Definitions and Terminology
- 2.5 Related Documents
- 3 Mifos Permissions and Mandatory Fields
- 4 Export Mifos Loan Disbursals
- 5 Import Loan Disbursal and Fee Transactions
- 6 QA Considerations
- 7 Standard Considerations
- 8 Open Questions and Notes
Introduction
KEEF is planning to have mobile integration with M-PESA. They are using Mifos for their MIS platform. Mifos currently can import M-PESA loan payments and savings deposits into Mifos. To complete this integration, the ability to disburse loans will be added. This requires the following:
Ability to extract pre-approved loans (phone number and net disbursement amount) from Mifos. This extract will be uploaded into the M-PESA system. Once uploaded, M-PESA will disburse the loans to the clients' M-PESA accounts via mobile.
Ability to diburse net disbursal loan amount. The Mifos extract should include the net loan amount, which is defined us total loan amount less loan fees due at disbursement.
Ability to import M-PESA disbursement transactions into Mifos.
Ability to match the M-PESA disbursement records into Mifos approved loans and corresponding fees. In the given example, there will be 1 M-PESA transaction matching 2 transactions with Mifos: the Loan for 450,000 and the up-front loan fee of 3,000. MPESA Disbursement transction of 47,000 will be equivalent to Mifos 2 transactions of 1) 50,000 disbursement and 3,000 loan fee.
User Stories
Priority | User Story | Section in FR | |
|---|---|---|---|
1 | As a user (Data Encoder) at the HO, I want to be able to export Approved Loans into Excel file and import it into the M-PESA system. |
| |
1 | As a user (Data Encoder) at the HO, I want to be able to import a file of disbursals from M-PESA into Mifos so that M-PESA loan disbursements are accurately recorded in Mifos. |
| |
1 | As a user (Data Encoder, Accountant, Admin, Loan Officer) at either the BO or HO, I want to be able to see the loan disbursements with its corresponding fees properly recorded in Mifos. |
|
|
1 | As a user (Accountant) at the HO, I want to be able to reconcile transactions in the M-PESA system, Mifos, and Sage Pastel. |
|
|
1 | As a user (Data Encoder), I want to be able to see errors in export and import and be able to correct them. |
|
Goals
Mifos should be able to produce an extract in CSV that contains Approved Net Loan amount and customer phone number. This extract will be used to upload loans into MPESA system for disbursal.
Ability to import file of disbursement transactions from MPESA into Mifos to disburse the earlier approved loans.
Ability to deduct loan fees from loan amount and generate net loan amount for export report
Properly account for all transactions read, ignored, errored, and imported during import.