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

  1. User logs into Mifos 
  2. User navigates to the Admin screen -> Manage roles and responsibilities
  3. Clicks on the link "New role"
  4. 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

  1. User logs into Mifos 
  2. User navigates to the Admin screen -> Manage roles and responsibilities
  3. Clicks on the link of an existing role
  4. 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

  1. User logs into Mifos and navigates to the loan summary page
  2. Clicks on the "Apply payment" option
  3. 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

  1. User logs into Mifos and navigates to the loan summary page
  2. Clicks on the "Apply payment" option
  3. User clicks on the "mode of payment" Dropdown
  4. 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

  1. User logs into Mifos and navigates to the loan summary page
  2. Clicks on the "Apply payment" link
  3. User clicks on the "mode of payment" Dropdown
  4. Chooses the "Transfer from Savings Account" option
  5. All the available savings accounts associated with the client/group should be visible
  6. 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

  1. Log into Mifos and navigates to the loan summary page
  2. Click on the "Apply payment" link
  3. Click on the "mode of payment" Dropdown
  4. Choose the "Transfer from Savings Account" option
  5. All the available savings accounts associated with the client/group should be visible
  6. Choose the savings account through which you want to make the payments
  7. Enter the amount to be paid through the savings account
  8. 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

  1. User logs into Mifos and navigates to the loan summary page
  2. Clicks on the "Apply payment" option
  3. User clicks on the "mode of payment" Dropdown
  4. Chooses the "Transfer from Savings Account" option
  5. All the available savings accounts associated with the client/group should be visible
  6. Choose the savings account for making the payments
  7. 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
1. Saving Account number
2. Account Available Balance
3. Type of Account
4. Maximum amount per withdrawal
The existing fields in the apply payment screen should be displayed as per the current mifos functionality

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

  • ...