...
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.
...
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.
2. 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.
3. The data has been uploaded successfully.
...
Enter the closing balance and post the document.
Thanks for being a First bit Customer! #bank statement#excel#download