How Does Bank Register Report Works in iDempiere

The Bank Register report shows all the transactions recorded for a selected bank account listed in date order along with a running balance. Instead of checking each payment or receipt one by one, users can see all the activity for an account in one place and easily match it with the bank statement.

This report is mainly used by Finance and Treasury teams to reconcile bank accounts, keep track of cash balances, and confirm that the transactions recorded in the system match what actually happened in the bank.

Business Rules

• The report is generated by a dedicated report process that populates the T_BankRegister temporary working table with the transaction rows that match the selected parameters; unlike a database view, this table holds no data until the process runs.
• Each row in T_BankRegister represents a single bank transaction line, combining bank (C_Bank_ID), bank account, and business partner (C_BPartner_ID) information into one record so no separate lookups are needed.
• Rows are generated for the specific AD_PInstance_ID of the report execution, so each time the report is run it builds its own isolated result set; concurrent runs by different users do not overwrite one another.
• Transaction amounts are captured in the account currency as separate debit (AmtAcctDr) and credit (AmtAcctCr) columns, matching how the movement affected the bank account.
• A running Balance is calculated cumulatively for each bank account, ordered by accounting date (DateAcct), so every row reflects the account balance after that transaction is applied.
• Results are always scoped to the requesting client and organization (AD_Client_ID, AD_Org_ID), so users only see transactions belonging to their own tenant and organization.

Report Parameters

The Bank Register parameter window allows users to filter transaction records before generating the report. Users can select the Bank, Bank Account, Account Date, and Business Partner to display only the transactions that match the selected criteria.

Report Output

• The Bank Register report displays one row per bank transaction line for the selected bank account, ordered by accounting date, with a running balance carried down each row.

The report includes the Bank Name, Business Partner, Document No, Acct Date, Acct Credit, Acct Debit, and Balance. It helps users reconcile bank account activity and confirm that recorded transactions match the actual bank statement.