Important
To use this functionality, you must implement the required bank file formats and all related actions and fields must be added to the user interface. Contact your Microsoft Certified Partner for more information.

You can import bank statements from your electronic bank site to quickly populate Microsoft Dynamics NAV with actual bank transactions.

Banks use different file formats, so you must specify the format of your bank’s statement file in the Bank Statement Format field in the Bank Account Card window.

You can import bank statement files in the following scenarios:

To import bank statements into the General Journal window

  1. In the Search box, enter General Journals, and then choose the related link.

  2. In the General Journal window, on the Home tab, in the Bank group, choose Import Bank Statement.

  3. Select the bank statement file, and then choose Open.

    The bank statement lines are filled into the general journal.

You can now proceed to automatically match payments with open invoices or credit memos. For more information, see How to: Automatically Apply Payments with Open Documents.

To import bank statements into the Bank Acc. Reconciliation window

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

  2. In the Bank Acc. Reconciliation window, on the Home tab, in the Bank group, choose Import Bank Statement.

  3. Select the bank statement file, and then choose Open.

    The bank statement lines are filled into the left pane of the Bank Acc. Reconciliation window.

You can now proceed to automatically or manually match bank entries to reconcile the bank account. For more information, see How to: Match Bank Statement Lines with Bank Account Ledger Entries.

Tip

See Also