Import and reconcile bank statements

Banks provide electronic bank statements for all your financial interactions. You can import these statements into the bank or giro journals.

The import bank statement is supported by the following protocols:

  • Rabobank mut.asc
  • Rabobank vvmut.ac
  • Rabobank ASCII
  • SEPA CAMT

To import and reconcile bank statements

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Bank/Giro Journal, and then choose the related link.

  2. Choose the Import Bank Statement action, select the required import protocol, and then choose the OK button.

  3. To reconcile the bank statements automatically when importing, on the Options FastTab, select the Automatic Reconciliation check box.

    Note

    This function does not work for bank statement files of type SEPA CAMT. Instead, use the Match Automatically action on the Bank Acc. Reconciliation page. For more information, see Reconcile Bank Accounts.

  4. Choose the OK button.

  5. To import the file that contains the electronic bank statement, specify the file name and path, and then choose the Open button.

The electronic bank statement is imported into the bank or giro journals. For more information, see Dutch Electronic Banking.

See also

Dutch Electronic Banking
Applying Payments Automatically and Reconciling Bank Accounts

Find free e-learning modules for Business Central here