,           ,
 /             \ 
((__-^^-,-^^-__))
 `-_---' `---_-'
  `--|o` 'o|--'     TWiki . Moap
     \  `  /
      ): :(
      :o_o:
       "-"
::: BulkEntryForm :::
 
  TWiki . Moap . BulkEntryForm # Edit # Attach # Diffs # Printable # More :::

Home

Project
Sourceforge
Tasks
Bugs

Collaboration
Mailing Lists
Chat

Bulk data entry

Most microfinance organizations use paper and pencil in the field to record transactions. Unlike a bank, this means that data must be recorded after the fact. Usually this is done as part of the workflow of the field officer (loan officer) who comes to the office to deposit the cash and make entries into a computerized system. Moreover, in order to keep things simple with thousands of transactions per loan officer per week, MFIs have typically choosen to not accept partial payments and to require certain amounts of savings (when allowed by law). This leads to a set of Expected Transactions that can be calculated based on the loan schedule and the mandatory savings amounts.

Both of these dynamics introduce a new requirement beyond what is found in typical banking applications, namely that a bulk-entry form is created to allow the loan officer to quickly reconcile paper records (which can also be pre-printed from the MIS in advance of the meetings) with the system's records. Because it is important that a system be based on transactions (not balances of accounts), the idea becomes that there is a set of expected transactions that are then sent to the transaction engine and recorded in the system. This is a kind of two-stage transaction record, something recommended in system design of this type.

Here are some graphical representations of how these screens may look with notations explaining some functionality.

  • screen one:
    bulkEntry1.gif

  • screen two:
    bulkEntry2.gif

-- JamesDailey - 09 Jan 2004

Attachment: Action: Size: Date: Who: Comment:
bulkEntry1.gif action 34102 09 Jan 2004 - 00:57 JamesDailey Screen One
bulkEntry2.gif action 40466 09 Jan 2004 - 00:58 JamesDailey screen two

# Edit menu  


Topic revision r1.3 - 09 Jan 2004 - 01:01 GMT - JamesDailey
Topic parents: WebHome > MicroFinanceFormsReports
Copyright © 1999-2003 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback.