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.

Original Tool:  Bitcoin Cryptocurrency LIFO (Last In First Out) Gain Calculator for Taxation  by Tejasvita Soni

Description
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

Discuss

Further information

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

Reviews

  • Sean K Young(last updated: 23/04/2019 15:59)
  • 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

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!

  • M Mm
    To do our taxes, we need to know what is short term gain/loss and what is long term. For both LIFO and the FIFO calculations. I do not see this distinction in the sheets.
    arrow_drop_uparrow_drop_downReply reply
    • 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.

        Regards
        Soni
        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
          Carlo
          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.

            Regards
            Soni
            1arrow_drop_uparrow_drop_downReply reply
      • M Mm
        Version 2 doesn't use VBA. Is that because it is no longer needed?
        What was changed to Ver 2?
        arrow_drop_uparrow_drop_downReply reply
        • Tejasvita Soni
          Yes, version-2 is not needed. Please use LIFO tool version with VBA code.
          arrow_drop_uparrow_drop_downReply reply
        • M Mm
          There is no audio on the video
          arrow_drop_uparrow_drop_downReply reply
          • Tejasvita Soni
            It is just to show the simple steps - self explanatory. However, if you suggest, I will add audio to it.
            arrow_drop_uparrow_drop_downReply reply
          please wait...