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

You can use three different features to import bank statements from your bank.

Note
For all three features, you start the import by choosing the Import Bank Transactions action in the Payment Reconciliation Journal window.

You can import bank statement files in the following scenarios:

To import bank transactions into the Payment Reconciliation Journal Window

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

  2. To work in a new payment reconciliation journal, on the Home tab, in the New group, choose New Journal or Import Bank Statement.

  3. In the Payment Bank Account List window, select the bank account that you want to reconcile payments for, and then choose OK.

    The Payment Reconciliation Journal window opens prepared for the selected bank account.

  4. On the Home tab, in the Application group, choose Import Bank Transactions.

    If the bank account for the selected journal is not set up for importing bank statements, then a dialog will open to help you fill the relevant fields. For more information, see Bank Statement Import Format.

  5. In the Select a file to import window, select the file that contains the bank transactions for payments that you want to reconcile, and then choose Open.

  6. If the Bank Statement service is enabled, in the Bank Statement Filter window, specify the date interval for the bank statements to be imported as a bank feed.

You can now proceed to review the automatic payment applications automatically or manually apply. For more information, see How to: Reconcile Payments Using Automatic Application and How to: Review or Apply Payments After Automatic Application.

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