Setup multi-account statement Import

This page explains how to setup a statement that contains multiple accounts (in short: Multi-statement).

1. Go to Setup  > Bank Reconciliation Setup > Multiple Statement Config > New

2. Create one record for all accounts you want to import using one file:

3. 1. Enter a name

   2. For Bank, select a file format or default bank configuration if applicable

   3. Enter Folder ID, you may use the same one as for the bank statements

   4. For CSV files only: Enter the number of the column that holds the identifier to the bank account (field: Identifier Column)

   5. For CSV files only: Select the csv delimiter and number header and trailing rows if any

   6. Save

4. Go to the Bank Account Configuration records needed to be imported this way (Setup  > Bank Reconciliation Setup > Bank Account Configuration)

5. For each one, edit. Do three things:

6. 1. For Bank, choose the default bank configuration (if applicable)

   2. For Multiple Statement Record, chose the one created in step 2

   3. For Multiple Statement Identifier, enter the identifier of the account

      1. For CSV files, the value in this field should be equal to the value in the Identifier Column in the file

      2. For MT940 files, use the account number (note that some MT940 formats include the currency at the end of the account number, i.e. NL99RABO0123456789EUR)

      3. For CAMT.053 files, use the account number or IBAN

   4. Remove the header and trailing rows if any (this must be set to zero)

   5. Save

7. Now you are ready to import files.