Bank Reconciliation in ERPNext

Bank Reconciliation in ERPNext helps businesses match transactions recorded in ERPNext with transactions appearing in bank statements. This process ensures that bank balances in the accounting system accurately reflect actual balances maintained by the bank.

Differences often occur because of cheque clearance delays, bank processing times, pending deposits, or transactions that have not yet been recorded.

Regular bank reconciliation improves financial accuracy, prevents discrepancies, and helps identify missing or duplicate transactions.

To access Bank Reconciliation:

Home > Accounting > Banking and Payments > Update Bank Transaction Date

1. What is a Bank Reconciliation Statement?

A Bank Reconciliation Statement compares:

• Bank balance shown in ERPNext
• Bank balance shown in the official bank statement

The report highlights differences caused by uncleared payments, deposits in transit, or missing clearance dates.

When the Balance as per Bank matches the bank statement balance, it indicates that all reconciliation entries have been correctly updated.

Any mismatch usually indicates transactions whose clearance dates have not yet been updated.

2. How to Update Bank Transaction Dates

Follow these steps to manually update clearance dates:

1. Open Bank Clearance.
2. Select the required Bank Account.
3. Choose the date range.
4. Optionally include reconciled entries and POS transactions.
5. Click Get Payment Entries.
6. Review the listed Bank Voucher transactions.
7. Update the Clearance Date for each entry.
8. Click Update Clearance Date.

This process synchronizes ERPNext records with the actual bank statement.

Updating clearance dates is the foundation of successful bank reconciliation.

3. Types of Bank Reconciliation Tools

ERPNext provides two reconciliation methods:

• Manual Bank Reconciliation Tool
• Semi-Automatic Bank Reconciliation Tool

4. Manual Bank Reconciliation Tool

To access the report:

Accounts > Banking and Payments > Bank Reconciliation Statement

The report helps users compare bank balances and identify transactions that are still awaiting reconciliation.

Key benefits include:

• Manual review of bank transactions
• Verification of clearance dates
• Identification of unreconciled entries
• Accurate bank balance reporting

5. Semi-Automatic Bank Reconciliation Tool

The semi-automatic process consists of two steps:

1. Import bank transactions into ERPNext
2. Reconcile imported transactions against ERPNext vouchers

5.1 Bank Statement Import

Bank statements can be imported directly into ERPNext.

To access:

Accounting > Bank Statement > Bank Statement Import

Steps:

1. Download the bank statement from your bank portal.
2. Create a new Bank Statement Import.
3. Select Company and Bank Account.
4. Upload the statement file.
5. Map bank statement columns to ERPNext fields.
6. Start the import process.

Imported transactions are automatically created as Bank Transactions in ERPNext.

Column mappings are saved for future imports, reducing manual effort.

5.2 Bank Account Synchronization

ERPNext supports automatic bank synchronization using supported banking integrations.

Once connected, bank transactions are automatically imported into ERPNext without manual uploads.

5.3 Automatic Party Matching

ERPNext can automatically identify Customers, Suppliers, or Employees related to imported bank transactions.

Enable this feature from:

Accounts Settings > Banking > Enable Automatic Party Matching

Additional options include:

• Automatic party identification using registered bank accounts
• Fuzzy matching based on party names and descriptions
• Automatic population of Party and Party Type fields

Fuzzy matching helps identify parties even when exact bank account information is unavailable.

5.4 Reconcile Imported Transactions

To access:

Accounting > Bank Statement > Bank Reconciliation Tool

Steps:

1. Select Company and Bank Account.
2. Enter Bank Statement Start and End Dates.
3. Verify opening balance.
4. Enter the closing balance from the bank statement.
5. Save the document to load bank transactions.
6. Match imported transactions with existing ERPNext vouchers.
7. Create new vouchers where necessary.
8. Update bank transaction details when required.

The objective is to reduce the reconciliation difference to zero.

6. Matching Bank Transactions

ERPNext automatically suggests possible matching vouchers based on:

• Transaction amount
• Transaction date
• Reference information
• Party details

Users can:

• Match against existing vouchers
• Match multiple vouchers to a single bank transaction
• Create new vouchers directly from reconciliation
• Update transaction information for better matching

Automatic matching significantly reduces reconciliation effort and improves accuracy.

7. Benefits of Bank Reconciliation

• Ensures ERPNext balances match bank records
• Detects missing or duplicate transactions
• Improves cash flow visibility
• Simplifies financial audits
• Reduces manual bookkeeping errors
• Speeds up month-end and year-end closing activities

8. Related Topics

• Payment Reconciliation
• Bank Guarantee
• Payment Entry