Problem: How to upload a bank statement using an existing template.
Solution: To download a bank statement using an existing template, follow these steps:
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
Double-click to open the template
Download and save the sample template.
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.
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.
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)
On the Operations tab, click on the download button to select the file you filled in.
Click next for the next steps.
The data has been uploaded successfully.
Enter the closing balance and post the document.
