automated bank reconciliation for customer receipts by matching customer name
Hi
We are planning to implement Automatic Bank Reconciliation and require guidance on configuring the appropriate matching rules.
The bank statement contains the following fields that can be used for reconciliation:
- Customer Name
- Transaction Date
- Transaction Amount
The corresponding system (Accounts Receivable) transactions also include:
- Customer Name
- Transaction Date
- Transaction Amount
Business Issue
The system transaction number and the bank statement transaction reference cannot be used for matching purposes. Instead, the requirement is to match transactions based on the Customer Name, supported by Transaction Date and Transaction Amount.
Request for Guidance
Please advise on how to configure a matching rule that uses
Tagged:
0