Is there a way to get a investment tranaction report, 1 line per transaction?

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?

Thanks SS

Reply to
sandstones
Loading thread data ...

Hi, SandStones.

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.

RC

Reply to
R. C. White

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 the transactions 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 there.

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....

Reply to
sandstones

Reply to
wbertram

It's not.

The report is designed to look the way you see it.

Reply to
John Pollard

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 transactions.

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.

SS

Reply to
sandstones

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.