I'm trying to get data into Excel, to mimic what I used to be able to
do with MS Money.
If I make an investment transaction report I get most transactions
with 1 line for what I want (date, action, quantity etc) and then
another line that looks to be some subset of the transaction, although
I can't figure out what it really for. They don't have a date,
action, security name, but appear to be resolving cash,and in any case
I would like to exclude them. In some cases, the first line of the
transaction just has the security info and the values are only in the
second line, which means that just copying to Ecxel ends up with
something that cannot be sorted or made any use of.
Am I missing something? I can't believe there is not a way to get a
straighforward report, but none of the customizations or options I can
find seem to do anything. Some of those extra lines go away if I
exclude all transfers, but there are still a lot there. Getting rid
of all the cash columns does nothing to help.
Any ideas? Is this some strange result of converting from MS Money?
Also is there any way to sort the report?
I don't use Reports very much at all, so my idea may not make sense. But I
wonder if you can solve the problem - wholly or partially - by adjusting the
width of the data columns? Narrowing some columns might allow all the data
to be printed on one line.
You're pretty much limited to what you see. There's no way to sort
the report. Subtotaling by category get's you a "one-line" per
transaction report but may not work for you.
I've resorted to exporting the standard report to Excel and then using
various macros to massage the information into the "one-line" form I
want, then use Excel's sort features.
The issue is not that the line is too long. Its that there are two lines (and
in some cases three
lines) with different information generated for many transactions
The first line has date, account, action, security, category, price, shares, and
cash (total) like
one would expect. The category is a transfer to the corresponding cash account
(taken from MS
Money). Many transactions then have a second line that is blank (spaces) for
date, account, action,
security. The category on the second line is _DivInc, _Rzldgain, _IntInc,
things like that.
In some cases the price and shares are blank on the second line and the total is
the negative of the
total on the first line. Iin other cases the only the second line has any
values, and in some cases
it looks like a subset of the transaction.
I've tried turning off the categories that show up in the second line, but then
just don't show up - i.e. turning off _Rzldgain gets rid of all the Sells. Not
too useful. I've
all tried turning off all transfers and that gets rid of some things but there
are still a lot
It seems like this might be some artifact of the conversion from MS money.
I've ben trying to ask Intuit about this - Chat says they weren't trained on it,
email says to call
them, and calling them never calls back. Very frustrating....
>I don't use Reports very much at all, so my idea may not make sense. But I
>wonder if you can solve the problem - wholly or partially - by adjusting the
>width of the data columns? Narrowing some columns might allow all the data
>to be printed on one line.
Would a simple register printout give you what you are looking for?
Seems like the info you are looking for is just what is contained in
each account register. Print the register yo a file, then open the file
I guess all I can say is that for a product that is supposed to be the leader in
the field, I am
astounded at how primitive the reporting is. I can't even sort an investment
report, and now I find
that to sort it in Excel I first have to write a program to recombine
Another example of how an inferior product wins out by better marketing - in
this case turning the
tables on Microsoft who has previously done that to many other companies.
>> It seems like this might be some artifact of the conversion
>> from MS money.
>The report is designed to look the way you see it.