Bitcoin Cryptocurrency LIFO (Last In First Out) Gain Calculator for Taxation
  • Bitcoin Cryptocurrency LIFO (Last In First Out) Gain Calculator for Taxation
  • Bitcoin Cryptocurrency LIFO (Last In First Out) Gain Calculator for Taxation
Originally published: 30/10/2018 14:21
Last version published: 05/11/2018 08:52
Publication number: ELQ-33038-2
View all versions & Certificate
certified

Bitcoin Cryptocurrency LIFO (Last In First Out) Gain Calculator for Taxation

Very easy-to-use handy Excel sheet for calculating the gains (after commissions) in bitcoin trading using LIFO method.

bitcoinbitcoin taxbitcoin tax calculatorbtc tax calculatorcryptocurrencycryptocurrency tax calculatorlast in first outlifo calculatorlifo gainstax calculator

Description
This is another tool to fulfil demand of my valuable customers to help them calculate trading gains/losses using LIFO method.

Just put your trading details in columns A:D and it will show LIFO gains. You can also set exchange commission for buy/sale in percentage in cells B1 and B2. Spreadsheet is ready to calculate up to 2000 transaction, which can be easily extended further by dragging the formulas (rows) as per your requirement.

You will just have to fill 4 fields i.e. Transaction Type (buy/sale) , Date of Transaction, BTC Quantity and Price in columns A:D. Formulas in columns E:T will set to process this data and you will see Gain/Loss after every transaction on LIFO basis in column S. Besides this, spreadsheet will also show you other important data e.g. Cumulative Cost of BTC Purchased, Cumulative Earning from Sale of BTC, Total BTC Purchased, Total BTC Sold, BTC in Hand after every transaction.

Columns N:Q contains formulas for calculating costs of coins sold in split/parts. These formulas are complex and doing the calculation using LIFO method. These contains intermediate results. You may show/hide them as per your preference.

I have spent several hours in implementing this complex LIFO based calculation into a very easy-to-use format.

Sheet can be copied and used to calculated gains for other crypto coins.

Please let me know if you have any question or suggestion to improve this template. If you want further customization, I will be happy to make changes as per you requirement for a reasonable fee.

This business tool includes
1 Excel Spreadsheet

Acquire business license for $10.00

Add to cart

Add to bookmarks

Discuss

Further information

Easily calculate the gains in bitcoin or cryptocurrency trading using LIFO method

Reviews

  • Sami Nagata(last updated: 05/11/2018 12:32)
    Thank you very much!
    I was looking forward for this verison a lot! Now I can finally calculate the Taxes with FIFO and LIFO.Thank you :)

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Bitcoin Cryptocurrency LIFO (Last In First Out) Gain Calculator For Taxation?

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

please wait...