Account reconciliation (form) [AX 2012]

Updated: May 24, 2011

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.

NoteNote

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.

  1. Click Cash and bank management > Common > Bank accounts.

  2. Select a bank account. On the Action Pane, click Account reconciliation.

  3. In the Bank statement form, enter information in the Bank statement date field and the Bank statement field.

  4. Click Transactions.

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

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.

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.

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.

NoteNote

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.

NoteNote

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.

NoteNote

(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.

NoteNote

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.

NoteNote

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.

NoteNote

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.

NoteNote

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.

NoteNote

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.


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

Community Additions

Show: