If you're new here, you may want to learn what this site is about. I encourage you to subscribe to my RSS feed. Thanks for visiting!
I use Quicken to track my personal finances. Back in the olden days, I used Andrew Tobias’ Managing Your Money, but that hasn’t worked on my Macs for nearly a decade. I’d still use it if I could.
Quicken on the Mac is a pale comparison to the Quicken on the PC. I feel like I should be able to get more out of the program, so I went on a scavenger hunt, scouring the web for the best Quicken hacks. There aren’t many out there. Here are the 24 hints and tips I deemed worth sharing:
Getting started with Quicken
- How to get started using Quicken — Gina Trapani is a dedicated Quicken user. Here she explains how to get up-and-running in no time. [@ Lifehacker]
- How do I convert data from Microsoft Money files? [@ Quicken customer support]
- Handy Quicken shortcuts for entering dates — t is today, for example. [@ Quickenhead]
- How to use categories in financial software — This site is a mess — it’s more ads than content — but the info here is good if you’re just getting started with Quicken. [@ About.com]
Setting up accounts
- Tracking your mortgage and escrow account in Quicken — “If you are like me, you have a monthly mortgage payment that also includes an amount that goes into Escrow every month. Here’s how you can record your mortgage and escrow account in Quicken.” [@ Quickenhead]
- Tracking an interest-only mortgage in Quicken [@ Quickenhead]
- Configuring Quicken to access your Vanguard accounts — Apparently this isn’t as straight-forward as it should be. [@ Making Our Way]
- Track airline miles or points — By setting up your airline miles as a “foreign currency”, you can track them from within Quicken. [@ Consumerism Commentary]
- How to incorporate your PayPal account into Quicken — Tricia shows how to set up a PayPal account. In the comments, Mandi explains how to set up your account so you can download data from PayPal and import it. [@ Quickenhead]
- How to track an envelope budgeting system in Quicken — “A very popular way to budget is the Envelope Budgeting System. Paychecks are cashed and then a budgeted amount for certain expenses are placed in envelopes. When you need to spend money, you use the money from each envelope. Can you record a system like that in Quicken? You bet!” [@ Quickenhead]

Working with Quicken
- Back up your data files often. I back up my files once a month. It is imperative that you back up your data before you upgrade versions. Intuit practices an asinine “sunsetting” program whereby they intentionally “break” older versions of their software. For example, I was using Quicken 2004 on my Mac. It worked just fine. But because of the sunsetting policy, Intuit was going to prevent that version from downloading transaction information online. I was forced to upgrade to the new version. Why this is legal is beyond me. It makes my blood boil. Anyhow, Quicken upgrades have been known to break things. When you upgrade, be sure to create a backup copy of your data.
- Tips for solving reconciliation discrepancies in Quicken — “The main thing is to try to not get frustrated.” I recently had a $.06 error that I could not find. When I reconciled with the next month’s statement, things balanced. Sometimes you just need to put things aside and come back later. [@ Quickenhead]
- Tracking cash spending using Quicken — “To me, cash can often be forgotten about when it comes time to looking at your finances. Here’s a way that has helped me keep track.” (Note that Tricia also writes Quicken Head.) [@ Blogging Away Debt]
- What category to use when you’re unsure what an expense is for — What should you do when you can’t remember where your money went? This is a great reason for saving your receipts in one easy-to-find location! [@ Quickenhead]
- Quicken investment recordkeeping tricks — “Quicken provides powerful investment record-keeping tools for individual investors. Unfortunately, once you step beyond investments like stocks, bonds, and mutual funds, the mechanics can get a little tricky. Here are some tips for handling common investments in Quicken.” [@ Buzzle.com]
- How to set aside money in your checking account for a future expense — This is a clever idea, a way to remove money from the general pool without actually spending it. [@ Quickenhead]
- Accounting for accrued expenses in Quicken — “Sometimes you may received services one month, but not be billed for it until months afterward. Normally, you would pay the bill after the bill is received and that expense will show on your income & expense statement the month you paid it. If you would actually prefer to show that expense the month it was incurred (using an estimated or known cost), the following tutorial will help you do that.” [@ Quickenhead]
Working with files
- How to access a password-protected Quicken file without the password. [@ Quicken customer support]
- Hack Quicken to import QFX files on OS X — Quicken data files are the same for both Mac and Windows. But because of obscure licensing issues, Intuit disables importing from certain banks on the Mac. This hack allows you to work around the issue to get at your data. (More here.) [@ Digital 501]
- QIF Master — “QIF Master adds Quicken categories based on the description (e.g. payee) of each transaction.”
Quicken resources
- Many of these tips are from I’m a Quicken Head, which has infrequent but useful updates. (Subscribe to Quicken Head.)
- Quicken community forums — Get help from other Quicken users.
- Quicken hints and tips by Dr. M — This is a treasure-trove of Quicken tips, with ten pages of ideas. But the site may make you go blind. If you can’t find help elsewhere, check here.
- Kerry’s Quicken tips has some good ideas, particularly if you’re tracking a small business in Quicken in addition to your personal accounts. (Such as I’m doing.) But this site, too, may make you go blind.
- Ask Metafilter: How different is Quickbooks from Quicken? And how difficult is it to learn?
I’d love to hear about more Quicken tips and tricks, especially when it comes to working with graphs and reports. I’ve managed to learn a few things on my own simply through trial and error. For example, I can now create reports that break down data by quarter. These are useful for spotting trends. (Like too much comic book spending.)
How many of you use Quicken? Do you feel comfortable with it? Do you have questions about it? Flexo just posted a list of 10 improvements he’d like to see in Quicken 2008. He’s also giving away a copy of Quicken Premier 2007!
.jpg)

May 17th, 2007 at 9:11 am
I am also a Mac user. I’ve actually decided to go back to Quicken for Windows, though, by running it on a Parallels Desktop virtual machine within my (Intel-based) Mac. I am having some trouble getting my data converted back to Quicken for Windows (even after carefully following the instructions on the Quicken website), but I’ll figure it out eventually. I think the problem is that I don’t have the latest and greatest Quicken for Windows, which is what the website instructions target. I’m not eager to pay for an upgrade, though.
Thanks for the tips, though. Great post!
May 17th, 2007 at 9:25 am
I was using Quicken 2002 for a few years, but dropped it when I realized they wanted me to buy a new version every year.
Lately I’ve been using Gnucash, which is able to download transactions straight from my banks as well as read and write Quicken’s file formats. Plus it’s Open Source so all I had to do was install and run it. It’s available in several popular linux distributions.
If you’re on Mac OS X, you can use http://macports.org to install it; macports takes care of the many dependency libraries for you.
May 17th, 2007 at 11:40 am
We started using Quicken this year and I find that it works well for tracking where our money goes during a particular month. However, I have not been able to get the budget part of Quicken (which is supposed to be generated off the data I already inputed) to work. When I tried to get Quicken to generate a budget from the past month’s data, I got a big mess. When I tried to create my own budget I ran into a problem b/c we have 4 mortgages (4 different properties) and there is only one line for mortgage and I can’t figure out how to add additional mortgage payments. Any thoughts would be appreciated.
Thanks!
May 17th, 2007 at 12:16 pm
[...] Quicken Hacks: 25 Hints, Tips and Tricks [...]
May 17th, 2007 at 12:19 pm
I used to be a loyal Quicken for the Mac user until I learned more about the “sunset” policy that cripples old versions of Quicken. I just logged in last night to download transactions from my bank when I saw that my bank had stopped supporting Quicken 2004.
As you mentioned J.D., this is infuriating to me. I don’t want the new functionality, I just want my software to keep working.
Last night I decided to start looking elsewhere. I found a program called Moneydance, which is cross-platform (Windows, Mac, Linux) and $30. You can download the software for free and enter up to 100 transactions before needing a license.
I’m writing about the transition on my blog (linked above), but so far it’s been very smooth. Importing 1.5 years of data from Quicken to Moneydance was easy and quick - no more than a couple of minutes. Also, I was able to connect directly to my banks to download transactions - something I could never get to work with Quicken 2004. Before I had to download the file and then import it to Quicken.
Moneydance also seems to be more intuitive and less feature-bloated than Quicken. And best of all, the license covers free upgrades for the next few years with no evil sunset clause.
May 17th, 2007 at 2:37 pm
Does anybody know of a good site for MS Money tips? That’s my SW of choice.
May 17th, 2007 at 4:50 pm
Create your own Microsoft Excel files by going to the MS site with the templates.
http://office.microsoft.com/en-us/templates/FX100595491033.aspx?pid=CL100632981033
You’ll learn more and be in control.
May 17th, 2007 at 5:36 pm
Clearance Items: Fast Food Crime Watch!…
It’s Thursday, time for… The Consumerist Grease Blotter®: Police arrest woman with Parkinson’s [Visalia Times-Delta] Avila, 46, says she has suffered from Parkinson’s disease for 11 years and takes several medications for the condition. While wai…
May 17th, 2007 at 10:34 pm
[...] Quicken Hacks: 25 Hints, Tips and Tricks [...]
May 18th, 2007 at 10:09 am
amazon has quicken deluxe on sale, i bought it just a few days ago. great post, j.d. you’re timing couldn’t have been better.
here’s the link (+coupon code) if anyone else wants to as well: http://dealnews.com/deals/Quicken-Deluxe-2007-for-30-shipped-more/166714.html
May 18th, 2007 at 10:59 am
[...] Quicken Hacks: 25 Hints, Tips, and Tricks Quicken on the Mac is a pale comparison to the Quicken on the PC. I feel like I should be able to get more out of the program, so I went on a scavenger hunt, scouring the web for the best Quicken hacks. There aren’t many out there. Here are the 24 hints and tips I deemed worth sharing [...]
May 18th, 2007 at 8:18 pm
I tried quicken a few months ago but I found it unreliable and bloated with features that I didn’t need. It took me hours to figure out things and there was a bug with downloading transactions that almost caused me to bounce a check. All that could be forgiven, but the horrible customer service I went through made me never want to deal with Intuit again.
I got my refund and went back to using my trusty excel spreadsheet.
GJ
http://www.60in3.com
May 19th, 2007 at 4:19 pm
I also use Quicken on a Mac. My favorite thing about it is that I can also use Pocket Quicken on my Treo to enter cash transactions as they happen, and synchronize it with the desktop version. It also lets me check my net worth while I’m on the subway, which is weirdly satisfying.
May 20th, 2007 at 8:10 pm
[...] Quicken Hacks: 25 Hints, Tips and Tricks [...]
May 21st, 2007 at 7:58 pm
Thanks for the great tips. I have used both Money and Quicken in the past. I like Quicken better as it is actually easier to use and has a more user-friendly interface for an computer idiot like me.
May 25th, 2007 at 6:06 am
I was initially frustrated that Quicken didn’t support downloading of data from the Thrift Savings Plan (TSP), the 401(k) for civil servants and military (more frustrated at TSP than Quicken). I did some research and figured out how to import historical prices into Quicken much like Quicken will do with commercial financial institutions.
I have wrote up a HOWTO and also have the updated file that contains TSP historical prices from 2003′ish to now for all the funds. The HOWTO and file is located here:
http://middleriver.net/WordPress/?p=35
Hope folks find this useful,
-Allen
May 29th, 2007 at 6:36 am
[...] Quicken Hacks: 25 Hints, Tips, and Tricks [@ Get Rich Slowly] [...]
June 1st, 2007 at 4:21 pm
[...] May 17th: Quicken hacks: 25 hints, tips, and tricks [...]
June 6th, 2007 at 9:38 am
If you would like to use a web-based solution what supports SSL try MoneyFlickr ( http://www.moneyflickr.com ). Advantages are: multiple currency support, easy-to-use - it’s a fairly simple tool. I’m using this for personal finance since I can reach my history from everywhere, everytime (and no installation required).
June 6th, 2007 at 2:19 pm
Sorry, but I’d feel _very_ nervous entrusting financial data to a site which doesn’t even have a published privacy policy. (By contrast, Wesabe’s privacy policy.)
And dH, a little more disclosure would be appropriate here: you appear to be not just a satisfied user, but MoneyFlickr’s developer.
June 6th, 2007 at 2:40 pm
Dear James,
thank you for the reply - yes it’s not a secret, I’m a developer - and we have a privacy policy of course: http://www.moneyflickr.com/?mode=policy (at the bottom of every screen - maybe it’s too small, you’ve right!). I try to put every useful functions to the system while I try to keep it simple also. There is more complex offline systems, like Quicken - MoneyFlickr developing is ‘on-demand’. If you have an idea/request what should be implemented, drop a mail to us. Also it’s true, you have to trust in a 3th company when you store - for an example - financial data remotely but the same thing happens with information; like Google emails, calendars, contacts, or FlickR private photos, etc. And we all know, information is value.
June 6th, 2007 at 2:44 pm
A last notice: despite the fact as I’m a developer - I’m a satisfied user of the system also.
- But I don’t want to ’spam’ GetRichSlowly threads with MoneyFlickr entries, we’re going to offtopic - If you have any questions please ask on the developer blog or drop me a mail - I’m happy to reply to any questions.
June 6th, 2007 at 3:05 pm
we have a privacy policy of course: http://www.moneyflickr.com/?mode=policy (at the bottom of every screen - maybe it’s too small, you’ve right!)
My apologies, I hadn’t spotted that.
Best wishes with your development.
August 31st, 2007 at 1:01 am
[...] with this popular piece of personal finance software. Several months ago, I gathered and posted a collection of my favorites. Macworld has collated their top 10 Quicken tricks. While one is Mac-specific, I believe the others [...]
September 1st, 2007 at 11:21 am
Here is one trick I came up with for tracking shared expenses (with roommates, significant others, etc) so that you can account for the fact that you may have bought groceries but the other person paid the electricity bill.
http://www.davidgiesberg.com/2007/06/27/tracking-shared-expenses-in-quicken/
September 19th, 2007 at 4:47 am
In Quicken 2007 deluxe the program never remembers the current file in use, it always asks which file to open.
Could you advise please
Thank you
Dave UK
September 28th, 2007 at 4:28 am
Quicken have thoroughly let us UK and indeed European customers down. All they seem to care about are the American and Canadian markets. On top of this their programs are much too complicated with many rarely needed facilities, and they have actually programmed in planned obsolesence. It’s a pity as people will choose other software, Intuit are not the only ones making personal accounting software.
December 3rd, 2007 at 1:17 pm
I used to track everything in Quicken — but I found that it took way too much of my time. Now I use it as my check register and that’s it. Is it REALLY worth the effort to enter all your credit card and cash xactions etc etc? Would love to hear from folks — I’m not convinced it’s worth all my time.