Blowing Quicken a little KISS

This post may contain affiliate links, which means that we may be compensated if you click to a merchant and purchase a product or sign up for a service.


To move forward with our personal finance plan for 2013, we'll be tracking our expenses more carefully.  Just like Johnny Five, we need input to change direction with our finances, and to start making better deals with ourselves to meet financial goals.

I've had one version of Quicken or another for years, but I've always fallen short in keeping things current.  Call it personal laziness, call it ADHD, call it whatever, but I haven't stuck with it long enough to reap any benefits from the process.  This isn't Quicken's fault.  It's my fault.

However, one thing I did have control over, and one decision that contributed to my lack of success in this area, was that I tried to track too much.  Quicken is powerful and can track things at a very granular level.  And I think that I wanted to track everything at that level, down to the penny, to satisfy some kind of dark personal finance deviancy or something.

Avoiding the account tracking chain reaction

One dirty little secret with tracking accounts is that they're interconnected.  Another dirty little secret is that deciding to track the details of an account probably triggers the creation of more accounts, each of which have their own details that need to be tracked.  This was what caused me to experience overwhelm with trying to track lots of stuff.

Trying to track all of the items on my paycheck was the biggest offender.  Since I have money deducted that goes to my retirement plan, I needed to track how each payment was allocated if I wanted all of the numbers to match up in the retirement plan account.  Also, there were deductions for my flexible spending account; those would have needed to be tracked as well.  It was just too much.

So I'm trying a different tack this year.  I'll think more about what I really need to track.  The corollary to this: I need to get comfortable with what I'm letting go untracked.

Another way to think about this is to keep things as simple as possible, but not simpler.  (Apologies to Albert Einstein.)

This is my plan …

Here are some of the trade-offs that I've already made (with discussion with my wife) in tracking expenses in Quicken:

  • We're letting our credit cards do the heavy lifting with how we categorize expenses.  After an unfortunate experience with getting rid of receipts and needing them only a week later for my flexible spending account claims, I was paranoid about getting rid of receipts.  I kept them all, for years.  At the end of last year, I finally got rid of many of them.  With the exception of stores like grocery stores, wholesale clubs, and department stores, we're going to keep it simple with the categorization.  If we go to Chili's we don't need to keep the receipt to know that it's in the Dining category.  If we go to the vet, we don't need to keep the receipt to know that it's in the Pets category.  But we'll keep Walmart receipts so that we can break things down to groceries, household, and medical expenses, for example.  We cam probably get by even without keeping convenience store receipts.  If the charge is a few bucks, it's probably food.  If it's $30 to $40, it's gas.
  • I'm only going to track my net pay on my paycheck.  Tracking every last deduction, withholding, and deferral on my paycheck was too much, and I'm not really sure what I would have used the information for anyway.  If I need to see that I paid more in Social Security tax this year than last year, I can look at the end-of-year statements, or my tax forms.  If I want to track allocation to my retirement accounts, I'll do it periodically on whatever schedule I choose, instead of needing to allocate each and every paycheck (which required manual lookups from the website, unfortunately).  I think I can trust my employer to get all of the numbers right.  It's a big employer.
  • I'm not tracking sales tax.  A side effect of not keeping each and every receipt is that I miss out on the sales tax amount.  On my federal taxes, I have the choice of deducting state income tax or state sales tax, but not both.  By not keeping track of sales tax, I can only choose to deduct state income tax.  Since I live in a state with a whole bunch of different sales tax rates, it's not cut and dried to figure out the tax from the total bill.  But I'll forgo that option for the time to keep things simple.
  • We're using as much automatic updating as we can.  I had tried to update everything manually in an effort to become more aware of where our money was going.  But that turned out to be a lot of busywork.  Using the automatic updating for as much as we can has already saved a lot of time.
  • For some investment accounts I'll update only once in a while.   My retirement account can probably be updated once a month or so, if that.  (This one doesn't have the ability to be updated automatically, unfortunately.)  It's not changing that rapidly, and not by a large percentage, so I can update this as I feel the need.
  • We will, however, track categories of spending in a detailed way.  The big number — the credit card payment — just wasn't enough information to be actionable, so we'll be separating out groceries, medicines, prescriptions, household items, etc.
  • We will, however, track principal and interest portions for our debts.  After we build up our savings a bit, we'll be aiming to pay off the debts we have.  Seeing the debt amounts go down faithfully will be important.

That's my plan, and I'm sticking to it.  Keep it simple, stupid.

Quicken wizards:  Any more tips on working with Quicken for someone who obviously has a lot to learn?

8 thoughts on “Blowing Quicken a little KISS”

  1. Sounds like a pretty big change that will take some getting used to. I’d probably focus on this for a few months and not get into trying to make many other big changes or other goals. This will require quite a bit of attention from the sounds of it, but should then lead to more opportunity to make changes based on what Quicken ends up telling you.

    Reply
    • I’m hoping that doing it regularly will help. It was so discouraging to see a huge box of receipts and no tracking. So yes, lots of attention, but in manageable chunks. 🙂

      Reply
  2. I have used Quicken for 3 years and Money for something like 5 years before that (I only switched after Microsoft killed Money). I have everything automatically update each time I open the program (aside from my checking since I don’t feel like paying a direct connect fee). From there I quickly go through the transactions to see if anything is uncategorized, and if it is, I code it. I don’t bother with tracking any cash accounts, but I do break down my paycheck so I can have a clear picture of what my tax position is at any given point in time–I don’t want to go through the hassle of logging into the online site to pull my stubs. Then, when I get the email notice of my statements being ready, I go online with one screen and reconcile each account in the program on the other screen so I know that my file is accurate. All in all, it takes maybe 20 minutes a month to keep up with everything.

    Reply
    • 20 minutes per month?! That’s surprisingly low. I find that I can spend 5 minutes on a single receipt if it’s complicated.

      Reply
      • I don’t usually break down receipts. I lump groceries & household in the same broad category and that would be the only possible place for analysis. Otherwise, I simplified everything to the point where I can have everything tied out and balanced in a snap.

        Reply
  3. I use my credit card in the same way. It’s insurance for my sanity because I hate keeping track on my own. It leads to much easier reconciling at the end of the month.

    Reply
  4. So here it is – end of the year … How did you do? Any lessons learned?

    My big bugaboo with Quicken (which I’ve used for many years) is what to do with investment accounts – especially 401-K. Recently started a new job with lots of rollovers, so my previous lack of detail tracking just got swept under the rug … From each paycheck I recorded net pay, and then added (as a transfer) my retirement contribution. I was inconsistent about “closing the loop” and often didn’t allocate the contribution to the various mutual funds. Turns out I don’t miss the detailed investment performance reports from Quicken – I learned how easy it is to get performance data in Excel with XIRR – only needs the dates and dollar amounts of contributions (easily exported) and a current balance and voila – your own personal dollar-weighted rate of return.

    The wrinkle: now with my newer version of Quicken I can download and import from Transamerica – but it’s tons of transactions and still takes time – is it worth getting this level of detail if it doesn’t really change anything?

    Reply

Leave a Comment

Get my ebook 49 Ways to Spend Less free!

Subscribe to get this ebook, great content, and other goodies by email! All free!

Check your email to confirm and get your ebook!