So naturally as an engineer I am very numbers and data driven. Fluff is not my game, numbers, charts, graphs, hard tangible data is where I thrive. I started tracking my spending while on co-op and internship, I figured it would be good practice for when I got out in the real world on my own and needed to be financially responsible. So, at that point I created what is now my most useful tool that I use to track my finances and goals, the co-op money breakdown google sheet. Doesn’t sound exciting but contained in these 8 pages excel spreadsheet is a lot of cool stuff. We’ll start with what started it all, the daily tracking of my finances.
I color coded my categories of expenses, from left to right they are Food, gas, fun money, fitness, Significant other, and other costs. I would track every cost that came in with running totals at the bottom, weekly amount spent on each category as well as the percentage of my costs it represents. This helped figure out where I was over spending and what needed to be adjusted. Next, on the same page of the excel sheet right next to the color-coded spending category is my income category. Here I would track my income (mainly paychecks) as well as how much of that income I saved. I also tracked my 401k contributions on every paycheck and kept a running total of that as well. Yes, I had a 401k through my co-op company at 20 years old, it was pretty frickin cool. Moving on, I would run totals on all of that, run percentages for amount of money I was saving compared to making and how much I was investing compared to how much I made in total etc.
|Date:||Income:||Net profit||Savings||Invested (401k)|
|5/24/16 tax return||$74.00||$7,629.20||$900.00||$378.00|
After that I believe I started tracking my net worth in specific categories. As you can see below I would track it every month and I have a nice little graph and everything, but I would track cash, emergency fund, P2P lending, Robinhood stock account, Stash and acorn, and finally my 401k. Add all that up in a couple different columns and there’s my net worth tracking.
Another critical tool that I use on this spreadsheet is my Robinhood portfolio spreadsheet. Shown below it contains all the information on my stocks, shares, cost average, value into the position, market value and then the gain/loss with percentages. Also, the conditional formatting is a nice touch to quickly assess the portfolio. I usually update this sheet twice a week or more if I make big moves in the portfolio which I have recently.
|Ticker||shares||cost average||value in||market value||gain/loss||gain/loss %|
|updated||$8,515.13||profits and dividends||-$796.93||Current Value|
|1/18/18||money in||$8,000.00||$515.13||current market ROI|
|started||face value ROI||6.44%|
|12/2/16||net annual profit||$456.37|
Following the stock portfolio, I have two tables for dividend tracking however I’m only going to show the monthly counting dividend table. Below is a table showing how much I’ve received in dividends by each month and then sum it all together for the yearly total. As you can see I was relatively close to my goal this past year, a lot of my money was tied up in bad positions that didn’t pay dividends which ultimately hurt my portfolio as well. The other table features all the stocks I own that pay dividends, their payout on a yearly basis, how many shares I own, total yearly dividend income from those stocks, etc. I believe I am right at the $200 a year in dividends mark as we are speaking, that is not including interest payments I receive from Robinhood or the dividends I receive in stash.
I also use 2 tables for my Lending Club portfolio, the one below just tracks the interest I receive each month as it says on the account statement I get. Very simple and easy to fill out, nice little tool to figure out how the portfolio is doing overall at a quick glance.
|Lending club interest collected|
|1 year gain||$254.47|
This next one is a bit more intimidating. This is a detailed depiction of the Lending Club portfolio, I fill this one out biweekly and the immediate return column is the only one that is self-calculated, everything else is straight from the Lending Club dashboard/summary screen. I use the immediate return to gauge my APY % as it comes in rather than the speculative NAR % return.
|Lending Club info||deposited||account value||NAR % return||date||immediate return||monthly payments|
Finally, I track my blog statistics and posting schedule on my spreadsheet. As you can see I have tracked my advertising costs as well as the WordPress cost of the blog. I also track my views, visitors each month. Now if you are familiar with blogging or have one already you know that jetpack tracks this all for you currently. I just like the convenience of pulling up this spreadsheet and having all the numbers and data I’d ever care to know about right at the tip of my fingertips and easily analyzed. I think It is worth the extra time to fill out the spreadsheet.
|Blog sheet||blog was created||11/24/2017||Blog stats||2018|
|11/24||$46.98||wordpress 1 year||views||3||81|
Like I said, just a schedule of what I’ve posted and when, I also anticipate a posting schedule but that is never correct, I always have too much on my plate or other things that need my attention before this. The yellow highlighted posts are blog posts that have the potential to profit through affiliate sales, referral codes, etc. I have a column next to it with the amount they’ve made so far. Unfortunately that’s a big fat goose egg right now.
|11/30/17||future real estate investment|
|12/7/17||side money challenge|
|12/11/17||lending club review|
|12/12/17||change of plans|
|12/27/17||Discover Credit Card|
|12/27/17||Dividend update 12/27/17|
|1/3/18||stock market book FE|
|1/5/18||side money update 1|
As always let me know that you think!Hope you got some useful information from this post, and may apply some of the ideas and concepts to help organize your finances or something else important to you.