Bank imports and transfers

58

On rereading this thread I believe I’m envisioning a slightly different function to what @Ealfardan had described. To explain.

The Bank import system

  • Retains all bank import records unchanged by Manager or the user. Probably accessed via a bank import tab where new bank imports can be created and the user can drill down on existing / old bank imports.

  • Progressively match of bank import transactions to Manger transaction occurs from most specific match to least specific match. The matching is done dynamically when the bank import is viewed (no static links between bank import transactions and Manager transactions are created).

  • By default only significant differences between Manager and the bank import are shown. As a result the screen mapping bank transactions to Manager transactions would look almost the same as the existing screen (where bank rules are applied).

  • When Manager imports a bank statement, Manager does not automatically create transaction in the suspense account. Transactions in Manager are only created when a bank rule batch update is done or a a bank entry is “edited” (editing a bank transaction would clone it’s contents to a Manager transaction so the user is actually creating a Manager transaction not editing a bank import).

By progressive transaction matching, I mean dynamically link in an order something like

  1. Same amount, same cleared date and same description
  2. Same amount, same cleared date and Bank rule account on bank import = Existing Manager transactions COA account.
  3. Same amount, same cleared date and similar description
  4. Same amount, same cleared date

The matching then repeats the above matching sequence but compares bank statement cleared date near Manager transaction. As a result importing the a bank statement should enable batch update of bank clearance date.

The functionality the change offers is

  • Allows users to use bank import, Manual transactions entry or an optimal mixture of both
  • Allows asynchronous entry of linked “bank” imports. Such as bank transfers, credit cards, epfpos, POS systems
  • Automates auditing of bank records
  • Assists user in bank account reconciliation, as transaction differences as shown and full context / bank import can optionally be shown.
  • The cumulative total shown in the existing “Bank Reconciliations” tab should be retained for those who don’t use bank imports and to ensure bank imports cover all time (none are missing).