Bank reconciliation worksheet (form) [AX 2012]

Updated: August 10, 2012

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

Click Cash and bank management > Common > Bank accounts. Select a bank account, on the Action Pane, in the Reconcile group, select Bank reconciliation. In the Bank reconciliation journal form, click the Lines The Bank reconciliation worksheet form is used when importing a bank statement file.

NoteNote

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

Use this form to match transactions on an imported bank statement with bank document transactions received or posted by the company that are on or before the Cut-off date specified on the General tab in the Bank reconciliation journal form.

The fields on this form cannot be modified and are available only for the purpose of reconciling.

When you double-click a line, the Bank document list form will open in read-only mode to show document line details.

The following types of bank documents are available by default:

  • Bank checks

  • Deposit slip

  • Electronic payments to vendors

  • Electronic payments to customers

In the Bank reconciliation worksheet form, you can match one bank source document transaction to one or more bank statement lines or match one bank statement line to one or more bank document transactions.

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

Tab

Description

Open documents

In the Open statement lines grid, view all imported bank statement transactions that have a transaction date on or before the Cut-off date that is specified on the General tab in the Bank reconciliation journal form and that have not been matched with a bank document transaction. In the Open bank documents grid, view all bank document transactions that have a transaction date on or before the Cut-off date that is specified on the General tab of the Bank reconciliation journal form and that have not been matched with a bank statement transaction.

Matched documents

In the Matched statement lines grid, view all imported bank statement lines that have been matched with a bank document transaction. In the Matched bank documents grid, view all bank document transactions that have been matched with a bank statement line.

Line details

View additional information for the selected line.

Button

Description

Run matching rules

Run automatic matching based on the matching rules that are set up in the Reconciliation matching rules form. For more information, see Reconciliation matching rules (form)

Refresh

Click Refresh to retrieve any new bank statement lines and bank document transactions that have a transaction date on or before the Cut-off date that is specified on the General tab in the Bank reconciliation journal form.

Subtotal

Open the Reconciliation subtotals by transaction type form.

Reconcile

Post the bank reconciliation journal.

Print reconciliation statement

Print the bank reconciliation statement report.

Match

Create a match relation for the marked bank document line and bank statement line.

Mark as new

Update the status of the selected line to a status of New.

Unmatch

Remove the reconciliation match between the bank statement lines and the bank document lines.

Show all statement lines

Show all matched bank statement lines and bank document lines for the selected bank statement line.


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

Community Additions

Show: