Overview
Many-to-Many Matching in Bank Rec Online allows multiple transactions from your accounting records to match against multiple transactions from your bank statement during the reconciliation process.
This feature is particularly useful when deposits, payments, batches, or grouped transactions appear differently between your accounting system and your bank account.
Instead of manually reconciling these transactions one at a time, Many-to-Many Matching helps you quickly identify and reconcile related transactions as a group.
Common Many-to-Many Matching Scenarios
Many-to-Many Matching is frequently used when:
- Multiple customer payments are combined into a single bank deposit
- A payment processor batches several transactions together
- Multiple accounting entries correspond to multiple bank transactions
- Deposit activity is split or grouped differently by the bank
- ACH collections or payment batches contain multiple underlying transactions
Example
Your accounting records contain:
| Date | Description | Amount |
|---|---|---|
| 11/01/26 | Customer Payment A | $500 |
| 11/01/26 | Customer Payment B | $300 |
| 11/01/26 | Customer Payment C | $200 |
Total: $1,000
Your bank statement contains:
| Date | Description | Amount |
|---|---|---|
| 11/01/26 | Deposit Batch 1 | $700 |
| 11/01/26 | Deposit Batch 2 | $300 |
Total: $1,000
Although the transactions do not match on a one-to-one basis, Bank Rec Online can recognize that the combined totals balance and allow them to be reconciled together.
Benefits of Many-to-Many Matching
Using Many-to-Many Matching can help organizations:
Reduce Manual Reconciliation Work
Match groups of transactions in seconds instead of reviewing each item individually.
Improve Reconciliation Accuracy
Identify offsetting groups of transactions and reduce the risk of missed matches.
Handle Complex Banking Activity
Easily reconcile merchant processor deposits, ACH batches, lockbox transactions, and other grouped activity.
Speed Up Month-End Close
Reduce the time required to complete account reconciliations and investigate variances.
How Many-to-Many Matching Works
Bank Rec Online analyzes both your bank transactions and accounting records to identify potential groups of transactions whose totals match.
The system evaluates:
- Transaction amounts
- Transaction dates
- Matching tolerances
- Available unreconciled transactions
When matching groups are found, Bank Rec Online presents them as reconciliation candidates for review and approval.
Best Practices
For optimal matching results:
- Import complete bank statement data before reconciling.
- Ensure accounting transactions are accurate and up to date.
- Review unmatched transactions regularly.
- Use consistent transaction descriptions whenever possible.
- Establish reconciliation procedures for recurring batch activity.
Related Matching Methods
Bank Rec Online supports several reconciliation methods to accommodate different transaction scenarios:
- One-to-One Matching
- One-to-Many Matching
- Many-to-One Matching
- Many-to-Many Matching
Together, these matching capabilities help automate the reconciliation process while maintaining visibility and control over transaction matching decisions.
Frequently Asked Questions
1. What is Many-to-Many Matching?
Many-to-Many Matching allows multiple accounting transactions to be matched against multiple bank transactions when the combined amounts reconcile correctly.
2. When should I use Many-to-Many Matching?
This method is commonly used for merchant service deposits, ACH batches, grouped payments, lockbox transactions, and other situations where transactions are aggregated differently between systems.
3. Does Bank Rec Online automatically reconcile transactions?
Bank Rec Online identifies potential matches and presents them for review, helping streamline the reconciliation process while allowing users to maintain oversight.
Need Help?
Still have questions? Contact Treasury Software Support or visit www.treasurysoftware.com for personalized assistance.
