Transaction Tags in Moneydance

After making the switch to Moneydance at the beginning of 2010 I discovered a useful feature of the software called “Transaction Tags” (or “Tags” for short).  What are Tags?  Well, the short answer is they provide an alternative way to group transactions beyond the standard categories Moneydance provides.

Why would you use this?  Well, let’s examine a few scenarios.  Let’s say I have a category called Parties.  Let’s go a bit further and say that I threw a backyard BBQ called “Project Velociraptor” in 2011 (which I did) and I placed all the expenses incurred for that party into the Parties category.  Now when I run a category report I see these expenses summed up in the Parties category just as I expect.

Suppose a couple years later I want to throw another party of a similar nature.  I want to see how much it cost me last time, so that I can budget properly.  I could run a category report for Parties for the year 2011 and get my total.  Easy enough.

But, what if I end up also throwing a Halloween party in 2011?  Now I have to try to figure out which transactions belong to the BBQ, and which transactions belong to the Halloween party.  That’s kind of a pain.

I can solve this problem with Tags.  First, I’d create a transaction tag by clicking Tools -> Edit Transaction Tags from the main menu.

Continue reading “Transaction Tags in Moneydance”

###
Guess what? I also write horror and thriller novels. Click here for more...


Equity Reporting in Moneydance

One thing Quicken introduced some years back was the ability to associate a liability account to an asset account.  So if you bought a house or a car, for instance, you could associate a corresponding loan account to the asset.  Then Quicken could easily do the math (asset value – liability amount) to determine your equity.

This is useful if you’re contemplating taking out a home equity loan, or maybe selling your house.  You might want to see if you’re upside-down on your car.

Moneydance doesn’t allow you to associate liability accounts with assets.  I liked this feature of Quicken, so I set out to recreate it within Moneydance.

I accomplished this by creating customized net worth reports and graphs.  The graph trends my equity over time, while the report shows me exactly how much equity I have at the time I run the report.

I started by building a standard net worth report.

Continue reading “Equity Reporting in Moneydance”

###
Guess what? I also write horror and thriller novels. Click here for more...


Multiple Escrow Payments in Moneydance

Moneydance can track your home’s value as an asset, and it can also track your mortgage as a liability.  When you set up your mortgage in Moneydance it’ll ask you which account you want your escrow payment to transfer into.

If you just want to track the total amount that goes into escrow as an expense, then this is fine.  Just create a category called something like “Mortgage Escrow” and set the loan account to transfer your monthly escrow payment into this category.

However, if you want to track the discreet breakout of each portion of your escrow payment, this poses a problem.  My escrow payment is a combination of my home insurance and my property taxes.  I want to track both of these expenses under Insurance and Taxes categories.

Quicken could do this right from the loan account.  Unfortunately Moneydance can’t.  There is way, however, to make this work in Moneydance.

Continue reading “Multiple Escrow Payments in Moneydance”

###
Guess what? I also write horror and thriller novels. Click here for more...


Category Reporting in Moneydance

Categories aren’t new to personal finance software.  A category is just a bucket in which to track spending.  You could have categories for Food, Entertainment, Auto, Utilities, and more.  I won’t go into great detail here; you can read the Moneydance documentation for more information.  I’m going to assume you have a rudimentary understanding of what categories are and how they’re used.

The point of this article is to provide examples of useful categories and subcategories, and some tricks on reporting on them.  This is by no means a definitive guide on the subject; rather it’s more of a set of examples to illustrate how I’ve come to use them.

Categories are easy to create.  Click on Tools -> Categories from the main menu.

You’ll be presented with a list of existing categories.  Moneydance also displays the type (Income or Expense), the balance, and the grand total.

One thing to keep in mind is that categories are really just accounts in category’s clothing.  Moneydance presents them as logically different, but functionally they’re the same.  But I don’t want to get off-topic here; it’s not important for this purposes of this article.  It just explains why there are balances in your categories.

Continue reading “Category Reporting in Moneydance”

###
Guess what? I also write horror and thriller novels. Click here for more...


Quicken 2007 & Lion

Intuit recently announced that Quicken 2007 for Mac won’t run on the new Mac OS X 10.7 “Lion”.  The reason for this is that Apple is discontinuing support for their “Rosetta” technology, a technology that allows old Power PC code to run on newer Intel Macs.  Intuit is “working with Apple” on this to see if they can’t get Apple to bend a little, possibly allowing Intuit to distribute Rosetta libraries with Qucken 2007.

Instead of providing a decent upgrade option for Mac users, Intuit has released “Quicken Essentials”.  Based on what I’ve seen and read Quicken Essentials doesn’t match either Quicken 2007 for Mac or Quicken for Windows’ feature set.  It appears to be woefully inadequate; not a viable upgrade option.

And don’t forget that Intuit forces their users to upgrade by crippling the software they paid for.  Three years pass and they turn off all online features.

Intuit’s advice to Mac users is to “upgrade” to Quicken Essentials and just suck up the lack of functionality, or run the Windows version.

My suggestion?  Upgrade to a different software package instead.

Download Moneydance for free.  Import your Quicken data, then run it side-by-side with Quicken before buying.  It can do virtually everything Quicken can do, and the developer won’t cripple your software after three years.

*** An important note: Before upgrading to OSX 10.7 “Lion” you must export your Quicken 2007 data before you upgrade the OS; otherwise the data will be locked up in an application that will not launch.  Regardless of which financial application you switch to (Essentials, Moneydance, iBank, See Finance, etc.) you’ll need this data in QIF format in order to import it into your new application. ***

Why go backward when you upgrade?  Might as well invest in the future.

###
Guess what? I also write horror and thriller novels. Click here for more...


Moneydance 2011

Back in February of 2010 I replaced Quicken for Windows with Moneydance on the Mac.  Since then I’ve written briefly about SEE Finance and more recently about iBank 4.

As a Moneydance user it seemed only fitting to also talk about the latest Moneydance release, Moneydance 2011.  As I write this, version 2011 is currently in release candidate state.  Since release candidates are feature-frozen I don’t feel I’m jumping the gun by writing now.  Moneydance 2011 has been officially released and can be downloaded from here.

I’m going to assume that readers are already familiar with Moneydance 2010.  If not, you might want read the original article I wrote, or visit the developer’s website.  Having said that, I thought I’d mention some of what I consider to be the more salient improvements Moneydance 2011 brings to the table.

First off, the general look and feel of the software is the same; the interface has undergone only cosmetic changes.  The application is still written in Java and is still available for all three major OS platforms.  Moneydance still isn’t the prettiest software, but its strengths have been and continue to be functional in nature.

Continue reading “Moneydance 2011”

###
Guess what? I also write horror and thriller novels. Click here for more...


iBank 4

Recently I was contacted by IGG Software about a post I wrote back in early 2010 detailing my search to replace Quicken with a Mac equivalent.  Doug Bowman (formerly of Google and currently at Twitter) commented about my article on his Twitter feed.  I guess that generated a little buzz for a couple days.  In my original article I evaluated GnuCash, Moneywell, Moneydance, and iBank, eventually settling on Moneydance.  In that original comparison I used iBank 3, but the performance after importing my ten years of existing Quicken data was so poor that I couldn’t actually test the features.

When IGG contacted me, they informed me that they’d released version 4 of the software since then and that the performance had been improved drastically.  They asked if I’d take a look at their latest version.  I love personal finance software and I was interested in seeing the improvements, so I happily agreed.

The goal in my original article was to find a Mac-native replacement for Quicken.  As I mentioned I did that with Moneydance over a year ago.  Since that problem has already been solved I decided that this article should focus on two things:

  1. Answer the question of whether or not iBank is now capable of handling large amounts of data
  2. Finally review iBank to see if the important features are there

 

The short answer to question #1 is a resounding yes.

Continue reading “iBank 4”

###
Guess what? I also write horror and thriller novels. Click here for more...


Budgeting With Moneydance

I recently switched from Quicken 2009 to Moneydance 2010 back in February of this year.  Since then I’ve been on sort of a quest to fix our finances.  Part of that quest has been to set a budget and stick to it.  I toyed with budgeting in Quicken a few years back but back then I was trying to budget each subcategory and, since I have so many, I found that difficult and ultimately useless.

So I thought I’d give Moneydance’s budgeting features a go and see what happened.  First though a bit of a disclaimer: this isn’t intended to be a tutorial per se; rather this is an account of how I use the software.  That said, if you find that this information is helpful then all the better.  Also, this article assumes that you have a working knowledge of the software; for example, you have one or more accounts set up and have entered transactions that are assigned to one or more categories.  Hopefully you also have at least a few subcategories set up too.  It’s also a good idea to first read the instructions for the budgeting component of Moneydance, located here.

Creating A Budget

To create a budget you first choose “Budget Manager” from the “Tools” menu.  Then click the “New” button.  You’ll see this window:

Continue reading “Budgeting With Moneydance”

###
Guess what? I also write horror and thriller novels. Click here for more...


Turning Off Windows

When I decided to switch to the Mac one of the first things I did was create an application to application comparison matrix in order to ensure I could find an comparable Mac replacement for all my important Windows applications.  I found some great articles written by others who’d made the switch and that really helped in that process.  Now that I’ve had my Mac for a year and a half or so I’ve found replacements for virtually everything I had on Windows.  In order to help others who are making the switch to a Mac or maybe just looking for a Mac replacement for a Windows application they can’t seem to shake, I thought I’d put my cross-reference list here, albeit it in a very informal, unstructured manner (trying to avoid a boring list).  I’ve included links where possible.

My hope was that most of the apps I used on Windows would have a Mac port.  That way I wouldn’t have to learn something new and the learning curve would be shortened.  I’m not opposed to learning something new but switching everything over at once and having to relearn everything is a tall order and I wanted to be productive as quickly as possible.  Luckily many of the apps I used on Windows had Mac ports.  Firefox, for instance, is available for both (as well as Linux).  I used Safari for a while but ended up going back to the comfort and familiarity of Firefox.  Unfortunately the default theme for Mac Firefox is kinda ugly, in my opinion.  I use the Silvermel theme and it both looks and works great.  There’s also Opera and Camino, as well as a slew of other, more obscure browsers to choose from.  Most recently though I’ve been using  Google Chrome; it’s been lightening fast, incredibly stable, and has a great bookmark syncing feature.  It’s also available not only for the Mac but for Windows and Linux as well.  No matter which browser you go with giving up Internet Explorer will be incredibly satisfying. Continue reading “Turning Off Windows”

###
Guess what? I also write horror and thriller novels. Click here for more...


Moneydance 2010

In the spring of 2010 I’d been a Quicken user for a little more than ten years (since 1999 to be exact).  In the summer of 2008 I made the switch from Windows to a Mac but I had to hang onto Windows XP for a couple applications for which I just couldn’t find Mac equivalents.  One of these two applications was Beyond Compare for which I finally found a suitable replacement in DeltaWalker.  The other was Quicken.  Quicken for Mac does exist but every review I’ve ever read about it is completely unfavorable.  I’ve never seen a product more universally panned.  It hasn’t been updated since version 2007 and the first proposed update since (Quicken Financial Life) had a fraction of the features of its Windows counterpart.  That initiative was scrapped by Intuit (generally read sentiments being that it was pretty terrible) and has since been tasked to a company Intuit recently purchased called Mint.com.  That product at the time of this writing is called Quicken Essentials for Mac (the title really a euphemism meaning fewer features for the same price).  It’s still pretty lame in comparison to its Windows counterpart, so much that I’m not willing to spend $60 on it only to likely have to request a refund (since I can’t seem to get a trial version).

So after having the Mac for about a year and a half I went on the search once again for a suitable Quicken replacement for the Mac.  There were more players than I had originally thought but most of them did not have a comparable feature set to Quicken.  After doing some research I ended up settling on four possible replacements; iBank, GnuCash, Moneywell, and Moneydance.  What I found is that I experienced such poor performance on many of the replacement solutions I was unable to test most of these “feature by feature”.  All of the other applications had problems of varying degree importing my Quicken data as well.  Instead this is more of a review of Moneydance than anything else.  For more extensive reviews on multiple personal finance products click here.

(I’ve added an addendum review to include a short review on a Mac personal finance application called SEE Fiance after it was recommended in a comment below by Robert Tell.  I’ve also added a follow up review on iBank 4.)

Continue reading “Moneydance 2010”

###
Guess what? I also write horror and thriller novels. Click here for more...