In order to get in control of your financial situation you have to see first where all your money goes. And that is about budget. You can do it old fashioned way with pen and paper or with software. Since I’m a software engineer my natural choice is software. I spent fair amount of time researching the market for a product that will suits my needs. It came down to two software products Intuit Quicken and MS Money. I liked more Quicken because it better adopted for Canadian users.

Here comes a challenge, both products are complex enough and instead of focusing on your initial goal you have to spend time learning the product.
I believe I read this on Joel Spolsky blog:
“When you design a software design it like if your mom will be using it!”

That is so true! Well, I didn’t plan to spend so much time on learning process so I decided to compile something simple for my own use. And voila, my “Household Budget” excel is ready. Please feel free to download it, use it, modify it and of course if you have suggestion or wish to change something in it but don’t know how drop me a line I will be glad to help.

Here is a link for download: FamillyBudget_v1_00.xlsx (134.69 kb)

The only thing I would like to ask, mention this website if someone will get interested where you got the file.

User Manual

Assets & Liabilities
The first tab on the file called “Assets & Liabilities”. It’s a sort of reality check, where actually you stand with your finances. Please understand it’s not a net worth statement, it doesn’t include any tangible assets like real estate or car or boat. It’s more about cash flow.

Semi-Monthly/Monthly Budget
These tabs are most important ones. Since I’m getting paid on semi monthly basis I’m using “Semi-Monthly Budget”. I find it easier to plan based on pay cheque frequency. Choose based on your situation. Simply delete the tab you don’t need (put mouse cursor over the tab you want to delete, right click, chose option delete). I broke it into “Income” and “Expenses” parts and the summary at the bottom.

Cheque Information
We are all humans and it’s really difficult to remember to who you wrote a cheque especially if it’s a post dated cheque.  So when it’s withdrawn from your account the only thing you can see cheque number and in my case lender will charge me $1.5 to view an image of the cheque. So I figured out it will cost me less if I will simply keep a record of it.

Groceries
Although we are using cash envelop for our grocery spendings, we still can get into the situation when we are pulling some cash from our chequing account for bread or milk. So I got interested in stats on how much precisely we are spending on the groceries and that’s the tab meaning. Besides that I’m considering to become an executive member   in Costco so I need data to understand if it’s worth it.

Clothing
This tab is very similar to groceries. I’m just interested in stats. But will you come up with your own idea please share with me.

That’s pretty much it, for demo sake I inserted random numbers into tables, so please feel free to delete them. I’m looking forward to hear from you on” Household Budget”.