- Comments (15)
- Text Size: Down Up
moneysense.ca, 4/01/09
Four Reports to Track Your Finances
Want to get a better handle on your finances? The first step in improving your finances is knowing where you stand. And what better time than the New Year to start afresh! Every January, I compile four financial reports for our household and you may find them interesting and instructive as well.
Income versus Expenses
It’s Personal Finance 101: Spend less than you earn. But how are you actually doing? If you track your finances using software like Microsoft Money, Quicken, Gnu Cash or even trusty old Excel, this part is easy. You simply have to generate the report for Income and Spending for 2008.
If you don’t track your expenses, perhaps you may want to consider doing so in 2009. If you think that this is a boring chore that will suck up time that you’d rather spend doing something more pleasurable, it doesn’t have to be. Most banks and credit card companies allow you to download your monthly statements in a variety of file formats from their website.
Net worth Statement
Is your overall financial situation showing improvement over the years? How does your total household debt compare to your equity? If you track your net worth, you’ll have a clear picture of where you stand and how you are doing over time.
While I still track our net worth, I find it much less useful these days because the bulk of our assets are in stocks and a bad year in equities (and 2008 wasn’t a very good year!) can easily mean negative growth. Still, I find value in writing down all the different accounts we have and how much they are worth as of January. If nothing else, a copy of your net worth statement could form an important part of your estate planning documents.
Portfolio Allocation
How does your current portfolio allocation compare with your targets? If you didn’t rebalance last year, you likely have a much larger portion of your portfolio in fixed income than your target allocation calls for. You can choose to rebalance or channel new contributions to equities over the next year. Being aware of your current asset allocation will also help you avoid chasing “hot” assets by reminding you that you already have enough in that asset class.
I track our portfolio using Microsoft Money and simply export the current holdings to an Excel spreadsheet and use some simple scripts to compute the current portfolio allocation.
Portfolio Expenses
As a percentage of your portfolio, how much do you pay in mutual fund fees, account fees, trading commissions etc.? Studies have shown that expenses are a significant determinant of portfolio returns. — the more you spend on your portfolio, the less your returns are likely to be. The vast majority of our portfolio is in ETFs with rock-bottom expenses but we still have trading expenses to account for. With Microsoft Money, it is easy to see how much your trading commissions are costing you. Export the Investment Transactions report into Excel and add up the commissions’ column. For instance, I found that trading commissions costs (mostly buying) cost us 20 basis points last year.
moneysense.ca, 4/01/09









These are definitely good ones. I have a spreadsheet with monthly and quarterly income and expenses – it’s nice to see a growing gap. I still need to make some adjustments since a few large things like paying taxes are distorting it.
I got this idea from a blog post that also showed passive income so you can see it rising to (hopefully) meet the expenses if that’s part of your plan. It takes a bit of work and it seems really simple, but it helps to know where you are and how close you’re getting to what you want.
SP: I believe that idea is from Your Money or Your Life. I suppose that tracking the total income from a portfolio (in the form of dividends, distributions and interest) could be another interesting metric to track. I don’t bother too much because with a mostly indexed portfolio, the yield is pretty much the same as the market’s. Still, it would be interesting to keep track of and see how the income increases over time. As you say, the day when the portfolio income exceeds household expenses would be day we achieve financial independence.
I do the first three (spending, net worth and asset allocation) quarterly. I don’t chart my fees, as I do not invest in MFs. Although we do hold ETFs and we have a flat fee commission arrangement with our discount broker, so nothing is really hidden. Also, the trading fee is a capital expense so it is included in the cost of the security.
I also find it useful to do a quick “where my money goes” report in Quicken every three or four months as a way for me to monitor my expenses and identify any “leaks” so I can plug them before they turn into problems. It also helps me identify my larger expenses so I can focus on them and think about ways to reduce costs.
My big realization in looking over my expenses for 2008 was that I’m wasting an awful lot of money on my car. My car is fairly new (2005) and paid for, and yet in 2008 I spent over $3000 in maintenance, parts, repairs, registration, insurance, and fuel. In contrast for $140/year I can have a membership in Communauto, Montréal’s version of Zipcar, and avoid all the maintenance, repairs, registration, and insurance costs. I don’t drive much anymore (it takes me a month and a half to go through a tank of gas), so I really can’t justify the expense and hassle of having my own car anymore, so come spring I’m putting it on the market.
My net worth took a beating this year because of the market and because I bought a car (which I count as a consumer purchase). I haven’t gotten all my annual statements yet to actually know what the damage is, but I expect it’s down more than 10%. I don’t track expense vs earnings, that would probably make me feel better.
3 out of 4 definitely.
Tracking expenses vs. income is the core of my financial planning. I have developed quite a nice spreadsheet that allows me to copy and paste from online accounts, categorize all my monthly exp. & inc. and pivot into monthly and annual summaries. I am working on making it a bit more robust such than someone with a general knowledge of Excel could make use of this sheet without any formatting etc, and the ability to create their own categories in a couple of minutes. May share with you CC another day when it’s a bit more robust and see if there is any value in posting it for your readers.
Net worth is also a useful tool, broken down into various sub-categories like car/home equity, and financial investments. Nice to see it going up over time, and make corrections if it happened to go down for any reason. I always keep the value of my house constant in an upward rising housing market, because I want to know that any increase in asset value is due to our own savings/lifestyle, and not the whims of the market. I have no such qualms about lowering its value in the current/coming down market though.
And I check and rebalance the allocations a couple of times a year (a habit I’ve certainly picked up from you CC).
Group RRSP trading fees are paid by our employer, and we have only the fairly low MER’s to contend with on the index funds.
Aleks: Tracking expense vs. earnings does make one feel better. Knowledge is power – if I make money, I want to know it, and if I lose money in a month, I want to know that too. I also want to know why, and how to continue or change the behaviour next month. Incidentally, I am an advocate of the yearly budget, vs. monthly, because so many expenses are not monthly, and get forgotten about. An annual budget is more likely to be an honest one.
I do 1 through 3.
I don’t have account fees, no management fees for me (i chose only low MER ETFs for my wife), and don’t trade often.
I do make mental notes regarding trading fees at the time and minimize it as a % of the amount invested but I never concerned myself with actually calculating #4 although maybe I would be surprised, hopefully on happy kind
Does anyone know of good expense tracking for Mac? I understand they’re creating Quicken for Mac in August but would like to start tracking now.
Derek ~ I use http://www.wesabe.com on my Mac. It’s online and it’s free. I love the tags which it recognizes each time so I don’t have to put them in every time. It does all the work for me. I’ve been really impressed and it didn’t cost a dime.
[...] Four reports to track your finances [...]
So how did you actually do last year?
[...] Capitalist writes that there are four reports to track our finances! Check out his post to find out what they [...]
Shadox: Nosy, aren’t you? We saved 55% of our income (I count portfolio dividends as income). Net worth was down roughly 5.4% due to negative portfolio returns. I rebalanced late last year, so asset allocation is on target and like I mentioned in the post, portfolio expenses were 0.2%.
[...] Capitalist writes that there are four reports to track our finances! Check out his post to find out what they [...]
[...] you are at. If you don’t know what to track, Canadian Capitalist provides a four ways to track your personal finance. If you have filed using the shoebox method, take an afternoon to sort through them and start with [...]