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.
Navigating the form
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).