How to Import CSV Transactions as Split Entries in KMyMoney

Help
1

Hi everyone,

I’m trying to import a groceries receipt into KMyMoney using the CSV importer. When I manually enter the transaction, I create a split transaction where:

  • Credit: One entry for the total amount in my bank account
  • Debit: Multiple entries for each item in the groceries category

However, when I use the CSV importer, each item appears as a separate transaction in the bank account instead of as part of a single split transaction. I couldn’t find a setting that allows me to replicate the manual entry method.

Is there a way to achieve this through the CSV importer? Or would another import method or tool be better suited for handling split transactions? Any tips or workarounds would be greatly appreciated!

2

CSV does not support split transactions. QIF might be an alternative to try, because it supports them already by the protocol. As usual, your mileage may vary.

3

There are plenty of CSV to QIF tools at csv to qif tool - PrivAU , but possibly it will need some customised code ?

4

I didn’t look at all those links, but none of the ones I did check are free software, so I doubt you can even see their code to customize or modify it. The major issue I see is how to indicate that multiple lines of a csv file are splits of the same transaction rather than separate transactions. Once that is established, someone could probably create a PR to enhance the existing CSV importer to handle it as easily as converting it to QIF or OFX.

5

Thanks for the suggestion. QIF import works for me!