Page History

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.

Image Modified

Double-click to open the template.

Image Modified

Download and save the sample template.

Image Modified 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, a prompt will appear, indicating the user is prompted to specify the format for filling in this entering data into that column.

Image Modified

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.

Image Added

2. Add the bank statement-

Open the Bank Statement document to download upload the data. Go to Money > Bank statement.

Image Modified

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).