Quicken for Mac - ruminating again

Quicken Classic for Mac (2018+) is completely different from my old Quicken Mac 2007. So I’ve been getting used to a whole new way of entering and viewing things as information is presented very differently. I’m having to rediscover how to do things I used to do in the old one.

There are a couple of things I really needed. A major one is that the new Mac version does not have a portfolio value report!! Whereas apparently the Windows version does! I use this report to calculate my retirement investments asset allocation, pasting it into a spreadsheet. There is a much more cumbersome way to get at that information and export it to a csv file. That going to be my only option. Fortunately I only need to do it about once a month.
Yes, I was surprised at the minimal asset allocation details in the Mac Version. But I don’t track that too much anyway. But, I also maintain a large spreadsheet where I track the allocation, so I’m ok with Quicken’s single chart on the Homepage.
 
If you export it to Numbers, there is a template "Net worth" that does it all for you very nice. In fact numbers has a few nice templates to view the data. DO the export and bring it into numbers. It takes a minute to align the import fields but then it's done (can be automated). Also, get a dummy file set up (dont show your real data) and visit the MAC store to learn how to do it in person. THey do well with it! They have classes for it as well.
 
BTW, Numbers also has a nice "retirement Savings" template. Great graphs. You can also combine the Net Worth to the Retirement savings files. I'm not a zealot - it's just no one uses these features, and when you do it is surprisingly great, and it's what I always wanted the paid softwares to do. Quicken never gave me the flexibility and graphs I wanted. Good Luck
 
If you export it to Numbers, there is a template "Net worth" that does it all for you very nice. In fact numbers has a few nice templates to view the data. DO the export and bring it into numbers. It takes a minute to align the import fields but then it's done (can be automated). Also, get a dummy file set up (dont show your real data) and visit the MAC store to learn how to do it in person. THey do well with it! They have classes for it as well.
Export what to numbers?
 
I have used a free program for at least 10 years called"Checkbook". Its a Apple only product-its updated frequently. I don't use more than a few parts of it but it has the capability to be a near Quicken. Look into it.
 
I am not sure we are in synch. If the DATA is in quicken, in a field, try to export it to a file. That file will be just a series of data in rows and columns. Numbers will open the file and create a database file. You can then make some adjustments or not, and that database will have the ability to make reports (the template give reports right in the file - like a net asset chart) or readjust the data for the report you want. For instance if Quicken only gives you a yearly number, and you want monthly, in Numbers you can divide it by 12 and then plot it or report it (can actually do it by month if the information is there). Anyway, just a rough example for you. I'd suggest searching it and seeing if a video is available to show you. Or, as I said, visit a MAC store. Or just try a very small file for fun. It's free and in your computer already.
 
I’m still not clear. I’m already exporting some sets of data as CSV for further processing for other functions, but the particular data set I need for the Portfolio Value report is much more cumbersome to get at since the new Quicken Mac doesn’t provide that particular report and make it customizable and most importantly allow me to save the customized report (as I have in Quicken 2007 Mac). I need a mix of the accounts so each time I have to do multiple CSV exports from various portfolio views and then stitch them together in Numbers, very cumbersome. Only certain groupings consolidate securities and I need that feature.

And the nearest Apple Store is over 250 miles away!
 
Last edited:
I’m still not clear. I’m already exporting some sets of data as CSV for further processing for other functions, but the particular data set I need for the Portfolio Value report is much more cumbersome to get at since the new Quicken Mac doesn’t provide that particular report and make it customizable and most importantly allow me to save the customized report (as I have in Quicken 2007 Mac). I need a subset of the accounts, not all the accounts, so each time I have to do multiple CSV exports from various portfolio views and then stitch them together in numbers, very cumbersome. Only certain groupings are securities consolidated and I need that feature.

And the nearest Apple Store is over 250 miles away!
I set up quicken mac for a report of transactions by account, but then 'edit' and and specify which accounts to use. Export to numbers.

In Numbers you can sort by a hierarchy of rules - accounts, then who, then date.... etc.

This is easier to do than describe!
 
I set up quicken mac for a report of transactions by account, but then 'edit' and and specify which accounts to use. Export to numbers.

In Numbers you can sort by a hierarchy of rules - accounts, then who, then date.... etc.

This is easier to do than describe!
I don’t want transactions, just a consolidated list of the securities held and their value for a certain set of accounts. Not separated by account either, consolidated.
 
This might be close but it's all in Quicken Mac

Choose "investing" on the sidebar.
Choose "Portfolio"
"Portfolio Value" and "By security"
You can then pick all accounts, retirement accounts, brokerage accounts or individual.
 
Yes, that’s what I’ll be doing. I had already been testing that out.

And I now see that I can choose Portfolio Value by Security at any level in the investing sidebar and it will consolidate the holdings. I thought it only allowed certain sub-groupings, but that was because it switched to by Account when I clicked on other groupings.

So it looks like I can get down to one CSV export, at least for the investment accounts of interest. This is a relief.

Also, unless you change it, it appears to remember the previously selected accounts. So that might work for me, save me selecting each time I want an export.

Lots of hidden little things!
 
Last edited:
I have used a free program for at least 10 years called"Checkbook". Its a Apple only product-its updated frequently. I don't use more than a few parts of it but it has the capability to be a near Quicken. Look into it.
Thanks for this. I am thinking of a Quicken alternative for DW for next year. Right now she is using Quicken Mac from 2018, the last one you could just buy. I hate subscription software.

I believe Apple will drop support next year for Intel compiled code on M chip Macs , so I need a new solution. Checkbook is buy once.
 
I'm using Quicken Classic Deluxe for Mac, as a subscription though the software lives on my laptop. When Quicken rebuilt its Mac version after the rather excellent old Quicken for Mac 2007 version, it was indeed very rough, especially with reports. But I find it has steadily improved over the years, and I see a lot of ways to get AA and diversification and ROI and other information on the portfolio or individual investments. Including the regularly updated home screen, as Paunchy says above. And as also was said above, there are kind of a lot of hidden new but excellent charts or other features.

(Paunchy said he has tried iBank (under its new name), which I did years ago, and I've used MoneyDance. Especially MoneyDance is a nice little program, too.
 
Thanks for all the advice folks.

In a little over a week I have successfully brought my new Quicken Classic Mac up to current values matching my old Quicken Mac 2007.

I built the new one from scratch so it only has a month or so of transaction data. I was able to recreate many of the accounts (checking, savings, credit card) by using downloaded QFX files matching the most recent statement. Unfortunately I had to manually enter all of my securities (although many were recognized and then updated with price data). I’m not prepared for Quicken to store my brokerage login credentials on their servers, so that was a no go. Several brokerage accounts including IRAs I had to set up manually, but it’s done. I also have all of my scheduled and repeated transactions in the new Quicken. And with all my accounts setup transfer between accounts are now linked (credit card payments, ACH transfers, etc.)

The goal was to have everything in place by Jan 1, so I’m well ahead of that goal. I’ll be keeping them both up to date until Dec 31. I have this year’s income data in Quicken 2007 and I’m dependent on its reports to do my end of year income estimation and Jan 2025 estimated taxes. I’ll also have to make darn sure my income reports are accurate in the new Quicken next year. I’m pretty sure it can generate the reports I need, but the format is different.

I’m very happy to report that I was able to modify my retirement portfolio asset allocation spreadsheet (used for rebalancing after withdrawal) to accept data exported from the new Quicken. I discovered that with my investment portfolio view by security (which fortunately remembers the selected accounts) I am able to copy to clipboard, and then I do a paste directly into my new Numbers spreadsheet. Very slick!
 
Last edited:
Oh, I kind of hoped that the new Quicken would be able to import prices for my T-Bills. I entered the CUSIP, but they aren’t recognized.

In my old version I manually updated the values about once a month and it looks like I will continue same. I expect many people download these by directly linking to their brokerage accounts, but I’m not willing to do that.

I get current mutual fund and stock prices which is great. That broke for me a few years ago on Quicken 2007 but I learned how to generate the needed QIF file from Numbers.
 
Last edited:
Back
Top Bottom