Skip to main content

Assisted Bank Reconciliation Implementation

September 4, 2024 The purpose of this document is to lay out the steps necessary for configuring and using the Assisted Bank Reconciliation process.

  • Interfaces
    • An interface is a definition of how imported files will be used, i.e., column layout, translations, etc.
    • A single interface can be used for multiple bank accounts, but any layout is likely to only apply likely to a single bank. For example, the interface for EastWest Bank can be used for ALL EastWest Bank accounts, assuming that the same export format for EastWest Bank has been used on all accounts being reported.
    • Interfaces can be difficult to set up and manage and should, most likely, be left to MD or IT support.
    • Interfaces are created/reviewed in MD Accounting
      • General Ledger, General Ledger
      • Select a bank account.
      • Click on Reconciliation button (lower right corner of screen)
      • Click on Account Reciliation button (upper, center of screen)
      • Click on Import button

Image

  • A new interface and any existing interface can be managed here, i.e., interface “maintenance” is not tied to the bank account originally selected.
  • Key maintenance to be done here is on the Mapping tab of any field that has been defined.

Image

  • A mapping can also be used to override change a value.

Image

Image

  • The data in the file does not contain the actual branch, only the merchant ID. However, the mapping of known merchant IDs to branches can be down in the interface.
  • Recurring maintenance issue:
    • New branches and/or change in merchant numbers need to be updated in interfaces the need to “map” to a branch.
    • Defined interface mappings are in the table BANKINTERFACEMAPPING. See Informer Live Excel link:*** ***O:\ACCTGRP\InformerLinks\Multidev\Multidev - Assisted Bank Rec Interface Mapping.iqy
  • Generator
    • Generator entries are another form of mapping.
    • Generator entries are created/reviewed in MD Accounting
      • General Ledger, General Ledger
      • Select a bank account.
      • Click on Reconciliation button (lower right corner of screen)
      • Click on Account Reciliation button (upper, center of screen)
      • Click on Generator
    • Generator entries are unique at the Interface level AND at the deposits vs checks level, i.e., a generator defined for a deposit/credit cannot be used for processing of a check/debit in the input file (and vice versa).
    • However, a deposit/credit or check/debit generator can be qualified to apply to:
      • This format –generator will apply to any process using this interface (format).
      • This company – restricting the generator entry at the company level (allow for different treatments of the same data in different companies). We only have one company set-up at this time, SHER.
      • This bank – restricting the generator entry at the bank account level (allow for different treatments of the same data (same format) when applied to different bank accounts).
    • In practice all generators should be at the “This Format” level.
    • Defined generator records are in the table BANKGENTRANS. See Informer Live Excel link:*** ***O:\ACCTGRP\InformerLinks\Multidev\Multidev - Assisted Bank Rec Generator Records.iqy
    • The results of a generator records BEFORE they are reconciled can be see in this Informer Live Excel link: O:\ACCTGRP\InformerLinks\Multidev\Multidev - Assisted Bank Rec Generator Results.iqy