1. How to Activate Tags in Quicken

    Reader MataDorG left a comment on my latest post discussing tags in Quicken, asking how to make the tag field appear in the Quicken register. Apparently, his/her version of Quicken (2010 Home & Business, in this case) wasn’t showing the tag field at all.

    The “tags” feature is one which can be turned off and on in Quicken. When tags are enabled, the “tag” field should appear appear in the register, like so…

    If that’s not the case, then head up to your Quicken menubar to turn the feature on.

    Activating Tags in Quicken

    In the menubar, select EDIT → PREFERENCES → QUICKEN PREFERENCES. This should bring up a separate window. In the left section of that window, select REGISTER, as shown below.

    Now put a checkmark in the box labeled “Show Tag field.” Finally, click the OK button.

    That should do it. Tags should now be available in your Quicken account registers!




     

     

  2. Poll: What Matters When Buying a New Car?

    There’s a new poll out from Rasmussen. Apparently, Americans have become more origin-conscious when it comes to buying new vehicles.

    In a similar poll from 2008, roughly 51 percent of Americans said the most important factor in buying a new automobile was getting the best deal. Today, however, that percentage has dropped:

    Two years ago, only 32 percent of respondents placed more importance on “buying American.” So it appears there’s been something of a mindset-change.

    There’s a snag, however. Just what exactly does “buy American” mean? As the article tells us:

    But Americans are divided on what exactly American-made means. Forty-one percent (41%) believe buying a foreign brand that is built in the U.S. is the same as buying American, but 42% do not. Another 17% are not sure.

    Still, a majority (59%) of adults consider the “Big Three” — Ford, General Motors and Chrysler — to be the only American car companies. Twenty-nine percent (29%) disagree, while 12% are undecided.

    For my part, while my employer is a GM-centric auto group, my household has purchased only Hondas and Nissans in our vehicle-buying history. I was never a big GM fan to begin with, but after seeing everything that’s gone down the last several years, I can safely say that I will never purchase a GM or Chrysler product. (I have no qualms with Ford, though, and might actually consider them if I needed, say, a new full-size truck … though that’s extremely unlikely. Actually, I greatly respect Ford for NOT stepping up to the taxpayer trough when their two counterparts limped into Washington with their hands out. After all, that would’ve given Ford all the cover in the world to get in on the taxpayer action.)

    Obviously, my fellow Americans (1) have very short memories, and (2) have no problem purchasing cars and trucks from companies that have proven themselves to be miserable failures, over and over again, and who have been direct and unrepentant beneficiaries of taxpayer bailouts.

    (And oh yeah — they’re brazen liars, too.)




     

     

  3. Quicken: Cash Flow Forecast

    Over the years, Intuit has added lots of tools to Quicken — mostly, I would argue, to encourage its users to adapt an annual upgrade cycle of the software. While I adore Quicken for its performance at tracking accounts, spending, and net worth, I find myself using very few of the additional tools that its Deluxe and Premium versions offer. (As of this post, I’m using Quicken 2010 Deluxe.)

    One such tool — brought to my attention by an email a few months back — is Quicken’s Cash Flow Forecast. It’s meant to help with long-range (say, a year out or more) cashflow planning. Quicken’s Help Files explain it like this:

    For long term forecasting use Quicken’s Cash Flow Forecast feature. A cash flow forecast lets you project your cash flow for the future, based on scheduled bills and deposits and estimated amounts. Quicken can forecast your spending patterns for up to two years, and displays your account balances in a graph.

    You can get to the Cash Flow Forecast via the menubar:

    PLANNING → CASH FLOW FORECAST

    When I select that, Quicken displays a graph like this:

    That awfully smooth, upward-sloping line is meant to show me how my bank-account balances will steadily increase over the next year IF my monthly “Income Items” and “Expense Items” meet the parameters I’ve set up. (Displayed figures above have been certified by the Congressional Budget Office. So you know they’re, uh, reliable.)

    Forecasting: It’s a Lot of Work

    The graph is all fine and dandy, I suppose. However, it took me a patience-testing hour or so to get Quicken’s Cash Flow Forecast set up in a way that’d reflect anything close to reality. Initially, Quicken’s “brain” had taken my next year’s worth of Scheduled Transactions, combined it with my average monthly categorized income and expenses, and applied all of that to my household financial cash flow in a manner that I can only describe as MADDENINGLY RANDOM.

    Some “income items” appeared twice. Many “expense items” appeared three and four times. Now, I’m all for conservative planning, but come on. Those initial figures were a disaster, and way out of whack.

    I can’t imagine that any large chunk of Quicken users would be willing to plow through their incomes and expenses, category by category, Scheduled Transaction by Scheduled Transaction, just to get this thing running at a somewhat realistic clip. I did it, but only because I’m a money dork. The rest of you probably have lives.

    Just Start Over?

    The Cash Flow Forecast allows you to create and save different scenarios, which is probably pretty useful IF you have a few hours to kill. I wasn’t even willing to approach this feature, given what it took just to get the thing set up. (When making changes, income and expense items aren’t even listed in alphabetical order, for crying out loud. Who the hell came up with this?)

    I think that, if I were going to rely on the Cash Flow Forecast at all, I would start by scrapping ALL of the estimated items Quicken creates. I’d then simply enter the categories I wanted, by hand, starting with my largest categories (taxes, food, insurance, etc.) first. I’d likely keep the “Known Items,” as Quicken creates these from Scheduled Transactions, which ought to be fairly ironclad. (Ironclad, that is, IF you’re good about setting up all your recurring transactions as “Scheduled Transactions.”)

    Like a lot of Quicken “tool” offerings, there’s probably some value in the Cash Flow Forecast … but if you’re like me, it might take you so long to rebuild the Forecast data that you simply ignore it altogether.

    Sorry, Intuit. I’m opting instead for dumping a few months’ of Quicken report data into Excel, and working from there!




     

     

  4. K-Cup Prices to Increase

    It’s a good thing we have the Fed on our side, promising future “easy money” policies and thereby making sure that market prices don’t do something nasty, like decrease.

    Otherwise, you might have retailers and producers resorting to absolutely insane schemes, such as dropping prices on commodities and food and various necessary items. Obviously, in a credit-soaked economy like ours, price declines must be resisted at every opportunity. The last thing you want is for your present-day dollars to actually go farther (and past debts to grow more cumbersome).

    Heresy, for sure.

    Thankfully, the fine folks at Green Mountain Coffee have gotten the memo:

    Green Mountain Coffee: We’re Raising Our Prices

    I’m a big K-Cup and Keurig fan, so this eight percent increase (from $11.95 per box to $12.95) isn’t likely to dissuade me much.

    So go ahead, Federal Reserve governors. Threaten to flood the system with more money. And smile, why don’t you.




     

     

  5. Blurry Images in IE8

    Okay. So this post has absolutely nothing to do with personal finance, but I’m going to mention it anyway.

    Internet Explorer 8 is my browser of choice these days. Sometime in the last few months, I noticed that most web images (GIFs in particular) were just a smidge blurry. Not horrible, but enough to notice … and just enough to bug the living crap out of me.

    Numerous Google searches left me with no fix. I played around with settings in TOOLS → INTERNET OPTIONS for hours, probably, but to no avail. I figured it had to be something with Internet Explorer 8, as the same blurry images looked just fine in IE7 (the default browser on my work laptop).

    Then I happened upon the third post in this message-board thread … and BINGO.

    Turns out the zoom slider in the bottom right corner of my IE8 browser had somehow gotten changed to 105%.

    When I adjusted it back to 100%, my web images were clear again.

    Oh, the joy I felt. Amazing how such a little thing can cause untold irritation. And the fix, of course, was in plain sight the whole time!




     

     

  6. Excel: Switching Rows & Columns

    Every so often I find the need to swap (or transpose) rows and columns in Excel.

    Take a report generated in Quicken, for instance. I like to see how my spending categories change from month to month. Getting Quicken to generate a Spending Report that shows this is really easy. In the Quicken menubar, REPORTS → SPENDING → SPENDING BY CATEGORY will get you there. Generate the report, then select your Date Range. Add a column for “Month” and you’re set:

    Spending-By-Category Report

    Exporting this data to Excel is a simple matter, too. In the Quicken report menubar, choose EXPORT DATA → REPORT TO EXCEL-COMPATIBLE FORMAT, then give your data a save location and a name, and save it.

    One problem, though: When opened in Excel, Quicken reports usually have the date periods as columns, and spending categories reside in rows. What if you want your categories in columns, and your dates in rows? (This is usually my preference.)

    Thankfully, Excel makes such a switch very easy to do.

    Transposing Rows & Columns in Excel

    As an example, I created a “Spending by Category” report in Quicken which shows my auto expenses for a portion of 2010 (March 1 thru July 31):

    Spending-By-Category Report

    Exporting that to an Excel-compatible format gives me a text file, which I named “Data2.txt” and saved on my desktop. I then opened a blank Excel spreadsheet, and from within Excel, I then opened Data2.txt.

    Importing a text file to Excel like this is quite easy: In the Excel menubar, select FILE → OPEN. Navigate to the text file you wish Excel to import. Excel opens its Import Wizard, where you can change column breaks and ignore rows as necessary. When you’ve finished this, click OK to close the Import Wizard, and your text file should now be converted into Excel.

    Readers who wish to follow along with the files I’m using can get them here:

    Excel File: Sample Data (ZIP file with Data2.txt and Data2.xls inside)

    Just download and extract that ZIP file, and you’ll have the files I use below. Play with them as you wish!

    Once the text file has been opened in Excel (I’m using Excel 2010), it’s time to work some magic. We want our date headers to be in rows, rather than columns, and our categories to be in columns, rather than rows.

    First, select the area of data to be transposed. In this case, that’s B5 thru H13:

    Select the data to transpose.

    Now right-click inside that area, and select COPY:

    Right-click and select COPY

    Now place your cursor in the spot where you want the data to be moved (and transposed) into. For this example, I’ll select Cell B15. In that cell, right-click again, and choose PASTE SPECIAL:

    In the PASTE SPECIAL menu that appears, select TRANSPOSE:

    PASTE SPECIAL -- TRANSPOSE

    Our data rows and columns have now been switched (transposed)!

    Data is now transposed.

    I can’t tell you how many times that this feature of Excel — being able to swap rows and columns with a few clicks — has saved me TONS of work!




     

     

  7. Quicken Users: What Do Tags Do For You?

    Reader Kelsey emailed me with a Quicken-related comment a few days ago. Buried in the middle of it was a question that intrigued me:

    Categories I get, but there’s these tag things … what would anybody even do with those?

    Personally, for my household, I haven’t really come up with a good use for tags in Quicken. To this point, categories have taken me everywhere I need to go. (I’m currently using Quicken 2010 Deluxe, and have reviewed it previously.)

    Quicken Tags: What’s the Point?

    Basically, tags give Quicken users a way to “categorize” transactions outside of, and across, categories. I guess you could call tags a “second level” of categorizing goodness.

    Suppose you wanted to sort of “sub-track” your grocery spending so that you could see how much of your grocery spending was attributable to unhealthy food. You could do something like this…

    … and then run a report as necessary to see how much you’ve been spending on foods that will kill you. But in reality, such a usage of tags wouldn’t be all that novel. After all, you could do the same thing with categories. Simply have a subcategory of “Junk Food” in your main “Grocery” category, and you’d be set.

    However, say you wanted to track all your “Nonessential” spending. That’s a “tag” that could span across categories because, after all, “nonessential” could apply to Groceries, Entertainment, House Repair & Remodel, and just about any other category you could think of.

    So keeping an eye on “Nonessential” spending, via a tag named “Nonessential” or something similar, is more along the lines of what Quicken intended tags to accomplish.

    Possible Use of Tags: Tracking Your BMF

    One “big picture” idea for tag-use that comes to mind — but which I’d be way too lazy to implement — would apply to anyone who wanted to follow Elizabeth Warren’s Balanced Money Formula, as described in her book All Your Worth (review).

    Warren advocates that folks classify their outflows as one of three types: “Must-Haves,” “Savings,” and “Wants.” Then track where your money’s going, and aim for the following percentages:

    BMF Targets: 50% Must-Haves, 20% Savings, 30% Wants

    I’m good with using those three “types” to track spending and saving, and to create a plan for such, but I’m a Certified Data Dork, too. I would also want to know what I was spending on, say, groceries, household consummables, mortgage debt, and so on.

    So, in Quicken, I’d categorize my spending normally as regards the groceries, dining, and so on. But then I’d also give my spending “tags” of Must-Haves, Savings, and Wants as applicable. That way, I could quickly generate a Quicken report (utilizing those tags) to show me how my BMF-style money plan was working out.

    Possible Use of Tags: Monitoring Use-Tax Expense

    For a while, I really thought I could make great use of Quicken’s tagging feature by assigning specific tags to my use-taxable online purchases throughout the year. By assigning a tag of something like “Use Tax” to all my online purchases on which I hadn’t paid sales tax at the time of purchase, I could, at tax time, fire up a simple report and see how much I needed to remit in use taxes to my state’s taxing authority.

    In the end, though, I decided to treat my use-tax liability as what it really is — an ongoing “debt” that I owe to the state, and which I pay off in April of each year. So I accrue for it in its own Quicken liability account, as detailed in my Quicken: Handling Use Tax tutorial.

    What Have You Made Tags Do?

    I’m sure lots of people have put Quicken tags to work for them — I’m just not one of those folks. To date, I’ve been able to make categories do ALL my heavy lifting.

    So what about you? Have you come up with a great use for Quicken tags that I’ve overlooked?




     

     

  8. Quicken’s Register Calculator

    As readers probably know, I’m a big fan of Quicken. It’s my finance-tracking tool of choice, and has been since the mid-1990s.

    Last week, I received an email from reader Dennis, who apparently has caught on to something of a shortfall in Quicken’s internal register calculator. For those of you who aren’t sure what that is, here’s a screenshot:

    Quicken's internal register calculator

    If you have numbers to add or subtract, you can do it inside the SPEND and RECEIVE columns in Quicken’s register. Anyhow, here’s what Dennis had to say:

    In your review of Quicken 2010 you revealed that you have been a Quicken user for a number of years. Personally, I’ve been using it since the second release.

    I’d like to alert you to a bug in Quicken that has been for many years. I submit a bug report on this issue with every new release, but apparently one user isn’t enough to promote change. Maybe you would have better luck.

    The Quicken Register Calculator does not perform calculations in the mathematically standard priority sequence of Parenthetical, Exponential, Multiplication, Division, Addition and Subtraction operations. Using the Register Calculator, the key strokes “2+3*3+5*3″ are evaluated as “(((2 + 3) * 3) + 5) * 3″ resulting in 60 (the wrong answer) instead of “2 + (3 * 3) + (3 * 5)” which results in the right answer of 26. Anyone accustomed to using any standard calculator will experience this error.

    To avoid this error, it’s necessary to add repetitive values individually when using the Register Calculator (2+3+3+3+5+5+5 = 26). It’s a lot easier (and more accurate) to use any external calculator and copy the result into Quicken; however, since that last step creates an opportunity for transcription error, so it would be better if Intuit would simply fix the Register Calculator. Of course they could rename it to “Register Adding Machine” which would at least alert the user that it doesn’t function as a ‘Calculator’.

    Dennis’ note caused me to think: I can’t remember the last time I used any Quicken calculator. I almost always have Excel open, so it’s kind of become my default “quickie” calculator. And now that the calculator in Windows 7 shows you all the numbers you’ve entered …

    Windows 7 Calculator

    … as you input your formula, I have even less reason to utilize any “calc-ability” inside Quicken.

    I spent some time trying to think of a situation where having Quicken calculate this way — computing what is effectively a formula, and doing it without standard mathematical priorities — would be an issue for me, but I couldn’t come up with one. Again, I’ve grown accustomed to using Excel as my calculator for pretty much everything.

    I suspect that Intuit programmers never really intended this feature to do much more than add or subtract a string of numbers. Don’t guess I can really fault them for that, either. It’s awfully tough to program software that can do everything for everybody!




     

     

  9. How to Know You’re a Dork

    This past week, I replaced my laptop (a 5-year-old Dell Inspiron) with a fresh ‘n’ shiny Toshiba Satellite A665-S6050.

    Inherent in this upgrade was my switchover from Windows XP Home, which I loved, to Windows 7 Professional, for which I don’t yet have a verdict.

    (No, I never so much as bothered with Vista. In fact, a couple of years ago, I purchased a second Dell laptop for my wife. My first out-of-the-box change? Wipe the hard drive and its Vista operating system, and replace it with a clean, non-OEM-cluttered full version of XP Home.)

    However, based on something I just discovered, Windows 7 just got big bonus points in my book. If you’re a power user of the calculator in Windows, as I am, you just gotta love this revamp:

    Windows 7 Calculator

    Giggity.

    And yes, I am a complete dork.




     

     

  10. Online Personal Finance Tools

    The answer to Jim’s question is “No, I don’t.”

    Great. That’s out of the way.

    So what was the question?

    Bargaineering: Do You Use Online Personal Finance Tools?

    Call me crazy. Call me “stuck in the 1990s.” Call me whatever you like. But I’m very much a guy who feels better when my personal-finance software, and the vast amounts of sensitive data therein, reside right on my hard drive.

    Now, when I say “personal finance software,” what I’m talking about is stuff like Quicken. Spending, saving, and account-balance tracking software. And I know there are lots of super-cool online-based tools out there these days — heck, Quicken and Quickbooks offer online-access versions, but even here, Intuit is way late to the game. I, however, am not yet sold on the concept.

    I like knowing that my household’s financial data is stored locally. “Locally,” as in, in my laptop. On my kitchen table. (And in a backup hard drive that’s also “locally” stored.)

    Actually, Jim’s (the Bargaineering author) feelings on the subject very much mirror mine:

    I trust all the services to do the right thing and to protect my information and privacy, but I know that sometimes mistakes are made and things can happen. Maybe I’m a little too old school; I’m about the age where I am comfortable telling people where I am via Twitter but not comfortable telling a third party my banking credentials. Mint and the like will treat it with the sensitivity it deserves but … you never know.

    Precisely. It could be, though, that I’ll rethink this stance in the coming years. Since I don’t ever use Quicken’s “transaction download” features, and thus would never store any account-access credentials with Quicken/Mint or whomever, the only info I’d be leaving on their servers would be account-balance and spending data. And who’d give a crap about that, aside from some data-mining, consumer-research enterprise?

    (Note to any data-mining, consumer-research entities who read this post: My life is boring. My spending patterns are boring. Steal my data, and you will be underwhelmed. I promise.)