Bitcoin Cryptocurrency FIFO Gain Excel Calculator with Yearly Summary for Taxation
Originally published: 12/05/2018 17:40
Last version published: 21/06/2021 07:02
Publication number: ELQ-93697-11
View all versions & Certificate

Bitcoin Cryptocurrency FIFO Gain Excel Calculator with Yearly Summary for Taxation

Easy to use Excel calculator for trading gains in bitcoin, crypto and stocks using FIFO method with year-wise summary.

This is an easy-to-use Excel calculator for calculation of profits in cryptocurrency trading using 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 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, spreadsheet will also show you other important data e.g. Cumulative Cost of BTC Purchased, Cumulative Proceeds from 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 transaction on either percentage basis or currency amount or 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.

Sheets 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 sell. Along with the estimated profit or loss for a prospective sell at proposed sell price, 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.

I 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 purpose.

This Best Practice includes
1 Excel spreadsheet,

Acquire business license for $39.00

Add to cart

Add to bookmarks


Further information

Easily calculate trading gains in bitcoin or other stock trading using FIFO method.

4.9 / 5 (16 votes)

please wait...