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 Best Practice:  Bitcoin Cryptocurrency LIFO (Last In First Out) Gain Calculator for Taxation  by Soni Excel Solutions

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 Best Practice includes
1 Excel Spreadsheet

Acquire business license for $22.00

Add to cart

Add to bookmarks


Further information

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

4.9 / 5 (8 votes)

please wait...