Bank Transaction in ERPNext: Importing & Reconciling Bank Activity
The Bank Transaction form shows the bank transactions imported into ERPNext, typically from bank statements or integrations. Each record represents a single line of bank activity that can then be reconciled against the vouchers in your books.
1. Prerequisites
Before using Bank Transaction, it’s advised to create the following first:
- Bank
- Bank Account
2. How to use Bank Transaction
A Bank Transaction is typically not created manually. It’s usually imported or created using:
- Bank Statement Import — import from CSV or XLSX files.
- Data Import — the standard data import tool.
- Bank integration apps — such as Plaid or other third-party integrations.
Once imported, bank transactions can be reconciled with vouchers using the Bank Reconciliation Tool.
3. Fields
3.1 Basic Information
- Date: the date of the bank transaction.
- Status: the current status – Pending, Settled, Unreconciled, Reconciled, or Cancelled.
- Bank Account: the Bank Account the transaction was made from.
- Company: the company associated with the bank account (auto-fetched from the Bank Account).
3.2 Transaction Amount
- Deposit: the amount deposited (credited to your account).
- Withdrawal: the amount withdrawn (debited from your account).
- Currency: the currency the transaction was made in.
3.3 Description and Reference
- Description: a description from the bank statement.
- Reference Number: a cheque number or other reference.
- Transaction ID: a unique identifier from the bank (read-only).
- Transaction Type: the type of transaction as reported by the bank.
3.4 Payment Entries
The Payment Entries table links the bank transaction to vouchers in ERPNext for reconciliation:
- Payment Document: the document type reconciled against such as Sales Invoice, Purchase Invoice, Payment Entry, Journal Entry, or Expense Claim.
- Payment Entry: the specific document linked to this transaction.
- Allocated Amount: the amount allocated from this bank transaction to the payment entry.
- Clearance Date: the date the payment was cleared (shown after submission).
3.5 Allocation Summary
- Allocated Amount: the total amount allocated to payment entries (read-only).
- Unallocated Amount: the remaining amount not yet allocated (read-only).
3.6 Payment From / To (Party Information)
- Party Type: the type of party (e.g. Customer, Supplier, Employee).
- Party: the specific party linked to this transaction.
The following fields hold party information as provided by the bank statement:
- Party Name / Account Holder (Bank Statement): the party name from the bank statement.
- Party Account No. (Bank Statement): the party’s account number from the bank statement.
- Party IBAN (Bank Statement): the party’s IBAN from the bank statement.
NOTE
Party information from the bank statement can be used for automatic party matching when that option is enabled in Accounts Settings.
3.7 Extended Bank Statement (Fee Handling)
These fields handle bank fees that may be included in or excluded from the transaction amount:
- Included Fee: a fee already included within the Withdrawal amount. For example, if a withdrawal of 100 includes a 5 fee, the net payment is 95.
- Excluded Fee: a fee charged separately from the transaction. On save, this is automatically converted to an Included Fee by adjusting the transaction amount.
NOTE
Excluded fees adjust the transaction amount, they reduce the Deposit or increase the Withdrawal.
Related Topics
- Bank
- Bank Account
- Bank Reconciliation Tool
- Bank Statement Import
- Data Import
SUMMARY
A Bank Transaction shows bank activity imported into ERPNext from statements or integrations. It’s usually created via Bank Statement Import, Data Import, or a bank integration rather than by hand, then reconciled against vouchers using the Bank Reconciliation Tool. Its fields capture basic information (date, status, bank account, company), transaction amounts (deposit, withdrawal, currency), description and reference, the Payment Entries table linking it to documents, an allocation summary, party information (usable for automatic party matching), and extended fee handling for included and excluded bank fees.
