The Frugal Canadian

A frugal spender seeks to find new ways to save money and increase her net worth.

Sunday, March 05, 2006

Microsoft Money Review

I just finished test-driving 2006 Microsoft Money Deluxe version(US). I was thinking about getting the Canadian version, but was offered this for a trial period so I thought I'd try this out first. As an accountant, I've used a number of packages such as Quicken, Quickbooks and Simply Accounting all of which are geared towards owning a business. I've always used an excel spreadsheet that I had developed for my personal finances and to date have been happy with it. My brother however has been a long time user of Microsoft Money and raves about it.

I found the setup to be fairly lengthy. Setting up the bank accounts was quite easy despite the fact that I have 5 active bank accounts. I was able to easily import the activity from the financial institutions and then I had to go through each transaction since the beginning of the year(the date of my first imported transaction) and allocate it as an income/expense category. This was a somewhat lengthy task, although I am told that in future months, the program will recognize recurring items and automatically assign them the previous month's category. I'm looking forward to see if this is the case.

I had a difficult time getting my investments setup. I already have my adjusted cost-basis calculated for my investments and since I could not import the transactions from my brokerage account, I simply wanted to enter the original cost basis. This caused a few problems because I had transfers from my bank account for recent purchases which needed to be allocated somewhere otherwize they would should up as an expense. I'm sure there was an easier way to deal with this, but I ended up creating a "dummy" account to deal with my transfers.

The other problem I had was with my Self-Directed RRSP account. My account has a number of stocks, ETFs and index mutual funds. Some of the stocks are US stocks but are converted into Canadian dollars in my brokerage account. Money automatically tagged these stocks as USD stocks and kept them in USD even though I entered them as Canadian dollars. In the end, I was able to reflect them in Canadian dollars. Money will automatically get the USD quote and convert it at the current exchange rate which I am quite impressed with. I question whether the average consumer would have the patience to set up such an investment account, but perhaps the average consumer would not have a self-directed RRSP plan.

Now that I am setup I think it will be quite a useful program and it should save me a lot of time compared to my excel template that I had developed. There are a wide array of reports that are used and these can all be exported to excel if I wanted to do additional analysis. I have set up my budget within the program which will speed up my monthly budget review. I am curious to see how the program will handle DRIPs. I also have not used any of the tax features since they are all US based. I will continue to use Money until my trial period is up. At that point, if I'm still happy with, I will purchase the Canadian version.


Post a Comment

<< Home