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 above 2.1.1.29
Bank statements, typically received from banks and imported into the database, are used for reconciling with internal bank records.
- Import template
Go through: Administration > Master Data > Excel import Templates.
Double-click to open the template.
Download and save the sample template.
Complete it with the required data. For your convenience, there is a hint available. When you hover your mouse over the upper-right corner of each column in the template, 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 upload the data. Go to Money > Bank statement.
On the Main tab, enter the date, entity, bank account, period, and opening balance (which should match the closing balance of the previous statement).
On the Operations tab, click on the import button to select the file you need to fill in.
Click next for the next steps.
3. The data has been uploaded successfully.
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 Customer! #bank statement#excel#download