Request for Customizable Reporting Engine in Quicken for Mac

Because of the new 255 chars limitation on the new feedback form for submitting request for Other Features, I am posting details here, then submitting the link to this post on the feedback page to the send to the developers. This is not intended to open a discussion but simply to enable my feedback submission. If you agree, feel free to add your vote.
Background
First, this is a request for a customizable report generating engine similar to what is in QM2007 (and even Quicken for Windows), with all its flexibility. Pre-defined canned reports are far too limiting and can never accommodate the needs of all users as it requires anticipating their every need. With customizable report templates, users can modify to meet their needs.
Currently in QM2007, there are 17 templates for transactional reports (10 Standard, 7 business) + 6 for Investments. As I have pointed out before, there are ONLY 8 unique generic templates needed in QM2007 to generate all 17 reports (2 are for taxes and 5 are for the other 15) and 4 unique templates to generate the 6 Investment reports.
So far, only 4 of 8 generic report templates have been implemented in QM2016 (Summary, Net Worth & Tax Schedule). QM2016 has rolled into the current reports the Detailed reports but is very clumsy and limiting. The other reports in QM2016 are simply subsets of the generic templates in QM2007; in QM2007 only one template is needed to be able to create the Account Summary report, Category Summary report, and the Payee Summary report.
As a comparison, because QM2016 has rolled Summary and Detailed reports into one "template", 3 report templates are needed to generate the the 6 different Accounts, Category and Payee reports. On the other hand, QM2007 uses only 2 templates, one Summary, one Detailed, to create all 6 reports. The current design approach will prove a problem when moving forward to create new templates (see the Job/Project columnar summary report discussed below).
There is also the fact that the layout designs of existing reports in QM2016 are very "mickey mouse" and lack a professional look and feel (as has been many times reported on QLC) due to lots of white space, totals at the top, etc. but more importantly lack the ability to truly select and organize the data as needed, e.g. selection criteria such as which accounts or details are included, sorting, subtotals, managing splits, organization such as Income vs Expenses or Cash Flow, etc.
Requests
Ideally, I (and many others) would like to see the other report templates implemented. To help prioritizewhich next template to implement, I personally would like to see what is called the Job/Project report template in QM2007. It is essentially the existing Summary report that allows adding columns across the top, creating a multi-column report. It should have the same flexibility to allow selecting what shows up on the right side (Category, Payee, Account, Tags) and what shows up in the columns (Category, Payee, Account, Tags, various time periods). The highest priority is the Category vs Tag combination (see below for supporting info). This should be linked to the Detailed Transactions report template to be able to drill down on any one entry.
I believe to implement this, and other reports needed, the report creation engine needs to be re-designed to allow creating multiple reports from the fewest number of templates. I highly recommend taking cues from other versions of Quicken to create a more efficient reporting engine.
The other priorities include improving the selection criteria to allow more info on existing report templates and organization of the info, as discussed above.
Another complementary request is that once adequate templates are created, create the ability to import existing saved templates from QM2007 (and even Quicken for Windows).
Supporting Info
The following are just a few samples of requests that support the requests above:
Request for Columnar Summary Report template:
(FYI: I alone have almost 20 saved columnar summary reports to carry over)
From QM2007:
(NOTE: I alone have about 80 saved reports that I re-use all the time, and need to carry forward. Recreating them would be a major undertaking.)
Background
First, this is a request for a customizable report generating engine similar to what is in QM2007 (and even Quicken for Windows), with all its flexibility. Pre-defined canned reports are far too limiting and can never accommodate the needs of all users as it requires anticipating their every need. With customizable report templates, users can modify to meet their needs.
Currently in QM2007, there are 17 templates for transactional reports (10 Standard, 7 business) + 6 for Investments. As I have pointed out before, there are ONLY 8 unique generic templates needed in QM2007 to generate all 17 reports (2 are for taxes and 5 are for the other 15) and 4 unique templates to generate the 6 Investment reports.
So far, only 4 of 8 generic report templates have been implemented in QM2016 (Summary, Net Worth & Tax Schedule). QM2016 has rolled into the current reports the Detailed reports but is very clumsy and limiting. The other reports in QM2016 are simply subsets of the generic templates in QM2007; in QM2007 only one template is needed to be able to create the Account Summary report, Category Summary report, and the Payee Summary report.
As a comparison, because QM2016 has rolled Summary and Detailed reports into one "template", 3 report templates are needed to generate the the 6 different Accounts, Category and Payee reports. On the other hand, QM2007 uses only 2 templates, one Summary, one Detailed, to create all 6 reports. The current design approach will prove a problem when moving forward to create new templates (see the Job/Project columnar summary report discussed below).
There is also the fact that the layout designs of existing reports in QM2016 are very "mickey mouse" and lack a professional look and feel (as has been many times reported on QLC) due to lots of white space, totals at the top, etc. but more importantly lack the ability to truly select and organize the data as needed, e.g. selection criteria such as which accounts or details are included, sorting, subtotals, managing splits, organization such as Income vs Expenses or Cash Flow, etc.
Requests
Ideally, I (and many others) would like to see the other report templates implemented. To help prioritizewhich next template to implement, I personally would like to see what is called the Job/Project report template in QM2007. It is essentially the existing Summary report that allows adding columns across the top, creating a multi-column report. It should have the same flexibility to allow selecting what shows up on the right side (Category, Payee, Account, Tags) and what shows up in the columns (Category, Payee, Account, Tags, various time periods). The highest priority is the Category vs Tag combination (see below for supporting info). This should be linked to the Detailed Transactions report template to be able to drill down on any one entry.
I believe to implement this, and other reports needed, the report creation engine needs to be re-designed to allow creating multiple reports from the fewest number of templates. I highly recommend taking cues from other versions of Quicken to create a more efficient reporting engine.
The other priorities include improving the selection criteria to allow more info on existing report templates and organization of the info, as discussed above.
Another complementary request is that once adequate templates are created, create the ability to import existing saved templates from QM2007 (and even Quicken for Windows).
Supporting Info
The following are just a few samples of requests that support the requests above:
Request for Columnar Summary Report template:
(FYI: I alone have almost 20 saved columnar summary reports to carry over)
- http://getsatisfaction.com/quickencommunity/topics/reinstate-mac-quickens-great-reporting
- http://getsatisfaction.com/quickencommunity/topics/in-quicken-2007-i-can-create-custom-reports-with-categories-rows-and-classes-columns-export-it-to-excel-for-tax
- http://getsatisfaction.com/quickencommunity/topics/does-quicken-for-mac-2016-have-a-report-including-tag-columns-and-category-lines -does-quicken-for-mac-2016-have-a-report-including-tag-colum...
- http://getsatisfaction.com/quickencommunity/topics/reports-by-tag-in-quicken-2015-mac-or-any-mac-version
- http://getsatisfaction.com/quickencommunity/topics/is-there-a-way-in-quicken-2016-for-mac-to-view-a-report-organized-categorized-by-tags...
- http://getsatisfaction.com/quickencommunity/topics/how-can-i-make-a-tag-report-and-include-summary-of-untagged-items...
- Income vs Expenses, Cash Flow: http://getsatisfaction.com/quickencommunity/topics/just-upgraded-from-quicken-for-mac-2007-to-mac-2016-and-converted-files-cant-find-my-saved-reports-from-2007...
- Sorting & Subtotals: http://getsatisfaction.com/quickencommunity/topics/can-i-create-a-report-selected-by-category-but-sorted-and-sub-totaled-by-payee-in-quicken-for-mac-2015...
- http://getsatisfaction.com/quickencommunity/topics/unable-to-sort-categorized-reports-by-payee-with-quicken-mac-2015...
- http://getsatisfaction.com/quickencommunity/topics/quicken-mac-v2-4-2-i-was-hopeful-but-ill-be-putting-in-for-a-refund...
From QM2007:
(NOTE: I alone have about 80 saved reports that I re-use all the time, and need to carry forward. Recreating them would be a major undertaking.)
- http://getsatisfaction.com/quickencommunity/topics/if-i-upgrade-from-quicken-for-mac-2007-to-quicken-for-mac-2016-will-my-saved-reports-convert-automatically-or...
- http://getsatisfaction.com/quickencommunity/topics/just-upgraded-from-quicken-for-mac-2007-to-mac-2016-and-converted-files-cant-find-my-saved-reports-from-2007...
- http://getsatisfaction.com/quickencommunity/topics/converting-quicken-2013-for-windows-reports-to-quicken-mac-2015...
- http://getsatisfaction.com/quickencommunity/topics/can-i-import-custom-reports-from-quicken-for-windows-into-quicken-for-mac...
- http://getsatisfaction.com/quickencommunity/topics/why-im-requesting-a-refund-for-quicken-mac-2016?notification_token=4c79eb47b7210849bc5fb06cd16b113b&utm_cam...
Have Questions? Check out these FAQs:
Object to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian
user since '92, STILL using QM2007)
- Where to find a Help Guide for Quicken for Mac?
- Quicken Mac FAQ list
- Quicken Windows FAQ list
- Help Guide and FAQs for Quicken Mobile
Object to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian

0
This discussion has been closed.
Comments
I hope Quicken is seeing the same thing I am seeing here on QLC, which is a very strong demand for customizable reports, with similar capabilities as ALL other versions of Quicken (Mac & Windows) before QM2015.
Also a strong demand to be able to carry over memorized reports in the Mac and Windows versions.
To see the evidence since I posted this here 1 1/2 months ago, see the first link under the first 2 headings above, as good examples.
- Where to find a Help Guide for Quicken for Mac?
- Quicken Mac FAQ list
- Quicken Windows FAQ list
- Help Guide and FAQs for Quicken Mobile
COMPLETE list of Product Ideas - Quicken for Mac to VOTE onObject to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian
Questions? Check out the Quicken Windows FAQ list
- Where to find a Help Guide for Quicken for Mac?
- Quicken Mac FAQ list
- Quicken Windows FAQ list
- Help Guide and FAQs for Quicken Mobile
COMPLETE list of Product Ideas - Quicken for Mac to VOTE onObject to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian
- Where to find a Help Guide for Quicken for Mac?
- Quicken Mac FAQ list
- Quicken Windows FAQ list
- Help Guide and FAQs for Quicken Mobile
COMPLETE list of Product Ideas - Quicken for Mac to VOTE onObject to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian
Who closed this thread?? In the Lounge?? I was typing a reply, and by the time I clicked to submit it, someone had closed the thread.
Anyway...
I think the fact that they added a new Export CSV function to the Category Summary report, while helpful, is potentially worrisome. I was hoping to see evidence of an overhaul of the reports section of the program, which I find awful. (I've posted about reports before, and I won't repeat it all here.) If this CSV export functionality on a single report in version 3.1 was a quick-and-easy temporary solution, great -- many people want the ability to export reports. But if this signals that the development team thinks they can just add a few tweaks here and there without re-engineering the reports, that's bad. And note that better customization of reports is not one of the top 12 things presented for people to vote on in the polls on the Feedback and Compare web pages.
@smayer97: For your sake, I hope I'm wrong, but I'm guessing it's unlikely they'll ever implement a carry-over of reports from the legacy Mac version, because the databases and reports are so different. The amount of work needed to engineer it, for the relatively small number of Mac users who will still be using Quicken 2007 by the time they could get it built, makes me think they won't do it. That will definitely cause some pain for a small number of Mac users who have lots of custom reports. (For me, it's a minor inconvenience; I could rebuild the reports I need without too much pain.)
Not me. When I first read it, it was closed, but it made sense to me based on this statement "This is not intended to open a discussion but simply to enable my feedback submission." in the very first paragraph.
-also older versions as needed for testing
-Questions? Check out the Quicken Windows FAQ list
- Where to find a Help Guide for Quicken for Mac?
- Quicken Mac FAQ list
- Quicken Windows FAQ list
- Help Guide and FAQs for Quicken Mobile
COMPLETE list of Product Ideas - Quicken for Mac to VOTE onObject to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian
- Where to find a Help Guide for Quicken for Mac?
- Quicken Mac FAQ list
- Quicken Windows FAQ list
- Help Guide and FAQs for Quicken Mobile
COMPLETE list of Product Ideas - Quicken for Mac to VOTE onObject to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian
Click the link above to go take a look at the list and vote for the ones you want to see implemented in Quicken for Mac.
Be sure to scroll down the page, as some contain lists of related features. Click on the link to EACH IDEA separately. Then you click the VOTE button at the top of EACH page that opens up respectively to increase the count and therefore its visibility to the developers
If you do not click VOTE at the top of the page of each feature, your vote will NOT be counted for THAT feature!
(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)
- Where to find a Help Guide for Quicken for Mac?
- Quicken Mac FAQ list
- Quicken Windows FAQ list
- Help Guide and FAQs for Quicken Mobile
COMPLETE list of Product Ideas - Quicken for Mac to VOTE onObject to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian
- Account Summary Report (aka Balance Sheet aka Net Worth; Columnar Summary report subtotaled and sorted by account, single column subtotal)
- Category Summary Report (Columnar Summary report subtotaled and sorted by category, single column subtotal)
- Payee Summary Report (Columnar Summary report subtotaled and sorted by Payee, single column subtotal)
- Tag Summary Report (Columnar Summary report subtotaled and sorted by tag, single column subtotal)
- Spending Over Time (Columnar Summary report subtotaled and sorted by category, displaying multiple selected periods)
- Net Worth Over Time (Columnar Summary report subtotaled and sorted by account, grouped by Assets vs Liabilities, displaying multiple selected periods)
- Comparison Report By Category (Year over Year) (Columnar Summary report subtotaled and sorted by category, displaying multiple selected periods, which adds an extra column for each comparative period, and columns showing the calculation of the differences)
- Comparison Report By Payee (Year over Year) (Columnar Summary report subtotaled and sorted by payee, displaying multiple selected periods, which adds an extra column for each comparative period, and columns showing the calculation of the differences)
- Comparison Report By Tag (Year over Year) (Columnar Summary report subtotaled and sorted by tag, displaying multiple selected periods, which adds an extra column for each comparative period, and columns showing the calculation of the differences)
To further explain what I mean, let's examine the Columnar Summary Report template.First, I want to point out that the only difference between a properly designed columnar summary report (like in QM2007) and a Summary report is that the Summary report only shows the subtotals for each row with no additional columns. All a columnar summary report does is add extra columns to show more detail of the subtotals, as outlined above for each report.
In fact, the report template UI could be taken one step further than QM2007 achieved and easily roll up the Comparison reports too by simply adding a check mark to expand the columnar summary report into a Comparison report, by adding the extra needed columns, as has been outlined above, because those reports are just another extension/application of the columnar format.
Once properly developed, then a whole bunch of Business related reports that are currently in QM2007 could easily be deployed, listed as follows:
- Accounts Payable by Vendor (Columnar Summary report subtotaled by Payee, displaying multiple selected periods (by month?), with pre-selected accounts=Banks, excluding Payments and Deposits) (Like Payee Summary Report and Spending Over Time formats combined)
- Accounts Receivable by Customer (Columnar Summary report subtotaled by Payee, displaying multiple selected periods (by month?), with pre-selected accounts=Assets, excluding Cleared and Reconciled transactions) (Like Payee Summary Report and Spending Over Time formats combined)
- Balance Sheet (~Net Worth Over Time but on specific day only, aka Accounts Summary )
- Cash Flow Report (=Category Summary Report, pre-selected accounts, organized by cash flow)
- Income Statement (aka Profit and Loss-P&L) (=Category Summary Report, organized by Income vs Expenses)
- Job/Project Report (Columnar Summary report subtotaled and sorted by category, displaying multiple columns as tags, organized by Income vs Expenses)
- Payroll Report (Columnar Summary report subtotaled and sorted by category, displaying multiple columns as payees, pre-selected categories, organized by cash flow)
Again, though there might be some tweaks needed, all the above reports would be the same Columnar Summary Report, simply with pre-set criteria as outlined above, as many report defaults are currently set up in QM2007.Currently, the Category/Transaction Detail reports are accessible via the respective Summary reports. In like manner yet again, a properly designed report engine and equally important UI for these, like done in QM2007, needs to be independently accessed, to be able to be configured as needed, and not have to generate and store the Summary report first.
In fact, once properly developed, another report that are currently in QM2007 could easily be deployed, the Tax Summary report, listing transactions for all tax related categories.
In other words, the following are the advantages:
- all these reports would be rolled up into one (1) UI, with one (1) report template for the summary version, and one (1) report template for the transactional version, versus 16 separate reports or more (not including budget, investment, and tax reports) (assuming all are re-created)
- it would allow easy configuration in defining selection criteria due to a common interface
- it would allow easily switching between the different reports without having to recreate the section criteria, either before OR after generating a report (as I already pointed out over two months earlier in this post). Right now, you have to re-create the criteria if you decide to use a different report
- more efficient for the user with far less effort
- maintains backward compatibility to be able to carry forward saved reports from QM2007 and QWin.
This is extremely valuable when performing data analysis or trying to figure out which report view would best serve a need.One way to implement this in a common UI is to have a report selection window with a menu with either the choice of a generic template (only default settings) or a selection of the different pre-defined reports, as listed above, whereby the UI shows or hides selection criteria as applies to the report.
I do not believe it would be significantly more effort than designing the reports individually but the return would be more significant from a usability perspective.
In the words of Mike Holmes of HGTV fame, "Do It Right".
If you see the value in this approach (similar to what is in QM2007), be sure to:
- click VOTE at the top of this page for this Customizable Report Engine
- click on Columnar Summary report, then click VOTE at the top of THAT page to add your vote for that template
- click on Create Useful Category/Transaction Detail Report, then click VOTE at the top of THAT page to add your vote for that template
A mirror of this post is cross-referenced to a similar post in the Columnar Summary report IDEA here.(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)
- Where to find a Help Guide for Quicken for Mac?
- Quicken Mac FAQ list
- Quicken Windows FAQ list
- Help Guide and FAQs for Quicken Mobile
COMPLETE list of Product Ideas - Quicken for Mac to VOTE onObject to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian
Create Useful Category/Transaction Detail Report, as follows:
- SubTotals on reports
- Choose to Show/Hide Columns That Appear in Reports
- Show/Hide Splits in registers and reports
- Add Ability to Organize Reports by Income and Expense vs Cash Flow
- and of course carry forward report formats from other versions
You may want to add your vote for each of these. First, click on each underlined link above to go there, then click VOTE at the top of THAT page, so your vote will count for THAT feature and increase its visibility to the developers.More Sorting Options to Reports
Selection Criteria for -No Category- and -No Tag- on Reports
Include or Exclude Transfers on Reports
Add Unreconciled Filter in Transaction Register and Reports
Report Formatting Options
(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)
- Where to find a Help Guide for Quicken for Mac?
- Quicken Mac FAQ list
- Quicken Windows FAQ list
- Help Guide and FAQs for Quicken Mobile
COMPLETE list of Product Ideas - Quicken for Mac to VOTE onObject to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian
I expected Quicken 2015 to be the same, if not better than the 2009 version, not unbelievably WORSE, to the point that it is USELESS to me as a business owner. How can that be????
This software used to be the most powerful accounting software on the market, only to be given a lobotomy in its current versions. It is USELESS for a business owner until it can make reports like 2007 and 2009 versions.
I am going to have to take the information from the "Summary Report" and make my own Excel or Numbers spreadsheet. It will take me hours...
- Where to find a Help Guide for Quicken for Mac?
- Quicken Mac FAQ list
- Quicken Windows FAQ list
- Help Guide and FAQs for Quicken Mobile
COMPLETE list of Product Ideas - Quicken for Mac to VOTE onObject to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian
Is Quicken for Mac 2007 Compatible with Mojave (macOS 10.14)?
- Where to find a Help Guide for Quicken for Mac?
- Quicken Mac FAQ list
- Quicken Windows FAQ list
- Help Guide and FAQs for Quicken Mobile
COMPLETE list of Product Ideas - Quicken for Mac to VOTE onObject to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian