Bank statement (form)

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

Click Cash and bank management > Common > Bank statements. Select a bank statement and click Edit.

–or–

Click Cash and bank management > Common > Bank accounts. Select a bank account and on the Action Pane, click Bank statements.

Use this form when you reconcile a bank statement using advance bank reconciliation.

Note

This form is only available if the Advanced bank reconciliation check box is selected in the Bank accounts form for the selected bank account.

The following tables provide descriptions for the controls in this form.

Buttons

Button

Description

Edit

Modify the selected bank statement.

Validate

Complete the bank statement validation process.

Reopen

Reopen the bank statement.

Statement

Create a new bank statement.

Import statement

Open the Import bank statements form, where you can import an electronic bank statement. For more information, see Import bank statements (form).

Post

Post the bank statement lines that have the New check box selected.

View distributions

Distribute the bank statement line transaction amount between multiple ledger accounts. For more information, see Accounting distributions (form).

Subledger journal

Preview the accounting entries for the bank statement. For more information, see Subledger journal (form).

Sales tax

View and modify the sales tax transactions that have been calculated for the selected line. For more information, see Temporary sales tax transactions (form).

Bank statement

Field

Description

Bank account

The bank account that the bank statement is related to.

From date

The starting date of the bank statement.

To date

The ending date of the bank statement.

Bank name

The name of the bank.

Opening balance

The bank balance at the beginning of the time period.

Ending balance

The bank balance at the end of the time period.

Currency

The currency code for the bank account.

Net amount

The total amount of all bank statement lines.

Total lines

The total number of lines on the bank statement.

Bank statement lines

Buttons

Field

Description

Add line

Add a new line to the bank statement.

Reconciliation relations

View matching details for reconciled bank document lines and bank statement lines.

Distribute amounts

Distribute the transaction amount between multiple ledger accounts. For more information, see Accounting distributions (form).

Sales tax

View and modify the sales tax transactions that have been calculated for the selected line. For more information, see Temporary sales tax transactions (form).

Fields

Field

Description

New

Select this check box to indicate that this is a new bank transaction.

Booking date

The date of the bank transaction.

Status

Indicates if the transaction is for information only or if the transaction is posted to the bank account.

Entry reference

Additional information entered for the transaction.

Bank statement transaction code

The type of transaction that is defined by the bank.

Trading party

Information about the origin of the transaction. For example, it displays customer information if the bank transaction is a payment.

Amount

The transaction amount in the currency that is assigned to the bank account.

Document number

The document number of the transaction.

Reference No.

Payment information that is provided by the remitter. For example, the paid invoice number.

Reversal

Select this check box to indicate that the selected bank statement line is reversed.

Reconciled

A selected check box indicates that the bank statement line is reconciled.

Line details

Field

Description

Counter currency

The currency that the transaction is recorded in if it is different than the bank account currency.

Counter amount

The amount in the counter currency.

Counter exchange rate

The exchange rate that is used to convert the transaction currency to the bank account currency.

Description

The description of the transaction.

Bank transaction type

The type of transaction.

Related bank account

The bank account that the transaction is posted to.

Related bank

The bank that the transaction is related to.

Offset account number

The account number that the transaction is posted to.

Currency

The transaction currency.

Amount

The amount of the transaction.

Exchange rate

The cost of the transaction in the foreign currency.

Description

The description of the transaction.

Bank transaction type

Select the type of bank transaction for the selected bank statement line. For more information, see Bank transaction type (form).

Sales tax group

Select the sales tax group to be used to calculate sales tax on a sale or a purchase. For more information, see Sales tax groups (form)

Item sales tax group

Select the item sales tax group that will be used to calculate sales tax on an item. For more information, see Item sales tax groups (form).

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).