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 the format for filling in this a prompt will appear, indicating the format for 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.
If additional details need to be uploaded beyond the current columns, or remove any columns you will need to create a new template since the existing one cannot be edited.
To create a new template, navigate to More Actions > click on the Copy option > In the new template, change the description > make the changes to the new template > save.
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