Quicken 2005 Investment Account Report Problems

[Guest]

I'm having a huge problem upgrading from Quicken 2002 Deluxe to 2005.
Specifically, when I complete the upgrade and data conversion, the
reports do not pull the data correctly from my investment account that
includes split cash transactions. In 2002, I had a linked account to
handle my cash transactions such as check writing, deposits, transfers,
and ATM withdrawals from my brokerage account.

Under this system, I could not download my transactions from the USAA
website because they combined brokerage transactions and cash
transactions into the same file and Quicken 2002 could not handle this
mix.

One of the advantages to 2005 is investment accounts that can handle
cash transactions without the need to have a linked account. I've been
working on this problem for several weeks now with Quicken phone
support and they keep trying new things, but none of them fix the
problem and they don't seem to realize there is a bug in the software.

I tried to validate and supervalidate the data prior to and after
conversion, and neither came up with errors or fixed the reports
problem. I used the CTRL-Z feature to fix the date, and this did not
help either.

I was told that the problem is I wrote checks on an investment account,
and that was the root of my problem, and that I shouldn't have done
that, but this doesn't seem to be an appropriate decision for Quicken
help to make...

After much discussion, I was finally told that the only way to fix this
is to create a new account, download all of the data available online
from USAA, do a cash transfer from the earlier split account into the
new account, and start anew tracking in a new account from as far back
as I can download the transactions from USAA. This was a huge task to
reassign categories and payees to all my transactions going back 18
months, but over the weekend, I accomplished this.

The bad news is, it didn't fix the problem and my reports are still
wrong.

I even started a new Quicken 2005 file and downloaded fresh from the
site with none of my old data, and I still get the same problems.

Here are my specific problems with the reports:

When I create a Cash Flow report which includes my investment account
(downloaded from the USAA site Brokerage account, including cash and
investment transactions), it includes the categories and amounts, but
when I double click on one of those amounts to get the list of
transactions that make up that amount, it gives me an error message
that there are no transactions in that range and I should use the
customize to change the range. This is a bit absurd considering I'm
clicking on an amount, and that had to come from somewhere.

When I create a Tax Schedule report, I don't get my mortgage payments
on the list. I have set up mortgage payments through the loan wizard
feature that have interest, principle, and escrow transactions in the
split window, withdrawing from my investment account. I have
customized the report to pull from my investment account, and I have
set the escrow category as a Schedule A:Real Estate Tax in the Tax
Schedule assignment portion of Quicken, yet it doesn't seem to be able
to pull this type of transaction from an investment account.

Investment type transactions in this account seem to work fine in the
reports, such as stock sales, earned interest, and dividends, so I know
I have the account and range selected properly for the report.

I've also had trouble with my monthly paycheck split transactions not
showing up properly in the reports.

Both of these reports were working properly in Quicken 2002, and in
2005 before I combined the linked checking account with the investment
account, but I have to manually input all of my transactions unless I
convert the linked account to the combined account, which was the whole
purpose of upgrading to 2005.

I discovered this problem initially when I started working on my taxes
with TurboTax 2004 and it didn't pull the right data.

So I have all of this transaction data in my database, but I'm unable
to use it for my taxes. After over a month hacking at this problem,
I'm very discouraged, tired, and frustrated.

Any assistance would be greatly appreciated, or at least knowing I'm
not the only one having this problem so we can get Quicken to fix it.

[Paul]

Ralphrrogers, I'm sorry I can't help you. You have my sympathy. I'm
planning to upgrade my Q2002 to Q2005 within the next week. My
investments, etc. sound similar to yours, so I'm worried even more now.
About 1 year ago I tried to upgrade to Q2004 and after about 60 days of
frustration trying to fix mainly the investment registers, I gave up
and went back to Q2002. If I remember correctly, most of my problems
were with splits.

I'm not looking forward to this task and if it weren't for Intuit's
sunset policy, I would not attempt it. And if there were a good and
solid competitive alternative, I wouldn't go with Quicken again.

Best of luck to you.


Ralphrrogers@netscape.net wrote: I'm having a huge problem upgrading from Quicken 2002 Deluxe to 2005. Specifically, when I complete the upgrade and data conversion, the reports do not pull the data correctly from my investment account
that includes split cash transactions. In 2002, I had a linked account to handle my cash transactions such as check writing, deposits,
transfers, and ATM withdrawals from my brokerage account. Under this system, I could not download my transactions from the USAA website because they combined brokerage transactions and cash transactions into the same file and Quicken 2002 could not handle
this mix. One of the advantages to 2005 is investment accounts that can handle cash transactions without the need to have a linked account. I've
been working on this problem for several weeks now with Quicken phone support and they keep trying new things, but none of them fix the problem and they don't seem to realize there is a bug in the
software. I tried to validate and supervalidate the data prior to and after conversion, and neither came up with errors or fixed the reports problem. I used the CTRL-Z feature to fix the date, and this did not help either. I was told that the problem is I wrote checks on an investment
account, and that was the root of my problem, and that I shouldn't have done that, but this doesn't seem to be an appropriate decision for Quicken help to make... After much discussion, I was finally told that the only way to fix
this is to create a new account, download all of the data available online from USAA, do a cash transfer from the earlier split account into the new account, and start anew tracking in a new account from as far
back as I can download the transactions from USAA. This was a huge task
to reassign categories and payees to all my transactions going back 18 months, but over the weekend, I accomplished this. The bad news is, it didn't fix the problem and my reports are still wrong. I even started a new Quicken 2005 file and downloaded fresh from the site with none of my old data, and I still get the same problems. Here are my specific problems with the reports: When I create a Cash Flow report which includes my investment account (downloaded from the USAA site Brokerage account, including cash and investment transactions), it includes the categories and amounts, but when I double click on one of those amounts to get the list of transactions that make up that amount, it gives me an error message that there are no transactions in that range and I should use the customize to change the range. This is a bit absurd considering I'm clicking on an amount, and that had to come from somewhere. When I create a Tax Schedule report, I don't get my mortgage payments on the list. I have set up mortgage payments through the loan wizard feature that have interest, principle, and escrow transactions in the split window, withdrawing from my investment account. I have customized the report to pull from my investment account, and I have set the escrow category as a Schedule A:Real Estate Tax in the Tax Schedule assignment portion of Quicken, yet it doesn't seem to be
able to pull this type of transaction from an investment account. Investment type transactions in this account seem to work fine in the reports, such as stock sales, earned interest, and dividends, so I
know I have the account and range selected properly for the report. I've also had trouble with my monthly paycheck split transactions not showing up properly in the reports. Both of these reports were working properly in Quicken 2002, and in 2005 before I combined the linked checking account with the
investment account, but I have to manually input all of my transactions unless I convert the linked account to the combined account, which was the
whole purpose of upgrading to 2005. I discovered this problem initially when I started working on my
taxes with TurboTax 2004 and it didn't pull the right data. So I have all of this transaction data in my database, but I'm unable to use it for my taxes. After over a month hacking at this problem, I'm very discouraged, tired, and frustrated. Any assistance would be greatly appreciated, or at least knowing I'm not the only one having this problem so we can get Quicken to fix it.

[Guest]

TL,

Thanks for the reply. If you have to upgrade, or are given a free
upgrade like I was, I would go ahead and do it without any
reservations. The problem only occurs if you don't keep your checking
account and investment account separate, making them into a single
hybrid (investment and cash transactions) account. I have had vast
experience trying to make this hybrid account work, and would not
suggest anyone take 'advantage' of this feature until Intuit fixes the
problem with the reports. Other than that, Q2005 is working for me,
and in most cases, better than 2002 version. My beef with Intuit right
now is that they won't recognize this issue and warn people not to use
this feature until the problem is resolved.

Having said this, I should admit that this problem I'm experiencing may
be only the tip of the iceberg, but as far as I can tell it is limited
to the way the reports pull data from hybrid accounts.

What I'm doing now is keeping my investment account and linked checking
account as they originally were in the 2002 version, and continuing to
manually update and reconcile the accounts. The reports work fine, as
they did in the 2002 version. My other investment accounts that did
not have a linked checking account I can get daily, automatic one-step
updates on and haven't experience any problems. This is a nice
improvement over 2002, but be sure to never try to unlink the accounts,
or set them up for downloads, or you are asking for trouble.

turningleaves02@yahoo.com wrote: Ralphrrogers, I'm sorry I can't help you. You have my sympathy. I'm planning to upgrade my Q2002 to Q2005 within the next week. My investments, etc. sound similar to yours, so I'm worried even more
now. About 1 year ago I tried to upgrade to Q2004 and after about 60 days
of frustration trying to fix mainly the investment registers, I gave up and went back to Q2002. If I remember correctly, most of my problems were with splits. I'm not looking forward to this task and if it weren't for Intuit's sunset policy, I would not attempt it. And if there were a good and solid competitive alternative, I wouldn't go with Quicken again. Best of luck to you. Ralphrrogers@netscape.net wrote: I'm having a huge problem upgrading from Quicken 2002 Deluxe to
2005. Specifically, when I complete the upgrade and data conversion, the reports do not pull the data correctly from my investment account that includes split cash transactions. In 2002, I had a linked account
to handle my cash transactions such as check writing, deposits, transfers, and ATM withdrawals from my brokerage account. Under this system, I could not download my transactions from the
USAA website because they combined brokerage transactions and cash transactions into the same file and Quicken 2002 could not handle this mix. One of the advantages to 2005 is investment accounts that can
handle cash transactions without the need to have a linked account. I've been working on this problem for several weeks now with Quicken phone support and they keep trying new things, but none of them fix the problem and they don't seem to realize there is a bug in the software. I tried to validate and supervalidate the data prior to and after conversion, and neither came up with errors or fixed the reports problem. I used the CTRL-Z feature to fix the date, and this did
not help either. I was told that the problem is I wrote checks on an investment account, and that was the root of my problem, and that I shouldn't have done that, but this doesn't seem to be an appropriate decision for
Quicken help to make... After much discussion, I was finally told that the only way to fix this is to create a new account, download all of the data available
online from USAA, do a cash transfer from the earlier split account into
the new account, and start anew tracking in a new account from as far back as I can download the transactions from USAA. This was a huge task to reassign categories and payees to all my transactions going back 18 months, but over the weekend, I accomplished this. The bad news is, it didn't fix the problem and my reports are still wrong. I even started a new Quicken 2005 file and downloaded fresh from
the site with none of my old data, and I still get the same problems. Here are my specific problems with the reports: When I create a Cash Flow report which includes my investment
account (downloaded from the USAA site Brokerage account, including cash
and investment transactions), it includes the categories and amounts,
but when I double click on one of those amounts to get the list of transactions that make up that amount, it gives me an error message that there are no transactions in that range and I should use the customize to change the range. This is a bit absurd considering
I'm clicking on an amount, and that had to come from somewhere. When I create a Tax Schedule report, I don't get my mortgage
payments on the list. I have set up mortgage payments through the loan
wizard feature that have interest, principle, and escrow transactions in
the split window, withdrawing from my investment account. I have customized the report to pull from my investment account, and I
have set the escrow category as a Schedule A:Real Estate Tax in the Tax Schedule assignment portion of Quicken, yet it doesn't seem to be able to pull this type of transaction from an investment account. Investment type transactions in this account seem to work fine in
the reports, such as stock sales, earned interest, and dividends, so I know I have the account and range selected properly for the report. I've also had trouble with my monthly paycheck split transactions
not showing up properly in the reports. Both of these reports were working properly in Quicken 2002, and in 2005 before I combined the linked checking account with the investment account, but I have to manually input all of my transactions unless
I convert the linked account to the combined account, which was the whole purpose of upgrading to 2005. I discovered this problem initially when I started working on my taxes with TurboTax 2004 and it didn't pull the right data. So I have all of this transaction data in my database, but I'm
unable to use it for my taxes. After over a month hacking at this
problem, I'm very discouraged, tired, and frustrated. Any assistance would be greatly appreciated, or at least knowing
I'm not the only one having this problem so we can get Quicken to fix
it.

[John Pollard]

Ralphrrogers@netscape.net wrote: I'm having a huge problem upgrading from Quicken 2002 Deluxe to 2005. Specifically, when I complete the upgrade and data conversion, the reports do not pull the data correctly from my investment account that includes split cash transactions. In 2002, I had a linked account to handle my cash transactions such as check writing, deposits, transfers, and ATM withdrawals from my brokerage account. Under this system, I could not download my transactions from the USAA website because they combined brokerage transactions and cash transactions into the same file and Quicken 2002 could not handle this mix. One of the advantages to 2005 is investment accounts that can handle cash transactions without the need to have a linked account. I've been working on this problem for several weeks now with Quicken phone support and they keep trying new things, but none of them fix the problem and they don't seem to realize there is a bug in the software. I tried to validate and supervalidate the data prior to and after conversion, and neither came up with errors or fixed the reports problem. I used the CTRL-Z feature to fix the date, and this did not help either. I was told that the problem is I wrote checks on an investment account, and that was the root of my problem, and that I shouldn't have done that, but this doesn't seem to be an appropriate decision for Quicken help to make... After much discussion, I was finally told that the only way to fix this is to create a new account, download all of the data available online from USAA, do a cash transfer from the earlier split account into the new account, and start anew tracking in a new account from as far back as I can download the transactions from USAA. This was a huge task to reassign categories and payees to all my transactions going back 18 months, but over the weekend, I accomplished this. The bad news is, it didn't fix the problem and my reports are still wrong. I even started a new Quicken 2005 file and downloaded fresh from the site with none of my old data, and I still get the same problems. Here are my specific problems with the reports: When I create a Cash Flow report which includes my investment account (downloaded from the USAA site Brokerage account, including cash and investment transactions), it includes the categories and amounts, but when I double click on one of those amounts to get the list of transactions that make up that amount, it gives me an error message that there are no transactions in that range and I should use the customize to change the range. This is a bit absurd considering I'm clicking on an amount, and that had to come from somewhere. When I create a Tax Schedule report, I don't get my mortgage payments on the list. I have set up mortgage payments through the loan wizard feature that have interest, principle, and escrow transactions in the split window, withdrawing from my investment account. I have customized the report to pull from my investment account, and I have set the escrow category as a Schedule A:Real Estate Tax in the Tax Schedule assignment portion of Quicken, yet it doesn't seem to be able to pull this type of transaction from an investment account. Investment type transactions in this account seem to work fine in the reports, such as stock sales, earned interest, and dividends, so I know I have the account and range selected properly for the report. I've also had trouble with my monthly paycheck split transactions not showing up properly in the reports. Both of these reports were working properly in Quicken 2002, and in 2005 before I combined the linked checking account with the investment account, but I have to manually input all of my transactions unless I convert the linked account to the combined account, which was the whole purpose of upgrading to 2005. I discovered this problem initially when I started working on my taxes with TurboTax 2004 and it didn't pull the right data. So I have all of this transaction data in my database, but I'm unable to use it for my taxes. After over a month hacking at this problem, I'm very discouraged, tired, and frustrated. Any assistance would be greatly appreciated, or at least knowing I'm not the only one having this problem so we can get Quicken to fix it.

I had already researched this, but was hoping others,
particularly others who did, or wanted to do, things the way
Ralph Rogers does them would jump in with corroborations,
observations, or what have you.

I think there is a problem that started, at least, as early as
Q2004 which has specifically to do with split transactions in
Investment Accounts; and Q2004 is worse than Q2005.

The bottom line of the problem is that the second through the
last split lines in an Investment account transaction are not
"found" by Quicken in certain reports and, at least sometimes,
when found, are reported incorrectly.

In the Cash Flow report for example, Quicken seems to correctly
report Category totals, but when the Category is double-clicked
to "zoom" in on the underlying detail, Quicken will only report
non-split transactions and the first line of split transactions.
(It might actually be a bit more complicated than that). The
same thing happens in the Spending report, and I suspect others
as well.

In Q2005, you can work around the problem by creating a Cash
Flow/Transaction report showing individual split lines ... not
as convenient, but at least you can answer your question. But
Q2004 can't get the Cash Flow/Transaction report right either.
When you tell it to display the individual split lines for each
transaction, it shows the correct number of split lines, but
each line has the same category and amount ... the category of
the first split line and the total amount of the transaction.

I think the Cash Flow/Transaction report is normally a very
useful report, but if one makes much use of the new
checking-account-within-an-investment-account capability in
Q2004 and uses split transactions in those investment accounts,
I think they will be quite disappointed in this report.

And it does not appear that one can get any help from the
Investment Transaction report; it does not permit the display of
individual split lines in either Q2004 or Q2005.

As to the complaints about the paycheck and loan transactions, I
may be missing something, but neither Q2004 or Q2005 allow
loan-wizard payments to be made from Investment accounts; and
Q2004 does not permit paycheck-wizard paychecks to be deposited
in Investment accounts. In any event, I believe the problems
reported with paycheck and loan transactions are basically the
same problem I noted above.

Naturally the reason that things "worked" in Q2002 is that in
Q2002 none of these transactions could have been in Investment
accounts, and there was no such thing as a split-category
investment account transaction. To the best of my knowledge,
zooming in a spending (or cash flow) report always worked, but
the zooming never had to contend with split investment account
transactions. And I suspect that if one kept the same linked
cash account arrangement in Q2005 that was in Q2002, that Q2005
would work like Q2002 ... though I did not test this.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup

[Guest]

It is possible to pay a loan or deposit a paycheck through the
investment acccount, but you can't set it up that way in the wizard.
In the wizard, you have to select a default cash account to make the
transaction from, but when you actally make the regular transaction,
you have a choice to over-ride the default. At this point, all of your
accounts show up in the drop down list. However, I would not recommend
doing this, or having any cash transactions in your investment account,
since you will not be able to get proper tax schedule reports or cash
flow reports out of the system anymore.

Until Intiut corrects this problem in Quicken 2005 or future version,
do yourself a favor and don't take advantage of this feature which
would allow you to automatically download transactions from your
investment firm. Keep the Linked-Checking Account and input manually.

Ralph