Prerequisites<\/h2>\n\n\n\n
Ensure the following configurations are completed before configuring the Bank window:<\/p>\n\n\n\n
- \n
- Chart of Accounts \u2014 <\/strong>GL accounts for cash and bank must exist before linking bank accounts.<\/li>\n\n\n\n
- Currency \u2014 <\/strong>All currencies used by your bank accounts must be defined in iDempiere.<\/li>\n\n\n\n
- Organization \u2014 <\/strong>The correct Organization (or * for shared) must be active.<\/li>\n\n\n\n
- Business Partner \u2014 <\/strong>For supplier payment banks, the Business Partner record must exist.<\/li>\n\n\n\n
- Payment Terms \u2014 <\/strong>Required if payment terms are to be linked to bank payment transactions.<\/li>\n<\/ul>\n\n\n\n
Business Rules<\/h2>\n\n\n\n
- \n
- Only active bank records are available for selection in payment transactions and bank account lookups.<\/li>\n\n\n\n
- Deactivating a bank record prevents new transactions from referencing it but does not affect historical records.<\/li>\n\n\n\n
- Each bank account must be assigned to a currency; multi-currency banks require separate account records per currency.<\/li>\n\n\n\n
- A bank account designated as the Default automatically populates in payment documents for the assigned document type.<\/li>\n\n\n\n
- Bank accounts must be linked to a valid GL Account before payments can be posted to the chart of accounts.<\/li>\n<\/ul>\n\n\n\n
Navigation<\/h2>\n\n\n\n
Path: <\/strong>Menu \u2192 Financial Management \u2192 Business Partner \u2192 Bank<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n The Bank window displays all existing bank records. Use the search bar to locate a specific bank by name or routing number.<\/p>\n\n\n\n
Step-by-Step Configuration<\/h2>\n\n\n\n
Step 1: Open the Bank Window<\/h2>\n\n\n\n
Purpose: <\/strong>Access the Bank master list to view existing banks or create a new bank record.<\/p>\n\n\n\n
- \n
- Navigate to Financial Management \u2192 Business Partner \u2192 Bank.<\/li>\n\n\n\n
- The window displays all bank records configured in iDempiere.<\/li>\n\n\n\n
- Use the search bar at the top to filter by bank name, routing number, or organization.<\/li>\n\n\n\n
- Click any existing record to view its details, or proceed to Step 2 to create a new bank.<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Master-Bank-1024x488.png\")
<\/figure>\n\n\n\nStep 2: Create a New Bank Record<\/h2>\n\n\n\n
Purpose: <\/strong>Create the bank master record with identification details, routing information, and contact address.<\/p>\n\n\n\n
- \n
- Click the New Record icon (+) in the toolbar.<\/li>\n\n\n\n
- A blank Bank form opens.<\/li>\n\n\n\n
- Fill in all mandatory fields before saving.<\/li>\n<\/ul>\n\n\n\n
Field Reference \u2014 Bank Header Tab<\/h3>\n\n\n\n
Field<\/strong><\/td> Sample Value<\/strong><\/td> Description<\/strong><\/td><\/tr><\/thead> Name<\/td> State Bank of India \u2014 Retail<\/td> Full name of the bank as it appears in transactions and reports.<\/td><\/tr> Description<\/td> Primary retail banking partner for POS settlements<\/td> Internal description for reference. Not printed on documents.<\/td><\/tr> Organization<\/td> *<\/td> Set to * to share the bank across all branches, or assign a specific org.<\/td><\/tr> Routing No<\/td> 110002<\/td> Official bank routing or IFSC code used for electronic transfers.<\/td><\/tr> Swift Code<\/td> SBININBB<\/td> SWIFT\/BIC code required for international wire transfers.<\/td><\/tr> Active<\/td> Yes (checked)<\/td> Controls whether this bank is available for use in transactions.<\/td><\/tr> Street<\/td> 18 MG Road<\/td> Bank branch street address for correspondence.<\/td><\/tr> City<\/td> Chennai<\/td> City of the bank branch.<\/td><\/tr> Postal Code<\/td> 600001<\/td> Postal \/ PIN code of the bank branch.<\/td><\/tr> Country<\/td> India<\/td> Country where the bank is registered.<\/td><\/tr> Phone<\/td> +91 44 2234 5678<\/td> Bank contact telephone number.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n Step 3: Configure the Bank Account Tab<\/h2>\n\n\n\n
Purpose: <\/strong>Add one or more bank accounts under the bank master. Each account represents a distinct account number and currency used for transactions.<\/p>\n\n\n\n
- \n
- Inside the Bank record, click the Bank Account tab.<\/li>\n\n\n\n
- Click New Record (+) to add a new bank account.<\/li>\n\n\n\n
- Fill in account details including Account No, Account Type, and Currency.<\/li>\n\n\n\n
- Link the account to a GL Account for financial posting.<\/li>\n\n\n\n
- Mark the account as Default if it should auto-populate on payment documents.<\/li>\n\n\n\n
- Save each account before adding another.<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Master-Bank_account-1024x645.png\")
<\/figure>\n\n\n\nField Reference \u2014 Bank Account Tab<\/h3>\n\n\n\n
Field<\/strong><\/td> Sample Value<\/strong><\/td> Description<\/strong><\/td><\/tr><\/thead> Name<\/td> SBI Current Account \u2014 Chennai Main<\/td> Descriptive name for the bank account. Appears in payment lookups.<\/td><\/tr> Account No<\/td> 30012345678<\/td> The actual bank account number issued by the bank.<\/td><\/tr> Account Type<\/td> Checking<\/td> Checking or Savings. Controls reconciliation and statement import rules.<\/td><\/tr> Currency<\/td> INR<\/td> Currency in which this account operates. One account per currency.<\/td><\/tr> GL Account<\/td> 10110 \u2014 Bank Current Account<\/td> Chart of accounts code for posting payments and receipts.<\/td><\/tr> Default<\/td> Yes (checked)<\/td> If checked, auto-populates this account on payment documents.<\/td><\/tr> Credit Card<\/td> No (unchecked)<\/td> Check if this account is a credit card account.<\/td><\/tr> IBAN<\/td> IN30110002300123456<\/td> International Bank Account Number for cross-border transactions.<\/td><\/tr> Active<\/td> Yes (checked)<\/td> Inactive accounts are hidden from transaction lookups.<\/td><\/tr> Description<\/td> POS daily settlement account<\/td> Internal note about the account usage.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n Example Bank Account Records<\/h3>\n\n\n\n
Account Name<\/strong><\/td> Account No<\/strong><\/td> Type<\/strong><\/td> Currency<\/strong><\/td> GL Account<\/strong><\/td> Default<\/strong><\/td> Active<\/strong><\/td><\/tr><\/thead> SBI Current \u2014 Chennai<\/td> 30012345678<\/td> Checking<\/td> INR<\/td> 10110<\/td> Yes<\/td> Yes<\/td><\/tr> SBI Savings \u2014 Reserve<\/td> 30098765432<\/td> Savings<\/td> INR<\/td> 10120<\/td> No<\/td> Yes<\/td><\/tr> HDFC USD Settlement<\/td> 56781234560<\/td> Checking<\/td> USD<\/td> 10130<\/td> No<\/td> Yes<\/td><\/tr> SBI POS Collection<\/td> 30054321900<\/td> Checking<\/td> INR<\/td> 10115<\/td> No<\/td> Yes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n Each bank account is independently available in payment documents. Multiple accounts can exist under one bank record. Only the account marked Default auto-populates; all others must be selected manually.<\/p>\n\n\n\n
Step 4: Configure the Account \u2014 Accounting Tab<\/h2>\n\n\n\n
Purpose: <\/strong>Map the bank account to GL accounts for automated financial posting. This tab controls how payments and receipts affect your chart of accounts.<\/p>\n\n\n\n
- \n
- Inside the Bank Account record, click the Accounting sub-tab.<\/li>\n\n\n\n
- The accounting schema for your organisation is pre-loaded.<\/li>\n\n\n\n
- Assign the correct GL accounts for each accounting element.<\/li>\n\n\n\n
- Confirm that the Bank Asset Account matches the account in your chart of accounts.<\/li>\n\n\n\n
- Save the accounting configuration.<\/li>\n<\/ul>\n\n\n\n
Field Reference \u2014 Bank Account Accounting Tab<\/h3>\n\n\n\n
Field<\/strong><\/td> Sample Value<\/strong><\/td> Description<\/strong><\/td><\/tr><\/thead> Accounting Schema<\/td> Primary Accounting Schema<\/td> The accounting schema this mapping applies to.<\/td><\/tr> Bank Asset Account<\/td> 10110 \u2014 Bank Current Account<\/td> Main GL account debited\/credited for bank transactions.<\/td><\/tr> Bank In Transit<\/td> 10150 \u2014 Bank In Transit<\/td> Interim account for payments that are not yet cleared.<\/td><\/tr> Bank Unidentified<\/td> 10160 \u2014 Unidentified Receipts<\/td> Used when incoming payments cannot be matched to invoices.<\/td><\/tr> Bank Expense<\/td> 63010 \u2014 Bank Charges<\/td> GL account for bank service charges and fees.<\/td><\/tr> Bank Interest Expense<\/td> 63020 \u2014 Bank Interest Expense<\/td> GL account for interest charged by the bank.<\/td><\/tr> Bank Interest Revenue<\/td> 42010 \u2014 Bank Interest Income<\/td> GL account for interest earned on bank balances.<\/td><\/tr> Bank Revaluation<\/td> 65010 \u2014 FX Revaluation<\/td> GL account for foreign currency revaluation differences.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n Step 5: Configure Payment Processor (Optional)<\/h2>\n\n\n\n
Purpose: <\/strong>Link a payment processor (e.g. Razorpay, PayU, Stripe) to a bank account for automated POS or e-commerce payment collection in retail.<\/p>\n\n\n\n
- \n
- Inside the Bank Account record, click the Payment Processor sub-tab.<\/li>\n\n\n\n
- Click New Record (+).<\/li>\n\n\n\n
- Select the payment processor from the drop-down.<\/li>\n\n\n\n
- Enter the Merchant ID, API credentials, and processing currency.<\/li>\n\n\n\n
- Set Accepted Tender Type (Credit Card, UPI, Wallet, etc.).<\/li>\n\n\n\n
- Save and test connectivity if supported.<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/06\/TenthPlanet-iDempiere-Master-Bank_Account_Processor-1024x600.png\")
<\/figure>\n\n\n\nField Reference \u2014 Payment Processor Sub-Tab<\/h3>\n\n\n\n
Field<\/strong><\/td> Sample Value<\/strong><\/td> Description<\/strong><\/td><\/tr><\/thead> Name<\/td> Razorpay \u2014 Chennai POS<\/td> Unique name for the payment processor configuration.<\/td><\/tr> Payment Processor<\/td> Razorpay<\/td> Select from installed payment processor plugins in iDempiere.<\/td><\/tr> Merchant ID<\/td> rzp_live_XXXXXXXXXXXX<\/td> Merchant identifier issued by the payment processor.<\/td><\/tr> Accepted Tender Type<\/td> Credit Card, UPI<\/td> Payment methods accepted through this processor.<\/td><\/tr> Currency<\/td> INR<\/td> Processing currency for this merchant account.<\/td><\/tr> Active<\/td> Yes (checked)<\/td> Activates the processor for live transactions.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n Step 6: Save the Bank Record<\/h2>\n\n\n\n
Purpose: <\/strong>Persist the bank master and all associated account records to make them available in transactions.<\/p>\n\n\n\n
- \n
- Click the Save icon (disk icon) in the toolbar, or press F10.<\/li>\n\n\n\n
- iDempiere validates all mandatory fields before saving.<\/li>\n\n\n\n
- The saved bank record is immediately available in payment documents and bank account lookups.<\/li>\n\n\n\n
- Save each tab (Bank, Bank Account, Accounting) individually after entering data.<\/li>\n<\/ul>\n\n\n\n
Step 7: Activate or Deactivate a Bank Record<\/h2>\n\n\n\n
Purpose: <\/strong>Control which bank records appear in transaction lookups without deleting historical data.<\/p>\n\n\n\n
- \n
- Open the Bank record you want to activate or deactivate.<\/li>\n\n\n\n
- Locate the Active checkbox on the bank header.<\/li>\n\n\n\n
- Uncheck Active to deactivate: the bank and its accounts are hidden from all new transaction forms.<\/li>\n\n\n\n
- Re-check Active to restore availability.<\/li>\n\n\n\n
- Deactivating a bank does not delete or modify historical transactions that used it.<\/li>\n\n\n\n
- Apply the same Active control at the Bank Account level to deactivate individual accounts while keeping the bank visible.<\/li>\n<\/ul>\n\n\n\n
Important: <\/strong>Always deactivate rather than delete bank records. Deleted banks cause referential integrity errors in historical transaction reports.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n Common Issues and Resolutions<\/h1>\n\n\n\n
Issue<\/strong><\/td> Cause<\/strong><\/td> Resolution<\/strong><\/td><\/tr><\/thead> Bank account does not appear in payment document<\/td> Account is inactive or not linked to the correct org<\/td> Check the Active flag and Organization on the Bank Account tab.<\/td><\/tr> Payment posted to wrong GL account<\/td> Incorrect account mapping in Accounting sub-tab<\/td> Open Bank Account \u2192 Accounting tab, correct the Bank Asset Account GL code, and re-post affected transactions.<\/td><\/tr> Cannot save bank record \u2014 routing number error<\/td> Duplicate routing number entered for same org<\/td> Check for existing banks with the same Routing No. Use a unique identifier or differentiate by name.<\/td><\/tr> Default bank account not auto-populating on invoices<\/td> Default flag not checked on the bank account<\/td> Open the bank account and check the Default checkbox. Only one account per document type should be default.<\/td><\/tr> Bank account missing from bank statement import<\/td> Account No format mismatch between bank file and iDempiere<\/td> Verify that the Account No in iDempiere matches exactly the account number in the imported bank statement file.<\/td><\/tr> Historical payments lost after bank deletion<\/td> Bank record deleted instead of deactivated<\/td> Restore from backup. Going forward, only deactivate bank records by unchecking Active.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n Best Practices<\/h1>\n\n\n\n
- \n
- Use a consistent naming convention: Bank Name \u2014 Branch \u2014 Purpose (e.g. “SBI \u2014 Chennai \u2014 POS Settlement”).<\/li>\n\n\n\n
- Map all GL accounts (Asset, In Transit, Charges, Interest) in the Accounting tab before going live to prevent unposted transactions.<\/li>\n\n\n\n
- Mark only one bank account as Default per document type to avoid auto-population conflicts.<\/li>\n\n\n\n
- Create separate bank account records for each currency; never use one account for multiple currencies.<\/li>\n\n\n\n
- Deactivate unused accounts rather than deleting them to preserve audit trail integrity.<\/li>\n\n\n\n
- Review bank account GL mappings at every financial year-end to ensure alignment with the updated chart of accounts.<\/li>\n\n\n\n
- Link payment processors at the bank account level only after confirming API credentials in a sandbox environment.<\/li>\n\n\n\n
- Keep routing numbers and IBAN codes up to date; outdated numbers cause payment failures.<\/li>\n\n\n\n
- Document the purpose of each bank account in the Description field for easy identification during audits.<\/li>\n<\/ul>\n\n\n\n
Next Steps<\/h1>\n\n\n\n
After completing Bank configuration in iDempiere, proceed with:<\/p>\n\n\n\n
- \n
- Cash Journal \u2014 <\/strong>Configure cash accounts linked to POS tills and petty cash for daily retail cash management.<\/li>\n\n\n\n
- Payment Terms \u2014 <\/strong>Define payment terms for suppliers and customers that reference the configured bank accounts.<\/li>\n\n\n\n
- Business Partner Bank Account \u2014 <\/strong>Link supplier and customer bank details for automated payment runs.<\/li>\n\n\n\n
- Bank Statement Loader \u2014 <\/strong>Set up automatic bank statement import using the configured bank account identifiers.<\/li>\n\n\n\n
- Outgoing Payment \u2014 <\/strong>Configure and test payment documents using the newly created bank accounts.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
Learn how to configure the Bank window in iDempiere for retail \u2014 set up bank accounts, routing, payment methods, and […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[67,68],"tags":[],"class_list":["post-18783","post","type-post","status-publish","format-standard","hentry","category-retail","category-masters"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18783","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=18783"}],"version-history":[{"count":5,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18783\/revisions"}],"predecessor-version":[{"id":18877,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18783\/revisions\/18877"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=18783"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=18783"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=18783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Payment Terms \u2014 <\/strong>Define payment terms for suppliers and customers that reference the configured bank accounts.<\/li>\n\n\n\n
- Cash Journal \u2014 <\/strong>Configure cash accounts linked to POS tills and petty cash for daily retail cash management.<\/li>\n\n\n\n
- Currency \u2014 <\/strong>All currencies used by your bank accounts must be defined in iDempiere.<\/li>\n\n\n\n