| Summary: | option to invert transaction amounts during import | ||
|---|---|---|---|
| Product: | [Applications] kmymoney | Reporter: | harry bennett <kdebugs> |
| Component: | importer | Assignee: | KMyMoney Devel Mailing List <kmymoney-devel> |
| Status: | RESOLVED FIXED | ||
| Severity: | wishlist | CC: | kdebugs, lukasz.wojnilowicz |
| Priority: | NOR | ||
| Version: | 4.7.2 | ||
| Target Milestone: | --- | ||
| Platform: | MacPorts | ||
| OS: | macOS | ||
| Latest Commit: | http://commits.kde.org/kmymoney/94154a8211b40ecc53560c891cd9fd532e4fefce | Version Fixed In: | 5.0 |
| Sentry Crash Report: | |||
| Attachments: | sample csv of how data is provided by credit card company | ||
|
Description
harry bennett
2015-06-11 15:58:47 UTC
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 |