Transfer from Savings account for loan repayments and fee payments
Transfer from Savings account for loan repayments and fee payments
Release | Release I | ||
Current Owners: | Intrasoft Technologies (K) Inc./Chetan Bekkinkeri | |
|
Status (Draft, In Review, Stable / Approved): | Draft |
Contents:
1.Introduction
MFIs want the ability to recover fees and loan repayments from Savings Accounts especially in default cases or a member of a group may exit and give instructions his/her savings transferred to another member.
Mifos does not support this functionality currently and MFIs who wish to recover loan instalments from savings are forced to make a withdrawal then apply payment to the loan.
For proper reporting, MFIs need to differentiate direct payments to the loan accounts and transfers
Goals
List Goals of feature
Ability to apply loan payment from savings account.
Ability to pay for client charges from savings.
Non-Goals
The following items will not be addressed in this release:
Ability to transfer funds from one savings account to another.-- this will be taken up in the next release.
Ability to apply payment for a loan by using the savings account balance of a different client/group
Transfer of payments from multiple savings account
Making payments using the transfer option from the collection sheet.
Definitions and Terminology
Term | Definitions |
|---|---|
User | User of system |
Mandatory fields will be preceded by "*" (an asterisk)
Links are italicized
Buttons are Button
Related Documents
*insert links to related specs here
2.User Stories
List high level user stories - these can be broken down later into small user stories / user tasks if needed
Priority | User Stories | Section in FR | |
|---|---|---|---|
PR1 | As a Mifos Administrator, I want to be able to assign the permission "Can make payments to the account using Savings Account transfer" to a role, so that the users with the role can make loan and fee payments using savings account transfer | FR#1 | |
PR2 | As a Mifos user, I want to be able to view "Transfer from Savings Account" as a default accepted payment type so that the users can use the payment type to make account payments ( loan installments and fees) | FR#2 | |
PR3 | As a Mifos user, I want to be able to view all available Savings account of a client/group when I select the "Transfer from savings account" payment option so that the users can use the "Transfer from Savings Account" payment option to make account payments ( loan installments and fees) | FR#3 | |
PR4 | As a Mifos user, I want to be able enter the amounts to be transferred from the savings account of a client/group so that the users can use the "Transfer from Savings Account" payment option to make account payments ( loan installments and fees) | FR#4 | |
PR5 | As a Mifos user, I want to be able to view the appropriate transactions for payments made using the "Transfer from savings account" option | FR#5 | |
PR6 | As a Mifos accountant, I want to be able view appropriate accounting entries so that payments made from savings account are visible in the financial transaction history details | FR#6 |
|
3.Use Cases
3.1 New Permission : Can make payments to the account using Savings Account
Actors
Mifos Administrator with sufficient permission to assign permissions to roles
Preconditions
The Mifos administrator is logged into the system using the credentials provided
Basic Flow
User logs into Mifos
User navigates to the Admin screen -> Manage roles and responsibilities
Clicks on the link "New role"
Navigates to the Loan management ->Loan transactions
Post-conditions
A new permission "Can make payment to the account using Savings Account Transfer" is listed under the loan transactions permissions.
Mifos administrator should be able to choose the permission and submit the same
Alternative Flows
User logs into Mifos
User navigates to the Admin screen -> Manage roles and responsibilities
Clicks on the link of an existing role
Navigates to the Loan management ->Loan transactions
Validations
3.2 New default accepted payment type "Transfer from Savings Account"
Actors
Mifos user with permission to make loan and fee payments
Preconditions
A loan has already been created, disbursed and approved.
Basic Flow
User logs into Mifos and navigates to the loan summary page
Clicks on the "Apply payment" option
User clicks on the "mode of payment" dropdown
Post-conditions
"Transfer from Savings" should be visible as a payment option in the dropdown
Alternative Flows
Validations
3.3 View Savings account associated with client/group in the "apply payment" screen
Actors
Mifos user with permission to make loan and fee payments
Preconditions
A loan has already been created, disbursed and approved with a repayment due
"Can make payment to the account using Savings Account Transfer" permission is assigned to the user's role
Basic Flow
User logs into Mifos and navigates to the loan summary page
Clicks on the "Apply payment" option
User clicks on the "mode of payment" Dropdown
Chooses the "Transfer from Savings Account" option
Post-conditions
All the available savings accounts associated with the client/group should be visible.
This should include both Mandatory and voluntary savings account
Alternative Flows
Validations
3.4 Loan repayments using the "transfer from savings account" option
Actors
Mifos user with permission to make loan and fee payments
Preconditions
A loan has already been created, disbursed and approved with a repayment due
The permission "Can make repayments from Savings account" has been assigned for the user's role
Basic Flow
User logs into Mifos and navigates to the loan summary page
Clicks on the "Apply payment" link
User clicks on the "mode of payment" Dropdown
Chooses the "Transfer from Savings Account" option
All the available savings accounts associated with the client/group should be visible
User chooses one of the savings account
Post-conditions
The savings account details including the account balance is visible
The user should be provided the option to enter the amount he wants to pay.
Entering the amount and clicking on submit should ensure that the savings account balance gets reduced by the amount entered and the payments get applied to the loan account
The repayment amount entered should follow the loan repayment application hierarchy for Mifos Penalty->Fees->Interest->Principal
Alternative Flows
Validations
1. If the amount entered is greater than available balance in the savings account, then an error "Insufficient Balance in savings account to make the payments" should be displayed
2. If the amount entered is greater than the maximum amount per withdrawal limit on the savings account, an error message "The amount entered exceeds the maximum amount per withdrawal limit on the savings account" should be displayed.
3.5 Create Transactions for payments made using the "Transfer from savings account" option
Actors
Mifos user with permission to make loan and fee payments
Preconditions
A loan has already been created, disbursed and approved with a repayment due
The permission "Can make repayments from Savings account" should be assigned to the user's role
Basic Flow
Log into Mifos and navigates to the loan summary page
Click on the "Apply payment" link
Click on the "mode of payment" Dropdown
Choose the "Transfer from Savings Account" option
All the available savings accounts associated with the client/group should be visible
Choose the savings account through which you want to make the payments
Enter the amount to be paid through the savings account
Click on submit
Post-conditions
A withdrawal entry should be made against the savings account through which the payment is made
A payment entry should be made against the loan account with the amounts split across the Penalty->Fee->Interest->Principal hierachy
Alternative Flows
Validations
1. If the amount entered is greater than available balance in the savings account, then an error "Insufficient Balance in savings account to make the payments" should be displayed
2. If the amount entered is greater than the maximum amount per withdrawal limit, an error message "The amount entered exceeds the maximum amount per withdrawal limit on the savings account" should be displayed.
3.6 Accounting Entries for payments using transfer from savings account
Actors
Mifos user with permission to make loan and fee payments
Preconditions
A loan has already been created, disbursed and approved with a repayment due
The "transfer from savings account" has been created as an accepted payment type
The savings account through which the loan repayments are being made should have sufficient balance.
Basic Flow
User logs into Mifos and navigates to the loan summary page
Clicks on the "Apply payment" option
User clicks on the "mode of payment" Dropdown
Chooses the "Transfer from Savings Account" option
All the available savings accounts associated with the client/group should be visible
Choose the savings account for making the payments
Enter the amount to be paid out and click on submit
Post-conditions
If the savings account choosen for transfer is Mandatory,
a Debit entry for the amount entered should be against the Mandatory savings GL account code defined ( in the savings product)
a corresponding Credit entry for the amount entered should be on the loan account GL account code defined ( in the loan product). The credit entry should be split across Principal, interest, fees and penalty appropriately
If the savings account choosen for transfer is Voluntary,
a Debit entry for the amount entered should be against the voluntary savings GL account code defined ( in the savings product)
a corresponding Credit entry for the amount entered should be on the loan account GL account code defined ( in the loan product). The credit entry should be split across Principal, interest, fees and penalty appropriately
Alternative Flows
Validations
4. Functional Requirements
4.1 New Permission : Can make payments to the account using Savings Account
FR# | Description | Comments/Mockups |
|---|---|---|
4.1.1 | A new permission " Can make payment to the account using Savings Account Transfer" needs to be defined in the admin->Manage Roles and responsibilities-> Role->Loan Management ->Loan transaction | A new permission " Can make payment to the account using Savings Account Transfer" is to be defined in the admin section |
4.2 New default accepted payment type "transfer from Savings Account"
FR# | Description | Comments/Mockups |
|---|---|---|
4.2.1 | Under the Mifos administrator section the defined accepted payments type screen ( admin-> Define accepted payment type) should display the "transfer from savings account" as a valid payment type on the left hand side pane | This payment type should be displayed for Fees and loan repayments sub sections only |
4.2.2 | User with administrator privileges should be able to choose and add or remove payment ype payment from screen | Similar to how other payment types can be added or removed |
4.3 View details of Savings account associated with client/group in the "apply payment" screen
FR# | Description | Comments/Mockups |
|---|---|---|
4.3.1 | Clicking on the Mode of payment field dropdown , should display the "transfer from savings account" as a payment type | Need to display from the lookup as a list of values |
4.3.2 | Once the mode of payment is selected as "transfer from savings account", the list of savings accounts associated with the client/group should be displayed | |
4.3.3 | Clicking on the savings account number should display the available balance,type of account and the maximum amount per withdrawal allowed values | Display the following field |
4.3.4 | Display the review transaction button after the displaying the savings account information |
|
4.3.5 | Clicking on the "review transaction" should ensure that the savings account balance is validated against the amount entered. | If the savings account balance is less than amount entered in the amount field, an error message "Insufficient Balance in Savings account to make payments" should be displayed |
4.3.6 | If the amount entered is greater than the amount per withdrawal entered in the savings account, an error/validation message should be displayed | A message "The amount entered exceeds the maximum amount per withdrawal limit on the savings account" should be displayed. |
4.4 Create Transactions for payments made using the "transfer from savings account" option
FR# | Description | Comments/Mockups |
|---|---|---|
4.4.1 | After transferring the amount from the savings account to loan account , a withdrawal transaction should be made on the savings account | The withdrawal transaction type should specify a description - "Transfer for loan payments" |
4.4.2 | View transaction history on the savings account page should display the withdrawal transaction with appropriate GL codes | |
4.4.3 | The payment transaction should reflect the Penalty->Fees-> Interest->Principal hierarchy |
|
4.4.4 | The payment transaction should have the debit and credit entries for the Penalty, Fees, Interest and Principal |
|
4.5 Accounting Entries for payments using transfer from savings account
FR# | Description | Comments/Mockups |
|---|---|---|
4.5.1 | A debit entry equivalent to the amount transferred from the savings account should be made against the GL code assigned in the savings product | Savings accounts are "client Deposits" and hence should be treated as an Liability account for the MFI. |
4.5.2 | A credit entry should be made for the principal, interest, fees and penalty amount. | The GL codes to make the credit entries should be extracted from the Loan product ( principal, Interest), Fee Defined( Fees) and Penalty defined (Penalty) |
|
|
|
Standard Considerations
Security
Security (Permissions, Roles, and Data Scope) | Yes/No | Comments |
|---|---|---|
Does the user need to be in a particular user hierarchy to use this feature? | No |
|
Does the office hierarchy affect use of this feature? | No |
|
Are you using any existing permissions to control this feature? | No |
|
Are you adding any new permissions or changing existing permission to control this feature? | Yes |
|
Are you using any existing activities to control this feature? | No |
|
Are you adding any new activities or changing existing activities to control this feature? | No |
|
Are there any special considerations for upgrade scenarios? What will be the default value for new permissions? | No |
|
What will be the default values for default roles in a new installation? | N/A |
|
Impacts to System
Impacts to System | Yes/No | Comments |
|---|---|---|
Does this feature affect Bulk Loan Creation? How? | No |
|
Does this feature affect Collection Sheet Entry? How? | No |
|
Does this feature affect Redo Loans? | Yes |
|