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

Поделиться
HTML-код
  • Опубликовано: 24 дек 2024

Комментарии • 111

  • @EagelzOfficial
    @EagelzOfficial 3 года назад +15

    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.

  • @vijayarjunwadkar
    @vijayarjunwadkar 3 года назад +11

    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! 😁

  • @jonk3361
    @jonk3361 3 года назад +12

    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?

  • @AH-xd9tj
    @AH-xd9tj 3 года назад +8

    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
      @LeilaGharani  3 года назад +5

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

    • @federicocostantino9029
      @federicocostantino9029 2 года назад

      @@LeilaGharani Please Leila!! we need this videoo

    • @abduvalitolipov5254
      @abduvalitolipov5254 Год назад

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

  • @abdrachman4825
    @abdrachman4825 3 года назад +6

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

  • @farisalsolmi1921
    @farisalsolmi1921 9 месяцев назад

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

  • @mohamedrazaa585
    @mohamedrazaa585 3 года назад +2

    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.

  • @KevinCastillousac
    @KevinCastillousac 2 года назад

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

  • @zeeshanalijaved2402
    @zeeshanalijaved2402 3 года назад +1

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

  • @ahmedhassanahmedhassan6495
    @ahmedhassanahmedhassan6495 3 года назад +4

    Which presentation program did you use for this illustration ??

  • @Schlaumeierakademie
    @Schlaumeierakademie Год назад

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

  • @gregoryking4796
    @gregoryking4796 3 года назад

    So important yet overlooked.

  • @oyungerelgonchig4127
    @oyungerelgonchig4127 2 года назад

    Thank you for teaching powerful tools

  • @VENKATRAMANIYER-g7b
    @VENKATRAMANIYER-g7b 26 дней назад

    Excellent explanation .... how about an example of the same with your excel techniques ☺

  • @boxhero_official
    @boxhero_official 10 месяцев назад

    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.

  • @lordamitbag8579
    @lordamitbag8579 3 года назад

    your videos deserve more likes comments shares views

  • @alhabib-tutorials6826
    @alhabib-tutorials6826 3 года назад +1

    Wonderful explanations..God bless you

  • @denconstutube
    @denconstutube 3 года назад +1

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

  • @ExcelExciting
    @ExcelExciting 3 года назад

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

  • @flinhh
    @flinhh 3 года назад

    Grazie mille Leila, ottima spiegazione

  • @akkemik
    @akkemik 3 года назад +11

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

  • @moweringfan3376
    @moweringfan3376 2 года назад

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

  • @umeshpopli926
    @umeshpopli926 3 года назад

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

  • @Betterifitsfree
    @Betterifitsfree 3 года назад

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

  • @JoeDiLillo
    @JoeDiLillo 3 года назад

    One of your best videos!

  • @xozeintk8093
    @xozeintk8093 2 года назад

    Thank You Leila for the explanation

  • @wayneedmondson1065
    @wayneedmondson1065 3 года назад

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

  • @ramidoleh6596
    @ramidoleh6596 3 года назад

    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

  • @ManikandanRaju
    @ManikandanRaju 2 года назад

    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.

  • @mohamedmoaid999
    @mohamedmoaid999 9 месяцев назад

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

  • @barttitulaerexcelbart9400
    @barttitulaerexcelbart9400 3 года назад +2

    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?

  • @accnotech3863
    @accnotech3863 3 года назад +3

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

    • @accnotech3863
      @accnotech3863 3 года назад

      @@valver8362 well I would love to see your work... Plz forward it to contact@accnotech.com, if you feel comfortable...

    • @excel-businessinexcel5181
      @excel-businessinexcel5181 3 года назад

      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. ruclips.net/video/WW7ei0LVlVU/видео.html P.S.

  • @maartentjewut
    @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!

  • @ninjapirate123
    @ninjapirate123 2 года назад

    But how do you do the inventory card in accounting

  • @mattschoular8844
    @mattschoular8844 3 года назад

    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.

  • @raidhamidal-qurtas5447
    @raidhamidal-qurtas5447 3 года назад +3

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

    • @gregoryking4796
      @gregoryking4796 3 года назад

      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.

  • @taizoondean689
    @taizoondean689 3 года назад

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

    • @taizoondean689
      @taizoondean689 3 года назад

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

  • @martinelduin2214
    @martinelduin2214 3 года назад

    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.

  • @lec530
    @lec530 3 года назад

    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??

  • @simonhall886
    @simonhall886 3 года назад +1

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

    • @christinakloster1498
      @christinakloster1498 3 года назад +1

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

    • @simonhall886
      @simonhall886 3 года назад

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

    • @christinakloster1498
      @christinakloster1498 3 года назад

      @@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.
      ruclips.net/video/OFKMk93yLn8/видео.html

  • @bkkb7117
    @bkkb7117 2 года назад

    Perfect video thanks !

  • @yosef-yosef9414
    @yosef-yosef9414 3 года назад

    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🤗

  • @S.Kh57
    @S.Kh57 3 года назад

    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
      @LeilaGharani  3 года назад +1

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

  • @jodi-annricketts3753
    @jodi-annricketts3753 3 года назад

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

  • @kennedylouis72
    @kennedylouis72 3 года назад

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

    • @LeilaGharani
      @LeilaGharani  3 года назад

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

  • @mahindabandarahangilipola8978
    @mahindabandarahangilipola8978 3 года назад

    thank you ,video is very well

  • @Disaenz10
    @Disaenz10 3 года назад +1

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

    • @LeilaGharani
      @LeilaGharani  3 года назад

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

  • @mbhla
    @mbhla 3 года назад

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

  • @faitholateju6590
    @faitholateju6590 2 года назад

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

  • @pnqguy
    @pnqguy 3 года назад +4

    Beauty With Brains ☺️

  • @Blackshark553
    @Blackshark553 10 месяцев назад

    excellent

  • @feraskraim936
    @feraskraim936 3 года назад

    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

  • @vlearnacademy5556
    @vlearnacademy5556 5 месяцев назад

    Please explain the formula for valuation in excel mam

  • @manojchintu6372
    @manojchintu6372 2 года назад

    Thank you 👌

  • @alhabib-tutorials6826
    @alhabib-tutorials6826 3 года назад

    Thank you so much for doing so well

  • @abduvalitolipov5254
    @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

  • @AMDSTT
    @AMDSTT 2 года назад

    Thank you

  • @ManojKumar-sk3fw
    @ManojKumar-sk3fw 3 года назад

    Nice show

  • @davidclayton2512
    @davidclayton2512 3 года назад

    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
      @LeilaGharani  3 года назад

      Good point. Thanks for your feedback, David!

  • @ahmadimalarasool495
    @ahmadimalarasool495 Год назад

    Please can you create it in excel sheet.

  • @jw9410
    @jw9410 3 года назад

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

  • @EpicDreamer_
    @EpicDreamer_ 3 года назад +1

    Great!

  • @christinakloster1498
    @christinakloster1498 3 года назад

    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

  • @mattclairmont6066
    @mattclairmont6066 3 года назад

    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

  • @remars-xcel
    @remars-xcel 3 года назад

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

  • @cajatinaswani609
    @cajatinaswani609 3 года назад

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

  • @jasmins3453
    @jasmins3453 3 года назад

    Bravo

  • @abidsherazi7629
    @abidsherazi7629 3 года назад

    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

  • @salmanpirzada924
    @salmanpirzada924 3 года назад

    Love from Pakistan

  • @pravinasampelli3177
    @pravinasampelli3177 3 года назад

    I thought you're indian 😍😍

  • @marionforge2769
    @marionforge2769 Год назад

    I don't get it