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 |
 |
Does this feature affect Reverse Loans? |
Yes |
 |
Is this feature affected by Holidays? |
No |
 |
Globalization/Localization
Globalization/Localization |
Yes/No |
Comments |
---|---|---|
Will this feature support users localizing data that they enter? |
N/A |
 |
Does this feature involve any date/time related data, and if so how should conversions be handled? |
N/A |
 |
Is there currency or other numeric data ? If so does it require any special handling or validation? Is there a need for mult-currency? (Loan Accounts) |
N/A |
 |
Logging
Change Log
Change Log |
Yes/No |
Comments |
---|---|---|
Do changes to the data that is collected or stored by the new feature have to be fully logged by the system? |
No |
 |
Does the administrator configuring the system need the ability to turn on or off logging for this feature? |
No |
 |
Is the feature currently logged but the structure of the logged records changing? |
No |
 |
Reporting
Provide any relevant information about reporting requirements for the new features and answer the questions below, providing detail to explain any particular area when necessary.
Reporting |
Yes/No |
Comments |
---|---|---|
Does the feature affect any existing reports? |
Yes |
 |
Does the feature require adding any new reports? |
Yes |
 |
Performance
Performance |
Yes/No |
Comments |
---|---|---|
Will the feature be a high use-case scenario? |
No |
 |
Will the feature have potential for high concurrency? |
No |
 |
Does the feature include complex UI or data gathering logic that will be used by a significant portion of the user base? |
No |
 |
Does the feature contain risks of database connection timeout? |
No |
 |
Will the feature contain any bulk insert/update/delete transactions? |
No |
 |
Will the feature contain any caching mechanisms or cache refreshing mechanisms? |
No |
 |
Could the feature result in a large amount of data being sent to the client or between the database and web server? |
No |
 |
Would users on a low bandwidth connection likely face issues with a part of this feature? |
No |
 |
Does the feature affect existing batch jobs or require adding any new batch jobs? |
No |
 |
Setup and Installation
New Installations
New Installations |
Yes/No |
Comments |
---|---|---|
Does this feature require both Mifos Business Intelligence Suite and Mifos Product? |
 |
 |
Does this feature require special work for hosting? (sys admin) |
 |
 |
Backward Compatibility and Upgrades
Backward Compatibility and Upgrades |
Yes/No |
Comments |
---|---|---|
Is there any data conversion that needs to be done as part of an upgrade? |
No |
 |
Will customers lose data or will the way existing data is stored change significantly? |
No |
 |
Will another feature, workflow or portion of the data model be deprecated as a result of this new feature? |
No |
 |
Will existing role permissions be changed or impacted by this feature? If so provide details in the security section. |
Yes |
 |
Will existing customers need to learn a new UI process or change the way they use the system as a result of this new feature? |
Yes |
 |
Hosting Support
Hosting Support |
Yes/No |
Comments |
---|---|---|
If different user groups are using the same database, are there concerns over the sharing of data related to the feature? |
No |
 |
Are there expected to be performance related issues with having many customers sharing the same hardware in support of this feature? |
No |
 |
Configuration
Configuration |
Yes/No |
Comments |
---|---|---|
Does this feature require changes to configuration files? |
No |
 |
If so, is this feature enabled or disabled by default? |
No |
 |
Are existing configuration properties used to control this feature? If yes, which ones? |
No |
 |
Are new configuration properties added for this feature? |
No |
 |
Open Issues
- ...
Reviews and Approvals
- ...