Bank and Bank Statements

Bank and Bank Statement Introduction

Bank and Bank Statement - Bank Setup

• You create accounts for your Bank Account => Bank Asset and Bank In-Transit accounts in the Account Element window => Element Value subtab (just like creating any other account in your COA).
• You create a unique pair of GL accounts per Bank Account - said another way, each Bank Account gets it own Bank Asset account and Bank In-Transit account.
• It is OK for the Account Element => Search Key (also known as: account number) to include special characters. This is convenient for Bank Accounts because you can name your accounts like: "10023-BA" and "10023-BIT". Even thought they have the same prefix, they are Technically different accounts.
• I strongly recommend you update the Accounting Schema window => Defaults subtab => Bank Asset and Bank In-Transit default fields to a '99998 - default account - do not use' so that if you ever forget to change newly created Bank Account => Accounting records, it is obvious when you run your trial balance.

Bank and Bank Statement - Create GL Accounts

Bank and Bank Statement - Payment to Bank Statement Demonstration

Bank and Bank Statement - Create Payment from Bank Statement Line

Bank and bank Statement - Add Bank Fee to Transaction

Bank Transfers

• It is a process that automates the creation of two Payment records (one 'Payment' and one 'Receipt').
• Since Payments require a Business Partner, the Bank Transfer process also requires a Business Partner.
• I typically create a 'Bank Transfer' Business Partner to help identify the resulting Payment records.
• They system clears the transaction through a GL account via a Charge. The Charge is a required parameter of the Bank Transfer process.
• I recommend creating and using a GL account and associated Charge called 'Bank Transfer Clearing'.
• To help make the DocumentNo field more meaningful and consistent, I recommend you default the value using Context (search context) with a date or other bank related values.

Simplified Bank Cash Balance Enhancement (Daily Banking)

2014-10-09 - Batch Deposit - Payments into Batch

• Introduction - how to collect multiple AR Receipts into single batch so that a user can find the applicable receipts at the time of bank statement creation.
• 0:01:00 Process overview
• 0:02:45 Create invoices
• 0:04:00 Create AR Receipts
• 0:04:45 Create Payment Into Batch Record and add Receipts
• 0:06:00 Create Bank Statement
• 0:07:00 Potential enhancements
• Other enhancements
  • Payment needs before void/reverse logic to prevent void/reverse if payment is in a batch.
  • Bank Statement window needs subtab called "Bank Statement View" that (a) hides payments that are in a batch and instead shows batches as a single line. This helps users compare the iDempiere bank statement view with how the bank's statement looks.
  • Bank Statement window => Line subtab => add Batch field to show if the payment is part of a batch (Column SQL)