次の方法で共有


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:

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.

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