Bug 349033

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
Attachments:	sample csv of how data is provided by credit card company

Description harry bennett 2015-06-11 15:58:47 UTC

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.

Comment 1 NSLW 2016-06-05 13:57:18 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?

Comment 2 harry bennett 2016-06-05 14:30:50 UTC

Created attachment 99382 [details]
sample csv of how data is provided by credit card company

Comment 3 allan 2016-06-06 12:17:34 UTC

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

Comment 4 NSLW 2016-06-08 16:50:43 UTC

(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?

Comment 5 harry bennett 2016-06-08 22:25:11 UTC

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?

Comment 6 NSLW 2016-06-24 18:45:36 UTC

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