Bank (credit card) providing my import data (CSV, as no other usable format is available by them) shows debits as credits and credits as debits. At present, I open the CSV in a spreadsheet manipulate the amount column (multiply by -1), save my modified version and use that to import into KMM. I propose an 'invert' checkbox into importer dialog while performing the setup.
Are you sure that your bank "shows debits as credits and credits as debits" and not "shows debits and credits as credits" (i.e. all values are positive)? Could you provide sample csv file?
Created attachment 99382 [details] sample csv of how data is provided by credit card company
Pending a proper solution, it might save a little effort when importing to select the present amount column as Debit, and some other column as Credit. Then, when importing, you are given the option to accept either the debit or credit column amount, for each transaction. That's a bit of a fag, but it might be easier. The credit amount would need to be edited after import. Allan
(In reply to harry bennett from comment #2) > Created attachment 99382 [details] > sample csv of how data is provided by credit card company Thanks for the data. Did you already multiply amount column by -1 in that file, because it looks OK to me? Amount "-1915.16" is the only payment in that file and it's imported correctly into KMyMoney under Payment column. Is that not right for you?
No, I did nothing but edit for the foo/bar due to privacy concerns. I'll have to do an import to check. I'll get back to you. The OP is from a year ago, maybe it got fixed?
Git commit 94154a8211b40ecc53560c891cd9fd532e4fefce by Łukasz Wojniłowicz. Committed on 24/06/2016 at 18:41. Pushed by wojnilowicz into branch 'master'. Add checkbox to change amount sings to opposite in CSV Importer REVIEW: 128154 M +124 -111 kmymoney/plugins/csvimport/bankingwizardpage.ui M +22 -0 kmymoney/plugins/csvimport/csvdialog.cpp M +3 -0 kmymoney/plugins/csvimport/csvdialog.h M +6 -0 kmymoney/plugins/csvimport/csvwizard.cpp M +6 -0 kmymoney/plugins/csvimport/csvwizard.h http://commits.kde.org/kmymoney/94154a8211b40ecc53560c891cd9fd532e4fefce