How to: Import Bank Statements
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.
Note
Bank statements in the SEPA CAMT format are supported out-of-the-box. Use the Date Exchange Framework to enable other bank or payroll file formats. For more information, see How to: Enable Import/Export of Bank or Payroll Files Using the Data Exchange Framework.
You can import bank statement files in the following scenarios:
As the first step in matching payments with open documents or entries in the General Journal window. For more information, How to: Automatically Apply Payments with Open Documents.
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 statements into the General Journal window
In the Search box, enter General Journals, and then choose the related link.
In the General Journal 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 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
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.
See Also
Tasks
How to: Automatically Apply Payments with Open Documents
How to: Match Bank Statement Lines with Bank Account Ledger Entries
How to: Fill In Bank Reconciliations
How to: Export Payments to a Bank File
Other Resources
Bank Statement Import Format
General Journal
Bank Acc. Reconciliation
How to: Enable Import/Export of Bank or Payroll Files Using the Data Exchange Framework