FIFO Inventory Accounting Method EXPLAINED | First In, First Out Inventory Cost Flow

[@vijayarjunwadkar]

I graduated in Commerce with Accounting and Statistics. How I wish the concepts could have been explained back then, like the way in this video! But better late than never! Nice work Leila! 😊👍 While this is FIFO, it's always LIFO for me! Leila In Fear Out! 😁

[@LeilaGharani]

Haha, you're the best!

[@EagelzOfficial]

In the logistic scene we use FEFO as well. First Expired, First Out. This one is helpful when you're dealing with best before dates.

[@lampsizgod]

So mostly for the perishable food industry?

[@LeilaGharani]

Thanks for the feedback, Tim!

[@sitisaidah4100]

Agree...we used FEFO for pharmacy

[@malithfernando2185]

Indeed

[@jonk3361]

Am I the only one who wants to watch this all over again? Oh and while we are here, how can we do this in excel?

[@mohamedrazaa585]

Hi Leila, Once again your explanation was astonishing. Please do a video, how to apply FIFO in excel and find cost of sale for each sales. It’s a nutshell for you. I am eagerly waiting........ Thanks.

[@akkemik]

i would like to see how you would solve this fifo problem in excel with your magic ;)

[@KevinCastillousac]

Thanks for your work, when you explained all of more clear. Never stop make videos. You are great.

[@farisalsolmi1921]

Wow, Your way of teaching is just a click to mind !! all the best

[@zeeshanalijaved2402]

Kindly make a video on fifo method using excel and generate profit out of it. Love from Pakistan

[@Schlaumeierakademie]

Thx very much for this very good explanation of Fifo. I was not used to get an explanation in english so far 🤗.

[@abdrachman4825]

so.. how do you make this in excel, Leila?.. thx

[@wayneedmondson1065]

Thanks Leila. Interesting concepts, even for non-accountants. Thanks for sharing :)) Thumbs up!!

[@oyungerelgonchig4127]

Thank you for teaching powerful tools

[@ExcelExciting]

Well Explained, FIFO & LIFO is very clear..!!

[@LeilaGharani]

Thanks Faraz!

[@gregoryking4796]

So important yet overlooked.

[@LeilaGharani]

Thanks!

[@barttitulaerexcelbart9400]

Hello Leila, thanks for this theoretical explanation. I saw some of the reactions and they ask for an Excel solution. On youtube I found some, but they were quite long, so this is not so easy. But maybe PQ will be handy?

[@lordamitbag8579]

your videos deserve more likes comments shares views

[@AH-xd9tj]

Could you please make a video with examples using Excel ? For instance, how do we find out the cost basis of the latest inventory in a pile of data? or what would be the quantity left in the latest inventory. Thanks !

[@LeilaGharani]

I'll think about it. Thanks for your suggestion, Andy!

[@federicocostantino9029]

@@LeilaGharani Please Leila!! we need this videoo

[@abduvalitolipov5254]

Please Leila! you are the best i believe that you can help as always) @@LeilaGharani

[@ahmedhassanahmedhassan6495]

Which presentation program did you use for this illustration ??

[@LeilaGharani]

We use mainly Camtasia for video editing.

[@ahmedhassanahmedhassan6495]

@@LeilaGharani thanx 4 replying... ☺️

[@raidhamidal-qurtas5447]

Thank for sharing Very useful knowledge Any excel or Google sheet function 🤔? Kind regards

[@gregoryking4796]

Of course, but you would have to either manually enter your purchase history and cost, and utilize excel to pull data from your POS (point of sale) software, if possible. Each item would need a unique identifier (SKU) to match with the receipt when you purchased it.

[@flinhh]

Grazie mille Leila, ottima spiegazione

[@LeilaGharani]

Prego :)

[@Disaenz10]

Nice. Is this part of a new series of videos about logistics? Hope you talk more about the supply chain world :)

[@LeilaGharani]

No, sorry. I'm not an expert for logistics :)

[@maartentjewut]

Hi there, is it possbile to make a video on FiFo planning based on expiration dates? I am having huge struggles with this on how to get it into Excel. If I'd be able to solve this issue, then this will help me a lot in my profession. Thanks!

[@martinelduin2214]

This may apply as a gage for departmentalized sales, but it would be misleading to think this directly corelates to a business’s profitability. Initial intentions should always be to get as much as the market will bear, and if the market will bear a higher price this month as opposed to last it may be wise to consider that stock replacement is going to go higher. Still an excellent place to begin for someone just learning the ropes.

[@faitholateju6590]

Thank You!!! Pretty Top Too, Suits You!

[@simonhall886]

Nice overview, could you do one on Average cost as well please

[@christinakloster1498]

With Average costs method you just find the Average costs pr. unit and use that average to multiply sales numbers.

[@simonhall886]

@@christinakloster1498 How do you think you would calculate is historically?

[@christinakloster1498]

@@simonhall886 you would need to add all purged materials from the given periods and then divide that number with the number of total periods. This gives you the average number of both units and prices. I found this video for you. It's the best one I have jet to come across here on YT. kzbin.info/www/bejne/hXeufp5vaN5_pJo

[@bkkb7117]

Perfect video thanks !

[@accnotech3863]

I thought there is some thing related to excel, can we have a tutorial on maintaining stock in excel,

[@accnotech3863]

@@valver8362 well I would love to see your work... Plz forward it to [e-mail], if you feel comfortable...

[@excel-businessinexcel5181]

Here is a video of my program. Only the interface is shown. The program is complex, the Russian can not understand it... :), but if you ask me again after watching the video, I will send it to you. With respect. kzbin.info/www/bejne/jYialpxmgbufjLc P.S.

[@mohamedmoaid999]

In which funection in excel that can i use it to help me to calculate my inventory cost as fifo method type ?!

[@ManikandanRaju]

Hi Leila. Beautifully explained. However, how do use the same concept in maintaining the receivables from the customers. In case if there are 4 line items for an invoice and the customer pays partially. I need to assign the partially paid amount line item wise. For example, 4 line items has $500 each. The customer pays 1250. The balance to be paid column for the first and second line items has to be marked $0 and the third has to be $250 and the forth must be $500. Please help me.

[@AMDSTT]

Thank you

[@umeshpopli926]

How cogs and ending inventory can be the same since cogs is purchase - ending inventory. Please explain the line you mentioned at 8:35

[@feraskraim936]

Thank you Leila for good explanation It's still not clear very well for me because my English is not 100% But I'll replay the video again

[@LeilaGharani]

👍

[@S.Kh57]

Could you please share with us about Cash Book? How to manage it as receipt or payment sides, or as petty cash. I really struggle with these are. If you could even explain it shortly. I would be appreciate it.

[@LeilaGharani]

I'll think about it. Thanks for your suggestion!

[@moweringfan3376]

Hi, Leila, do you have a post that solve this FIFO issue by Excel?

[@ManojKumar-sk3fw]

Nice show

[@taizoondean689]

Thanks for the details. Can you help us how do we knock off entries in excel in FIFO scenario

[@taizoondean689]

@@valver8362 we have system in place but wanted to do in excel for control check and checking of open documents 🙂

[@mattclairmont6066]

Ya, I understand the method, I'm just not sure how this would look on an inventory card. I also wouldn't mind seeing this in excel

[@kennedylouis72]

During my days in manufacturing before, i have encountered FISH. First In, Still Here!

[@LeilaGharani]

Haha, I've seen a lot of those too 😄

[@pnqguy]

Beauty With Brains ☺️

[@mbhla]

or weighted average cost maybe? Sumproduct (units purchased, cost per unit)/Sum (units purchased)

[@LeilaGharani]

Yes, that's the AVCO method.

[@jw9410]

Great video. By the way you are the best dressed person on youtube.

[@LeilaGharani]

Wow, thank you!

[@salmanpirzada924]

Love from Pakistan

[@davidclayton2512]

Caution. If the new selling price drops below the purchase price, then you have to value at this price. Stock value is the lower of cost or net realisable value (a fancy name for what the item is worth now)

[@LeilaGharani]

Good point. Thanks for your feedback, David!

[@marionforge2769]

I don't get it

[@cajatinaswani609]

In India, the LIFO method is not acceptable for inventory valuation as it doesn't consider the current cost of inventory

[@LeilaGharani]

👍

[@pravinasampelli3177]

I thought you're indian 😍😍

[@yosef-yosef9414]

hi Ms. Leila Gharani ... i have a problem with our File .. Could you PLEASE help me Please please please😢 this is the situation in Column A sheet1 there's a Book codes (Ex: HG10, AB34, RD75) in Column B Sheet1 there's a Formula Sumifs(Sheet2!AB:AB,Sheet2!$AA:$AA,$A2) (there's also a Formula in Sheet 1 Column C - E) so when i copy paste the formula From Sheet 1 Column B - E to Column F-I The range in Formula from Column B Sumifs(Sheet2!AB:AB,Sheet2!$AA:$AA,$A2) will be automatically adjusted into Sumifs(Sheet2!AF:AF,Sheet2!$AA:$AA,$A2) Column F but our requirement is Sumifs(Sheet2!AC:AC,Sheet2!$AA:$AA,$A2) the Range must move only one Column even though i copy paste it into 2 or more than 2 Columns... this is just an Example because there's a lot of formulas that we created and same problem, we need the Range in formulas will adjusted moved 1 Column when we copy paste it into 2 or more than 2 columns... PLEASE HELP ME Leila .. could you please Make a Video about this ... Please Notice me .. God Bless🤗

[@abduvalitolipov5254]

Hello Leila. i follow you and really really appreciate your work. i would like if you show this fifo method solution in excel! thanks ahead

[@vlearnacademy5556]

Please explain the formula for valuation in excel mam

[@ninjapirate123]

But how do you do the inventory card in accounting

[@ahmadimalarasool495]

Please can you create it in excel sheet.

[@EpicDreamer_]

Great!

[@mahindabandarahangilipola8978]

thank you ,video is very well

[@alhabib-tutorials6826]

Wonderful explanations..God bless you

[@LeilaGharani]

Thank you

[@Blackshark553]

excellent

[@manojchintu6372]

Thank you 👌

[@jasmins3453]

Bravo

[@denconstutube]

As usual, you do a great job in teaching. Thanks.

[@LeilaGharani]

So nice of you

[@boxhero_official]

Great video Leila! 🙌 Accounting & Inventory are inherently related. Definitely recommend using inventory mgmt softwares that integrate accounting to keep track of your revenue, COGS, profit, etc.

[@lec530]

I have a video request if this is even possible... Can I schedule RECURRING emails in Outlook? I have a few standing reminders I have to send every single month. I have saved quickparts, but it just seems like I should be able to schedule them and let Outlook do the work for me??

[@ramidoleh6596]

When I find your videos on functions it is my first priority to open and learn from >> I opened this video thinking that I would learn the functions to do this task>> Would love to see your magical way to solve this, I am working on value chain analysis system that starts from inbound logistics to outbound logistics>> the first block is the warehouse and inventory >> would love to see your solution for FIFO, it is really needed (Without Script Please) I found one solution using MIN and OFFset functions but it is not clear, yet it seems a good solution>> but still I am finding it hard to follow with the explanation

[@xozeintk8093]

Thank You Leila for the explanation

[@christinakloster1498]

Good explanation - but this video doesn't address the transfer-in or transfer-out costs cross periods - would be nice to see how this issue can be solved in Excel by using the 5 step method

[@remars-xcel]

it will be interesting to have inventory management in excel class please with automated\custom print out without the use of VBA

[@JoeDiLillo]

One of your best videos!

[@Betterifitsfree]

Excellent explanation. Great refresher for an MBA. 5⭐'s for graphics also. They complete the majic Leila.

[@LeilaGharani]

Thanks for that!

[@mattschoular8844]

Thanks Leila. We use AVCO as we have too many skus and limited human resources to use FIFO or LIFO. I appreciate the video nonetheless.

[@LeilaGharani]

Thanks for the feedback, Matt.

[@alhabib-tutorials6826]

Thank you so much for doing so well

[@LeilaGharani]

It's my pleasure

[@alhabib-tutorials6826]

@@LeilaGharani May allah bless you

[@jodi-annricketts3753]

I am doing FIFO and its effect on organizational performance for my research paper.

[@LeilaGharani]

Interesting topic. Good luck with the paper!

[@jodi-annricketts3753]

@@LeilaGharani Thank you

[@jodi-annricketts3753]

@@LeilaGharani I should find a theory for my topic, but I can't seem to find any.

[@abidsherazi7629]

The tutorial was very easy to understand the system, kindly make an implementation tutorial in excel, i have learned alot from your videos because there are many scenarios in your videos which covers everyone needs