Codejig Reference

Bank Account: List of Transactions

Use the List of transactions tab to see all accounting and banking transactions referring to a bank account which has been triggered by certain documents.

The report is not available for newly created bank accounts as there is no banking and accounting data to be processed by the report yet. Only when certain transactions for a new bank account take place, the report retrieves and analyzes information from those transactions and render it in the generated table.

You can generate two kinds of reports based on the selected type of history:

Accounting type of history - only accounting transactions made to the Transaction journal are displayed.
Banking type of history - all banking transactions made to the Banking register are displayed.

When accessing the List of transactions tab of the bank account for which certain transactions took place, the report based on the accounting information is displayed by default allowing you to see all accounting transactions that have been created for this bank account during the whole period of your company’s activities.

To build any type of report, indicate the start and end dates for the report to limit the scope of the analysis, select one of two types of bank account tracking, either accounting or banking tracking, and set filters if necessary.

Transactions that have been triggered within a given period are displayed as report lines including certain accounting or bank details depending on the selected type of history.

Accounting report

If you generate the report based on the accounting information, the following details are displayed in the report:

Field	Used for displaying
Initial balance	Bank account balance in the system default currency as of the report start date.
Amount Dt	Total debit bank account turnovers for a given period in the system default currency.
Amount Ct	Total credit bank account turnovers for a given period in the system default currency.
Balance	Bank account balance as of the report end date in the system default currency.

In case the bank account is created in the currency that is not a default system currency, the following fields will be added to the Totals section:

Field	Used for displaying
Currency initial balance	Bank account balance in the currency of the given bank account as of the report start date.
Currency amount Dt	Total debit bank account turnovers for a given period in the currency of the given bank account.
Currency amount Ct	Total credit bank account turnovers for a given period in the currency of the given bank account.
Currency balance	Bank account balance as of the report end date in the currency of the given bank account.

Each transaction that was recorded over the specified period of time is displayed as a line item in a table. The following details are provided for each transaction:

Field	Used for displaying
Date	Date of a transaction.
Document	Document that caused the transaction.
Amount Dt	Amount in the system default currency with which the account is debited if it is a debit transaction.
Amount Ct	Amount in the system default currency with which the account is credited if it is a credit transaction.
Balance	Bank account running balance after the transaction. The balance after the transaction is calculated in relation to transactions preceding this transaction by date. For example, you have 2 000 EUR worth on a certain bank account, and then you spend 700 EUR worth of it. The system will work out the balance after this transaction as follows: It will subtract 700 from 2 000 and place a new balance of 1 300 next to the transaction.

However, not all line item fields are displayed by default. To enable such fields, you have to turn on the extended mode for line item by clicking the More button above the list of items/ top-right of a table.

On enabling the extended mode, the following fields appear:

Field	Used for displaying
Corresponding account	A contra account with which the specific account is paired and to which the opposite transaction was made.
Corresponding analytics	Additional details of the opposite transaction made to the contra account.
Currency amount Dt	Amount in the currency of the given bank account with which the account is debited if it is a debit transaction.
Currency amount Ct	Amount in the currency of the given bank account with which the account is credited if it is a credit transaction.
Currency balance	Bank account running balance after the transaction in the currency of the given bank account. The balance after the transaction is calculated in relation to transactions preceding this transaction by date. For example, you have 2 000 EUR worth on a certain bank account, and then you spend 700 EUR worth of it. The system will work out the balance after this transaction as follows: It will subtract 700 from 2 000 and place a new balance of 1 300 next to the transaction.

You can filter transactions appearing in the report.

For the running balance, total balances and turnovers to be worked out based only on the displayed transactions, apply filters using the following filter fields:

Filter field	Impact on the report
Document	Displays transactions triggered by a selected document. Other transactions are left aside.

Also, you can filter transactions with the help of the default filtering functionality. However, then the running balance, total balances and turnovers will not be recalculated to accord only with the transactions rendered in the report. They will be calculated taken into account all transactions, even those that are excluded from the report.

Banking report

If you generate the report based on the banking information, the same details in the Totals section are displayed in the report as for the Accounting report.

Values in the fields forming the Totals section are calculated automatically for informational purposes only. Totals section fields are disabled for editing and cannot be overridden.

Each transaction that was recorded over the specified period of time making banking movement is displayed as a line item in a table. The following details are provided for each transaction:

Field	Used for displaying
Date	Date of banking transaction.
Document	Document that has triggered the inventory transaction.
Type of payment	Purpose of the payment that was made or received.
Payee/Payer	Company or a particular bank account who paid or received the amounts.
Amount Dt	The amount in the system default currency with which the account is debited if it is a debit transaction.
Amount Ct	Amount in the system default currency with which the account is credited if it is a credit transaction.
Balance	Bank account running balance after the transaction. The balance after the transaction is calculated in relation to transactions preceding this transaction by date. For example, you have 2 000 EUR worth on a certain bank account, and then you spend 700 EUR worth of it. The system will work out the balance after this transaction as follows: It will subtract 700 from 2 000 and place a new balance of 1 300 next to the transaction.

Advanced line item fields

Not all line item fields are displayed by default. To enable such fields, you have to turn on the extended mode for line item by clicking the More button above the list of items. On enabling the extended mode, the following fields appear:

Field	Used for displaying
Currency amount Dt	Amount in the currency of the given bank account with which the account is debited if it is a debit transaction.
Currency amount Ct	Amount in the currency of the given bank account with which the account is credited if it is a credit transaction.
Currency balance	Bank account running balance after the transaction in the currency of the given bank account. The balance after the transaction is calculated in relation to transactions preceding this transaction by date. For example, you have 2 000 EUR worth on a certain bank account, and then you spend 700 EUR worth of it. The system will work out the balance after this transaction as follows: It will subtract 700 from 2 000 and place a new balance of 1 300 next to the transaction

If you want to turn off the extended mode, click the Less button.

Note: After turning off the extended mode, advanced item details will persist.

You can filter banking transactions appearing in the report with the help of the following filter fields:

Filter field	Impact on the report
Document	Displays transactions triggered by a selected document. Other transactions are left aside.
Type of payment	Displays transactions triggered for a selected type of payment. Other transactions are left aside.
Payee/Payer	Displays transactions triggered for a selected payee/payer. Other transactions are left aside.

The running balance, total balances and turnovers will be calculated taken into account only the transactions rendered in the report after applying filters. Total balances and turnovers will be recalculated as well.

You can apply several filters if required.

More information

Bank Account
Create a New Bank Account
Bank Account: General Area

Bank Account: Charts Tab

Payment Terms