Account reconciliation (form)

Article
10/09/2018

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

Use this form to include transactions in the bank reconciliation and to enter new transactions that appear on the bank statement but that have not yet been entered.

In the upper pane, enter new transactions or make corrections to posted transactions until the bank statement and legal entity records correspond to each other. In the lower pane, view the sum, by bank transaction group, of the transaction lines that you have included in the bank statement reconciliation. This includes all of the transactions that you create manually and the transaction lines for which you have selected the Cleared check box.

Note

If you are creating a new transaction during reconciliation and sales taxes are part of the transaction, you must also enter transactions in the Sales tax payments form.

To open the form

Click Cash and bank management > Common > Bank accounts.
Select a bank account. On the Action Pane, click Account reconciliation.
In the Bank statement form, enter information in the Bank statement date field and the Bank statement field.
Click Transactions.

Task that uses this form

Reconcile a bank account

Navigating the form

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

Tabs

Tab	Description
Overview	Create and view the transaction lines that are part of the bank statement reconciliation.
General	For the selected transaction line, view additional information about amounts, payments, vouchers, and purchase sales tax.
Financial dimensions	View information about financial dimensions, such as the default dimensions and where the dimensions are used in account structures and advanced rule structures.

Buttons

Button	Description
Reconcile account	Post the transaction lines that reconcile legal entity bank records with the bank statement, and record the bank statement as reconciled.
Mark check interval	Open the Mark check interval for reconciliation form, where you can define an interval of consecutive checks for which you want to select the Cleared check box.
Deposit slips	View or modify the deposit slips of the bank account. You can enter a deposit slip number on the line, if appropriate.
Checks	View or modify the checks that have been issued on the bank account. You can enter a check number on the line, if appropriate.
Original document	View the original document that is the basis of the transaction line, if the document can be identified.
Voucher	Open the Voucher transactions form, in which you can view the voucher that is the basis of the transaction line, if the voucher can be identified.
Print	Print a reconciliation summary or the bank reconciliation report.

Fields

Field	Description
Show transactions	Select the type of transactions to view in the upper pane.
Opening balance	The balance of the bank account at the end of the last reconciliation.
Ending balance	The ending balance of the bank account as is entered in the Bank statement form.
Unreconciled	The amount to be accounted for in the bank statement reconciliation. When you include transactions in the reconciliation by selecting the Cleared check box (or by creating new transactions, for which this check box is automatically selected), the amount in this field is recalculated. When the unreconciled amount is zero, and you have included all the transactions that appear on the bank statement, you can post the account reconciliation. Note Click Reconcile account to post the account reconciliation.
Cleared	Select this check box to include the transaction in the bank statement that you are reconciling. Note This check box is not available if the transaction has a status of Pending cancellation. Transactions might have this status if the system is set up to require that reversals or cancellations be sent to review before they are posted. For more information, see Check reversals lines (form) or Deposit slip payment cancellations lines (form).
Bank transaction type	Select or revise the transaction type of each transaction as you perform the bank statement reconciliation. The transaction type lets you sort and make calculations on various kinds of bank transactions.
Date	View or enter the date of the transaction. When you create a new transaction in this form, the default value for this field is the date that you entered in the Bank statement date field in the Bank statement form, but you can change the date.
Transaction date	The posting date when the legal entity gains knowledge of the transaction. Note (ITA) This control is available only to legal entities whose primary address is in Italy, and if the Transaction date reference to competence date field is selected in the General ledger parameters form.
Check number	The check number of the transaction, if applicable.
Deposit slip	The deposit slip in which the transaction is included.
Amount in transaction currency	The transaction amount in the currency that is specified for the bank account. If you enter a new transaction, enter the transaction amount in this field. Note The amount of a posted transaction cannot be changed. To correct the transaction amount, enter a correction amount in the Correction amount field. The correction amount must be entered in the currency of the bank account.
Correction amount	Enter a correction amount to the original transaction amount, if appropriate.
Bank amount	Enter the amount of the correction.
Main account	Enter the main account that is offset by a bank transaction (either a new transaction or a correction amount) that you create during reconciliation. Select an appropriate offset account, which should be either a posting account or an account according to the account type. Note To see the offset main account for one of the transactions that is already posted to the bank account, click Voucher.
Description	Enter a short description of the transaction or the correction that you have created.
Sales tax group	The sales tax group for the selected bank transaction.
Item sales tax group	The item sales tax group for the selected bank transaction.
Sales tax amount	The calculated sales tax amount for the selected bank transaction.
Bank account	The identifier of the bank account for which you are performing the bank statement reconciliation.
Manual	This check box is automatically selected when you create a transaction in this form to reconcile the bank statement.
Currency	The currency code of the bank account.
Amount	The transaction amount in the accounting currency. The accounting currency is specified in the Ledger form. The currency value is calculated automatically using the exchange rate that is specified in the Ledger form for the transaction date. Note The amount of a posted transaction cannot be changed. To correct the transaction amount, enter a correction amount in the Correction amount field. The correction amount must be entered in the currency of the bank account.
Registration currency	The currency code of the currency in which the transaction amount was posted. This is the currency of the bank account.
Registration amount	The amount in the currency of the bank account.
Method of payment	The payment method of the transaction, if the transaction is posted as a payment in a journal.
Payment reference	A reference to the specific payment transaction. The payment reference is copied to this field when the journal is posted. You can identify reconciliation transactions by the value in this field.
Voucher number	If a transaction is recorded in the daily journal, the transaction voucher number is automatically copied to this field. Note When you create a transaction manually during reconciliation, it is automatically assigned a voucher number from the appropriate number sequence, and the Cleared check box is automatically selected.
Default financial dimensions	The default financial dimensions for the main account. When you select a financial dimension value, the Where the %1 dimension is used field group displays where the dimension is used in account structures and advanced rule structures.
Where the %1 dimension is used	The account structures and advanced rule structures that use the financial dimensions that you selected in the Financial dimensions or Default financial dimensions field group. Note The name of the field depends on the selection in the Financial dimensions or Default financial dimensions field group.
Bank transaction groups	The bank transaction groups of the transactions that are included in the bank statement reconciliation. A bank transaction group can contain several bank transaction types.
Description	The description of the bank transaction group.
Transactions	The number of transactions that are selected as included in the bank statement reconciliation in the upper pane. For a transaction to be included in the bank statement reconciliation, the Cleared check box on the transaction line in the upper pane must be selected.
Cleared	The sum of the transaction amounts for the transactions that are included in the bank statement reconciliation, and that belong to the bank transaction group.