Investment Transaction Reports Break Transactions into Separate, Incomplete Lines

Question

I don't even know how to ask this.  When I export an Investment Transaction Report from Quicken to a spreadsheet, it keeps breaking what should be atomic transaction lines into multiple, incomplete lines:

I don't understand why Quicken's doing this, but it makes the report useless as a spreadsheet.  I need all of that kind of stuff on one, complete line.  But, I can find no setting or way of exporting the data that will do that.  Is there something I'm missing?

Jim_Harman · Answer

On the issue of blank cells, one of the methods discussed here might help

https://community.quicken.com/discussion/7868904/export-all-transaction-to-excel-split-categories-are-formatted-incorrectly

Please also vote on the Idea.

isonclubikin · Answer

That two-line format is fine as displayed in a Quicken report.  But, if I hit that Quicken report's “Export Report Data to Different Formats” button and choose “Export to Excel Workbook (.xlsx)”, then it should actually be exported as a valid spreadsheet.  IOW, all those blank fields need to be filled in.  Otherwise, once it's in a spreadsheet, it can't be manipulated.  And, if it can't be manipulated in the spreadsheet, there's not much use in exporting it there in the first place.

For instance, I just exported all of a Quicken file's investment transactions to a spreasheet and sorted it.  Twelve percent of the “transactions” (1,752 out of 15,057) fall right off the end of the spreadsheet because they have no date (or Account, or Action, or Security) associated with them.  And, once that happens (or any other manipulation of the data) the whole export is just a pile of steaming garbage.

Chris_QPW · Answer

I think you aren't looking at as as much a bug as a design decision on how to present the underline information.

It isn't as obvious in the screenshot you have posted, but is in a sell.

Here is the transaction:

In this transaction dialog you see the first line above.  What you don't see is the fact that Quicken is actually recording two transactions, maybe more precisely, a compond transaction.  The second line is recording the realized gain, and it can't be included in the first line because you have two “Cash” entries.