This forum has been archived. All content is frozen. Please use KDE Discuss instead.

How to match(?) 2 transactions from 2 different CSV imports?

Tags: None
(comma "," separated)
kde-kraken
Registered Member
Posts
3
Karma
0
Hello,

I'm looking for an advice.

I independently download 2 separate CVS files for my:
1) checking account
2) credit card

After the imports, paying off my credit card, which I do from the checking account, shows as 2 independent transactions in corresponding ledgers. The overall balance of my finances is correct, but in "Income and Expenses report", paying off the credit card shows as a type of income.

What do I need to do, so that KMyMoney morphs those 2 transactions into a single transfer between 2 of my own accounts?

Thanks in advance for any advice
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS
Make the expense a transfer from the checking to the credit-card account by replacing a possible existing category assignment with the credit-card account. Simply deleting the second transaction solves the problem, but may have some drawbacks, e.g. re-importing the CSV may re-create the transaction. Using the 'match transaction' feature may solve this.

Hope that helps.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
kde-kraken
Registered Member
Posts
3
Karma
0
Hi,

Thanks so much for the quick response!

I did try to manually convert one of those transactions into a transfer but the GUI doesn't let me do it.
After clicking Edit on one of those transactions, out of the 3 tabs inside transaction edit panel, "Transfer" is grayed out and not clickable.
If I try to change the category inside the "Payment" tab, there's very few options and none of them are accounts. They are just expense categories.

As far as the matching functionality is concerned, I tried to read the documentation https://docs.kde.org/stable5/en/extragear-office/kmymoney/details.ledgers.match.html. Since I have to multi-select both transactions with Ctrl pressed, I don't know how to do it in different ledgers.
I can have them in one list, by using search transactions functionality, but this view doesn't allow me to match.

I'm using KMyMoney Version 5.0.6
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS
The GUI will let you do it, but not the way you tried :)

Simply override the category with the (credit-card) account name. You can get the full list of all accounts and categories by double clicking on the down-arrow of the combo-box or by deleting the category name. BTW: Once you have the credit-card name and tab out of the field, KMyMoney will magically select the transfer tab.

Once you have the transfer setup, you can switch to the other side of the transaction (credit-card account) by simply using the right mouse button and select 'Goto <account-name>'. That should directly select the same transaction in the ledger of the 'other' account. There you will have access to both transactions and can select them for matching.

Hope that helps. If something is unclear, feel free to ask.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
kde-kraken
Registered Member
Posts
3
Karma
0
Awesome!
It did let me do it ;D
Thanks so much. Double clicking did the magic.

I'm super excited about how fast I got the answer from this forum.

Thanks for your support.


Bookmarks



Who is online

Registered users: bartoloni, Bing [Bot], Evergrowing, Google [Bot], ourcraft