Running the CSV importer on the file that hadfields : Status, Date, Description, Debit, Credit, MemberName Noticed that there were three rows with amounts in the Credit column and all said values where negative! Ran the importer and saw that those three rows were treated as charges. This is really Citi Credit Card issue as they put the values in a Credit column and then used Negative Values!! It would be nice to indicate that the creator of the file has used the opposite sign that would normally be expected. This should be on a column by column basis. As in my example, they put positive values in the Debit column and negative columns in the Credit column. I would want to specify that only the Credit column be treated as opposite to expected values.
This is the same issue as bug 797171, though you propose two different solutions. The multiple column selection in the other bug has my preference, so I'm marking this one as a duplicate. *** This bug has been marked as a duplicate of bug 797171 ***