Bank reconciliation worksheet (form)
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.
Note
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.
Navigating the form
The following tables provide descriptions for the controls in this form.
FastTabs
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. |
Buttons
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).