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
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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
--
R. C. White, CPA
San Marcos, TX
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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....

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
sandstones wrote:

It's not.
The report is designed to look the way you see it.
--

John Pollard
news://<YOUR-NNTP-NEWSERVER-HERE>/alt.comp.software.financial.quicken
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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.
Tom Young

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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 in Excel.
On 9/6/2010 6:34 PM, sandstones wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.