New GLIM Loan approach
Release | Unreleased |
Current Owners: |
|
Status: | Draft |
Contents:
Introduction
In previous version of Mifos, it was possible to create group loan with monitoring of every member (GLIM on) and also to create group loan without specifying members (GLIM off). Individual member accounts were only for information purposes, so they had only little connection to group account (e.g. after closing client, he was still visible on the Group account). There was also no possibility to repay individual member account because there was no access to those accounts and as a result, payments could be only applied to the whole group loan account. So, in general, there was a Group loan account and individual member accounts only for information purposes.
In new GLIM Loan there will be a new approach of Group Loan account. There will be individual member accounts and Group loan account only for information purposes. During the Group loan creation, also individual accounts will be created for every member of group loan. Group loan account will be will be a sum of member's accounts. It would be possible to access every individual member loan account, so that there will be a possibility to repay every individual account or close it, and information about that will be immediately visible on Group loan account. While applying payment to the entire Group loan, amount will be divided automatically into Group Loan account members but there will be also possible to modify exact payment amount of every member. This new approach will be more flexible and will meet more client requirements.
Goals
- Old Loan Product should accept new GLIM Loans for Groups
- Possibility to create Group Loan account with individual member loan accounts
- Ability to apply payment to Group Loan and also to individual member loan accounts
- Possibility to apply payment to entire Group loan with automatic amount deduction and option to manually edit payment amount for every individual member
- Possibility to apply payment only to individual member loan account
- Possibility to repay new GLIM Loan by trasfer from Savings
- Possibility to access individual member loan account from Client details page
- Possibility to adjust transactions on Group loan account with option to manually correct amount for every individual member
- Possibility to adjust transactions made on individual account
- Possibility to apply fees/penalties to group account with automatic amount deduction (according to contribution of every member) and option to manually edit charge amount for every individual member
- Possibility to apply fees/penalties to individual member loan account
- Possibility to apply full repay to individual member loan account and also to group loan account
- Amounts on group account are sum of amounts on member accounts
- No possibility to modify loan account parameters from member accounts
- Possibility to redo Loan with new GLIM approach
- Possibility to reverse new GLIM Loan
- Possibility to repay new GLIM Loan by using Audi Bank Plugin
- Possibility to approve new GLIM Loan by using 'Approve multiple loans' functionality
- Possibility to attach Question Groups to new GLIM Loan
- Possibility to close individual member Loan account and also the whole new GLIM Loan
Non-Goals
The following items will not be addressed in this release:
- Possibility to repay new GLIM Loan by using MPESA plugin
- Compatibility with Mifos Android Client
Related Documents
Epic issue: https://mifosforge.jira.com/browse/MIFOS-5628
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 |
---|---|---|
1 | As a user, I want to be able to create Group loan account, so that every member of group loan will have his own individual account | |
2 | As a user, I want to be able to create product for Groups | |
3 | As a user, I want to be able to have access to individual member accounts from Client details page | |
4 | As a user, I want to be able to make transactions to entire new GLIM Loan | |
As a user, I want to be able to specify exact payment amount for every member while applying payment to group account | ||
5 | As a user, I want to be able to make transactions to particular individual member loan account | |
5 | As a user, I want to be able to repay Loan transfer from Savings account | |
As a user, I want to be able to repay Loan by using Audi Bank plugin | ||
6 | As a user, I want to be able to apply fees/penalties to the whole new GLIM Loan and have possibility to modify fees/penalties amount for every member of the Loan | |
As a user, I want to be able to apply fees/penalties to individual member Loan account | ||
As a user, I want to be able to apply adjustment to the whole new GLIM Loan and have possibility to modify adjustment amount for every member of the Loan | ||
As a user, I want to be able to apply adjustment to individual member Loan account | ||
As a user, I want to be able to apply full repayment to whole new GLIM Loan and have possibility to modify full repayment amount for every member of the Loan | ||
As a user, I want to be able to apply full repayment to individual member Loan account | ||
As a user, I want to be able to repay Loan/fees/penalties by using Collection Sheet Entry | ||
7 | As a user, I want to be able to modify loan parameters only on group loan account | |
As a user, I want to be able to approve new GLIM Loan by using 'Approve multiple loans' functionality | ||
As a user, I want to be able to redo new GLIM Loan | ||
As a user, I want to be able to reverse new GLIM Loan | ||
As a user, I want to be able to attach a Question Group to new GLIM Loan | ||
As a user, I want to be able to close loan of individual member and see updated information on group loan account |
1. Use Cases - creating Group loan account
1.1 User can create Group loan account by using previously created product
Actors
- User with permissions to create Group Loan accounts
Preconditions
- Loan product for Group was previously created
Basic Flow
- From 'Group details' page, user clicks 'New loan application'
- User selects previously created product
- Select type of product: "Group loan"
- Page with loan parameters and schedule is displayed
- User can select members of group loan from the list (list contains only clients who are members of this group)
- User can enter amount of every member. Total group loan amount is a sum of amounts from every member
- User click 'Submit'.
Post-condition
- Group loan account is created along with individual accounts for every selected member of Group.
Validations
- Individual accounts are created only for members selected during loan creation, not for all members of the Group.
Alternative flow
- Loan product was not previously created.
- At 2. there is a validation message that no products are available.
1.2 User can display Group loan details
Actors
- User with permissions to create and display Group Loan accounts
Preconditions
- Group Loan account was previously created
Basic Flow
- From 'Group details' page, user clicks link with Loan name in 'Loan Accounts Overview' section
- Group loan details page is displayed with four information tabs: "Details", "Schedule", "Transactions" and "Additional Data" and also with transactions tabs: "Undo disbursal", "Modify", "Loan repayment", "Waive interest", "Write-off", "Close (as rescheduled)" and "Close".
- "Details" is a default tab after opening Group loan details page.
- User has possibility to view schedules of every member of group account from Group loan details page.
Post-condition
- Group loan details page has the same options as Client loan details page and also possibility to view schedules of every group loan member.
1.3 User can display individual member loan account details
Actors
- User with permissions to create and display Group Loan accounts
Preconditions
- Group Loan account was previously created
Basic Flow
- There is a new section on Client details page: "Group Loan Accounts Overview".
- User can display individual member loan account details by clicking on Group loan account name.
- Individual member loan account details page is displayed with four information tabs: "Details", "Schedule", "Transactions" and "Additional Data" and also with transactions tabs: "Loan repayment", "Waive interest", "Write-off", "Close (as rescheduled)" and "Close".
- "Details" is a default tab after opening Individual member loan account details details page.
Post-condition
- Individual member loan account details page has almost the same options as Client loan details page but "Undo disbursal" and "Modify" tabs are not available.
1.4 User can modify parameters of Group Loan account
Actors
- User with permissions to create and display Group Loan accounts
Preconditions
- Group Loan account was previously created
Basic Flow
- User opens Group Loan account details page
- User clicks on 'Modify' button
- User has possibility to modify all loan parameters
- User clicks 'Save' button to submit changes
Post-condition
- Group Loan account can be modified only from Group details page
- Group Loan account parameters cannot be modified from individual member account
2. Use Cases - payments
2.1 User can apply payment (with amount equal to installment amount) to entire Group Loan account
Actors
- User with permissions to create and display Group Loan accounts
- User with permissions to apply payments to Group Loan accounts
Preconditions
- Group Loan account was previously created
Basic Flow
- User opens Group Loan account details page
- User clicks on 'Loan repayment' button
- User enters total payment amount
- Amount is automatically deducted according to contribution of every member in Group Loan account
- In the next step, user has possibility to has to edit payment amount for every member
- User clicks 'Submit' button
Post-condition
Payment is applied to every member loan account and also information about payment is updated on Group loan account.
2.2 User can apply payment (with amount greater than installment amount) to entire Group Loan account
Actors
- User with permissions to create and display Group Loan accounts
- User with permissions to apply payments to Group Loan accounts
Preconditions
- Group Loan account was previously created
Basic Flow
- User opens Group Loan account details page
- User clicks on 'Loan repayment' button
- Amount is automatically deducted according to contribution of every member in Group Loan account
- In the next step, user has possibility to has to edit payment amount for every member
- User clicks 'Submit' button
Post-condition
- First the whole installment amount is repaid on individual member accounts and also information about payment is updated on Group loan account.. After that overpayment amount is applied to the next installment on individual member accounts also information about payment is updated on Group loan account.
- Amount of interest for next installment is recalculated according to the decreased principal amount.
2.3 User can apply payment (with amount partial installment amount) to entire Group Loan account
Actors
- User with permissions to create and display Group Loan accounts
- User with permissions to apply payments to Group Loan accounts
Preconditions
- Group Loan account was previously created
Basic Flow
- User opens Group Loan account details page
- User clicks on 'Loan repayment' button
- Amount is automatically deducted according to contribution of every member in Group Loan account
- In the next step, user has possibility to has to edit payment amount for every member
- User clicks 'Submit' button
Post-condition
- Partial amount is applied to the current installment on Group Loan account and also on individual member accounts.
- Amount of interest is recalculated since installment has not been fully repaid.
2.4 User can apply payment (with amount equal to installment amount) to individual member account
Actors
- User with permissions to create and display Group Loan accounts
- User with permissions to apply payments to Group Loan accounts
- User with permissions to apply payments to individual member accounts
Preconditions
- Group Loan account was previously created
Basic Flow
- User opens individual member account details page
- User clicks on 'Loan repayment' button
- User has possibility to specify payment amount
- User clicks 'Submit' button
Post-condition
- Payment is applied to individual member loan account and information about payment is automatically updated on Group Loan account. Amount of installment to be repaid on Group Loan schedule is decreased with amount equal to this paid on individual member account. Amount which has already been repaid should be displayed in 'Total Paid' column.
2.5 User can apply payment (with amount greater than installment amount) to individual member account
Actors
- User with permissions to create and display Group Loan accounts
- User with permissions to apply payments to Group Loan accounts
- User with permissions to apply payments to individual member accounts
Preconditions
- Group Loan account was previously created
Basic Flow
- User opens individual member account details page
- User clicks on 'Loan repayment' button
- User enters overpayment amount
- User clicks 'Submit' button
Post-condition
- First the whole installment is repaid on individual member account. After that overpayment amount is applied to the next installment on individual member account.
- Amount of installment to be repaid on Group Loan schedule is decreased with amount equal to this paid on individual member account. Amount which has already been repaid should be displayed in 'Total Paid' column.
- Overpayment amount is applied to the next installment on Group Loan account with amount equal to overpayment amount on individual member account.
- Amount of interest for next installment is recalculated according to the decreased principal amount.
2.6 Use Case - User can apply payment (with partial installment amount) to individual member account
Actors
- User with permissions to create and display Group Loan accounts
- User with permissions to apply payments to Group Loan accounts
- User with permissions to apply payments to individual member accounts
Preconditions
- Group Loan account was previously created
Basic Flow
- User opens individual member account details page
- User clicks on 'Loan repayment' button
- User enters partial payment amount
- User clicks 'Submit' button
Post-condition
- Partial amount is applied to the current installment on individual member account.
- Amount of interest is recalculated since installment has not been fully repaid.
- Amount of installment to be repaid on Group Loan schedule is decreased with amount equal to this paid on individual member account. Amount which has already been repaid should be displayed in 'Total Paid' column.
- Amount of interest on Group Loan schedule is recalculated since installment has not been not fully repaid.
3. Use Cases - adjustments
3.1 User can apply adjustment to entire Group Loan account
Actors
- User with permissions to create and display Group Loan accounts
- User with permissions to apply adjustments to Group Loan accounts
- User with permissions to apply adjustments to individual member accounts
Preconditions
- Group Loan account was previously created
- Payment was previously applied to entire Group Loan account
Basic Flow
- User opens Group Loan account details page
- User goes to 'Transactions' tab
- User clicks on 'Adjust' button next to the transaction
- User has possibility to automatically modify/revert transaction made to of every individual member
- User clicks 'Save' button
Post-condition
- Transaction is adjusted on all individual member loan accounts and also information about adjustment is automatically updated on Group Loan account.
- Transaction applied only on individual member account cannot be adjusted from Group Loan account
3.2 User can apply adjustment to individual member loan account
Actors
- User with permissions to create and display Group Loan accounts
- User with permissions to apply adjustments to Group Loan accounts
- User with permissions to apply adjustments to individual member accounts
Preconditions
- Group Loan account was previously created
- Payment was previously applied to individual member account or to entire Group loan account
Basic Flow
- User opens individual member loan account details page
- User goes to 'Transactions' tab
- User clicks on 'Adjust' button next to the transaction
- User has possibility to adjust/modify transaction
- User clicks 'Save' button
Post-condition
- Transaction is adjusted on individual member loan account.
- Group Loan account is updated accordingly to adjusted transaction on individual member account.
4. Use Cases - charges
4.1 User can apply charges to entire Group Loan account
Actors
- User with permissions to create and display Group Loan accounts
- User with permissions to apply charges to Group Loan accounts
Preconditions
- Group Loan account was previously created
Basic Flow
- User opens Group Loan account details page
- User clicks on 'Charge' button
- Charge amount is automatically deducted according to contribution of every member in Group Loan account
- In the next step, user has possibility to has to edit charge amount for every member
- User clicks 'Save' button
Post-condition
- Charge is applied to individual member accounts and information about applied charges is automatically updated on Group Loan account (sum of individual charges).
- Charge applied from Group Loan account level can be only modified from Group Loan account level and cannot be modified from individual member account level
4.2 User can apply charges to individual member loan account
Actors
- User with permissions to create and display Group Loan accounts
- User with permissions to apply charges to individual member loan accounts
Preconditions
- Group Loan account was previously created
Basic Flow
- User opens individual member loan account details page
- User clicks on 'Charge' button
- User charge amount for individual member
- User clicks 'Save' button
Post-condition
- Charge is applied to individual member accounts and information about applied charges is automatically updated on Group Loan account.
- Charge applied from individual member account level can be only modified from individual member level and cannot be modified from Group Loan account level
4.3 User can apply payment for the charge to entire Group Loan account
Actors
- User with permissions to create and display Group Loan accounts
- User with permissions to apply charges to Group Loan accounts
- User with permissions to apply payments to Group Loan accounts
Preconditions
- Group Loan account was previously created
- Charge was previously applied to Group Loan account
Basic Flow
- User opens Group Loan account details page
- User clicks on 'Loan repayment' button
- Amount is automatically deducted according to contribution of every member in Group Loan account
- In the next step, user has possibility to has to edit payment amount for every member
- User clicks 'Save' button
Post-condition
- Payment for charge is applied to individual member accounts and information about applied payments for charges is automatically updated on Group Loan account (sum of individual payments).
4.4 User can apply payment for the charge to individual member loan account
Actors
- User with permissions to create and display Group Loan accounts
- User with permissions to apply charges to individual member loan accounts
- User with permissions to apply payments to individual member loan accounts
Preconditions
- Group Loan account was previously created
- Charge was previously applied to individual member loan account
Basic Flow
- User opens individual member loan account details page
- User clicks on 'Loan repayment' button
- User enters payment for the charge
- User clicks 'Save' button
Post-condition
- Payment for charge is applied to individual member account and information about applied payment for charge is automatically updated on Group Loan account.
5. Use Cases - Loan product
5.1 User can create Loan products for Groups
Actors
- User with permissions to create Group Loan products
Preconditions
- Loan product for Groups has the same options as for individual Clients
Basic Flow
- Open 'Organisation Administration' tab
- Click on 'Add Loan Product'
- Select type of product: "Group loan"
- Enter all necessary product details
- Click on 'Save' button
Post-condition
- Product can be selected during Group Loan account creation
Validations
- Standard validation for every field during the product creation
6. Use Cases - closing Group loan account
6.1 User can close entire Group Loan account
Actors
- User with permissions to close Group Loan accounts
Preconditions
- Group Loan account has already been created
Basic Flow
- User opens Group Loan account details page
- User clicks 'Close' button
- User clicks on 'Save' button
Post-condition
- Group Loan account is closed as well as every individual member loan account.
Validations
- If any of the individual member loan account was previously closed then the rest of the accounts related to this Group loan account, are closed.
6.1 User can close individual member Loan account
Actors
- User with permissions to close individual member loan accounts
Preconditions
- Group Loan account has already been created
Basic Flow
- User opens individual member loan account details page.
- User clicks 'Close' button
- User clicks on 'Save' button
Post-condition
- Individual member loan accountt is closed and information about this is automatically updated on Group Loan account
Functional Requirements
FR# | Description | Comments/Mockups |
---|---|---|
1.1 Create a New Group loan account | Create flow will be almost the same as current implementation, there will be new link on Group details page: "New Group Loan application". After creating group account also new individual account will be created for every member of group account. | |
1.2 Group loan account details page | Group Loan account details page will be almost the same as in current implementation. Individual schedule will show schedules from individual member accounts. | |
1.3 Individual member loan account details page | Individual member loan account details page will be almost the same as Client loan account details page. However, "Undo disbursal" and "Modify" tabs will not available. | |
1.3 Client details page | There will be a new section on Client details page – 'Group Loan Accounts Overview', which will be showing individual member account details. | |
1.4 Modify account parameters | Parameters of Group Loan account can be modified only from Group Loan account level. There is no possibility to modify account details from individual member account level. | |
2. Apply payment | There will be possible to apply payment from every individual account and also from Group loan. When you try to apply payment from Group loan details page (click 'Loan repayment'), then new page will be displayed, on which it would be possible to enter exact amount for every member. Payment amount will be applied to every individual member account and information about payment will be automatically updated on Group Loan account. | |
3. Apply adjustment | It will be possible to adjust payment made by individual and also whole payment made to Group Loan account. While applying adjustment, it will be possible to revert/modify amount of every individual member. | |
4. Apply charge | Charges could be applied to individual member account and also to the whole Group account. While applying charge, it will be possible to specify exact charge amount for every individual member. | |
5. Loan product | Loan product for Groups has the same options as for individual Clients. There can be some restrictions on the Group product. | |
6. Close Group Loan account | It is possible to close the entire Group Loan account and then also individual member loan accounts are closed. There is also possibility to close individual member loan account only and information about this is automatically updated on Group loan account. |
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? | Yes |
|
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? | Yes |
|
Are you adding any new activities or changing existing activities to control this feature? | Yes |
|
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? | No special considerations. Default value is checked in User role. |
|
di