Criteria for Auto-Match in Bank Reconciliation Manager

Description of Issue

What criteria has to be met for a bank transaction to auto-match with a Munis transaction in Bank Reconciliation Manager?

Context
  • Cash Management
  • Bank Reconciliation Manager
  • BAI Import
Cause


Resolution

In general:

  • One or both of these options must be flagged in the BAI Import program : Match checks during import or Match deposits on import
  • The amount for the transactions must be equal.
  • The Customer Reference must equal the Munis Reference if the Munis transaction is an AP Check, PR Check, or Deposit.
  • The Bank Reference must equal the Munis Reference if the Munis transaction is a Journal.

Specific to Check transactions:

Auto-match should process if the following transaction details match:

  • Check #
    • Bank side = Customer Reference #
    • Munis side = Munis Reference #

  • Amount
  • Check Type
  • Cash Org/Obj/Proj 
  • Bank Item checks must be on BAI codes 474 or 475. 
Additional Information