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.
Navigate Money > Bank statements > Import statement.
Under the Import a bank statement from a file heading, select a bank account from the drop-down list Account for import.
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.
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.