Bank reconciliation journal (form) [AX 2012]

Updated: July 24, 2012

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

Click Cash and bank management > Journals > Bank reconciliation.


Click Cash and bank management > Common > Bank accounts. On the Action pane, in the Reconcile group, click Bank reconciliation.

The Bank reconciliation option is only available if the Advanced bank reconciliation check box is selected on the Bank accounts form on the Reconciliation FastTab.

Use this form to reconcile bank transactions.

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




Select which posting status of the journals to display.

Bank account

Select the bank account to display journals from.

Show user-created only

Select the check box to display journals that you have created.




Enter or view the bank reconciliation journal.


Enter or view additional information about the selected the bank reconciliation journal, such as reconciliation information and statement information.


View information about the user or process that is using the selected bank reconciliation journal.


View historical information about the selected bank reconciliation journal, which includes reconcile information and reconciled date.




Open the Bank reconciliation worksheet.


Post the Bank reconciliation journal.

Print reconciliation statement.

Print the reconciliation report.



Bank account

Select the bank account to start a new reconciliation.

Reconcile ID

An automatically assigned number from the Reconcile ID number sequence that is assigned in the Cash and bank management parameters form.


Enter a description for the reconciliation journal.


The currency associated with the bank account.

Cut-off date

Enter the cut-off date for the reconciliation journal.

Statement ID

The ID of the last bank reconciliation journal statement.

Ending balance

The ending balance of the bank account that is on the last statement in the bank reconciliation journal.

Net amount

The total amount of bank reconciliation journal statement lines that are not reconciled and that have dates that are before or at the cut-off date.


This check box is selected when the reconciliation worksheet is completed.

In use

This check box is selected when the reconciliation worksheet is available for additional reconciliation.


The name of the selected bank account.

Bank account number

The account number of the selected bank account.

Reconciled date

The date when the reconciliation was completed.

Used by user

The user who is completing the bank reconciliation.

Locked by system

If this check box is marked, the reconciliation is locked by a system process.


Open the User log form to view the selected user's logon history and user information.

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