If you are looking for a straightforward way to track your cryptocurrency investments and calculate your profit, a spreadsheet is an excellent solution. Whether you trade actively, mine coins, or stake tokens, a well-organized spreadsheet gives you full visibility into your cost basis, proceeds, and net gains.
Setting Up Your Transaction Sheet
Create a dedicated sheet for every trade or transfer. Essential columns include Date, Asset (BTC, ETH, DOGE, etc.), Type (Buy, Sell, Transfer), Amount, Price per Unit in your base currency, Total Value (Amount × Price), Trading or Network Fees, and Net Proceeds. For mining or staking rewards, set the Type to “Income” and the cost basis to zero or the associated electricity cost. A clean transaction log is the foundation of accurate profit tracking.
Basic Profit Formula
Profit for each trade is calculated as: Profit = (Sell Price − Buy Price) × Amount − Fees. You can extend this to track realized gains by subtracting the cost basis from the sale proceeds. For mining income, the profit is the current market value of the mined coins minus any operational costs such as electricity and pool fees.
Tracking Unrealized Gains
Add a column for the current market price (updated periodically or imported from an exchange). Your spreadsheet can then automatically calculate unrealized profit or loss for assets you still hold. This gives you a real-time view of your portfolio value and helps you decide when to take profits.
Building a Portfolio Summary
Use a separate sheet or section to aggregate your holdings. With functions like SUMIF, UNIQUE, or QUERY, you can group by asset, sum the total amount, compute the average buy price, and compare it to the current price to see overall P&L. This summary also helps you rebalance your portfolio and identify your best‑performing assets.
Cost Basis Methods
Depending on your jurisdiction, you may need to apply a specific cost‑basis method such as FIFO (First In, First Out), LIFO (Last In, First Out), or Specific Identification. A spreadsheet makes it easier to implement these methods if you record the date and price of each acquisition consistently.
Tax Considerations
Many countries now require reporting of capital gains and losses from cryptocurrency transactions. Maintaining a clean and accurate spreadsheet throughout the year makes tax season far less stressful. Always verify the specific rules with a qualified tax advisor.
For more detailed guides, profit strategies, and useful tools, explore our Crypto Category.