Importing Bank Payments
To import payments through your bank statement, you will need to have the upload file ready for import.
In order to get an idea of how the import file should look like and what columns (information) are expected, navigate to the Payments tab (Accounts menu option) and click on the Import Payments button. A popup showing 5 data columns will be displayed.
If you would like to see what columns are needed in order for the template to be import-ready, simply click on “Download our CSV template” and you will be able to download the sample file on your computer.
You need to format the bank statement according to this template file to import the payments.
Here, the most important information that is required is the Reference field. If this is not given correctly then it won’t match the payment with any of the available payees and you will have to do this manually.
- A file can be imported by clicking on choose file button, once the file is imported into Juniorlogs, the system will automatically populate the Payee name field according to the Description (which is a combination of Reference and Description fields from the CSV file)
- To match unmatched payment, Payee can be searched by typing the name as shown in the snapshot below:
- Unmatched payments will be ignored.
- Once the transactions are matched, click on the save payments button to complete the process.
Please see the following video to know all about Importing Bank Payment.