Overview
Treasury Software's Bank Rec Online includes powerful automated matching tools that help reconcile bank transactions against your General Ledger quickly and accurately.
Most users achieve excellent results by first running the system's predefined matching rules and then refining the process with optional Categories and User Defined Matching Rules as needed.
This guide explains:
- How Automated Matching works
- How to run your first matching session
- Predefined One-to-One Matching Rules
- Many-to-Many Matching Rules
- Categories and User Defined Rules
- Best Practices and FAQs
Table of Contents
- Automated Matching Overview
- Running Your First Match
- Predefined One-to-One Matching Rules
- User Defined Matching Rules
- Categories
- Frequently Asked Questions (FAQs)
Automated Matching Overview
After importing your bank transactions and General Ledger records, Bank Rec Online automatically analyzes both sets of data and attempts to create matches based on predefined matching logic.
Recommended Approach
For new reconciliations, Treasury Software recommends:
- Import Bank Records
- Import G/L Records
- Run Automated System Matching
- Review matched transactions
- Review unmatched transactions
- Add Categories or User Define Rules if needed
This approach provides the fastest path to a highly accurate reconciliation.
Running Your First Match
How Do I Run Automated Matching?
After importing records:
- Open the Matching Window
- If new records were imported, Bank Rec Online automatically starts the matching process
- Allow the process to complete before navigating away from Bank Rec
Important
Do not switch to another screen while Automated Matching is processing.
Once complete, you'll see:
- Unmatched Bank Records on the left
- Unmatched G/L Records on the right
From this screen, you can also manually match transactions when necessary.
For additional details, see the Matching Window Help Guide.
Predefined One-to-One Matching Rules
One-to-One Matching compares a single bank transaction against a single G/L transaction.
Bank Rec Online includes several built-in matching rules.
Available One-to-One Rules
Check to Check - matches transactions based on check numbers
Void to Issue - matches voided transactions to original issued transactions
Alphanumeric Matching - matches records using reference text and identifiers
How Rules Run
- Rules are processed from top to bottom
- You can enable or disable individual rules
- User Defined Rules are initially disabled until configured
For additional details, see One-to-One Matching Help Guide
Many-to-Many Matching Rules
Many-to-Many Matching is designed for situations where multiple transactions on one side correspond to one or more transactions on the other side.
Common examples include:
-
Deposits grouped by the bank
- Batch transactions
- Summarized accounting entries
- Merchant service deposits
How Many-to-Many Matching Works
The system follows a two-step process:
Step 1
Transactions are grouped and summarized according to the selected matching rule.
Step 2
The summarized groups are compared and matched automatically.
Available Many-to-Many Rules
Alphanumeric Matching (Text 1) - groups transactions using common reference values
Date and Category - groups transactions based on transaction date and assigned category
Check Number - groups transactions sharing related check information
Processing Order
Many-to-many rules run after One-to-One Matching has completed.
For additional details, see the Many-to-Many Matching Help Guide.
User Defined Matching Rules
User Defined Matching Rules are available in Corporate and Advanced editions of Bank Rec Online. These rules allow organizations to customize reconciliation logic for unique transaction types and workflows.
Recommendation
Start with predefined matching rules first.
After review unmatched transactions, determine whether custom rules would improve automation and reconciliation accuracy.
Categories
Categories help improve matching accuracy by assigning additional transaction attributes to both Bank and G/L records.
Why Categories Matter
Consider two transactions for the same amount:
| Transaction | Amount |
| Credit Card Deposit | $220 |
| Check Deposit | $220 |
Without Categories, the system could potentially match the wrong transactions.
With Categories assigned:
- Credit Card transactions match Credit Card transactions
- Check deposits match Check deposits
This helps reduce false matches and improve reconciliation accuracy.
Example
A bank description may contain:
Credit Card Des
While the General Ledger description may contain:
MC/V
A Category Rule can identify both descriptions as the same transactions type and allow the system to match them automatically.
Creating Categories
Categories are created using simple point-and-click rule building.
No programming or scripting is required.
For additional details, see Categories Help Guide
Tips & Best Practices
Re-Running Automated Matching
Normally, you do not need to manually rerun matching.
Bank Rec Online automatically triggers matching when:
- New records are imported
- You enter the Matching Window for the first time after import
You may want to manually rerun matching after:
- Updating records
- Creating new Category Rules
- Modifying User Defined Matching Rules
Unmatching Transactions
If a transactions was matched incorrectly:
- Open an All Records report
- Select the matched transactions
- Click the 'Unmatch' button
- Re-run Automated Matching if desired
Frequently Asked Questions (FAQs)
1. Do I need to configure matching rules before my first reconciliation?
No. Most customers can begin with the predefined matching rules and achieve strong matching results immediately.
2. When should I use Categories?
Categories are helpful when transactions share similar amounts but represent different transactions types.
3. Are User-Defined Rules required?
No. User-Defined Matching Rules are optional and are most beneficial for advanced reconciliation scenarios.
4. Can I manually match transactions?
Yes. The Matching Window allows users to manually select and match bank and G/L records.
5. Can I reverse a match?
Yes. Use the 'Unmatch' function to remove an existing match and rerun the matching process if needed.
Need Help?
Still have questions? Contact Treasury Software Support or visit www.treasurysoftware.com for personalized assistance.
