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: 01/12/2018 15:17
Publication number: ELQ-33038-3
View all versions & Certificate

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

This is another tool to fulfill 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 need to fill 4 fields i.e. Transaction Type (buy/sale) , Date of Transaction, BTC Quantity and Price in columns A:D and click on the macro button LIFO. Macro and formulas in columns E:Q will process this data and you will see Gain/Loss after every transaction (for each Lot) on LIFO basis in column N and Total LIFO Gain in column O. 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, BTC in Hand and Cost of Balance BTC after every transaction.

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

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


Further information

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


  • 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 :)


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

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

  • Carlo Damiano
    Good Morning Tejasvita,
    great work! It's possible even to know how of each "lot" is available after each sell?
    Thank you
    Carlo Damiano
    arrow_drop_uparrow_drop_downReply reply
    • Tejasvita Soni
      Hi Carlo,

      Good morning! Thanks for your comment. You can see Total Remaining Coins and their Total Cost of Purchase after each sell.

      arrow_drop_uparrow_drop_downReply reply
      • Carlo Damiano
        Yes, i noticed that you give this information for every movement filled in, it's very useful but you can't know how of each lot is remaining (if i understand your perspect, you can see only the cumulated one).
        To me, it would be more useful if you can "monitor" every "lot" purchased seeing him crunched by the sequence of sales.
        For example, if i:
        day 1) buy 4 units, price "A"
        day 2) buy 3 units, price "B"
        day 3) sell 2 units
        day 4) buy 2 units, price "C"
        day 5) sell 6 units
        ..would be useful to know, f.e., that the sale on day 5 has totally crunched lot "C", 1 remaining coin of lot "B" (already crunched by the sale on day 3, and part of lot "A".
        I don't know if you think that this info could be implemented.
        Excuse me for my horrible english :) thanks for your time, i think that i will purchase your format very soon.
        My best regards
        1arrow_drop_uparrow_drop_downReply reply
        • Tejasvita Soni
          Hi Carlo,

          Thanks for your valuable suggestion. I have made necessary modifications in the latest version as per your advice. I hope it is up to your satisfaction now.

          1arrow_drop_uparrow_drop_downReply reply
    please wait...