...

Alter the bank account configuration record

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

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

For Multiple Statement Identifier, enter

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

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

5. >Bank Reconciliation Setup>Bank Account Configuratio

6. Multiple Statement Record: Choose the name of the Multi Config created in previous step

7. Multiple Statement Identifier: Enter the identifier of the account (reference of the bank account number)

   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)

   Save

8. Number of Header Rows: Please reset to zero

9. Number of Trailing Rows: Please reset to zero

10. Now you are ready to import files.