Reports (Q Mac)

RPS777

I have used Quicken 2007 with great success but used up the transaction file. Tryin 2019 but it has no reports, no custom options, no way to investigate prices on securities over time. It is really quite useless so far. Please consider improving this. Or tell me how to get back transactions on my quicken 2007!

jacobs

I am looking for Internal Rate of Return reports that can customize to dates, accounts, and securities.

Click on the main Investing heading in the left sidebar. Click on the Portfolio button at the top of the main window.

Now set the first filter (under the graph) to Performance. Set the second filter to Group by Security or Group by Account as you prefer.

Now, customize the columns in the view by clicking on the Columns icon on the right side of the menu bar (to the right of the filters). You can select IRR and ROI for YTD, 1-, 3- or 5-years. (I don't believe there's a way to have it calculated IRR for a custom date range.) 

I am looking for the capability to see portfolio balances on specific dates

This one is easy: while on any Portfolio view, on the right side of the main screen, just under the Market Value total, there's a "Price and Holdings as of" box where you can enter a date or use a calendar to enter a date; the Portfolio will redisplay as of that date -- just as you could do in Quicken 2007.

I am looking to find and edit security prices.

This one is not as easy as it was in Quicken 2007. You can view and edit prices by going into each security, but not from the Portfolio view. (Entering from the Portfolio screen is a fairly frequent customer request. I encourage you to view this thread and cast your vote for this feature by finding the blue box under the first post, and clicking the little gray arrow under the vote counter to add your vote.) 

Back to the matter at hand… Select Window > Securities. Double-click  (or single click and then click the pencil icon) on a security for which you'd like to view or edit prices. In the security window, click on the Price History tab. Here, you see the table of all recorded price history. You can enter new prices manually at the top. You only need to enter a Date and Closing Price; all the other fields are optional.

I am looking to create customized comparison spending reports, customized by category and time as well as time intervals.

This should be pretty easy to accomplish. In the Reports menu, select Create Comparison Report. Select Rows=Category. Click next and then select two time periods you want to compare, either using built-in ranges (Last Year, Year to Date, etc.)  or your own custom dates. Now you can further customize the report to include selected accounts and/or categories.

A different variation is if you want to compare categories over a larger number of regular intervals, like months, quarters or years. For that, you could use Create Summary Report. Select Rows-Category. Select Columns=Time. Select Interval=Year or Quarter or Month or one of the other options offered. then click Continue to Customize, and again here you can select specific accounts or categories. After you generate the report, you can experiment with changing any of those settings above the column headings.

It still doesn't allow you to create every report you could in Quicken 2007, but there is a lot of flexibility in what you can create.