Bank in ERPNext
In ERPNext, the Bank master is used to define and manage different banks from which financial transactions are imported and reconciled.
It acts as a configuration layer that supports bank statement imports and enables smooth mapping of transactions to ERPNext ledger entries.
The Bank master helps standardize bank statement imports and ensures accurate mapping of external bank data to ERPNext Bank Transactions.
Access Path
Home > Accounting > Bank Statement > Bank
1. How to Create a Bank
Creating a Bank in ERPNext is straightforward:
- Go to the Bank list.
- Click on New.
- Enter the bank name.
- Save the record.
2. Configuring Bank for Data Import
To enable smooth bank statement import and reconciliation:
- Set the Field in Bank Transaction to map ERPNext fields.
- Set the Column in Bank File to match columns from the uploaded Excel statement.
This mapping ensures that imported bank data is correctly aligned with ERPNext’s Bank Transaction records.
3. Bank Reconciliation Integration
Once configured, the Bank master works closely with the Bank Reconciliation process:
- Bank statements are uploaded as Excel files
- Transactions are converted into Bank Transaction records
- Entries are matched with ledger transactions
- Reconciliation is completed for accurate accounting records
4. Key Benefits
- Streamlines bank statement imports
- Reduces manual data entry errors
- Improves reconciliation accuracy
- Ensures better financial visibility
- Supports faster accounting closure
5. Related Topics
- Bank Account
- Bank Reconciliation
- Bank Transaction
