Log into your bank account online and navigate to the statements page. Select the date range that you wish to download the statement for and export the statement to your computer as a CSV.


Use the guide below to import this statement file.


Other types of file formats supported by the bank import tool are OFX, QBO, QIF, SWI and 940 files. The format of these file types are fixed and do not need to be mapped as shown in step 4 below.


Step 1.


Navigate Money > Bank statements > Import statement.


BSImportstatement

Step 2.


Under the Import a bank statement from a file heading, select a bank account from the drop-down list Account for import.



Step 3.


Select Choose file to import a downloaded bank statement and select the default payment method. The payment method can be changed as each transaction is explained.



Step 4.


Match the headers of the columns on the CSV file to the fields in Clear Books.


The required fields are Date, Description, Money In and Money out (Amount if the column is combined).


It is possible to assign a description to multiple columns.



















Use the amount field if the debits and credits are combined and ignore any unnecessary columns e.g. the balance.





















Once the file is successfully imported the system will save this mapping. There is no need to match the column headers to the fields for every import. 


If the statement template changes in the future, the mapping can be deleted from the Money > Import rules > Mapping menu. Use the reset mapping guide for more help.


Alternatively, to the import tool, you can use the Yodlee feature which will import statements automatically.


For additional help, click here to view all our training options.


Technical support is available on Monday to Friday from 9 - 5. You can call us on 0203 475 4744 or email us at support@clearbooks.co.uk.


Alternatively, visit our Community to view our latest news & updates, raise new ideas, find answers to common problems, ask new queries and speak to other Clear Books users and employees.