Import Bank Transactions
Introduction
Al Majmoua currently handles all repayments of loans by clients by having clients deposit their repayments directly at a bank, and then Al Majmoua is able to download online a file of these recorded transactions to import their MIS. They need the ability to do this in Mifos as well. See related Business requirements for more detail.
User Stories (Epics)
Priority | User Story | Section in FR |
|---|---|---|
1 | As a user (accountant) at the HO, I want to be able to import a XLS of bank transactions from Audi Bank into Mifos so that all details for our clients' payments are accurately recorded in Mifos |
|
1 | As a loan officer at a BO, I want to be able to see the clients at branch have paid their loans in Mifos |
|
2 | As a user (accountant) at the HO, I want to be able to import a XLS of bank transactions from any bank into Mifos so that all details for our clients' payments are accurately recorded in Mifos |
|
Goals
Ability to import file of loan repayment transaction details into Mifos
Transaction History in Mifos accurately shows loan payments.
Non-Goals
The following items will not be addressed in this release:
Importing bank transactions from any bank other than Audi Bank
No import of attendance, savings, fees, or loan disbursal information - only loan repayments are imported.
Additional logging of import than what we do already in Mifos for logging
Definitions and Terminology
Mandatory fields will be preceded by *
Links are italicized
Buttons are Button
Related Documents
Business Requirements
Import Bank Transactions
This feature is in the Admin section and will allow the User to import bank transactions
Use Cases
Administrator assigns permissions to accountant to import bank transactions
Actors
Administrator
Preconditions
None
Basic Flow
Administrator logs onto Mifos and navigates to the Admin section. Administrator selects Manage Roles and Permissions. Administrator selects the role for accountants.
Mifos displays all possible permissions for the role and Administrator scrolls down to "Bulk". Administrator confirms that "Can import transactions" is checked.
Post-conditions
Accountant role has permission to import bank transactions
Alternative Flows
None
Validations
None
Accountant imports transactions (Audi Bank) - file with no errors
Actors
Accountant
Preconditions
Accountant has permissions to import transactions
Accountant has file in xls (Excel 97 format) to import
Basic Flow
Accountant logs onto Mifos and navigates to the Admin section. Accountant selects Import transactions.
Mifos displays new screen for Import Transactions.
Accountant selects Audi Bank Excel 97 or Audi Bank TSV for bank, and selects file from their computer for import. Accountant clicks on Continue.
Mifos imports file and checks for any errors (see Validations below). If there are no errors, Mifos displays Review & Submit screen with "There are no errors found. Click Submit to continue with import.".
Accountant clicks on Submit. Mifos displays confirmation screen that import was successful.
Post-conditions
All data available in the file has been imported and all the correct tables and loan account data correctly populated.
Validations
If a row has a cell that's empty in a required column is empty, that row is rejected and appropriate error message displayed.
No bad data - ie, no numbers in columns that require text and vice versa. Date of Transaction is in date format YYYY/MM/DD if it's a TSV file, or does not follow the expected format of that column. See FR's below.
Alternative Flows
Accountant cancels Import
At step 4, Accountant clicks on Cancel instead. Mifos returns User to the Admin screen.
Post-conditions