Bug 397050 - Extend payees to match on different values (besides payee name)
Summary: Extend payees to match on different values (besides payee name)
Status: ASSIGNED
Alias: None
Product: skrooge
Classification: Applications
Component: general (show other bugs)
Version: unspecified
Platform: Other Linux
: NOR wishlist
Target Milestone: 25.1.0
Assignee: Stephane MANKOWSKI
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-08-01 09:41 UTC by Erwin Van de Velde
Modified: 2018-08-01 15:58 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.