Here's how to upload all your bank transactions accurately into the Clever Accounts portal, ensuring you do not miss anything going into or out of the bank account.
Uploading bank statements directly from online banking is the easiest way to update your accounts system.
Firstly, you will need to download the appropriate transaction listing from your bank's online banking facility. The format needs to be in CSV (comma delimited).
Please refer to your bank if you have any problems downloading statements in CSV format.
Make sure you specify the correct dates for the export. However, don't worry if you include transactions already imported as Clever Accounts will check if there are duplicate transactions to be imported and will ignore these as standard.
Import a statement
Select Banking and then for the account your are uploading the statement for, from the main drop down select Import Entries.
You will then need to upload the file you downloaded from the online banking website. Click on and navigate to the folder you saved the file to and click ok to select it.
The point of selecting a bank will mean Clever Accounts will automatically match the columns from the CSV file to the table columns it needs to use to import the transactions.
Matching the CSV columns
You need to match the CSV file columns to the columns Clever Accounts will use to import into the database. For example, ensure the date column on the CSV file is mapped to the date column on the software.
If you need to make any changes, click on the drop down menu and select the appropriate column that represents the correct map to the CSV file column.
Once you are happy with the match, click on verify and complete import or go back a step to start over again.
Once the statement has been uploaded
Once you have uploaded the transactions, you will need to complete the final step and explain all imported transactions so that Clever Accounts know what to do with them in the accounts.
Explaining transactions simply means allocating an account code to the imported transactions and making sure the VAT rate is correctly assigned.
Once this procedure is complete the process is done.