Average Cost Method (AVCO) | Inventory Cost Flows
Vložit
- čas přidán 5. 08. 2024
- 💥Inventory Cost Flow Assumptions Cheat Sheet → accountingstuff.com/shop
In this video you'll learn about Inventory Cost Flow Assumptions. There are three of these:
▪ FIFO - First In First Out
▪ LIFO - Last In First Out
▪ AVCO - Weighted Average Cost Method
This accounting tutorial focusses on AVCO. You'll discover how the Weighted Average Cost method works and get to practice using it with an example. This episode is part of a mini-series exploring Inventory in Accounting. You can find the link to the whole playlist here ⬇️
🔗Full Inventory Playlist → • Accounting for INVENTO...
🔴Subscribe for more Accounting Tutorials → geni.us/subtothechannel
⏱️TIMESTAMPS
00:00 - Intro
00:37 - What is the Inventory Calculation?
01:09 - The three assumptions: FIFO, LIFO and AVCO
01:23 - How AVCO works (Weighted Average Cost)
01:58 - Accounting with AVCO - Example
02:41 - Step 1: Draw an Inventory Cost Flow Table
02:55 - Step 2: Enter what you know
04:17 - Step 3: Fill in the blanks
07:10 - Step 4: Cost of Goods Sold and Closing Inventory
08:03 - FIFO vs LIFO vs AVCO
🔝 CLOUD ACCOUNTING SOFTWARE
▪ QuickBooks Online USA (FREE TRIAL/DISCOUNT) → geni.us/jA9N
▪ QuickBooks Online Canada (FREE TRIAL/DISCOUNT) → geni.us/bNN7
▪ Xero (FREE TRIAL) → xeroamericas.grsm.io/ck90eoq1...
🔎FAQ
▪ My Favourite Accounting Book for Beginners → geni.us/5mKR7m
🚶FOLLOW ME ON
▪ Instagram → / accountingstuff
▪ TikTok → / accounting_stuff
▪ Facebook → / thisisaccountingstuff
🎬LEARN ACCOUNTING BASICS FOR FREE
▪ The Full Playlist → • ACCOUNTING BASICS for ...
________________________
DISCLAIMER
Some of the links above are affiliate links, where I earn a small commission if you click on the link and purchase an item. You are not obligated to do so, but it does help fund these videos in hopes of bringing value to you!
________________________
#accounting #accountingbasics #accountingstuff
That's a wrap on the Inventory Playlist! Let me know if you have any suggestions for future vids.
Timestamps:
00:00 - Intro
00:37 - What is the Inventory Calculation?
01:09 - The three assumptions: FIFO, LIFO and AVCO
01:23 - How AVCO works (Weighted Average Cost)
01:58 - Accounting with AVCO - Example
02:41 - Step 1: Draw an Inventory Cost Flow Table
02:55 - Step 2: Enter what you know
04:17 - Step 3: Fill in the blanks
07:10 - Step 4: Cost of Goods Sold and Closing Inventory
08:03 - FIFO vs LIFO vs AVCO
Howdy
@@kartikaylavaniya4245 Yo!
Need a video on inventory aging report
@@mujahidahmed8 Good shout!
Hi! I know this might be late but it would be an excellent help if you would be doing a video on analysis of cost behaviour. Thank you!
It's like you know exactly what i'm questioning and you answer everything. like, wow. you will be the SOLE reason i (hopefully) pass my accounting midterm at uni. Thank you! (Also you're quite entertaining so your videos aren't boring to watch either 😊)
Also using Accounting Stuff to hopefully pass my midterm. His videos are excellent!
Did you pass?
@@BillyBOb-cp6qm unfortunately not the first time lol, but the second time yes!
you are literally a lifesaver. your videos have taught me more than hours and hours of class and reading the textbook have. thank you thank you thank you!!
Hi James
What can I say. I looked at this in my study book and really didn't have a clue. Unwatched your FIFO, LIFO and AVCO and I got all the questions right! Thanks for taking the time to put these videos together. X
No problem at all. Glad to hear it's making sense!
I appreciate all the work you put into these videos, you can tell from the animations and identical format how you're trying to get it across in the easiest way possible. Much appreciated from a CFA candidate who never took an accounting class in college (somehow).
Thanks Phoebe! Hope your CFA is going well :)
Just wanted to thank you for all your amazing videos. You’re getting me through my online summer accounting class!🙏
Hey James! I'm a current yr 9, just entering gcse's and trying to grasp a head start on what i'd like to do in the future, and thanks to you, my heads set on financial accounting. I've also been on this channel for quite a while now and im proud to see that your channel has blown up so much! I just want to say thank you for your content and time!
OH MY GOOOOOD, your channel is salvation for me!!! I am from Uzbekistan, and i NEEDED an explanation of some topics. THANK YOU❤❤❤
No worries Anna, glad I could help!
Thanks man
we need more videos about accounting
Cheers mate, I plan to make a lot more
You are really amazing. You teach the whole thing in few minutes and i never got to understand the concepts from my teacher I'm in my bachelors and have science background so it was really difficult for me in the first place but you made it all easy. Thanks! ❤️
Thank you sir. I know these videos take more time and work than they look. I appreciate your time.
I began considering u the first reference and the first teacher to get info from. U inspired me, thanks a lot fam.
Accounting stuff > college professors that have been teaching for decades
I agree!! I'm studying for the CMA (certified management accountant) exam and this is VERY helpful. Excellent job James!! Hoping you see this and know what a great thing you are doing for many!!
This is soooo true, im crying😭
No kidding, I just read about these in my textbook and it did a really bad job at explaining all 3 of these flows.
5 more videos until I've watched all your videos in the Basics Playlist!! Thank you for the amazing videos!! I don't know if I've ever been able to keep to a video series for this long. haha.
Your videos are so insightfull, no need to hire a coach! Thanks for sharing such valuable knowledge :)
Your videos are precise and to-the point. I watched videos of FIFO, LIFO and AVCO. I understood all three concepts which I didn't understand earlier. It was really helpful for my exams.
You have no idea how grateful I am to have found your channel. Geez. Thank you so much! I will send all your vids to my peers and buy your cheat sheets. GOAT!
Thanks Karla, I appreciate your support!
James, you have the best accounting channel on youtube! Do a ppe and depreciation video (+ new ifrs 16 lease assets recognition)
Thanks mate! I plan to cover PPE & depreciation in the new year
Your videos amaze me. This youtube channel is free gold
Cheers Abdul, it's great to hear that you're finding the vids helpful. All the best!
Your Chanel is a blessing, mate. Thanks for the help!
Thanks Roberto, all the best!
You don't know how happy i am to have found your channel. You've made everything so clear! I'm doing my FA2 exam in 2 weeks and your videos are helping along with studying. I've always struggles with FIFO & LIFO. Thank you! I will be passing your video links to people I know 😁
Good luck in FA2! Hope you ace it :)
You are the best teacher I’ve ever had. Thank you soooo much
Thanks Ale! You've very welcome :)
Week’s away from my ELCO exam, without you genuinely I don’t think I’d pass, I had been stuck for days and then I watch this video and you break it down so well it becomes simple! Thank you!
You've got this!
And there goes another entire chapter understood thanks to your amazing videos, I wouldn't have reached to where I am in accounting without your help and lovely interactive videos :))
Great to hear it's going well. All the best :)
Hi James! After a month from finishing uni, I feel like I've forgotten what I've learnt, but your videos were great to refresh my memory. Good timing as I start applying for work. Keep it up! Your videos are really helpful and you make accounting interesting! 🙂🙂
Thanks Charmaine, good luck with your job hunt!
I love your videos. After each of my assigned chapters and my professors PowerPoints I find the topic that matches one of your videos and watch it to really understand the material and clarify. I call you my "second professor". Thank you so much for these videos, it is helping me pass this Financial Accounting class.
It's an honour and a privilege to be your 'second professor'! Best of luck with your studies :)
Thanks James for these videos! I have my accounting final this Saturday for my online accounting course, and I literally could not have passed this course without you! Keep the awesome content coming! Thanks! (Also, an explanation of a multi-step income statement would be very useful!)
No worries Kaleb, best of luck in your exam! Let me know how it goes
Hi James thanks for the video very informative , we need another video on inventory aging report
Thank you James.... Great job
I would be so lost in this textbook without you! Thank you!!!
You're very welcome :)
James! You are so helpful, i hope you get back as much as you are giving out. This was extremely helpful, thank you.
Thanks Lois! I'm happy you found it useful :)
I really enjoy your videos. Thanks for representing the industry well! Keep up the excellent work!
Cheers Sean!
Thank you so much for taking the time to explain accounting. I know I wouldn't have passed without your simple and easy format to follow. The textbook will explain the problem but the questions on homework and the quiz are not lining up LOL so thank you! You are the best teacher!!
No worries, congrats on passing!
Very detailed . thank you so much
Awesome effort mate. I have been trying to grasp inventory cost flow assumptions using two university text books on accounting. Just couldn't get it before my eyes glazed over. You explains things well and to the point. Thanks for the enlightenment.
No worries, glad it's making sense :)
Very clear explanation and easy to understand 👌👌👌
This is brilliant! I’ll use this as a basis for our inventory system. But we have raw materials inputs and use percentage of completion method for revenue cognition, so I’ll need yo adapt it to that
Just what I need to start my week ❤❤❤
🤘
Hi James, brilliant videos and very much appreciated. I've bought all your cheat sheets as a bundle and they have come in very handy. I'm with Kaplan on the ACA/CTA joint programme; using my exemptions. I just wanted to say you have a way with teaching; I luck forward to your future vids! Keep going!
Cheers CJ! I studied for my ACA with Kaplan too. Nice to hear that you have some exemptions, I had to take all of the exams. Best of luck with it!
This video was as useful as entertaining. Way to go James!
Cheers Michele, let's catch up soon!
This video made it so much easier for me! Thank you so much! ☺
Glad to hear it! All the best :)
Your videos and here to help me out yet again for another semester
All the best with your studies!
Your videos are so helpful and well explained. Thank you!!
Thanks Livia!
Everytime i finish my class i come to youtube to find his vids for better understanding, surely helps a lot
Best of luck with your studies!
Wow, you've really explained this so well and so easy
Thank you!!!
Cheers Owen, glad it helped :)
woahh! such a great and most understandable explanation! thank you so much!
You're very welcome :)
Thank you so much for making these amazing videos !
No worries, I'm happy to help!
Hi James. I really enjoy your videos! I have started studying Accounting this year and it has helped me loads. When can we expect some new videos?
Very clear and fun ad always! 👍
Cheers Lena!
So far have gotten an A in both financial and managerial accounting! I’m hoping to keep the A streak going for the rest of my accounting courses! 🙌🏻. Next semester-> Accounting Information Systems.
Congrats Dani, you're crushing it!
Love your video so much, good example clear explanation.
Thanks!!
You’re a life saver
idk how but your making me enjoy accounting for the first time in my life lol
That... is great news :)
I just loved the outro music ;)
Can you also cover the Adjusted Selling Price Method? You see, retail stores like to value their stock/inventory at their selling price. So calculating the COGS could be really tricky here(well for me lol)
Accounting never be too easy
Thanks man for adding flavour to this subject 💚💚💚💚💚
Love from Pakistan
No problem, love from Canada!
@@AccountingStuff 💚
great explanation, thank you
Cheers!
Hey man, thanks to you I got 30 cum laude (highest italian grade) in my accounting class, you're amazing! Thanks a lot, love and support from Rome!!!
Congrats!!
Excellent videos as usual 👍👍
Keep it up
Thanks, will do!
amazing amazing superb, i have no words to praise you. plzz share more and more knowledge with us. i believed very soon you are going to get the millions of subscriber inshallah. love from pakistan
Amazing
Hey James! Bro, you are soooo good at explaining and breaking down information. Your videos and edits are well done, the way you present information through visual illustrations is so clean & easy to follow. I'm a graphic designer and have a very deep appreciation for content creators who can use proper visuals to help improve comprehension and retention. You sir, makes accounting stuff easy to digest! Subscribed, liked, binge-watched all your vids and bought the Cheat Sheet Bundle. :) Thanks for providing very useful content.
As for my question:
The example you provided was for 1 product, how will this apply to multiple items/SKUs with different varying costs?
My initial thought would be to have individual cost flows for each SKU, then added together to get total closing inventory, is that the right way? Or... ALL inventory gets lumped together in one cost flow table then costs just get averaged out? ( btw, asking for the purpose of reporting COGS in tax return )
Thanks for your feedback! I really appreciate it.
Regarding your question - if you have multiple (different) products then you would use Inventory Assumptions to value each set of inventory separately. Then you would add them all together to come to a Closing Inventory number as you say.
But if each item has a bar code and can be tracked individually then you could use a specific identification instead i.e. no inventory assumptions
OMG YOU ARE AMAZINGGGG
Thanks for the great video.
I have a quick question, which doesn't specifically related to AVCO but to all inventory cost flow assumptions.
How should we handle goods return? like when we sale something then the customer returns it or when we are sending back some of the items that we bought?
Do you have a video on this? or a reference, example? Thanks in advance.
Thanks again for the great and easy to understand video :)
Love your videos!!! would you make one on stock-based compensations? This topic is pretty dense and I think you could find a more concise and easy-to-understand way to explain it. Thanks alot!!!
Hey Gem, thanks for your suggestion!
thanks so much!! I love your channel which explains accounting theory in a funny way :))
Cheers Alice, I'm happy you're enjoying the videos
Hello James. Thank you for these videos, they help with the absorption of information I am learning from my classes. Speaking of absorption, can you please do a video on cost centres and overhead absorption?
Many Thanks x
Glad to hear you're finding them useful. Thanks for your suggestions!
Great video as always........Discussing some typical questions on depreciation,inventory,.. Etc ..Could help gain further command on the topics
Thanks Thadesh!
Oh my goodness thank you for this.
You're welcome :)
Hey James, I've watched all your videos, made notes and ordered a copy of The Accounting Game. I've really enjoyed all of your content and I just wanted to say a big Thank You! What would you recommend in terms of taking the next step towards becoming an accountant? Should I start studying for the ACCA exams?
Thanks, James. I'm an accountancy student from Brazil.
No worries Cleiton!
thank you sir
He literally IS my accounting professor
your knowledge is amazing...plzzzzz try to share as much as you can.🌠👍👑
Thanks Makiya, will do!
James, you made accounting easier❤️
That's great to hear! All the best ;)
good stuff
perfect for asynchronous online classes
Hi sir
Thank you for your helpful video. I really like your video.
No worries Zahra, you're welcome
Hey man .. loving your explanation, would love to see an explanation on accounting for Sale and lease back of Finance lease and Operating lease.
Hey Vishal, cheers for your suggestion
Thanks!
Thank you!!!
Hi James, your videos are great and they're being very helpful while studying accounting. What do you think about making a video to explain depreciation and depreciation methods?
Thanks Luca, I plan to make a whole series on fixed assets and depreciation soon
Thanks! Do you have a video explaining how this works for the inventory left over for the year, and what to do with it into a new year? Can the old and new inventory be averaged out over 2 different tax years?
NICE!
Thanks Ari!
You're an angel. you explain better than my prof... i have one question... is it possible for a company to choose which method they want to use depend on the inflation, for instance, choosing LIFO when they don't want do pay more tax lol
just purchased your sheets. currently taking acct 2301 , thanks man
Cheers for your support!
Thanks for helping me out on my exams 🙏
No worries Jose, good luck!
Hi James! Love your videos, you make Accounting so easy to understand, and I'm going to buy your cheat sheet soon for my upcoming exam :) I have one question though, not sure if it's been asked. What happens to my opening inventory unit cost for the next month if I use AVCO? From your example, is it $2.65? Hope to hear from you!!!! Thank you
Cheers for your support! Opening Inventory Unit Cost is the same as the closing cost for the prior month
OMG, James, so glad to see all your videos again! I just done my ELCO exam and got 95%, really happy about that, but I could of done with this about 2 months ago. It's great though, I can brust up on everything on my FYSA exam coming up.
Love the videos man, still the best channnel out there. Hope all is well in Canada? James, do you offer private online lessons?
For sure videos I could recommend doing some on AAT leve-L3 and, 4. Maybe something to do with how we can get into different careers and what jobs we can do in accounting online, and also, what job types can we go into and some of the pros and cons. 'Kinda' finding out how do find what we would like to get into after outstudy.
Boom! Congrats on acing your exam!! Thanks for all of your suggestions, I appreciate it.
@@AccountingStuff No worries, you're welcome. I will keep an eye on your videos see what comes up.
@@AccountingStuff PS: Also maybe something on the 'finance function' and maybe something on the 'Ethics - The principles' and also the 'Threats to principles (conflicts of interest)'
could you cover the cost flows in both perpetual and periodic inventory systems?? Love you videos, bought all of the cheat sheets!!! Cheers!
Thanks for your support! I have covered that in another video :)
I realy like your way to explain all accounting stuff, but can you also make a video for auditing and other related topics on accounting? Cheers, keep up your greay work.
Thanks for your suggestion! I'd like to make some audit-related videos at some point. All the best!
You saved me!!
Happy to help :)
10 minute video as effective as as an hour lecture
Hey James, Applause from Pakistan.
I am facing great trouble in balancing accounts using brought down and carried forward methods. And how to use them in SOFP and Income Statements. And also expenditures and types of expenditures. Your huge #Fan from Pakistan waiting for these videos...
Hey Usman, cheers for the suggestions. All the best from Canada :)
Hi James, your videos are great! Is it possible that you make a video about WIP accounts in manufacturing? to me that is a very interesting topic that most companies try to avoid.
Cheers!
Hey Jacob, thanks for your suggestion! I'd like to cover that soon
Thanks broham
No worries Alex
Great video! Would you be able to cover case analysis and how to interpret the results? This is very difficult for me, as my mark in accounting always drops because of the case studies.
I'd like to cover financial ratio analysis at some point
top notch
Thanks Jay!
A big thank from Kabul
No worries Fardeen, you're welcome :)
Happy new year James
Cheers Munesh, likewise! Hope you enjoyed the holidays
the best accounting channel so far
so I'm implementing an accounting software and used the AVCO method, the problem is after many purchases with different costs and after selling tens of thousands of units, when the inventory becomes empty with zero stock, the inventory account is left with a credit balance of very small fractions like 0.0002.
is this something to be expected and is acceptable in terms of accounting ?
You are legend
Thanks :)