Problem: How to upload a bank statement using an existing template.
Solution: To
...
upload a bank statement using an existing template, follow these steps:
Important! Available for configurations from above 2.1.1.29
Bank Statements which are generally statements, typically received from banks and imported to into the database, are used for reconciliation reconciling with internal bank documentsrecords.
- Import template
Go through: Administration
...
> Master Data
...
> Excel import Templates.
Double-click to open the template.
...
Download and save the sample template.
Fill Complete it in with the necessary required data. There For your convenience, there is a hint for your convenienceavailable.
When hovering the you hover your mouse cursor over the upper-right corner of each column of in the template, the user is prompted to specify a prompt will appear, indicating the format for filling in this entering data into that 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.
2. Add the bank statement-
Open the Bank Statement document to download upload the data. Go to Money > Bank statement.
On the Main tab, specify enter the date, the Entityentity, the bank account, the period, and the Opening opening balance (it must which should match the Closing closing balance of the previous statement).
...
On the Operations tab, click on the download import button to select the file you filled need to fill in.
Click next for the next steps.
...
Enter the closing balance and post the document.
Once the bank statement is uploaded, it can be reconciled with the transaction, see in detail 6.7.2. Bank Reconciliations
Thanks for being a First bit Bit Customer! #bank statement#excel#download