How to: Import Bank Statements

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.

Use the Bank Statement service to import the bank statement directly as a bank feed. For setup information, see How to: Set Up the Bank Statement Service and How to: Link Bank Accounts to Online Bank Accounts.
Use the Bank Data Conversion service to convert bank statement files in any format to a data stream that you can import. For setup information, see How to: Set Up the Bank Data Conversion Service.
Use the predefined data exchange definition for SEPA CAMT bank statements or set up a new definition for another bank format using the Data Exchange Framework. For setup information, see How to: Set Up Data Exchange Definitions.

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:

As the first step in reconciling payments with open entries in the Payment Reconciliation Journal window. For more information, see How to: Reconcile Payments Using Automatic Application.
As the first step in reconciling bank accounts in the Bank Acc. Reconciliation window. For more information, see How to: Match Bank Statement Lines with Bank Account Ledger Entries.

To import bank transactions into the Payment Reconciliation Journal Window

In the Search box, enter Payment Reconciliation Journals, and then choose the related link.
To work in a new payment reconciliation journal, on the Home tab, in the New group, choose New Journal or Import Bank Statement.
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.
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.
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.
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.

In the Search box, enter Bank Account Reconciliation, and then choose the related link.
In the Bank Acc. Reconciliation window, on the Home tab, in the Bank group, choose Import Bank Statement.
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
For more information about how to work with fields and columns, see Working with Microsoft Dynamics NAV. For more information about how to find specific pages, see Search.