I’m a bit of a nerd (understatement) when it comes to tracking my finances. I’ve posted downloadable spreadsheets of my finances in the past, but thought it wouldn’t be a bad idea to have a sort of master spreadsheet embedded for all to see. Feel free to download them and customize them to your liking. But don’t laugh at them, they’re not as bad as some others that I’ve seen.
I need to take the time to update a lot of things for this year (hey, I’ve been trying to get out and explore and enjoy life), so a lot of the sheets are not exactly up to date, but at least you get the gist. Also my plan for 72(t) has sort of changed, rendering 1 sheet useless.
When looking at the spreadsheet, I’m still trying to figure out if my life is cool or sad 🙂 Not quite sure, but doing this stuff certainly helped me get to where I am financially…comfortable.
A few notes: I’m 100% liquid in that I have $0 in long term debt (just short term living stuff like utilities, food, transportation, etc.) and have been that way for a few years. So, I don’t exactly have any debt paydown tracking worksheet. Sorry.
So how about a little commentary on each sheet (or tab) starting at the far left (Net Worth):
Net Worth: Should be obvious what this is for, tracking your net worth. You can see my spreadsheet obsession started in 1999 when I was still in college. Really it should have started when I was 16 and working my first job and maxing out my traditional ira back in the day. I think it’s a pretty cool sheet, showing how your money grows over time. I try not to obsess over it too much and update it annually (I do have a running total in my head though). Some people do daily updates, but they probably need to get a life (looks who’s talking). Check out my goal for each year.
Dividend Total: I started tracking my dividend income back in 2008 when my brokerage company started allowing dividend reinvestments. Prior to that, dividends were just received in cash. I keep saying I’ll go back and pull records to make a bunch of updates prior to 2008, but let’s be real…that’s not happening. So, I’ll just be happy with that starting point in ’08. I’m going to destroy that 2036 goal.
If I Die: This is probably the most important sheet. Regardless of being married or not, there should be a list of assets (and liabilities) your loved ones can get to in order to settle your estate. This is not a replacement for a will, you should have one of those. But think of your spouse, for instance. In most households, one person looks over the finances. If that person dies, the surviving spouse could be left in the dark not knowing where the money is, or what bills need to get paid. I’ve also done some major consolidation, personally, just to make my financial life as simple as possible.
Expenses: I need to update this, but I know I’m tracking right on par for the course (if just a little bit under for the year). I pretty much charge everything and pay off the credit card each month. My expenses are pretty simple housing stuff, food, car, health, discretionary/fun. I wish I tracked this category sooner, but it looks like I have not had a mortgage payment since prior to 2012. Notice the low car expenses in the past. Also, at the bottom I compare dividend income to expenses. I succeeded on my goal of eliminating wasteful spending, just need to finalize executing the plan (and spend more $ on fun times).
DRIP Plan: Just tracking my dividend reinvestments for a number of years. Another way of comparing year over year, and quarter vs quarter.
DIV Worksheet: Just another way I was tracking the dividends and shares being reinvested over time. It helps me know upcoming income for a given time. Really need to update this.
72(t): This is completely out of date, as I think my plans have changed for the time being. So really, it’s just a bunch of numbers for now.
UTMA DRIP: This is a small account I set up for a niece. The goal is not to make her filthy loaded (she has to figure that out), but if the account can build into something triggering some decent passive income to start her out in life or maybe a down payment for a first home, that would be cool. Ideally, she’s not touching this money until 25. I remember what I was like in my early 20’s:
UNT/UTA/99 Galant: Just some old sheets I never deleted for some reason. You get to see how much my college degrees cost me back in the day. I had a small scholarship and was fortunate enough to receive some tuition reimbursements from a job I worked during those years (was so thankful for that).
And just like any great sales pitch… But wait there’s more!!! Here is a nifty spreadsheet for Mortgages (I didn’t create it). You can input your mortgage details, add a little extra to your payments, it will calculate when your mortgage gets paid off. ALL AVAILABLE FOR A LIMITED TIME!!! (Sorry for yelling, and it’s not really a limited time. It’s here for a long as the site exist 😉 ).
So, how do you like it (the spreadsheets that is… or um you know 🙂 )? TMI, just the right amount, not big enough? Let me know below.