Google Sheet Version of Bitcoin Cryptocurrency FIFO Gain Calculator

This is easy-to-use handy Google sheet for calculating the gains in bitcoin and other crypto trading using FIFO method.

Original Best Practice:  Bitcoin Cryptocurrency FIFO Gain Excel Calculator for Taxation  by Soni Excel Solutions

You will just have to put your trading details i.e. Transaction Type (buy or sale), Date & Time of Transaction, Bitcoin Quantity in columns A to D and sheet will automatically calculate FIFO gains and other important data for every row. You will see Gain or Loss after every transaction on FIFO basis in column U. Besides this, spreadsheet will also show you other important data e.g. Cumulative Cost of Bitcoin Purchased, Cumulative Earning from Sell of Bitcoin, Total Bitcoin Purchased, Total Bitcoin Sold, Bitcoin in Hand after every transaction.

Columns P, Q, R and S contain formulas for calculating costs of coins sold in parts. These formulas are complex and doing the calculation on FIFO method. These contain intermediate results. You may show or hide them as per your choice.

You can set exchange commission for buy or sell transaction in 2 ways:
First method is to set a fixed percentage for all Buy and Sell transactions in cells B1 and B2. It will be used to fill amount of commission (in $) for each transaction in column F and remove values from column E.

In second method you can manually fill amount of variable commission (in $) for each transaction in column E. In that case, value in column F will NOT be used by sheet.
Formula to calculate Effective Price after Commission in column G will first look for commission amount in column E. If it is blank, then commission amount from column F will be used (which itself is derived from %age values from cells B1 and B2).

You can adopt both the methods together, but remember that value in column E always takes precedence over column F.

Google Sheet is ready to calculate FIFO gains up to 2000 transactions, which can easily be extended further by dragging the formulas as per your requirement.

Sheet automatically highlights the rows for Buy and Sell transactions in Green and Orange colors so user can easily identify a Buy or sell transaction.

The tool is ready to calculate gains for 5 coins (Bitcoin, Bitcoin Cash, Ethereum, Litecoin and Ripple) and summary of these gains is shown in "Summary" sheet. User can copy or rename these sheets for other cryptocurrencies as well.

This Best Practice includes
1 PDF file with with Google Sheet URL

Acquire business license for $19.00

Add to cart

Add to bookmarks


Further information

To calculate trading profit using FIFO method

To calculate stock valuation using FIFO and then calculate profit or loss

I don't know


  • Rate this Downloadable Best Practice

    Write a review

  • James Montgomery(last updated: 07/05/2021 00:06)


More Best Practices from Soni Excel Solutions


Discussion feed for Google Sheet Version Of Bitcoin Cryptocurrency FIFO Gain Calculator

The user community and author are here to help. Go ahead!

  • Patricia Fenkell
    Can this products be used for tax purposes?
    arrow_drop_uparrow_drop_downReply reply
    • Soni Excel Solutions
      This tool calculates trading profit/loss using FIFO method, which further can be used for tax purposes as per the law of your country and further advise by a tax consultant.

      Some people use LIFO or Average cost methods also for calculating profit/loss.

      arrow_drop_uparrow_drop_downReply reply
    • Patricia Fenkell
      Can this be used for tax purposes?
      arrow_drop_uparrow_drop_downReply reply
      • Christopher Guynup
        Is there a way you could make a open "comment cell" somewhere - this would help the user document the purchase as a long term/short term gain for tax purposes, or some other note about the sale or purchase. Also, is there a way to relabel the sheet and have that auto update the fields with the symbol of the crypo purchased?
        arrow_drop_uparrow_drop_downReply reply
        • makaroniip pasta
          Hi I have downloaded the pdf and clicked on the link but could not access the file.
          arrow_drop_uparrow_drop_downReply reply
          • Soni Excel Solutions
            Hi, thanks for your purchase. Please let me know your email ID, so I can share the Google sheet with you.
            arrow_drop_uparrow_drop_downReply reply
            • makaroniip pasta
              Hi, can I reply to your email instead. Really not want to display my email in public
              arrow_drop_uparrow_drop_downReply reply
          • James Montgomery
            google wont give me permission to use Google Sheet Version Of Bitcoin Cryptocurrency FIFO Gain Calculator
            arrow_drop_uparrow_drop_downReply reply

            5.0 / 5 (1 votes)

            please wait...