How to Exclude Transactions in Bank Reconciliation Manager

Description of Issue

How can I exclude or disregard bank items in Bank Reconciliation Manager that should not be reconciled?

Context
  • Bank Reconciliation Manager
  • Match screen
  • BRM
Cause

Transactions are in Bank Reconciliation Manager that should not be

Resolution

User must be granted the permission Allow excluding bank reconciliation transactions

System Administration > Security > User Attributes

  1. Search user.
  2. Select relevant role.
  3. Click Edit Role underneath the roles (may affect multiple users).
  4. Select General Ledger folder.
  5. Click Update.
  6. Select 'Allow excluding bank reconciliation transactions.'  Accept.
  7. Reset Files

To exclude transactions in Bank Reconciliation Manager:

Cash Management > Bank Reconciliation > Bank Reconciliation Manager

  1. Select Match from the ribbon.
  2. Select a bank account from the Bank Account field.
  3. Select transactions to exclude by clicking bank item boxes
  4. Click Matching and select Exclude
Additional Information

To exclude all cleared transactions from Bank Reconciliation Manager as of a specified date, contact General Ledger Support for assistance. Support can update Bank Reconciliation Settings > Exclude cleared items as of field.