For amex and diners transactions, they are paid into the bank net of merchant fee. On the bank statement the gross settlement is included on the line part of the general narration. I need to extract this value from the feed so when uploaded for reconciling, both the gross and net settled amounts are visible.

Do you suggest simply to reformat the csv file and convert a cleansed csv?