I have been wanting for YEARS to move from Quicken 2007 to the latest version of Quicken on the Mac. In fact, I have to keep an old Mac that is still able to run Quicken 2007 because of this. I simply can not understand how reporting in the newer versions of Quicken can continue to be inferior to that of Quicken 2007 now that new versions have been released for the past few years and especially given subscription sales model.
In Q2007 I have created a number of custom reports that I have been either unable to duplicate or could only duplicate by retroactively adding tags to thousands of past transactions and continuing to add tags simply to compensate for Q2007 reporting functionality no longer in versions of Q6.1.1.
I have a number custom category detail reports that are subtotaled and this had been difficult or impossible to duplicate. One example is I have a custom report show interest income sub-totaled by account. This allows me confirm my 1099-DIV statements and Quicken match. Since I have a few related accounts (i.e. Savings, Money Market, etc.) at a couple of banks I created a custom for each bank subtotaled by account if everything matched the grand totals would match the 1099-DIV.
Another example are Q2007 custom reports I created to track my mortgage payments. I have 1 report that show the total payment from my bank account for each mortgage payment on a single line on the report. 12 months, 12 lines. This was the total of a split transaction that split money to principle, interest expense and escrow. In Q6.1.1 all I can get is a report that shows EACH of the split transactions on its own line. So instead of seeing 1 line for each payment, the report shows 3 lines for each mortgage payment, 12 months shows 36 less than useful lines.
Even more egregious is the investment reporting. In Q2007, I could create reports by security. In Q6.1.1, securities are listed as "Payees" and there are no options to report investments by Security or "Payee". Again, I need to match things like Dividend income, capital gains/losses by security on tax reports. An example is in Q2007, I have a custom report that shows dividend income subtotaled by Security with the grand total on the report showing the Dividend income for that investment account. I need this functionality as I have some individual DRIPS (Dividend Re-Investments) I track in a single account. I have been unable to truly duplicate this in Q6.1.1. Category reports that show investment transactions can't even display the Investment Action (buy, sell, div, etc.). The only way I could even get close to a dividend income report sub-totaled by security would be to create a "Div-{SecurityName}" tag and MANUALLY tag each DIV transaction. Then I could create a category report subtotaled by Tag report. This is insane. I gave up here, but also need Portfolio Transaction Reports by Security (i.e. Buy, Sell, etc.)
Does the latest version of Quicken on the Mac have any better reporting?
1