Excel Tutorial - FIFO Accounting Part 2 (First In First Out) 

Big thank you for the clear explanation, sir. I'm an accountant and I was embarrassed to be struggling to devise an easy way to track cost basis of my crypto investments in Excel. This lead me down the right path. Thanks again!

You say that is not professional. Yes it is. But you show us the logic of this FİFO. So I can use this method on my Portfolio Table. I am very glad for that.

Thank you. You provided a perfect solution to a problem I have had for a couple of years. I could not adequately track my crypto trades with FIFO applied on any SS I could find on RU-vid or the internet. I took you "pens" demo and adapted it to the crypto world and it seems to fit very well. We'll see if Big Brother (IRS) will accept the calculations. Again, thank you.

This was a great video. It took a bit of work for me unraveling two years of activity in the cryptocurrency market, but your layout made it a breeze.

Thanks for such a clear explanation Magic Monk! Much appreciate it I would love to see how earnings per sale may be displayed so easily as what you have tought so far!

You saved my Career,thank you so much

Many Thanks! It is exactly what I was looking for.

Deep thanks for your detail explaination

Good learning with clear explanation. Like to see the calculation of the profit against each sell transaction and anual % return against each sell transaction. Also love to see the weighted average purchase price and value of the closing stock with current sell cost.

Thanks u increase my skill on top

Hold on... You didn't calculate the individual profit of each sale you had at the start, which is what you need to report. How would you automate the splitting of a sale between the two (or more) respective purchases? I'm not sure it can be done without VB, as it involves creating new lines. Or you do it manually like you did in the beginning, maybe with the aid of some cross-check columns.

Thank you sooo much! It helped me a lot!

Is there a way to itemize the cost to see each individual profit margin? Or is it only as a whole?

Thank you sir. I got my answer

Thank you sir

sir, make vedio if there are many items it will be greatfull to you, thanks

How to deal with purchase return if any?...what formula to use or adjust here? Please help..

How can you calculate the individual selling batch costs? For example, you sold 89 Pens on 20 March & if you would like to calculate the cost of selling these 89 pens how do I do that?

nice

You are not good presenter