Created attachment 153169 [details] export.csv file which will create the error SUMMARY When using the CSV imported to import data from my bank into Kmymoney the payee descriptions on ACH debits are imported incorrectly. The data entered in the payee field is a character string from an old transaction followed by " &". It appears in the payee description field in the database as follows: "JOHNSONS PRODUCE &". The imported CSV file contains different payee data in the payee/data field and the issue is consistent whether the CSV is imported as either an 'amount' based CSV or a 'credit/debit' based CSV. The problem is also evident in previous versions of the Kmymoney CSV importer back to at least 5.1.1. STEPS TO REPRODUCE The CSV file line in question as a 'credit/debit' based CSV file is: 10/4/2022,,ACH Debit PAYPAL INST XFER 022277007290137,,125.50 1. file->import->csv 2. banking->skip setup->select file (export.csv) 3. formats: decimal symbol: dot(.) date format: m d y 4. import CSV 5. select banking account 6. click ok OBSERVED RESULT The first transaction containing a payee description line which contains "ACH Debit" in the payee description field is entered into the kmymoney database as "JOHNSONS PRODUCE &". EXPECTED RESULT The transaction payee description field should be entered into the kmymoney database as "ACH Debit PAYPAL INST XFER 022277007290137" which is what is in the CSV file payee description. SOFTWARE/OS VERSIONS Linux/KDE Plasma: (available in About System) KDE Plasma Version: 5.24.6 KDE Frameworks Version: 5.92.0 Qt Version: 5.15.3 ADDITIONAL INFORMATION a test CSV file has been attached.
I expect this to be the result of a matching operation which is not related to CSV but all import sources. Seems, you have a payee with the name "JOHNSONS PRODUCE &" in your data file. Check the values it matches against, please, and see if you can figure out what happens. See https://docs.kde.org/stable5/en/kmymoney/kmymoney/details.payees.personalinformation.html#details.payees.personalinformation.matching for details about payee matching. Please provide more details about the payee's matching parameters and configuration if you cannot solve the problem.
Thomas, it appears that your suggestion to this being a 'payee matching issue' was correct. I checked my payee data list and there was indeed an entry there for "JOHNSONS PRODUCE &" in the listing. Before I removed it, I tested the import function using the ofx importer with a *.qfx file containing the problem data and it produced the same result as the csv importer. I then removed the questionable payee entry, tested again, and the problem was cleared. Since then, I haven't seen a re-ocurrance of this issue. So the issue seems to be resolved. Thank you for the pointer as to where to look.