Create Report for Export to Quicken?

Question

Hi,

I hope somebody can help me.  I want to create a report that consolidates cash balances across all my banking and investment accounts.  I can create a report that lists the balances in banking accounts.  I'm unsuccessfully trying to add to this report the up-to-date cash balances in all my investment accounts.  My investment accounts do track cash balances, but how to break them out from all the other investment account information and add them to a cash balance report?

Once I have a report that provides with the summery data I want, I think it's straight-forward to export this report in Excel format(?)

Thanks for any help with a solution or tell me it's impossible in current Quicken.

Regards,

Ken

Pat Sills · Answer

Thanks everybody for your very useful comments. I now see how to accomplish my goal!

Yes, I meant to write "Create a report for export from Quicken to Excel".

Ken

Jim_Harman · Answer

The Portfolio view will only include investing accounts.

If you use the Account Balances report and include "No Security (includes Cash)" in the securities selection, the report will include the cash in investing accounts. If you include credit card accounts, the amounts will be negative, as they should be. You can also include money market funds in investing accounts if you want. to count that money as cash.

Scooterlam · Answer

@Pat Sills

You can do this a couple of ways:

* Use Investing>Portfolio
* Create a custom view
* Select the Columns, Accounts and Securities > Securities = "No Security (Includes Cash")
* Once the custom view is setup, Click on Export and send to Excel

Or,

*  Use Reports Center
* Select Account Balance report as the basis
* Customize as described in first option above
* Save the report
* Once the report's custom view is setup, Click on Export and send to Excel

I use the first approach to track total cash in my accounts.

Note, you may have to select additional securities if you own things like CDs (also cash).

I too, do not know what you mean by "Create Report for Export to Quicken"   This instruction would be to "Create a Report for Export from Quicken".