This is an easy-to-use Excel calculator for the calculation of profits in cryptocurrency trading using the FIFO method. It calculates and shows the useful trading data for every transaction and summary for all trades year-wise and all combined.
You will just have to put your trading details i.e. Transaction Type (buy/sale), Date & Time of Transaction, BTC Quantity in columns A:D, and the sheet will automatically calculate FIFO gains and other important data for every row. You will see Gain/Loss after every transaction on FIFO basis in column U. Besides this, the spreadsheet will also show you other important data e.g. Cumulative Cost of BTC Purchased, Cumulative Proceeds from the sell of BTC, Total BTC Purchased, Total BTC Sold, BTC in Hand after every transaction.
Every Sell trade shows the earliest and the latest buying dates of the lot sold along with the Cost of coins sold.
You can input exchange commission for buy or sell transactions on either percentage basis or currency amount or a mix of both methods.
You can create as many sheets as you require for each coin (or stock) just by copying and renaming the COIN sheet.
Sheet automatically checks for some common data entry mistakes and highlights those cells to help you easily identify and correct them.
Sheet highlights the rows in different colors automatically to help you easily distinguish between Lot Sold, Lot in Hand, Partial Sold, Sell with profit, Sell with loss, etc.
It also shows some interesting data about any prospective sale. Along with the estimated profit or loss for a prospective sale at the proposed sell price, the sheet will show you all the lots which will be sold with quantities, buying prices, and costs. It will show this data in a separate table for each lot.
You can also see the buying price ranges and quantities of coins (or stocks) you have in hand in a separate table.
We believe that you will find this Excel calculator very handy in analyzing and keeping records of your trades and perfect in calculating the gains with 100% accuracy for taxation purposes.