Importing CSV bank data that presents incorrectly in KMyMoney

I’ve had great success with Import of CSV files but within the past month a credit card CSV completes with the new imported data defaulting to a single, repeating payee and description. The CSV is correct but does not import and fill correctly. (Ex. Netflix, Entertainment). Netflix is a single monthly charge but I can’t understand why imports creates multiple monthly Netflix entries that should be attributed to other payees.

Are you able to share a cut down CSV file that shows the problem?

Sure. a few minutes.

Screenshot of KMyMoney and the corresponding CSV file from the bank. For some reason KMyM is defaulting to Netflix and it seems like on each import the number of charges/entries being attributed to Netflix is increasing. I have deleted/re-assigned the existing expense category and that did not correct the errors.

The corresponding CSV entries.

Can you post a few lines of the csv as preformatted text us8ng the </> button please? I can test a screen shot. Include the header line abd the line that is not matched as you expect please.

I’m going to guess that Payee matching is the culprit here. If you go to the Payees View (select on the left side of the window,) select Netflix and then the Matching tab. There is probably some entry that happens to match some text (a single space?) in all your csv rows (except for Fort Meyers, unfortunately, can’t match on Fort Meyers since that is text in many other rows.) Depending on whether this is your problem and what the “name” column is for the Netflix entry in your CSV, you might use exact matching for that Payee.

I hope this is what you are looking for.

Interesting thought - I went to Payee and changed the name, and eliminated any spacing in the name as well; did a new import and still the same issue, transactions belonging to other payees attributed to Netflix.

I even exported the account for 2025 where I had good data, deleted the account, re-built it, imported the KMyM CSV file, then did a new import and still the same thing - transactions still appearing as Netflix.

Success!!!

The Payee - Matching area had a “$” that I deleted, as well as the previous account names, and once I tried re-importing the data it is now presenting with the proper Payee.

Thank you all for the support.

ElmerFudd

Thanks for letting us know. You did not need to make any change to Payee Name, just to the Matching string or the matching rule. A dollar sign withing the matching string could easily cause problems. Out of curiosity, where in the string was it located?

There were 3 “$” signs, ^Netflicks Online$ ^Netflix$ and ^$.

That is picture of a GUI screen, not a CSV file.

What I wanted to see was the actual text in the CSV file as it is on disk.

For example here is a the head of one of my CSV files.

$ cat mybank.csv
Date,Details,Transaction Type,In,Out,Balance
27/03/2026,,Account Maintenance Fee,,3.00,4314.79