Details

    • New Feature
    • Status: Reopened
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Accounting

    Description

      A number of MFIs have requested the addition of a bank reconciliation module, making it easier for them to reconcile any journal entries made against their Bank Account GL(s) in Fineract, with the actual transactions in their bank account. First thoughts on how this would work below:

      • User will need the ability to select a specific GL Account to reconcile. Perhaps a checkbox should be added when creating / editing a GL to specify if it should be made available in the reconciliation module
      • Reconciliation module should show all GL accounts that were previously made available, along with the reconciled balance and unreconciled balance
      • User should then be able to select the GL account, and pull out either all journal entries between a start and end date, or all unreconciled entries, or all reconciled entries
      • User should have the ability to tick a checkbox for any entry that they wish to reconcile and then to save at the end once they have ticked multiple checkboxes they can save
      • The act of reconciliation should be tracked and shown in the audit module

      The more complex, but key, addition, will be the option to group (or if possible to sum) all transactions with the same reference together. This will be useful when reconciling group postings which appear as multiple GLs in Fineract, but only one transaction in the bank account.

      Attachments

        Activity

          edcable Ed Cable added a comment -

          emmanuelnnaa@musoni.eu sheyden Will this be a feature that Musoni will be contributing into Fineract? Will the functionality be like as described and shipped as part of the Musoni System 1.26 release?

          http://musonisystem.com/wp-content/uploads/2016/01/Musoni-System-Release-1.261.pdf

          edcable Ed Cable added a comment - emmanuelnnaa@musoni.eu sheyden Will this be a feature that Musoni will be contributing into Fineract? Will the functionality be like as described and shipped as part of the Musoni System 1.26 release? http://musonisystem.com/wp-content/uploads/2016/01/Musoni-System-Release-1.261.pdf
          emmanuelnnaa@musoni.eu Emmanuel Nnaa added a comment -

          edcable

          Do expect a pull request from Musoni before the end of next month. The functionality will work as described in the release document for Musoni System 1.26 Release.

          sheyden - FYI

          emmanuelnnaa@musoni.eu Emmanuel Nnaa added a comment - edcable Do expect a pull request from Musoni before the end of next month. The functionality will work as described in the release document for Musoni System 1.26 Release. sheyden - FYI
          Ippez Ippez Roberts added a comment -

          @Edward Cable, @Emmanuel Nnaa any update on this too

          Ippez Ippez Roberts added a comment - @Edward Cable, @Emmanuel Nnaa any update on this too
          mexina Mexina Daniel added a comment -

          This is very important feature for Fineract to have
          edcable emmanuelnnaa@musoni.eu Any update on this?

          mexina Mexina Daniel added a comment - This is very important feature for Fineract to have edcable emmanuelnnaa@musoni.eu Any update on this?
          francisguchie Francis Guchie added a comment -

          I am re-opening this issue coz am interested in it 

          francisguchie Francis Guchie added a comment - I am re-opening this issue coz am interested in it 

          People

            francisguchie Francis Guchie
            emmanuelnnaa@musoni.eu Emmanuel Nnaa
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated: