I am trying to import my retirement fund transactions using CSV file, that has following structure:

Description,Date,Total,Price of a share,Number of shares
Transaction 1,31-07-2009,213.85,27.45,7.7905

In the CSV Import window, I assigned the column names as follows:
Description,Date,None,Price,Deposit

After the import, the price for each transaction is 1 or close to 1 and the "Buy" and "Sell" columns have the exact same 7.7905 value as the 'Shares" column. 

My understanding here is that Price value should be 27.45 as in CSV's "Price of share" column, and the "Buy" and "Sell" should be a result of Price x Shares and be the exact same 213.85 amount as CSV's "Total" column.