Bug 397050

Summary:	Extend payees to match on different values (besides payee name)
Product:	[Applications] skrooge	Reporter:	Erwin Van de Velde <erwin.vandevelde>
Component:	general	Assignee:	Stephane MANKOWSKI <stephane>
Status:	ASSIGNED ---
Severity:	wishlist	CC:	stephane
Priority:	NOR
Version First Reported In:	unspecified
Target Milestone:	25.1.0
Platform:	Other
OS:	Linux
Latest Commit:		Version Fixed In:
Sentry Crash Report:

Description Erwin Van de Velde 2018-08-01 09:41:45 UTC

E.g. My Belgian bank only allows CSV exports and the payee field in the CSV is the bank account number. In the details field there is -among other things, badly formatted- the full name. What I would like to do is to make the link between account number and name the first time such an import for a payee occurs and afterwards see the name of the payee in the operations instead of the bank account number.

When you look at the competition (kmymoney :) ) :
https://docs.kde.org/trunk5/en/extragear-office/kmymoney/details.payees.personalinformation.html
--> Transaction Matching Settings

Something like that is what I am looking for.

Search & Process can be used, but feels convoluted (extra clicks etc) and you lose information: later on you cannot find the bank account number for that payee anymore unless you go through all search & process rules. Since these rules (in this case) really belong to the payee, it would be better to group that information in the payee window.

Comment 1 Stephane MANKOWSKI 2018-08-01 13:25:23 UTC

I don't really understand why "Search & Process" couldn't do the job.
Could you send me an example of CSV file (4 or 5 lines) and the expected result in Skrooge?

Comment 2 Erwin Van de Velde 2018-08-01 15:58:44 UTC

2018-0121;16/07/2018;15/07/2018;00.00;EUR;BEXXXXXXXXXXXXXX;FIRSTNAME LASTNAME ADDRESS BEXX XXXX XXXX XXXX  BIC YYYYYYYY COMMENT : DESCRIPTION VALUTADATUM : 15/07/2018;BEZZZZZZZZZZZZZZ
2018-0120;16/07/2018;16/07/2018;00.00;EUR;PAYEE DESCRIPTION;TERMINAL NR.XXXXXX DATE : 14-07-2018VALUTADATUM : 16/07/2018;BEZZZZZZZZZZZZZZ
2018-0119;15/07/2018;14/07/2018;-00.00;EUR;PAYMENT WITH CARD          ;WITH CARD XXXX XXXX XXXX XXXX X PAYEE  ADDRESS14/07/2018 EXECUTED ON 14-07 VALUTADATUM : 14/07/2018;BEZZZZZZZZZZZZZZ
2018-0118;15/07/2018;15/07/2018;-00.00;EUR;BEXXXXXXXXXXXXX;PAYEE BEXX XXXX XXXX XXXX  BIC YYYYYYYYCOMMENT : 000000000000 VALUTADATUM : 15/07/2018;BEZZZZZZZZZZZZZZ

Anonymized, but you get it :) with XXXX is payee, ZZZZ is my account. The 6th field should be replaced with a name where possible (PAYMENT WITH CARD can never be replaced automatically with the right payee of course)

While Search & Process will do the trick, it is in my opinion not the place for this information. Ideally, the operations tab would show the payee's name and when you click on (hover over it) it, you see the payee table with the link name -> account number. This way, it feels more logical and you can still trace the payee's bank account number easily.