Trying desperately to get my QMac2007 investment data correctly into QMac2019

Unknown
Unknown Member
edited December 2018 in File Conversion and Backup (Mac)
Upon reading about the critical new investment features in QMac2019, I finally decided to try to upgrade from QMac2007.  I am close to despair trying to get my data imported correctly, or at least to understand what the heck the new version is doing with inter-account transactions.  I am so confused about what it's doing that even trying to explain the problem may be fruitless, but I'm going to give it a try, because the alternative is just to get my money back and return to the old version.

For now I am doing everything manually.  I tried setting my primary account to auto, but it only imported 2 years of transactions.  My Q2007 file goes back to 1990-ish, so 2 years is not useful.

In Q2007, I had a single account defined for my brokerage account.  I also had several accounts defined each for a single mutual fund.  Though these funds were (are) held in my brokerage account, I preferred to track them in their own accounts in Quicken.  The new Quicken does not seem to have this type of account, so all my single-fund accounts were imported as brokerage accounts.

If I could simply merge those accounts into my brokerage account, it would solve all my problems.  But I can't find any way to do that.  Is there?

Assuming not: the problem arises whenever there is a BUY or SELL transaction on one of these mutual funds.  For a $1000 BUY, for instance, In the old Quicken I would do the following:
1) In the brokerage account, sell $1000 worth of money market.
2) In the mutual fund account, enter the BUY, and point it to the brokerage account, so the cash would be taken from there.

That is all quite sensible.

In Q2019, here's what the importer left me with:
1) In the brokerage account, there's a Payment/Deposit transaction.  In the Splits, the first column says Transfer: [mutual fund account name].  In the third column, the actual name of the account.  In the fourth column the amount of cash transferred.
2) This is linked to a transaction in the mutual fund account that says BUY zero shares, same dollar value as above.  In the memo, it says "Created based on Deposit of $1000".  In the transaction list, it shows a "-$1000" in the Amount column.

#2 makes no sense to me.  How is "Buy 0 shares" a placeholder for making cash available to purchase real shares?  How come the amount is -$1000, which suggests money going out of the account?  I end up with two consecutive BUY transactions, each showing -$1000, and yet mysteriously the Balance column stays at zero.  I am baffled.

I also cannot delete the transaction in #2, it tells me "this transaction is locked and can't be deleted".  Go To Source takes me back to the transaction describe in #1.

If I delete *that* one (the Payment/Deposit in the brokerage account), both disappear.  Then, if I create a new one that is exactly like the old one, the weird "Buy 0 shares" transaction does not appear in the Mutual Fund account.  So it seems that the importer is doing some special magic to put it there that I can't do myself?

I feel like there is almost zero chance anyone will be able to make any sense of what I'm writing here.

Likewise, there is zero chance I can make any sense of what Quicken is doing.  I don't know how to move forward with this program if I can't understand something so fundamental.

Can anyone help me untangle this mess?

Comments

This discussion has been closed.

Categories