# Bank Reconciliation Tool

# Advanced Bank Reconciliation Tool


:::info
Looking for a step-by-step walkthrough? See the [Bank Reconciliation Tool user guide](/doc/df082da9-8898-4ffe-9a0c-56a0d7a36137).

:::

The Advanced Bank Reconciliation Tool provides enhanced capabilities for matching bank transactions with accounting entries in NexWave. It offers both automatic and manual reconciliation options with support for multiple document types.

## Overview

This addon extends the standard bank reconciliation functionality with:

* **Intelligent matching** across multiple document types
* **Auto-reconciliation** for bulk processing
* **Manual reconciliation** with flexible voucher selection
* **Journal Entry and Payment Entry creation** directly from bank transactions, with full support for cost centres, projects, and accounting dimensions
* **Configurable defaults** for reconciliation action, document type, and journal entry type
* **Bank Rules** for automating recurring transaction patterns
* **Multi-currency support** for international transactions

 ![](https://docs.nexwaveapp.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2YxMTg5ZTEzLTdlMTQtNDA1ZC04MDI1LWMxZmI0Y2Y2MTg0ZC8wM2E4OTYyMC1kMGI2LTQxMTAtOTNmNS02ZjE3MmMyYTM4NWUvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTI2MjA5MDAsImV4cCI6MTc5MjcwNzMwMH0.mgj1By66RbGUKUUv5pDhfrGOtNcUhoer6KGtwOSvXkY " =2269x1288")

## Prerequisites

Before using this tool:

* Bank accounts must be set up in NexWave
* Bank statement transactions should be imported (via Bank Feeds or Import Bank Statement)
* GL accounts should be properly configured for journal entries
* If using accounting dimensions (e.g., Location, Department), ensure they are configured in **Accounting Dimension** setup with the correct mandatory rules per company

## Accessing the Tool

Navigate to **Accounting > Bank Reconciliation Tool**.

## Configuration

### Default Actions

Before starting reconciliation, you can configure default behaviour in **Settings > Advanced Bank Reconciliation Settings**.

| Setting | Description | Default |
|---------|-------------|---------|
| Default Reconciliation Action | Which action is pre-selected when opening the Actions dialog (Match Against Voucher or Create Voucher) | Match Against Voucher |
| Default Document Type | Which document type is pre-selected when creating vouchers (Payment Entry or Journal Entry) | Payment Entry |
| Default Journal Entry Type | Which JE type is pre-selected when creating Journal Entries (Bank Entry, Cash Entry, etc.) | Bank Entry |
| Validate selection against unallocated amount | Ensures selected invoices total matches the bank transaction amount | Off     |
| Reconcile unpaid invoices in background | Processes unpaid invoice reconciliation as a background job | On      |

 ![](https://docs.nexwaveapp.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2YxMTg5ZTEzLTdlMTQtNDA1ZC04MDI1LWMxZmI0Y2Y2MTg0ZC8xZmY5MWY4OS1jMDNhLTQ2N2UtODJlNi0xNzA1NWRlOGI3ZDYvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTI2MjA5MDAsImV4cCI6MTc5MjcwNzMwMH0.2pXzFE81KdcVCEBlAonBHkay_pa-ZWt7m_vr_Jkj7b0 " =2269x687")

These defaults are particularly useful for organisations where most transactions are handled the same way. For example, donation-based organisations can set the default to "Create Voucher" with "Journal Entry" to skip the voucher matching step entirely.

## Step-by-Step Guide

### 1. Select Bank Account and Date Range


1. Select your **Company**
2. Choose the **Bank Account** to reconcile
3. Set the **From Date** and **To Date** for the statement period
4. Optionally, check **Filter by Reference Date** to filter by the reference date on transactions instead of the transaction date

 ![](https://docs.nexwaveapp.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2YxMTg5ZTEzLTdlMTQtNDA1ZC04MDI1LWMxZmI0Y2Y2MTg0ZC8wOWUzYmJiOS1lOWI3LTRiNzctODUyNi0xMDc0ZDkwMGUxNTMvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTI2MjA5MDAsImV4cCI6MTc5MjcwNzMwMH0.1d0H-Ima0ok6DewfG423oG6JSIQISFQ5LME7TcMoFYY " =1421x241")

### 2. View Unreconciled Transactions

Once filters are set, click **Get Unreconciled Entries**. The tool displays all unreconciled bank transactions showing:

* Date and Bank Transaction reference
* Description
* Reference Number, Particulars, Code, and Bank Party (from the bank statement)
* Deposit/Withdrawal amount
* Current unallocated amount

 ![](https://docs.nexwaveapp.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2YxMTg5ZTEzLTdlMTQtNDA1ZC04MDI1LWMxZmI0Y2Y2MTg0ZC83M2U3MjI0ZS1kOGJiLTQ4NzgtYjVmOS00Njc1ZWM0Nzc3OGMvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTI2MjA5MDAsImV4cCI6MTc5MjcwNzMwMH0.IkBfMfvFbT8rlcxNJ34JBMqD-KNSyKL_vhPah0VhXeg " =1528x459")

### 3. Reconcile a Transaction

Click the **Actions** button on any unmatched transaction to open the reconciliation dialog. The dialog shows:

* **Transaction Details** at the bottom: Date, Deposit/Withdrawal, Bank Party, Reference Number, Description, Particulars, Code, and the current Allocated/Unallocated amounts
* Three available actions: **Match Against Voucher**, **Create Voucher**, or **Update Bank Transaction**

The default action is determined by your ABR Settings configuration.

#### Match Against Voucher

Select document types to search for matching vouchers:

| Document Type | Description |
|---------------|-------------|
| Payment Entry | Customer receipts and supplier payments |
| Journal Entry | General journal entries with bank account |
| Sales Invoice | Paid sales invoices |
| Purchase Invoice | Paid purchase invoices |
| Unpaid Sales Invoice | Outstanding customer invoices |
| Unpaid Purchase Invoice | Outstanding supplier invoices |
| Bank Transaction | Opposite transactions in same bank account |
| Loan Disbursement | Loan payout transactions |
| Loan Repayment | Loan repayment receipts |

Use additional filters (Customer Group, date range, inline column filters) to narrow results. Select one or more vouchers, then click **Reconcile** to confirm the match.

The tool ranks matches based on reference number, amount, and party information.

 ![](https://docs.nexwaveapp.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2YxMTg5ZTEzLTdlMTQtNDA1ZC04MDI1LWMxZmI0Y2Y2MTg0ZC80NzNhOWUxYi0wN2RiLTQxNGItYWNlNy0zMWRjNDMyOTE4ZjkvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTI2MjA5MDAsImV4cCI6MTc5MjcwNzMwMH0.i2xl3cCuS1NVRzZqkIbib_Fcb6MojEbVJ-ssrM2XQsE " =1166x1342")

#### Create Voucher

If no matching voucher exists, create one directly from the dialog:

**Journal Entry:**


1. Select **Create Voucher** and choose **Journal Entry**
2. Select the Journal Entry Type (e.g., Bank Entry)
3. Choose the second account (income, expense, etc.)
4. Optionally set Party Type and Party (for non-receivable/payable accounts, the party is stored as a reference on the journal entry line)
5. Set Cost Centre, Project, and any accounting dimensions (e.g., Location)
6. Click the primary action to create and reconcile, or use **Edit in Full Page** to open the full form

**Payment Entry:**


1. Select **Create Voucher** and choose **Payment Entry**
2. Set Party Type (mandatory) and Party
3. Set Cost Centre, Project, and any accounting dimensions
4. Click the primary action to create and reconcile, or use **Edit in Full Page** to open the full form

All configured accounting dimensions appear automatically in the dialog based on your system's Accounting Dimension setup. Cost Centre and Project are available for both Journal Entries and Payment Entries.

 ![](https://docs.nexwaveapp.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2YxMTg5ZTEzLTdlMTQtNDA1ZC04MDI1LWMxZmI0Y2Y2MTg0ZC9mMjVmNTEzNS1jNDEyLTRlYTUtOTM5MS01ODBmNWY3MWUzODIvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTI2MjA5MDAsImV4cCI6MTc5MjcwNzMwMH0.v1_rDrB8ekq8AAZXEcCMvu2rmBqP5dWWpPa8P2D9HzI " =1166x1332")

#### Update Bank Transaction

Use this option to update the reference number or party information on the bank transaction itself without creating or matching any voucher.

### 4. Bulk Reconciliation

The tool provides two bulk reconciliation options under the **Reconcile** button group:

**Run Bank Rules:** Applies configured bank rules to automatically create and reconcile vouchers for transactions that match rule conditions. Rules are processed in priority order. This is ideal for recurring transactions with predictable patterns (e.g., regular expenses, known vendors).

See [Bank Rules](/doc/44484d56-d71d-483d-8c44-0b3a84027bbe) for setup instructions.

**Auto Reconcile:** Automatically matches unreconciled bank transactions against existing Payment Entries and Journal Entries based on reference numbers, amounts, and party information. This is useful when payments have already been entered manually and just need linking to bank transactions.

**Recommended workflow:** Run Bank Rules first (to create entries for known patterns), then Auto Reconcile (to link any manually-created entries).

### 5. View Reconciled Transactions

The bottom section shows all reconciled transactions with:

* Date and Bank Transaction reference
* Party (derived from the linked voucher, including party references stored on Journal Entry lines)
* Particulars, Code, and Reference from the bank statement
* Deposit/Withdrawal amounts
* Payment Document type and link
* Allocated amount
* **Unreconcile** button to reverse the match

 ![](https://docs.nexwaveapp.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2YxMTg5ZTEzLTdlMTQtNDA1ZC04MDI1LWMxZmI0Y2Y2MTg0ZC81ZDdhZGZjOS01N2M0LTRlODItOTdjMi00NWVlMTAyNTVkZjcvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTI2MjA5MDAsImV4cCI6MTc5MjcwNzMwMH0.bUwO3OVy_gy4LbkTvbtBwgDK6Xjk1Q8Azz9jVZegIvc " =1539x665")

To unreconcile a transaction, click **Unreconcile**. You can choose to:

* **Unreconcile Only** - removes the link but keeps the Payment Entry/Journal Entry
* **Unreconcile and Cancel PE/JE** - also cancels the linked documents

## Tips for Efficient Reconciliation


1. **Configure defaults** in ABR Settings to match your most common workflow
2. **Set up Bank Rules** for recurring transactions to automate the majority of reconciliation
3. **Import statements regularly** to keep transactions current
4. **Use reference numbers** consistently for automatic matching
5. **Run Bank Rules first**, then Auto Reconcile, then handle exceptions manually
6. **Filter by reference date** when matching against document dates rather than bank statement dates

## Troubleshooting

### No matching vouchers found

* Verify the date range includes the voucher posting date
* Check if the voucher has already been fully allocated
* Ensure party information matches between transaction and voucher

### Transaction shows as partially reconciled

* The bank transaction amount may be split across multiple vouchers
* Check if the full amount has been allocated

### Auto-reconcile not matching expected items

* Verify reference numbers match exactly
* Check currency matches between transaction and voucher
* Ensure vouchers are in submitted (docstatus=1) state

### Accounting dimension errors when creating vouchers

* Ensure the dimension is configured as mandatory for the correct company in the Accounting Dimension setup
* NexWave validates dimensions during voucher submission, so missing mandatory dimensions will be flagged

## Related Documentation

* [Import Bank Statement](/doc/950b3e14-e00e-4530-a248-e6ef61dbb420) - For manually importing bank statements
* [Bank Feeds](/doc/af08c753-d3cb-489e-8202-9ea786645b85) - For automatic bank transaction synchronisation
* [Bank Rules](/doc/44484d56-d71d-483d-8c44-0b3a84027bbe) - For automating recurring transaction reconciliation
* [Accounting](/doc/85b00666-859d-4e2b-9bac-6c1dd3848464) - Payment Entries and Journal Entries

---

**Documents**

- [Bank Rules](https://docs.nexwaveapp.com/s/docs/doc/bank-rules-vct3bLUEwn)