To apply payments made to your online bank accounts or to reconcile bank accounts, you can import bank statements as bank feeds or as files. For more information, see How to: Import Bank Statements.
To import bank statements as bank feeds, you must set up and enable the Bank Statement service, an external provider of consolidated bank data in feeds. Then you must link the bank account in Microsoft Dynamics NAV to its related online bank account.
When the Bank Statement service is enabled, you can set a bank account up to automatically import new bank statements into the Payment Reconciliation Journal window every hour. Transactions for payments that have already been posted as applied and/or reconciled in the Payment Reconciliation Journal window will not be imported. For more information, see the “To enable automatic import of bank statement feeds” section in this topic.
To import bank statements as files, you must enable the predefined data exchange definition for SEPA CAMT bank statements, or create a new definition for another bank format. Alternatively, you can enable and use Bank Data Conversion service to import bank statements of any bank format. For more information, see How to: Import Bank Statements.
You link bank accounts to online bank accounts in the following different scenarios:
-
A bank account does not exist in Microsoft Dynamics NAV for your online bank account. Therefore, you create the bank account by linking from the online bank account.
-
A bank account exists in Microsoft Dynamics NAV, which you want to link to an online bank account.
-
A linked bank account must be unlinked because you want to stop using the Bank Statement service for the account.
-
Online bank accounts have changed and you want to update the information on bank accounts in Microsoft Dynamics NAV.
 Note |
|---|
| The Bank Statement service must be set up and enabled before you can link bank accounts. For more information, see How to: Set Up the Bank Statement Service. |
To create a new linked bank account
In the Search box, enter Bank Accounts, and then choose the related link.
On the Home tab, in the Bank Statement Service group, choose Create New Linked Bank Account. The Bank Account Linking window opens after a few moments.
Note This window shows the actual Web page of the Bank Statement service. Terminology and functionality in the window may not match instructions provided in this topic. In the Online Bank Account Linking window, in the Link Account pane, use the Search box to find the bank where you have one or more online bank accounts.
Choose the bank name. The Log In pane opens.
Enter the username and password that you use to log on to the online bank, and then choose the Next button.
The Bank Statement service prepares to link your online bank accounts at the specified bank to a new bank account in Microsoft Dynamics NAV.
Note If you have more than one online bank account at the bank, you must create additional bank accounts in Microsoft Dynamics NAV for those additional online bank accounts. See Steps 7 and 8. When the process has completed successfully, the bank name will appear in the My Accounts pane on the Linked tab. The number in brackets indicates how many online bank accounts were linked.
Choose the OK button.
If only one online bank account is linked, the Bank Account Card window for a new bank account opens, prefilled with the name of the online bank account. In this case, the bank account linking task is completed. All that remains is to set up the bank account. For more information, see How to: Set Up Bank Accounts.
If more than one online bank account were linked, the Bank Account Linking window opens listing the additional online bank accounts that are not linked to bank accounts in Microsoft Dynamics NAV yet. In that case, follow the next step.
In the Bank Account Linking window, select the line for an online bank account, and then, on the Home tab, in the New group, choose Link to New Bank Account.
The Bank Account Card window for a new bank account opens, prefilled with the name of the online bank account. For more information, see How to: Set Up Bank Accounts.
If a bank account already exists in Microsoft Dynamics NAV that you want to link the additional online bank account to, follow the next step.
In the Bank Account Linking window, select the line for an online bank account, and then, on the Home tab, in the Process group, choose Link to Existing Bank Account.
In the Bank Account List window, select the bank account that you want to link to, and then choose the OK button.
To link a bank account to an online bank account
In the Search box, enter Bank Accounts, and then choose the related link.
Select the line for a bank account that is not linked to an online bank account. The Linked check box is not selected.
On the Home tab, in the Bank Statement Service group, choose Link to Online Bank Account. The Online Bank Account Linking window opens with the name of the bank prefilled in the Link Account pane.
Choose the bank name. The Log In pane opens.
Enter the username and password that you use to log on to the online bank, and then choose the Next button.
The Bank Statement service prepares to link your bank account in Microsoft Dynamics NAV to the related online bank account.
When the process has completed successfully, the bank name will appear in the My Accounts pane on the Linked tab. If the bank has more than one bank account, only the bank account that you selected in step 2 is linked.
Choose the OK button.
In the Bank Account List window, the Linked check box is selected.
To unlink a bank account
In the Search box, enter Bank Accounts, and then choose the related link.
Select the line for a linked bank account that you want to unlink from its related online bank account.
On the Home tab, in the Bank Statement Service group, choose Unlink Online Bank Account.
Note If you choose Yes on the confirmation dialog, the link to the online bank account is removed, and the log-in details are cleared. To link the bank account to the online bank account again, you must log on to the bank again. For more information, see the “To link a bank account to an online bank account“ section.
To update bank account linking
In the Search box, enter Bank Accounts, and then choose the related link.
On the Home tab, in the Bank Statement Service group, choose Update Bank Account Linking.
If issues exist for any of the linked bank accounts in the Bank Account List window, the Bank Account Linking window opens specifying which bank accounts have issues. Issues can best be resolved by unlinking the online bank account and then re-creating the link. For more information, see the “To link a bank account to an online bank account“ section.
To enable automatic import of bank statement feeds
In the Search box, enter Bank Accounts, and then choose the related link.
On the Home tab, in the Bank Statement Service group, choose Automatic Bank Statement Import Setup.
In the Automatic Bank Statement Import Setup window, in the Number of Days Included field, specify how far back in time to get new bank transactions for.
Note It is recommended that you set this value to 7 days or more. Select the Enabled check box.
Every hour, the Payment Reconciliation Journal window will now be filled with any new payments that are made on the online bank account.
| Note |
|---|
| Transactions for payments that have already been posted as applied and/or reconciled in the Payment Reconciliation Journal window will not be imported. |
 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. |