Jump to content


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.


Can I use excel to keep track of my capital gains using LIFO?

  • Please log in to reply
1 reply to this topic

#1 aj777


  • Members
  • 22 posts
  • Local time:06:29 PM

Posted 13 January 2018 - 07:07 PM

Hi, I want to use excel to track my capital gains from my cryptocurrencies. If you don't know what cryptocurrencies are, just assume they're stocks, as it's the same thing for all intents and purposes.


Basically whenever I buy or sell a crypto, I want to enter the trading symbol (e.g. BTC), how much I bought or sold, the price per coin, and the fees.


I then want the spreadsheet to automatically calculate my capital gains whenever I sell, using LIFO accounting.


Is this possible?

BC AdBot (Login to Remove)


#2 britechguy


    Been there, done that, got the T-shirt

  • Moderator
  • 8,142 posts
  • Gender:Male
  • Location:Staunton, VA
  • Local time:07:29 PM

Posted 15 January 2018 - 07:59 PM



There are scads of LIFO spreadsheet templates out there.  See these search results:  https://duckduckgo.com/?q=excel+%22lifo%22+spreadsheet+template&norw=1&t=hg&atb=v91-1&ia=web 


Specifically:  http://exceltemplate.net/finance/cost-of-goods-sold-calculator/



or dig around until you find one that has a presentation format you prefer.

Brian  AKA  Bri the Tech Guy (website in my user profile) - Windows 10 Home, 64-Bit, Version 1803, Build 17134 

      Memory is a crazy woman that hoards rags and throws away food.

                    ~ Austin O'Malley






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users