How to edit a bank statement in ERPLY Books

How to edit a bank statement in ERPLY Books

This manual is for those customers whose bank statement is not supported by ERPLY Books. Now you can make the necessary settings by yourself.

In order to add the all the needed settings to the bank statement, first, you need to find out/ understand the following information:

  1. What is the encoding for this file?
  2. What is the data format?
  3. What is the format of the file separator?
  4. In what order is the information organized?

Then open the global parameters and type “Global Parameters” into the search box. Add a new parameter ATTRIBUTE_GLOBAL_CUSTOM_BANKS

Add the following parameters:

Value = bank name.

Alt value = is it starting from the first row. Values true or false.

Alt value 2 = the format of a file encoding.

Alt value 3 = date format.

Alt value 4 = CSV file separator, possible values are “,”, “;”, “|”.

Alt value 9 = the order of the information from the bank statement. Divide the information with dashes >  “|”.

You need to fill in the following information:

  1. Date
  2. Paid out amount (“amount”). If there are debit sum and credit sum, then fill these in  “debitSum” and “creditSum”
  3. Customer or supplier name
  4. Description
  5. Archiving attribute “id”
  6. Currency

The order of the information must be the same as it is in the bank statement. If there is more information in the bank statement than described here, mark it under “Other”.

For example, you have the following row in the file:

“date”,”order id”,”invoice id”,”tax type”,”payout amount”,”payout currency”,”invoice price”,”invoice currency”,”exchange rate (EUR)”,”description”.

Then write it like this:

date|id|other|other|amount|currency|other|other|other

This website uses cookies to give you the best experience. Agree by clicking the 'Accept' button.