Import improvements

netr@cer's Avatar


18 Jan, 2023 04:44 AM

As a followup of my migration from Quicken to Moneydance, I'd like to raise a consistent weakness concerning the import of split transactions which have multiple split lines going to the same account (or category). It sounds odd, but with tagging this makes some sense. For example....

I purchase 4 cases of beer totaling $100. One for myself and three for my friends because they drink more than me (not really, but work with me). The split looks something like this (brackets signify account transfer in Quicken):

Transaction Date: Beer Store : SPLIT : $100
Split Amount : Category : Tag
$25 - Food - Liquor : <none>
$25 - [Temp Hold] : Bob
$50 - [Temp Hold] : John

The [Temp Hold] account ensures I collect $75.00 from my friends for beer I bought them. $25 from Bob and $50 from John. When Bob pays me back I put $25 into cash as a transfer from [Temp Hold]. If I have a balance in Temp Hold it means someone owes me money.

When importing from Quicken the transaction and splits get created appropriately, BUT one additional transfer transaction gets created as well, which seems to be a summarization of amounts that are headed to the same account. So in the above example there would be a $75 transfer to Temp Hold on top of the actual split transactions. This results in an extra 75 in Temp Hold and a reduction of $75 in the source account.

It is not difficult to fix (simply delete the additional transaction), but it is tedious to find especially when you have a lot of these transactions in a lot of different accounts. And if memory serves (I'm not 100% on this) the new transaction had the clear flag enabled and the existing split transaction did not.

Import was completed using QIF format (all accounts, all dates, all options checked except memorized transactions on export) and MD v2022.5

  1. System closed this discussion on 19 Apr, 2023 04:50 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac