1.Download the transactions from your online banking facility as a CSV file (ensure that the first row of data on the CSV file is either the header of the transactions, or the first transaction, by deleting any other data above if required).
2.Select Transaction > Universal Input Sheet > Import from:CSV File (Alternatively, you can copy the transactions directly from the file then go back into the Import screen and select Transaction > Universal Input Sheet > Import from: Clipboard):
3.The import dialog opens, prompting you to select the CSV file; locate the file and select Open.
4.On the import screen that opens; make sure Bank statement options is selected:
5.If the first row of your CSV file contains the header of the transactions, tick First row of data contains column headers.
6.Assign the VT data type to each of the columns of your bank statement, by selecting from the list above each of the columns. Select the relevant data type from each list. Normally, you only need to import the following types of data from your statement:
•Date
•Description/Details
•Payment
•Receipt
7.For any other columns in your bank statement that are not to be imported select Not imported.
8.Once you have specified the columns, select OK.
9.The data then appears on the UIS. By default the data in the Primary account column is Current Account, but you can change this for a cell by double-clicking on it. To change it or the entire column, select the column, right-click and select Set, then select the account you wish to change it to.
10.On the UIS, select the accounts in the Analysis account column, by double-clicking on the cells. These accounts are the other side of the double entry for each bank transaction. To set the analysis account based on previous similar transactions, select a range of cells or the entire Analysis account column, right-click and choose AutoComplete from the pop-up menu (or hold down the Ctrl key and double click on a single cell). For more details, see AutoComplete below.
11.If any VAT needs to be accounted for, this can be entered in the VAT column, and the Analysis column will re-calculate accordingly to the net amount.
12.Alternatively, steps 6. and 7. can be bypassed by arranging the data directly on the CSV file/spreadsheet. The transactions in your CSV file/spreadsheet should be laid out in the same way as shown in the screenshot in Step 9. You can also populate the data required in steps 10. and 11. directly on the CSV file/spreadsheet. You can then either import the CSV file or copy the data from the spreadsheet and paste directly onto the UIS.
13.Once you are happy with the data to be imported, select Post.
As mentioned in step 10. you can use the AutoComplete function to populate the Analysis account column if there is data in the Details field that is the same as transactions previously posted.
AutoComplete works as follows. If a transaction has been posted before that contains a specific word in the beginning of the details field, clicking on AutoComplete in the Analysis account field will recall the same Analysis account used for the original transaction.
For example, if a previous transaction has the word Shop at the beginning of the Details field, and the Analysis account is Supplier: Tesco, then the next time a transaction is entered with the word Shop at the beginning of the Details field, selecting AutoComplete in the Analysis account field will recall Supplier: Tesco.
For the software to recognise the link, the word Shop must be at the beginning of the Details field.
The word does not need to be in isolation. For example, if a transaction contained the text Shop 123 in the beginning of the Details field, AutoComplete would recognise the Analysis account as being associated with the word Shop.
If AutoComplete does not recognise text from previous transactions, this is probably due to a slight difference between the source data and the previously entered text. This can sometimes be due to a change in formatting in the source data from the bank.
