Strange Investment Reports


B

Bob Stanny

Strikes me this is likely an old issue, but I've recently noticed that
my copy of Quicken 2004 incorrectly retrieves transactions when I ask
it to perform a cash-flow transaction report on an investment account.
For example, only the $50 realized gain is displayed when I retrieve a
$150 sale of a stock originally purchased for $100.

I wonder if this is standard Quicken behavior (boy, it oughtn't be), or
if my installation is corrupted, or if I need to buy a newer computer,
or if it would help to wear a tinfoil beanie when working with Quicken,
or what.

I've noticed that, judging from the structure of its report outputs,
Quicken may maintain some investment transactions in multiple,
contiguous data records that aren't linked in any way (e.g., with a
key). Thus, if you print one of these reports to file and sort the
file, parts of records may sometimes be flung hither and yon.

Any advice appreciated.

Bob Stanny
 
Ad

Advertisements

R

Ralphrrogers

I don't have any advice, but I know of similar problems. Quicken 2005
seems to have some serious problems with the reports of cash
transactions in the investment accounts. These problems don't seem to
occur in the cash accounts. Split transactions are even worse. I
don't have Q2004, but I've heard it is even worse about this than
Q2005, which I am now using. In 2004, the hybrid account was
introduced, which allowed you to input cash type transaction such as
check writing and deposits into the investment account, reflecting the
way many brokerage companies use these accounts now. The problem is
you can't get reports out of them properly. The Tax Schedule report
shows dividends and interest in the investment account, but doesn't
seem to look for deposits or payments from the investment account
regardless of the category assigned and the tax schedule associated
with it. They are slightly better in the cash flow reports, in that
they look for categories, but if the transaction is split, it may only
see the first category in the list, or completely lose track of things
when you attempt to get a sub-level report by double clicking on a
category total.

I have repeatedly tried to work with Quicken help on this, and reported
the problem as a bug, but I haven't seen any cure yet. The help line
either told me they couldn't help me with the investment section
(online) or that I shouldn't be doing cash transactions in an
investment account (phone). Hopefully, we will see a fix in future
versions, but until then, I'm using the linked-checking account with my
investment accounts to keep the cash transactions separate and usable.

Good luck!
 
J

John Pollard

Bob said:
Strikes me this is likely an old issue, but I've recently
noticed that
my copy of Quicken 2004 incorrectly retrieves transactions
when I ask
it to perform a cash-flow transaction report on an investment
account.
For example, only the $50 realized gain is displayed when I
retrieve a
$150 sale of a stock originally purchased for $100.
Did you make sure the date range of the report included the date
you bought the stock?
 
B

Bob Stanny

Whoa! Very interesting! No, I didn't include the purchase date. When
I did, Quicken retrieved a second record containing the purchase and
the correct date of the purchase. However, Quicken listed the amount
of the purchase as $0.00. (All the data for the transaction are
correct in the account register--and, yes, I *did* pay more than $0.00
for the stock.)

I'll repeat that what I've done is to create a *cash-flow* transaction
report. *Investement transaction* reports seem to have their own
curiosities.

Bob
 
V

vodil

I have experienced similar problems, but in even more amusing ways.
You can sometimes make the transactions appear in a cash flow report
that only includes the investment account, but if it includes cash flow
accounts it won't.
Even when it appears in the cash flow report, if you click on
an entry to get the detail, it may report there are no matching
transactions--yet you can see the total.

This is clearly a big bug. I have a W-2 report that I have been using
for years and it stopped working when I went from H&B03 to
H&B05--because my wife's paycheck is deposited into her brokerage
account.

I like the fact that there are now hybrid accounts and you don't have
to have linked ones. I have not dared try it yet, but I think the only
kludge we can do is to split these accounts.

They really messed up. I wish I could go back to 03 at this stage.
 
Ad

Advertisements

B

Bob Stanny

Vodil said:
...They really messed up. I wish I could go back to 03 at this stage.
I think that printing a register to a file still yields valid data.
You can analyze the results in Excel, though some of the stuff that
Quicken is intended to make easy isn't fun to do in a spreadsheet.
Correlating entries across linked accounts would not be fun by this
method.

Printing registers sometimes yields records that span multiple lines,
which makes sorting the results (say, in Excel) a concern. However,
these seem to be fairly rare and you can edit or delete them as
appropriate.

You're right, however. They've messed up. There's no excuse for
producing a version that works this badly. There's also no excuse for
failing to address the problem. It really looks like the results of
some amateurish decisions about datafile format (creating records
without keys, etc.) taken by inexperienced, poorly supervised
programmers who have been directed to dress-up Quicken's reports to
help justify the release of a new version. Terms for this include
"second-system effect," "creeping featuritis," and (my favorite)
"feeping creaturitis."
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top