Friday, March 26, 2010

I am sick

I'm kind of anal-retentive when it comes to money. (Tony will absolutely back me up on that statement.)  Our check book is balanced multiple times per week in Excel.  There are formulas to calculate the totals to ensure that I don't make a mistake in the math.  I have to know what's in there and at what point I'm in danger of bouncing checks.  My paydates are already populated for all of 2010.

Mid 2009, I started tracking expenses via a ledger we bought at Walmart.  I was trying to identify areas that we were overspending, as well as tabulating how much we were spending in each category so that I could properly create a budget template going forward.  This process was much to manual, so I had a tendency to "forget" to do it.  I hated printing out the statement each month, highlighting the various categories and then meticiulously writing them (in pencil, of course) into the ledger.  Why didn't I use Excel, you ask?  I don't know.  It never occurred to me.....until today.
I didn't feel like going anywhere for lunch, so I was balancing my checkbook at my desk during my lunchbreak.  Some of the credit card payment amounts made me wonder where we were spending all our money, so I started recording January, February and March charges in a spreadsheet.  Which made me wonder how much I was spending per category, so I created a pivot table.  While the total amounts made it easy to see where the bulk of our money was going, I wanted something more visual.  So I created a chart from my pivot table information.  The result was this:

There is something so wrong with me, because I'm actually PROUD of this.