Tracking Your Passive Income
Track all of your passive income streams in one place!
So lately, I have been knee-deep in crypto, DeFi and DAO projects. While it has been fun to learn and take part in all the passive income potential opportunities, tracking the money going into them and the passive income received from them seemed almost impossible.
I found some websites here or there that would give me my overall portfolio balance but it wouldn’t pull all of the rewards and APY accrual I had, this rendered them pretty useless.
So I decided I would go ahead and just build out a spreadsheet to better track this information. So I built a very basic version 1 of this spreadsheet and realized, it was still very manual process for me to pull all the data in and didn’t really do what I wanted it to.
So I started researching spreadsheet formulas and strategies and slowly started building something that was actually very helpful and pretty cool! This spreadsheet I created allows you to input each one of your crypto trades and it will pull the corresponding live price automatically. You will also be able to input your weekly reward accruals and it will add then to your total balance. The spreadsheet will automatically breakdown your Daily, Weekly, and Monthly passive income amount so you can get a clear overview of how much you are actually making.
Let’s jump into it and see how it works, I also created a live demo video which outlines how the spreadsheet works and I will include that at the end of the article.
First, upon picking up the spreadsheet, you will be greeted with a How to Guide tab, which outlines exactly how to setup and use the spreadsheet. Most of the sheet is pretty automated so it makes it easy for you to track your income without a whole lot of manual work.
After reading and understanding the how to guide, you will want to navigate to the live prices tab. This is where you can enter the coins you own and it will populate their current live price throughout the spreadsheet.
All you have to do is go to CoinGecko and then type in the coin/token you are wanting to add to the spreadsheet and then copy the portion of the url after “https://www.coingecko.com/en/coins/” and enter that in the “coin lookup” column of the sheet.
So for example, lets say you wanted to add KLIMA to the spreadsheet, you would not just add “KLIMA” to the code lookup section. You need to pull the ending of the url from coingecko which looks like this.
So you would enter “klima-dao” in the code lookup section. It should automatically populate the current price once you do that.
Now you want to navigate back to the Profit Tracker tab and then you want to enter KLIMA in the name field. Then in the API ID field you want to copy whatever you put in the “Code Lookup” column of the live prices sheet.
Once you do that, you should see the price populate within this tab. Then you want to enter your purchase date, purchase price, and number of coins purchased. Then do the same for all the other purchases you have made.
It should look something like this:
At this point we are almost complete with the setup process. The last step is to navigate to the coin count tab. Now for this to work the easiest for you, you will want to pull your rewards weekly for each of your projects you are in. I update mine every Monday morning and it takes me about 10 minutes to complete.
So what you need to do is fill out how much in rewards you have made each week. The easiest way to do this is to go to the “Profit Tracker” tab and look at the “Total Coins (Including Rewards)” column. Then go to the coins dApp site and take whatever that total is and subtract it from the total in the “Total Coins” column. This will give you the total amount accrued for the week, you can then enter it in the corresponding weekly field in the coin count tab. It should look something like this:
Once you have filled this section out, you are done! The spreadsheet should be fully functional and have all the tabs filled in. You can then check out your Daily, Weekly, Monthly income breakdowns via the “Breakdowns” tab and check out some of the chart data via the “Charts” tab. They should look something like this:
From here, the only work you need to do is come into the spreadsheet every week and update your accruals from the previous week. The rest of the spreadsheet will do the heavy lifting for you. You can also pull up the spreadsheet throughout the week and watch your numbers fluctuate based off the current market price of your trades.
How To Get It
First, if you want a live video demo of this spreadsheet to see how it works in real time, you can check the demo video out here:
If you would like to pick up a copy of this spreadsheet to use for yourself you can do so via this link:
The spreadsheet is available for you to name the price you are willing to pay for it. Including $0, the spreadsheet will also come with lifetime free updates, so anytime I have any updates or enhancement to it, I will send updates via email for free.
Hopefully you found this article helpful and now you have a way to better track your passive income revenue streams. As always if you have any questions on the setup process or want to talk about some things you want to see in the spreadsheet at a later date, feel free to reach out to me on Twitter.