(Canadian

Your clarification really helps. Thank you.neilw said:Thanks for the reply. A few points of clarification:
1) In Quicken 2007, I was doing everything manually. No importing of anything from anywhere. So, even though I had my funds held in a brokerage account, I had them separate in Quicken, and I entered relevant transactions in the appropriate register.
2) My plan was to do everything manually in Quicken 2019 as well, at least to get started. A chat agent at Quicken suggested I try starting from scratch with automatic. I tried that, and that's when I got the two years of data. I'd be happy (maybe) to start off manually to fill in the old data, and then turn on auto updates. However, it is not clear how I can do that, since there doesn't seem to be any way to take my old imported data (in separate accounts) and them merge them into the brokerage account.
But anyway, I basically discarded the file with the automatic updates, because with only two years of data it's basically useless. So all the rest of my questions regard the files where I did indeed start with a fresh file and then import from Q2007.
3) Yes, it appears that the lack of ability to combine transfers and buys/sells is an important limitation of Q2019. It makes having separate accounts for the mutual funds less appealing, because buy or sell transactions now require and extra transaction to be entered. But I don't understand where those "linked" transactions came from, since I don't seem to be able to enter them myself. The "Balance" column staying at zero during all these shenanigans (in the Mutual Fund account) also continues to mystify me.
4) Not mentioned in my original post is the fact that Q2019 flat out screwed up importing many of those buy/sell transactions, in various ways. That is why I need, at a minimum, to go through every buy/sell transaction and make sure they're all correct, and in many cases re-enter them.
It sounds like the most sensible approach going forward would be to combine the mutual funds back into brokerage account. Is there any way to do this in Q2019? I could find neither a function to merge accounts, nor to move transactions from one account to the other.
Thanks again for slogging through all this.
Yeah, I really do want that older data, at least for securities I still hold. I need to be able to track tax lots and such.neilw said:Thanks for the reply. A few points of clarification:
1) In Quicken 2007, I was doing everything manually. No importing of anything from anywhere. So, even though I had my funds held in a brokerage account, I had them separate in Quicken, and I entered relevant transactions in the appropriate register.
2) My plan was to do everything manually in Quicken 2019 as well, at least to get started. A chat agent at Quicken suggested I try starting from scratch with automatic. I tried that, and that's when I got the two years of data. I'd be happy (maybe) to start off manually to fill in the old data, and then turn on auto updates. However, it is not clear how I can do that, since there doesn't seem to be any way to take my old imported data (in separate accounts) and them merge them into the brokerage account.
But anyway, I basically discarded the file with the automatic updates, because with only two years of data it's basically useless. So all the rest of my questions regard the files where I did indeed start with a fresh file and then import from Q2007.
3) Yes, it appears that the lack of ability to combine transfers and buys/sells is an important limitation of Q2019. It makes having separate accounts for the mutual funds less appealing, because buy or sell transactions now require and extra transaction to be entered. But I don't understand where those "linked" transactions came from, since I don't seem to be able to enter them myself. The "Balance" column staying at zero during all these shenanigans (in the Mutual Fund account) also continues to mystify me.
4) Not mentioned in my original post is the fact that Q2019 flat out screwed up importing many of those buy/sell transactions, in various ways. That is why I need, at a minimum, to go through every buy/sell transaction and make sure they're all correct, and in many cases re-enter them.
It sounds like the most sensible approach going forward would be to combine the mutual funds back into brokerage account. Is there any way to do this in Q2019? I could find neither a function to merge accounts, nor to move transactions from one account to the other.
Thanks again for slogging through all this.
Investment transactions = *all* my transactions. That's all I use Quicken for.Not sure how useful this suggestion will be and YMMV on this but one unique capability of modern QMac is that it can import multiple QM2007 files and combine them into one QM2019 file. So you could create a version of your QM2007 data file with just your investment transactions and them import them into an existing QM2019 data file. I know this works for transactional data; not sure how well it works for investment transaction data.
(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)
That's a reasonable approach.JM said:@neilw
Reviewing the info you have posted - the Single Mutual Fund (SMF) accounts in your QMac2007 file are a major obstacle to converting to the newer QMac product. Specifically, the new QMac does not support nor recognize the combination "X" transactions - BoughtX. SoldX, DivX, etc. - that are associated with the use of SMF accounts. QMac makes an attempt to interpret and convert these transactions, but as you have noted, the results make no sense.
My recommendation would be to focus on cleaning up the QMac2007 file by eliminating the SMF accounts. You did indicate that these SMF holdings were actually part of your regular brokerage account - let's move them back to where they really belong while getting a file that can be converted.
The cleanup will be most easily done in QMac2007 using the Cut/Paste to move the investment transactions from the SMF accounts to your regular brokerage account. The newer QMac does not have the Cut/Patse (or Copy/Patste) feature, nor can one move investment transactions using Drag/Drop. Thus the editing will be much quicker and easier, with less chance for error, in QMac2007.
Do make frequent backups as you proceed. An effort of this magnitude provides many opportunities for a "shot to the foot" - give yourself safe retreats along the way.
Good Luck.
That is a question only you can truly answer - likely after you have used the product for a time. Each individual user has his/her own priorities.JM said:@neilw
Reviewing the info you have posted - the Single Mutual Fund (SMF) accounts in your QMac2007 file are a major obstacle to converting to the newer QMac product. Specifically, the new QMac does not support nor recognize the combination "X" transactions - BoughtX. SoldX, DivX, etc. - that are associated with the use of SMF accounts. QMac makes an attempt to interpret and convert these transactions, but as you have noted, the results make no sense.
My recommendation would be to focus on cleaning up the QMac2007 file by eliminating the SMF accounts. You did indicate that these SMF holdings were actually part of your regular brokerage account - let's move them back to where they really belong while getting a file that can be converted.
The cleanup will be most easily done in QMac2007 using the Cut/Paste to move the investment transactions from the SMF accounts to your regular brokerage account. The newer QMac does not have the Cut/Patse (or Copy/Patste) feature, nor can one move investment transactions using Drag/Drop. Thus the editing will be much quicker and easier, with less chance for error, in QMac2007.
Do make frequent backups as you proceed. An effort of this magnitude provides many opportunities for a "shot to the foot" - give yourself safe retreats along the way.
Good Luck.
To help you in that decision making and be sure to understand if it will meet your needs, you can read a lot more about the differences here:neilw said:Thanks for the reply. A few points of clarification:
1) In Quicken 2007, I was doing everything manually. No importing of anything from anywhere. So, even though I had my funds held in a brokerage account, I had them separate in Quicken, and I entered relevant transactions in the appropriate register.
2) My plan was to do everything manually in Quicken 2019 as well, at least to get started. A chat agent at Quicken suggested I try starting from scratch with automatic. I tried that, and that's when I got the two years of data. I'd be happy (maybe) to start off manually to fill in the old data, and then turn on auto updates. However, it is not clear how I can do that, since there doesn't seem to be any way to take my old imported data (in separate accounts) and them merge them into the brokerage account.
But anyway, I basically discarded the file with the automatic updates, because with only two years of data it's basically useless. So all the rest of my questions regard the files where I did indeed start with a fresh file and then import from Q2007.
3) Yes, it appears that the lack of ability to combine transfers and buys/sells is an important limitation of Q2019. It makes having separate accounts for the mutual funds less appealing, because buy or sell transactions now require and extra transaction to be entered. But I don't understand where those "linked" transactions came from, since I don't seem to be able to enter them myself. The "Balance" column staying at zero during all these shenanigans (in the Mutual Fund account) also continues to mystify me.
4) Not mentioned in my original post is the fact that Q2019 flat out screwed up importing many of those buy/sell transactions, in various ways. That is why I need, at a minimum, to go through every buy/sell transaction and make sure they're all correct, and in many cases re-enter them.
It sounds like the most sensible approach going forward would be to combine the mutual funds back into brokerage account. Is there any way to do this in Q2019? I could find neither a function to merge accounts, nor to move transactions from one account to the other.
Thanks again for slogging through all this.
Thanks, that led me to the page of hindrances to migrate from Q2007... and I saw the bit about incompatibility of Q2007 with auto-backups and APFS. I just upgrade to Mojave and it upgraded my Fusion drive to APFS for the first time, and I have gotten my first Q2007 crash. At the time I didn't realize what it was.neilw said:Thanks for the reply. A few points of clarification:
1) In Quicken 2007, I was doing everything manually. No importing of anything from anywhere. So, even though I had my funds held in a brokerage account, I had them separate in Quicken, and I entered relevant transactions in the appropriate register.
2) My plan was to do everything manually in Quicken 2019 as well, at least to get started. A chat agent at Quicken suggested I try starting from scratch with automatic. I tried that, and that's when I got the two years of data. I'd be happy (maybe) to start off manually to fill in the old data, and then turn on auto updates. However, it is not clear how I can do that, since there doesn't seem to be any way to take my old imported data (in separate accounts) and them merge them into the brokerage account.
But anyway, I basically discarded the file with the automatic updates, because with only two years of data it's basically useless. So all the rest of my questions regard the files where I did indeed start with a fresh file and then import from Q2007.
3) Yes, it appears that the lack of ability to combine transfers and buys/sells is an important limitation of Q2019. It makes having separate accounts for the mutual funds less appealing, because buy or sell transactions now require and extra transaction to be entered. But I don't understand where those "linked" transactions came from, since I don't seem to be able to enter them myself. The "Balance" column staying at zero during all these shenanigans (in the Mutual Fund account) also continues to mystify me.
4) Not mentioned in my original post is the fact that Q2019 flat out screwed up importing many of those buy/sell transactions, in various ways. That is why I need, at a minimum, to go through every buy/sell transaction and make sure they're all correct, and in many cases re-enter them.
It sounds like the most sensible approach going forward would be to combine the mutual funds back into brokerage account. Is there any way to do this in Q2019? I could find neither a function to merge accounts, nor to move transactions from one account to the other.
Thanks again for slogging through all this.
The automatic backup issue with Mojave (and High Sierra) is not a show stopper. There are work-arounds for that feature if you really want it, i.e. move the data file and backups to a HFS+ (MacOS Extended) formatted drive or partition. Otherwise, QM2007 is quite stable with these macOSes.neilw said:Thanks for the reply. A few points of clarification:
1) In Quicken 2007, I was doing everything manually. No importing of anything from anywhere. So, even though I had my funds held in a brokerage account, I had them separate in Quicken, and I entered relevant transactions in the appropriate register.
2) My plan was to do everything manually in Quicken 2019 as well, at least to get started. A chat agent at Quicken suggested I try starting from scratch with automatic. I tried that, and that's when I got the two years of data. I'd be happy (maybe) to start off manually to fill in the old data, and then turn on auto updates. However, it is not clear how I can do that, since there doesn't seem to be any way to take my old imported data (in separate accounts) and them merge them into the brokerage account.
But anyway, I basically discarded the file with the automatic updates, because with only two years of data it's basically useless. So all the rest of my questions regard the files where I did indeed start with a fresh file and then import from Q2007.
3) Yes, it appears that the lack of ability to combine transfers and buys/sells is an important limitation of Q2019. It makes having separate accounts for the mutual funds less appealing, because buy or sell transactions now require and extra transaction to be entered. But I don't understand where those "linked" transactions came from, since I don't seem to be able to enter them myself. The "Balance" column staying at zero during all these shenanigans (in the Mutual Fund account) also continues to mystify me.
4) Not mentioned in my original post is the fact that Q2019 flat out screwed up importing many of those buy/sell transactions, in various ways. That is why I need, at a minimum, to go through every buy/sell transaction and make sure they're all correct, and in many cases re-enter them.
It sounds like the most sensible approach going forward would be to combine the mutual funds back into brokerage account. Is there any way to do this in Q2019? I could find neither a function to merge accounts, nor to move transactions from one account to the other.
Thanks again for slogging through all this.
Actually, after going and trying this, I cannot figure out how to move transactions from one account to another in Q2007. There seems to be no way to copy, paste, or move a transaction.JM said:@neilw
Reviewing the info you have posted - the Single Mutual Fund (SMF) accounts in your QMac2007 file are a major obstacle to converting to the newer QMac product. Specifically, the new QMac does not support nor recognize the combination "X" transactions - BoughtX. SoldX, DivX, etc. - that are associated with the use of SMF accounts. QMac makes an attempt to interpret and convert these transactions, but as you have noted, the results make no sense.
My recommendation would be to focus on cleaning up the QMac2007 file by eliminating the SMF accounts. You did indicate that these SMF holdings were actually part of your regular brokerage account - let's move them back to where they really belong while getting a file that can be converted.
The cleanup will be most easily done in QMac2007 using the Cut/Paste to move the investment transactions from the SMF accounts to your regular brokerage account. The newer QMac does not have the Cut/Patse (or Copy/Patste) feature, nor can one move investment transactions using Drag/Drop. Thus the editing will be much quicker and easier, with less chance for error, in QMac2007.
Do make frequent backups as you proceed. An effort of this magnitude provides many opportunities for a "shot to the foot" - give yourself safe retreats along the way.
Good Luck.
Perhaps I made a bad assumption - assuming that one could Cut(or Copy)/Paste investment transactions in QMac2007.JM said:@neilw
Reviewing the info you have posted - the Single Mutual Fund (SMF) accounts in your QMac2007 file are a major obstacle to converting to the newer QMac product. Specifically, the new QMac does not support nor recognize the combination "X" transactions - BoughtX. SoldX, DivX, etc. - that are associated with the use of SMF accounts. QMac makes an attempt to interpret and convert these transactions, but as you have noted, the results make no sense.
My recommendation would be to focus on cleaning up the QMac2007 file by eliminating the SMF accounts. You did indicate that these SMF holdings were actually part of your regular brokerage account - let's move them back to where they really belong while getting a file that can be converted.
The cleanup will be most easily done in QMac2007 using the Cut/Paste to move the investment transactions from the SMF accounts to your regular brokerage account. The newer QMac does not have the Cut/Patse (or Copy/Patste) feature, nor can one move investment transactions using Drag/Drop. Thus the editing will be much quicker and easier, with less chance for error, in QMac2007.
Do make frequent backups as you proceed. An effort of this magnitude provides many opportunities for a "shot to the foot" - give yourself safe retreats along the way.
Good Luck.
I'm actually a bit shocked not to see it there....JM said:@neilw
Reviewing the info you have posted - the Single Mutual Fund (SMF) accounts in your QMac2007 file are a major obstacle to converting to the newer QMac product. Specifically, the new QMac does not support nor recognize the combination "X" transactions - BoughtX. SoldX, DivX, etc. - that are associated with the use of SMF accounts. QMac makes an attempt to interpret and convert these transactions, but as you have noted, the results make no sense.
My recommendation would be to focus on cleaning up the QMac2007 file by eliminating the SMF accounts. You did indicate that these SMF holdings were actually part of your regular brokerage account - let's move them back to where they really belong while getting a file that can be converted.
The cleanup will be most easily done in QMac2007 using the Cut/Paste to move the investment transactions from the SMF accounts to your regular brokerage account. The newer QMac does not have the Cut/Patse (or Copy/Patste) feature, nor can one move investment transactions using Drag/Drop. Thus the editing will be much quicker and easier, with less chance for error, in QMac2007.
Do make frequent backups as you proceed. An effort of this magnitude provides many opportunities for a "shot to the foot" - give yourself safe retreats along the way.
Good Luck.
I can confirm that there is no move function for investment transactions in QM2007.JM said:@neilw
Reviewing the info you have posted - the Single Mutual Fund (SMF) accounts in your QMac2007 file are a major obstacle to converting to the newer QMac product. Specifically, the new QMac does not support nor recognize the combination "X" transactions - BoughtX. SoldX, DivX, etc. - that are associated with the use of SMF accounts. QMac makes an attempt to interpret and convert these transactions, but as you have noted, the results make no sense.
My recommendation would be to focus on cleaning up the QMac2007 file by eliminating the SMF accounts. You did indicate that these SMF holdings were actually part of your regular brokerage account - let's move them back to where they really belong while getting a file that can be converted.
The cleanup will be most easily done in QMac2007 using the Cut/Paste to move the investment transactions from the SMF accounts to your regular brokerage account. The newer QMac does not have the Cut/Patse (or Copy/Patste) feature, nor can one move investment transactions using Drag/Drop. Thus the editing will be much quicker and easier, with less chance for error, in QMac2007.
Do make frequent backups as you proceed. An effort of this magnitude provides many opportunities for a "shot to the foot" - give yourself safe retreats along the way.
Good Luck.
Nor in QM2019!JM said:@neilw
Reviewing the info you have posted - the Single Mutual Fund (SMF) accounts in your QMac2007 file are a major obstacle to converting to the newer QMac product. Specifically, the new QMac does not support nor recognize the combination "X" transactions - BoughtX. SoldX, DivX, etc. - that are associated with the use of SMF accounts. QMac makes an attempt to interpret and convert these transactions, but as you have noted, the results make no sense.
My recommendation would be to focus on cleaning up the QMac2007 file by eliminating the SMF accounts. You did indicate that these SMF holdings were actually part of your regular brokerage account - let's move them back to where they really belong while getting a file that can be converted.
The cleanup will be most easily done in QMac2007 using the Cut/Paste to move the investment transactions from the SMF accounts to your regular brokerage account. The newer QMac does not have the Cut/Patse (or Copy/Patste) feature, nor can one move investment transactions using Drag/Drop. Thus the editing will be much quicker and easier, with less chance for error, in QMac2007.
Do make frequent backups as you proceed. An effort of this magnitude provides many opportunities for a "shot to the foot" - give yourself safe retreats along the way.
Good Luck.
For my clarification - in QMac2007, one can not use Cut/Paste (or Copy/Paste) to effectively move investment transactions?JM said:@neilw
Reviewing the info you have posted - the Single Mutual Fund (SMF) accounts in your QMac2007 file are a major obstacle to converting to the newer QMac product. Specifically, the new QMac does not support nor recognize the combination "X" transactions - BoughtX. SoldX, DivX, etc. - that are associated with the use of SMF accounts. QMac makes an attempt to interpret and convert these transactions, but as you have noted, the results make no sense.
My recommendation would be to focus on cleaning up the QMac2007 file by eliminating the SMF accounts. You did indicate that these SMF holdings were actually part of your regular brokerage account - let's move them back to where they really belong while getting a file that can be converted.
The cleanup will be most easily done in QMac2007 using the Cut/Paste to move the investment transactions from the SMF accounts to your regular brokerage account. The newer QMac does not have the Cut/Patse (or Copy/Patste) feature, nor can one move investment transactions using Drag/Drop. Thus the editing will be much quicker and easier, with less chance for error, in QMac2007.
Do make frequent backups as you proceed. An effort of this magnitude provides many opportunities for a "shot to the foot" - give yourself safe retreats along the way.
Good Luck.
Do post back your overall results when you are done.neilw said:Well I got one account's transactions merged into the main brokerage account, by manually re-entering them all. That was not what I would call a whole lot of fun.
Several more to go, but most of the rest have a lot fewer transactions so should go quicker.
4 accounts down so far, many to go. I decided that even for old accounts that are now empty, I was going to merge them in, because they are just as likely to incur import mistakes as the active accounts. And I do want to keep the historical data, though I did give a bit of thought to just deleting them entirely and moving on.neilw said:Well I got one account's transactions merged into the main brokerage account, by manually re-entering them all. That was not what I would call a whole lot of fun.
Several more to go, but most of the rest have a lot fewer transactions so should go quicker.
Glad you sorted it out. Just for reference for anyone else reading, here is a FAQ about placeholders:neilw said:This reply was created from a merged topic originally titled Status report: finished importing my QMac2007 investment data into QMac2019.
Here's my final(?) status report. Thanks to the mods for putting this back into its original thread.
The first thing I did was to merge the transactions from all my individual mutual fund accounts into the brokerage account where those funds are held. Because there was no way to actually transfer the transactions, I had to re-enter all of them. All I can say about that is: thank god I'm not an active trader. That was incredibly tedious and really had me questioning my life choices. But I got it done eventually.
At that point the import into QMac2019 worked.... mostly OK I guess.
My registers were now about 2 months out of date. So I thought I'd try taking advantage of automatic downloads (in the past I always did everything manually). Got it set up, and then... it only downloaded the last week or two of transactions. If there was a way to force it to load everything since my last manually-entered transaction, I couldn't figure out what that might be. Worse, though, everything was entered as literal translations of what was downloaded. That's all you could reasonably expect it to do, but it's not what I wanted. For instance, TDA lists divident re-investments as two transactions: a dividend and then a purchase (and sometimes there are MM sweeps and sales interspersed in there). That certainly works and is technically correct, but it also makes a mess of the register. I've always entered those as a single reinvest transaction. There were other small issues not worth going into.
At this point I needed a sanity break and walked away for a while.
This week I decided to get things in order. So I deleted all the downloaded transactions, turned off automatic updates, and went back to the way I used to do it. I find entering the transactions in Q2019 to be a mixed bag. Although it is a lot prettier, it also in some areas takes a lot more keystrokes and/or mouse interactions to enter a transaction. Entering MMF transactions is particularly annoying; because it seems you must enter dollar value and number of shares. For MMFs where the share value is (almost) always $1, that means needing to enter the same number twice. In the old Quicken, I could just enter the dollar value and a quick "1" for the share value, and then it fills in the number of shares. Oh well.
I also discovered that, presumably when I did my automatic transaction download, Quicken added a bunch of "add shares" transactions to the beginning of my ledger to get the share balances to square up. It took me a long time and a lot of hair pulling to discover those were there, because of course I didn't want them.
Now, as far as I can tell, everything is up-to-date. I have a pretty, modern, Mac-native UI, with a mixed bag of functionality. Better in some areas, lacking in others. Thanks to the poster in the previous thread who mentioned customizing the columns in the register, that certainly has proved to be helpful. Overall it's a wash I guess. I am at least encouraged that the app is under active development.
Oh, an finally: sometimes it takes me several seconds to switch from the Register view to the Portfolio view. Geez.
@neilwneilw said:This reply was created from a merged topic originally titled Status report: finished importing my QMac2007 investment data into QMac2019.
Here's my final(?) status report. Thanks to the mods for putting this back into its original thread.
The first thing I did was to merge the transactions from all my individual mutual fund accounts into the brokerage account where those funds are held. Because there was no way to actually transfer the transactions, I had to re-enter all of them. All I can say about that is: thank god I'm not an active trader. That was incredibly tedious and really had me questioning my life choices. But I got it done eventually.
At that point the import into QMac2019 worked.... mostly OK I guess.
My registers were now about 2 months out of date. So I thought I'd try taking advantage of automatic downloads (in the past I always did everything manually). Got it set up, and then... it only downloaded the last week or two of transactions. If there was a way to force it to load everything since my last manually-entered transaction, I couldn't figure out what that might be. Worse, though, everything was entered as literal translations of what was downloaded. That's all you could reasonably expect it to do, but it's not what I wanted. For instance, TDA lists divident re-investments as two transactions: a dividend and then a purchase (and sometimes there are MM sweeps and sales interspersed in there). That certainly works and is technically correct, but it also makes a mess of the register. I've always entered those as a single reinvest transaction. There were other small issues not worth going into.
At this point I needed a sanity break and walked away for a while.
This week I decided to get things in order. So I deleted all the downloaded transactions, turned off automatic updates, and went back to the way I used to do it. I find entering the transactions in Q2019 to be a mixed bag. Although it is a lot prettier, it also in some areas takes a lot more keystrokes and/or mouse interactions to enter a transaction. Entering MMF transactions is particularly annoying; because it seems you must enter dollar value and number of shares. For MMFs where the share value is (almost) always $1, that means needing to enter the same number twice. In the old Quicken, I could just enter the dollar value and a quick "1" for the share value, and then it fills in the number of shares. Oh well.
I also discovered that, presumably when I did my automatic transaction download, Quicken added a bunch of "add shares" transactions to the beginning of my ledger to get the share balances to square up. It took me a long time and a lot of hair pulling to discover those were there, because of course I didn't want them.
Now, as far as I can tell, everything is up-to-date. I have a pretty, modern, Mac-native UI, with a mixed bag of functionality. Better in some areas, lacking in others. Thanks to the poster in the previous thread who mentioned customizing the columns in the register, that certainly has proved to be helpful. Overall it's a wash I guess. I am at least encouraged that the app is under active development.
Oh, an finally: sometimes it takes me several seconds to switch from the Register view to the Portfolio view. Geez.
Neil, does your portfolio view show a line graph across the top? It’s there by default, but it takes awhile for Quicken to calculate. If you want, you can hide the graph and the time delay disappears. The trick to hiding the graph is noticing a small dot below the center of the graph. Click and drag it upward and the graph will shrink; keep dragging up and it will eventually disappear. Now switching between accounts should go quickly.neilw said:This reply was created from a merged topic originally titled Status report: finished importing my QMac2007 investment data into QMac2019.
Here's my final(?) status report. Thanks to the mods for putting this back into its original thread.
The first thing I did was to merge the transactions from all my individual mutual fund accounts into the brokerage account where those funds are held. Because there was no way to actually transfer the transactions, I had to re-enter all of them. All I can say about that is: thank god I'm not an active trader. That was incredibly tedious and really had me questioning my life choices. But I got it done eventually.
At that point the import into QMac2019 worked.... mostly OK I guess.
My registers were now about 2 months out of date. So I thought I'd try taking advantage of automatic downloads (in the past I always did everything manually). Got it set up, and then... it only downloaded the last week or two of transactions. If there was a way to force it to load everything since my last manually-entered transaction, I couldn't figure out what that might be. Worse, though, everything was entered as literal translations of what was downloaded. That's all you could reasonably expect it to do, but it's not what I wanted. For instance, TDA lists divident re-investments as two transactions: a dividend and then a purchase (and sometimes there are MM sweeps and sales interspersed in there). That certainly works and is technically correct, but it also makes a mess of the register. I've always entered those as a single reinvest transaction. There were other small issues not worth going into.
At this point I needed a sanity break and walked away for a while.
This week I decided to get things in order. So I deleted all the downloaded transactions, turned off automatic updates, and went back to the way I used to do it. I find entering the transactions in Q2019 to be a mixed bag. Although it is a lot prettier, it also in some areas takes a lot more keystrokes and/or mouse interactions to enter a transaction. Entering MMF transactions is particularly annoying; because it seems you must enter dollar value and number of shares. For MMFs where the share value is (almost) always $1, that means needing to enter the same number twice. In the old Quicken, I could just enter the dollar value and a quick "1" for the share value, and then it fills in the number of shares. Oh well.
I also discovered that, presumably when I did my automatic transaction download, Quicken added a bunch of "add shares" transactions to the beginning of my ledger to get the share balances to square up. It took me a long time and a lot of hair pulling to discover those were there, because of course I didn't want them.
Now, as far as I can tell, everything is up-to-date. I have a pretty, modern, Mac-native UI, with a mixed bag of functionality. Better in some areas, lacking in others. Thanks to the poster in the previous thread who mentioned customizing the columns in the register, that certainly has proved to be helpful. Overall it's a wash I guess. I am at least encouraged that the app is under active development.
Oh, an finally: sometimes it takes me several seconds to switch from the Register view to the Portfolio view. Geez.
Excellent suggestion.neilw said:This reply was created from a merged topic originally titled Status report: finished importing my QMac2007 investment data into QMac2019.
Here's my final(?) status report. Thanks to the mods for putting this back into its original thread.
The first thing I did was to merge the transactions from all my individual mutual fund accounts into the brokerage account where those funds are held. Because there was no way to actually transfer the transactions, I had to re-enter all of them. All I can say about that is: thank god I'm not an active trader. That was incredibly tedious and really had me questioning my life choices. But I got it done eventually.
At that point the import into QMac2019 worked.... mostly OK I guess.
My registers were now about 2 months out of date. So I thought I'd try taking advantage of automatic downloads (in the past I always did everything manually). Got it set up, and then... it only downloaded the last week or two of transactions. If there was a way to force it to load everything since my last manually-entered transaction, I couldn't figure out what that might be. Worse, though, everything was entered as literal translations of what was downloaded. That's all you could reasonably expect it to do, but it's not what I wanted. For instance, TDA lists divident re-investments as two transactions: a dividend and then a purchase (and sometimes there are MM sweeps and sales interspersed in there). That certainly works and is technically correct, but it also makes a mess of the register. I've always entered those as a single reinvest transaction. There were other small issues not worth going into.
At this point I needed a sanity break and walked away for a while.
This week I decided to get things in order. So I deleted all the downloaded transactions, turned off automatic updates, and went back to the way I used to do it. I find entering the transactions in Q2019 to be a mixed bag. Although it is a lot prettier, it also in some areas takes a lot more keystrokes and/or mouse interactions to enter a transaction. Entering MMF transactions is particularly annoying; because it seems you must enter dollar value and number of shares. For MMFs where the share value is (almost) always $1, that means needing to enter the same number twice. In the old Quicken, I could just enter the dollar value and a quick "1" for the share value, and then it fills in the number of shares. Oh well.
I also discovered that, presumably when I did my automatic transaction download, Quicken added a bunch of "add shares" transactions to the beginning of my ledger to get the share balances to square up. It took me a long time and a lot of hair pulling to discover those were there, because of course I didn't want them.
Now, as far as I can tell, everything is up-to-date. I have a pretty, modern, Mac-native UI, with a mixed bag of functionality. Better in some areas, lacking in others. Thanks to the poster in the previous thread who mentioned customizing the columns in the register, that certainly has proved to be helpful. Overall it's a wash I guess. I am at least encouraged that the app is under active development.
Oh, an finally: sometimes it takes me several seconds to switch from the Register view to the Portfolio view. Geez.
Keep in mind that each investment register is separate, including the main group register for "Investing" and the sub-group registers like "Investing" and "Retirement". So you have to do this hide-the-graph trick with each account and group to get rid of the time lag in creating the graphs.neilw said:This reply was created from a merged topic originally titled Status report: finished importing my QMac2007 investment data into QMac2019.
Here's my final(?) status report. Thanks to the mods for putting this back into its original thread.
The first thing I did was to merge the transactions from all my individual mutual fund accounts into the brokerage account where those funds are held. Because there was no way to actually transfer the transactions, I had to re-enter all of them. All I can say about that is: thank god I'm not an active trader. That was incredibly tedious and really had me questioning my life choices. But I got it done eventually.
At that point the import into QMac2019 worked.... mostly OK I guess.
My registers were now about 2 months out of date. So I thought I'd try taking advantage of automatic downloads (in the past I always did everything manually). Got it set up, and then... it only downloaded the last week or two of transactions. If there was a way to force it to load everything since my last manually-entered transaction, I couldn't figure out what that might be. Worse, though, everything was entered as literal translations of what was downloaded. That's all you could reasonably expect it to do, but it's not what I wanted. For instance, TDA lists divident re-investments as two transactions: a dividend and then a purchase (and sometimes there are MM sweeps and sales interspersed in there). That certainly works and is technically correct, but it also makes a mess of the register. I've always entered those as a single reinvest transaction. There were other small issues not worth going into.
At this point I needed a sanity break and walked away for a while.
This week I decided to get things in order. So I deleted all the downloaded transactions, turned off automatic updates, and went back to the way I used to do it. I find entering the transactions in Q2019 to be a mixed bag. Although it is a lot prettier, it also in some areas takes a lot more keystrokes and/or mouse interactions to enter a transaction. Entering MMF transactions is particularly annoying; because it seems you must enter dollar value and number of shares. For MMFs where the share value is (almost) always $1, that means needing to enter the same number twice. In the old Quicken, I could just enter the dollar value and a quick "1" for the share value, and then it fills in the number of shares. Oh well.
I also discovered that, presumably when I did my automatic transaction download, Quicken added a bunch of "add shares" transactions to the beginning of my ledger to get the share balances to square up. It took me a long time and a lot of hair pulling to discover those were there, because of course I didn't want them.
Now, as far as I can tell, everything is up-to-date. I have a pretty, modern, Mac-native UI, with a mixed bag of functionality. Better in some areas, lacking in others. Thanks to the poster in the previous thread who mentioned customizing the columns in the register, that certainly has proved to be helpful. Overall it's a wash I guess. I am at least encouraged that the app is under active development.
Oh, an finally: sometimes it takes me several seconds to switch from the Register view to the Portfolio view. Geez.
Thanks, I'll keep that in mind. For now I seem to be functional.neilw said:This reply was created from a merged topic originally titled Status report: finished importing my QMac2007 investment data into QMac2019.
Here's my final(?) status report. Thanks to the mods for putting this back into its original thread.
The first thing I did was to merge the transactions from all my individual mutual fund accounts into the brokerage account where those funds are held. Because there was no way to actually transfer the transactions, I had to re-enter all of them. All I can say about that is: thank god I'm not an active trader. That was incredibly tedious and really had me questioning my life choices. But I got it done eventually.
At that point the import into QMac2019 worked.... mostly OK I guess.
My registers were now about 2 months out of date. So I thought I'd try taking advantage of automatic downloads (in the past I always did everything manually). Got it set up, and then... it only downloaded the last week or two of transactions. If there was a way to force it to load everything since my last manually-entered transaction, I couldn't figure out what that might be. Worse, though, everything was entered as literal translations of what was downloaded. That's all you could reasonably expect it to do, but it's not what I wanted. For instance, TDA lists divident re-investments as two transactions: a dividend and then a purchase (and sometimes there are MM sweeps and sales interspersed in there). That certainly works and is technically correct, but it also makes a mess of the register. I've always entered those as a single reinvest transaction. There were other small issues not worth going into.
At this point I needed a sanity break and walked away for a while.
This week I decided to get things in order. So I deleted all the downloaded transactions, turned off automatic updates, and went back to the way I used to do it. I find entering the transactions in Q2019 to be a mixed bag. Although it is a lot prettier, it also in some areas takes a lot more keystrokes and/or mouse interactions to enter a transaction. Entering MMF transactions is particularly annoying; because it seems you must enter dollar value and number of shares. For MMFs where the share value is (almost) always $1, that means needing to enter the same number twice. In the old Quicken, I could just enter the dollar value and a quick "1" for the share value, and then it fills in the number of shares. Oh well.
I also discovered that, presumably when I did my automatic transaction download, Quicken added a bunch of "add shares" transactions to the beginning of my ledger to get the share balances to square up. It took me a long time and a lot of hair pulling to discover those were there, because of course I didn't want them.
Now, as far as I can tell, everything is up-to-date. I have a pretty, modern, Mac-native UI, with a mixed bag of functionality. Better in some areas, lacking in others. Thanks to the poster in the previous thread who mentioned customizing the columns in the register, that certainly has proved to be helpful. Overall it's a wash I guess. I am at least encouraged that the app is under active development.
Oh, an finally: sometimes it takes me several seconds to switch from the Register view to the Portfolio view. Geez.