Automatically Categorize Transactions During Bank Reconciliation

Category Matching in Bank Rec Online helps streamline your reconciliation process by automatically assigning transactions to predefined categories. Instead of manually reviewing and categorizing recurring bank activity, users can create category rules that automatically organize transactions during reconciliation.

This feature is especially helpful for organizations that regularly process recurring transactions such as bank fees, payroll activity, subscription payments, merchant deposits, utility payments, and interest income.

By automating transaction categorization, finance teams can reduce manual effort, improve consistency, and complete reconciliations more efficiently.

What Is Category Matching?

Category Matching allows Bank Rec Online to automatically assign transactions to categories based on criteria you define.

When a transaction meets the conditions of a matching rule, the system applies the designated category automatically. This helps standardize transaction classification and reduces the need for repetitive manual review.

Category Matching can help organizations:

• Reduce manual transaction coding
• Improve reconciliation efficiency
• Maintain consistent categorization practices
• Minimize data entry errors
• Improve financial reporting accuracy
• Speed up month-end reconciliation processes

Common Uses for Category Matching

Many organizations use Category Matching to automatically identify and classify recurring transactions.

By automatically categorizing these transactions, users spend less time reviewing routine activity and more time focusing on exceptions and reconciliation issues.

How Category Matching Works

Bank Rec Online evaluates transaction details against the matching rules you have configured.

Rules can be based on information such as:

• Transaction description
• Reference or memo information
• Transaction amount
• Transaction type
• Imported transaction details

When a transaction matches the specified criteria, Bank Rec Online automatically assigns the associated category.

This process helps create a more efficient and consistent reconciliation workflow.

How to Create a Category Matching Rule

Step 1: Access Category Matching Settings

Open the Category Matching section within Bank Rec Online.

Step 2: Create a New Category

Add a category that will be used to classify matching transactions.

Examples may include:

• Bank Fees
• Payroll
• Utilities
• Merchant Deposits
• Interest Income

Step 3: Define Matching Criteria

Specify the conditions that should trigger the category assignment.

Examples include:

• Transaction description contains "MONTHLY FEE"
• Transaction description contains "PAYROLL"
• Description contains a vendor name
• Transaction amount equals a specific value

Step 4: Assign the Category

Select the category that should be applied whenever a transaction meets the rule criteria.

Step 5: Save Your Rule

Save the configuration and begin applying the rule during future reconciliations.

Benefits of Category Matching

Faster Reconciliation Processing

Automatically assigning categories reduces the amount of manual transaction review required during reconciliation.

Improved Consistency

Transactions are categorized according to predefined rules, ensuring consistent treatment across users and reporting periods.

Greater Accuracy

Automation helps eliminate common manual coding errors and improves data quality.

Better Reporting

Consistent categorization supports cleaner financial reporting and more meaningful trend analysis.

Scalable Reconciliation Management

As transaction volumes grow, Category Matching helps organizations maintain efficiency without significantly increasing workload.

Notes on Category Maintenance

Proper category maintenance helps ensure accurate matching results and long-term reconciliation consistency.

Do Not Delete Categories with Unmatched Records

Avoid deleting categories that have unmatched transactions assigned to them.

Deleting a category that is still associated with active reconciliation records can make those transactions more difficult to manage and review. Before removing a category, verify that it is no longer being used.

Use Unique Category Names

When creating categories, always use unique names.

Unique category names help:

• Reduce confusion
• Simplify reporting
• Improve rule management
• Make transaction review easier

Using duplicate category names can create unnecessary complexity during reconciliation.

Unused Categories Are Acceptable

It is perfectly acceptable to maintain categories that are not currently in use.

Many organizations create categories in advance for:

• Future vendors
• New transaction types
• Seasonal activity
• Department growth

Unused categories do not negatively impact reconciliation performance.

Renaming Categories Is Supported

If a category name needs to be updated, it is safe to rename the category.

Common reasons to rename a category include:

• Standardizing naming conventions
• Improving clarity for users
• Reflecting accounting process changes
• Aligning with reporting requirements

Renaming a category allows you to improve organization without recreating matching rules or historical transaction assignments.

Best Practice

If a category is no longer needed, consider renaming or repurposing it before deleting it. This approach helps preserve continuity and reduces the risk of impacting existing reconciliation records.

Best Practices for Category Matching

To get the most value from Category Matching:

• Use specific and consistent category names.
• Review matching rules periodically for accuracy.
• Test new rules against recent transaction activity.
• Avoid creating duplicate categories.
• Monitor transactions that do not match existing rules.
• Update category names when business processes change.

Regular maintenance helps ensure that your automated matching remains accurate and effective over time.

Related Reconciliation Features

Category Matching works alongside other Bank Rec Online automation tools, including:

• One-to-One Matching
• One-to-Many Matching
• Many-to-Many Matching
• Automated Reconciliation Rules
• Transaction Import Processing
• Exception Management

Together, these tools can significantly reduce manual effort while improving reconciliation speed and accuracy.