Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...


Important! Available for configurations from 2.1.1.29


Bank Statements which are generally received from banks and imported to the database are used for reconciliation with internal bank documents.


Go through: Administration- Master Data- Excel import Templates


Image Modified


Double-click to open the template


Image Modified


Download and save the sample template.


Image Modified



Fill it in with the necessary data. There is a hint for your convenience.
When hovering the mouse cursor over the upper-right corner of each column of the template, the user is prompted to specify the format for filling in this column.


Image Modified


Important! If a cell is expected to have a value of 0, you must leave it empty without entering the "0" character in it. Fields with numeric values must not contain a space character.



Open the Bank Statement document to download the data.


Image Modified


Image Modified



On the Main tab, specify the date, the Entity, the bank account, the period and the Opening balance (it must match the Closing balance of the previous statement)


Image Modified


On the Operations tab, click on the download button to select the file you filled in.


Image Modified

Click next for the next steps.


Image Modified


Image Modified



The data has been uploaded successfully.


Image Modified


Enter the closing balance and post the document.


Image Modified