Microsoft Dynamics NAV provides a Bank Rec. Worksheet that you can use to reconcile bank account ledger entries with bank statements.

To reconcile bank accounts with bank statements

  1. In the Search box, enter Bank Account Reconciliations, and then choose the related link.

  2. On the Home tab, in the New group, choose New.

  3. On the General FastTab, fill in the required fields as described in the following table.

    Field Description

    Bank Account No.

    The bank account number to reconcile.

    Statement No.

    The bank statement number to reconcile.

    Statement Date

    The bank statement date.

    Statement Balance

    The bank statement balance.

  4. On the Actions tab, in the Functions group, choose Mark Lines.

    Note
    In the Functions group, you can also select the following bank reconciliation functions: suggest lines, clear lines, record adjustments, and recalculate the general ledger balance.

  5. In the Bank Rec. Process Lines batch job, on the Options FastTab, fill in the fields as described in the following table.

    Field Description

    Record type to process

    Specify the type as Checks, Deposits, or Both.

    Mark lines as cleared

    Select to process the option selected in the Record type to process field.

  6. On the Bank Rec. Line FastTab, select the appropriate filters.

  7. Choose the OK button.

  8. In the Bank Rec. Worksheet window, on the Adjustments FastTab, on the Bank Rec. Adj. Lines Subform FastTab, enter information into the remaining fields to make adjustments.

    Note
    If needed, you can also use the Bank Rec. Worksheet window to view the Bank Reconciliation Comments card or the Bank Reconciliation card. This feature is available on the Navigate tab.

  9. On the Actions tab, in the Posting group, choose Post.

Tip

See Also