Thank you for the suggestion.  I will check out this functionality however I it will not work for me.

My CSV value has over 5 lines.  In fact I split the single transaction into 15 different lines based on class, location, account and amount.  

The amount is different every time.  So I cannot use a standard percentage or a fixed value.