Need help with simple investment income report

Unknown

I am trying to generate a simple YTD investment transactions report to export to Excel.  The standard Investment Transactions report does not facilitate analysis in Excel because, for most transactions (e.g., ReinvDiv, DivX), the details of the transactions are split over two rows.  I just need the information (including Security, Symbol, Amount) on one line so that I don't have to combine the two lines into one in Excel.
Is there a way to generate such a report in Quicken Premier 2018?

Jim_Harman

Jim_Harman

Unknown

NotACPA

q_lurker

Jim_Harman

The second method I suggested, using the transaction list report exported to a file, has a clean version of the security name, with the price, shares, and amount in separate columns.

Unknown

Thanks all for weighing in.  Jim: I ran the report as you suggested but I still get the prefixed numbers in the Description

Unknown

I've decided to use the VLOOKUP (using a wildcard -*- option) to remove the unneeded prefix.  Thanks again for all the input.

q_lurker

Ken said:

Thanks all for weighing in.  Jim: I ran the report as you suggested but I still get the prefixed numbers in the Description

Dare I say, No you didn't.  

Jim's suggestion in more detail was to 

• go to the account transaction list
• Ctrl-P (or choose File / Print (account)
• Choose the date range of interest and report title
• Click Print
• Choose the Export to: option as PRN File
• Click Export
• Choose the location and name for the file including the .csv file name extension
• Click Save
• Open that csv file with Excel.

That csv file will NOT have the share count pre-pended to the security name.  

That process is different than exporting the banking or investment transaction report to a file.

Unknown

Ken said:

Thanks all for weighing in.  Jim: I ran the report as you suggested but I still get the prefixed numbers in the Description

Thanks - I took more time to complete the task this time.  The ReinvDiv description now shows without the prefixed numbers.  However, each DivX transactions are showing over two rows within excel instead of one.  So, I still can't work with the data.  I'm likely screwing up something simple and I'm open to any input to correct this.

q_lurker

Ken said:

Thanks all for weighing in.  Jim: I ran the report as you suggested but I still get the prefixed numbers in the Description

Yes, the ___X transactions include a second line with the transfer account and the amount. If you don't need that detail, delete those lines. You may choose to consider those lines as a separate transaction -withdrawing or sing to the account in which case you might want to fill out those lines with added detail.


That is as close as I can get you to a one-line presentation.

Jim_Harman