BKFuller wrote: [summarized for ease of response]
Maybe I should have been more specific in my question:
I need some decent reporting that Quicken doesn't really have. It has great summary data buy if you want it by payee, as required for itemized deductions it is not as good and hard to export and work with it in Excel.
After being through an IRS audit, they want each name of who you contributed money to not what category. You just can't say Medical. They want all the doctors and hospitals. You can't say Charitable Donations, they want the name of each organization.
I'm not even sure if Excel would accept exported Quicken files.
I am not familiar with Quicken 2010 for Windows, but I am very experienced on Quicken 2007 for Mac, including the use of QIF and CSV files.
I was audited by the IRS in 2010 for an earlier tax year when I used Quicken Deluxe 2002.
More importantly, I resolved litigation five months ago that involved complex issues of a family trustee commingling their own funds and expenses in bank accounts of their own and my father's. This required me to subpeona seven years of bank accounts of my father's and the trustee's and analyze them for ultimate testimony by my forensic accountant.
Had I let the forensic accountant do all the work, the cost would have been prohibitive. Instead I had all of the bank accounts spreadsheet registers scanned and I imported them into one large Quicken 2007 file. I then exported specific reports to the forensic accountant in MS Excel format so that he could further analyze them after I did all of the legwork. I saved tens of thousands of dollars in this way.
Quicken 2007 has a very powerful report generator built in. Please see the following screenshots:
Standard Reports

Business Reports

Investment Reports

"Easy Answer" Reports

And each of these reports is easily modified to make more specific selections and more powerful reports, which then can be memorized for ready access again later:



So for example, here is one page of a sample master PAYEE schedule:

[click on images to enlarge]
Or a more specific Payee Quick Report (Macy's):

And after I easily EXPORT the Macy's Quick Report to an EXCEL file, here it is in Excel, for easy numeric manipulation:

Quicken 2007 is available for $15 from Intuit's chat function on their Support website. The latest version is El Capitan compatible. I would suggest you avoid Quicken Essentials for Mac and Quicken 2015 for Mac and Quicken 2016 for Mac; which are where most of the user complaints originate.
Here are the instructions for converting your Quicken Windows data to Quicken 2007 for Mac:
https://quicken.intuit.com/support/help/how-do-i-convert-quicken-for-windows-fil es-to-quicken-for-mac-2007-/GEN82890.html
Let me know if you have any further questions.