Match bank transaction

  • Last Created On Jul 07, 2023
  • 475
0 0

The Match Mapping feature in Banking Feeds allows users to reconcile bank transactions with accounting records inside the system.

The system supports: 

  • Individual transaction matching
  • Ignoring transactions
  • Bulk matching

Before using the Match Mapping feature in Banking Feeds, users must first:

  • Import or download bank transactions

  • Create the related accounting records such as journal entries, transfers, or map payments, expenses, credit notes, etc. to this bank account.

Individual Transaction Matching

Go to Banking -> select Banking Feeds --> First you have to choose a bank account, data will be obtained based on that bank account. All transactions retrieved from the bank or imported via file will be displayed in Banking Feeds.



To match the transaction, select a transaction to clear and click on the gear. 

If you select Add Transaction

If you select Match to Existing Transaction

After successful match, the transaction is marked as cleared.
In case the transaction has been cleared, you can cancel the clear by selecting the gear and selecting Uncleared


In case the transaction has been ignored, you can clear it to continue matching the transaction by selecting Uncleared


Review your bank reconcile 

Go to the Reports menu and select Reconciliation Summary and Bnk Reconciliation Detail


Bulk Actions in Banking Feeds

The Bulk Actions feature allows users to process multiple banking feed transactions at the same time.

Available actions:

  • Match Transaction
  • Ignore
  • Delete

Match Transaction

The system automatically attempts to match selected banking feed transactions with existing accounting records. This helps automate bank reconciliation and reduce manual matching work.

Matching Criteria

The system searches for matching records using:

  • Same configured bank account
  • Exact amount match
    • Debit = Deposit
    • Credit = Withdrawal
  • Exact recording date match

Automatic Matching Behavior

If the system finds a single best-fit record:  

  • The transaction is automatically matched
  • The transaction status becomes Cleared

How to Use

Step 1: Choose one or multiple transactions select Bulk actions 


Step 2: Select “Match Transaction” click Confirm


  • After the matching process completes, the system displays a notification showing how many transactions were successfully matched.


  • Successfully matched transactions become Cleared


  • Transactions that cannot be matched automatically will remain Uncleared

Example: 

A banking feed transaction contains:

  • Date: 09/05/2026
  • Debit: 5.4

The system already contains an accounting transaction ( ex Journal entry)

  • Linked to the same bank account
  • Date: 09/05/2026
  • Debit: 5.4


When users run: Bulk Actions → Match Transaction, the system will automatically match the two transactions.


Ignore

The Ignore action marks selected transactions as ignored.

Ignored transactions:

  • Are excluded from reconciliation
  • Will not participate in transaction matching

How to Use

Step 1: Choose one or multiple transactions select Bulk actions 


Step 2.  Select “Ignore” click Confirm


Result: The selected transactions become Ignored




Delete

The Delete action permanently removes selected banking feed transactions from the system.

How to Use

Step 1: Choose one or multiple transactions select Bulk actions 


Step 2.  Select “Delete” click Confirm


Result: Selected transactions are permanently removed from the system.

Views: 475

Recent Articles

  • Bulk Edit Banking Transactions
    7
  • Class Tracking for Transactions
    9
  • Debit Note Mapping
    39
  • Credit Note Mapping
    35
  • Polls vs Surveys
    35

Popular Articles

  • Warehouse
    2432
  • Item Settings
    1963
  • Plaid environment & Setup Your Bank Acco...
    1756
  • General Accounting Settings
    1665
  • Mapping Setup
    1521