1. Click > Common Forms> , and select the bank account for which you want to reconcile the bank account statement.

    Note Note

    You cannot reconcile a bank account statement with a bank account if any of the checks or deposit slip payments that are listed on the statement currently have a status of . After a reviewer posts or rejects a check reversal or deposit slip payment cancellation, the status is no longer , and you can reconcile the bank account. For more information, see Cancel a deposit slip payment.


  2. Click > , and enter values in three fields.

    Two fields are mandatory: and . In the field (optional), enter the balance of the bank account as it appears on the bank account statement. For more information, see Bank account statement (form).

  3. Click . In the upper pane, you can view all the bank account transactions that have not yet been reconciled with a bank account statement.

    Note Note

    To maintain an overview of transactions as you proceed, limit or expand your view of the account transactions by changing the value in the drop-down list.


  4. For each transaction that is included in the bank account statement – if the amount in Microsoft Dynamics AX corresponds to the amount on the bank account statement – select the check box. As you do this, you can, if necessary, enter or revise the value in the field. This is important for your bank transaction statistics and for some reports.

    Note Note

    Do not select the check box on transactions that are not on the bank account statement. These transactions continue to appear in this form until they are reconciled with a future bank account statement.

    The check box is not available if the transaction has a status of . Transactions might have this status if your system is set up to require that reversals or cancellations be sent to review before they are posted. After a reviewer posts or rejects the reversal or cancellation, the status is no longer , and you can reconcile the bank account. For more information, see Set up a review process for reversals and cancellations.


  5. The bank account records may contain an interval of checks that are all present on the bank account statement. To select the check box for all the check lines, click and indicate the interval.

  6. A bank account transaction amount might not correspond to the amount on the bank account statement transaction. To make an appropriate correction in the field, enter an appropriate offset ledger account for the correction amount in the lookup field, and enter an explanatory text for the correction (or transaction) in the text box.

    Note Note

    If the accounting period of the transaction to be corrected is closed, the field cannot be used. Instead, create a new line with a transaction date in an open accounting period for the correction. In this case, you must add the dimensions that were attached to the original transaction, as well as the offset ledger account and the transaction text.


  7. Create transactions for entries (such as fees and interest) that are on the bank account statement, but that are not recorded in Microsoft Dynamics AX. Enter the offset account, the transaction text, and appropriate dimensions.

  8. As the transactions on the bank account statement are marked as included, the amount in the field (which is recalculated continuously as you make changes) approaches zero. When it reaches zero, click to post the reconciliation and the transactions and corrections that you have created.

  9. After the reconciliation is posted, the transactions that have been included cannot be revised or corrected any further, and they do not appear in any future account reconciliation.

  10. To view bank transactions that have not yet been reconciled, use the report; to view the bank statement for a bank account, use the report.

See Also