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