Inventory & Merchandising Transactions-Excel Practice Proble

所在平台: Udemy

课程主页: https://www.udemy.com/course/inventory-merchandising-transactions-excel-practice-proble/

课程评论:没有评论

第一个写评论        关注课程

课程简介

课程名称:库存与商品交易-Excel实践问题 课程概述: 本课程专注于Excel实践问题的部分,旨在为学习者提供复习练习,以免被其他资源分散注意力。课程涵盖了库存和商品交易的记账内容,重点讲解商品交易及其成本流假设。我们将讨论与库存相关的交易,包括库存的购买与销售,同时涉及销售折扣、购货折扣、销售退货与折让、库存萎缩,以及销售成本的计算。此外,我们将对比永续库存系统与定期库存系统,列举并描述各自的优缺点,并解释在实际运用中何时适合使用其中一种系统。 课程内容包括: 1. 商品交易:库存的购入与销售。 2. 永续与定期库存系统:对比二者的特点与应用情境。 3. 销售折扣与购货折扣:讨论如何记录这两种交易,以避免混淆。 4. 库存萎缩与销售退货:讲解库存损失的记录与销售后商品的退货交易。 5. 财务报表:分析商品公司的财务报表,尤其是收入报表相较于服务公司的复杂性。 6. 综合问题:通过两个综合性问题,从财务交易入手,第二个问题将涵盖商品公司完整的会计周期、财务交易记录、调整分录、财务报表及结帐过程。 7. 库存追踪方法:特定识别法、先进先出法(FIFO)、后进先出法(LIFO)、加权平均法。 8. 库存成本:包括运费、保险和购货折扣。 9. 定期系统与永续系统下的FIFO、LIFO及加权平均法的讨论。 授课教师背景: 本课程由拥有丰富技术经验的注册会计师(CPA)、特许全球管理会计师(CGMA)、税务硕士(MST)以及认证高等教育讲师(CPS)教授授课。作为实践中的CPA,讲师与众多客户在多种复杂的会计问题上合作,通过教学与课程设计帮助学生达到学习目标,深知如何逻辑性地设计技术类课程并解决相关问题。 参加本课程,学习者将掌握库存与商品交易的关键会计知识与Excel实践技能。

课程评论(0条)

课程详情

This course will only provide the Excel practice problems component of our resources, so that learners can review practice problems without being distracted by other resources.Bookkeeping for inventory and merchandising transactions. We cover merchandising transactions and cost flow assumptions.Merchandising transaction, those transaction that deal with inventory, including the purchase of inventory and the sale of inventory. We will discuss related topics including sales discounts, purchase discounts, sales return and allowances, shrinkage and the cost of goods sold calculation. We will also compare and contrast a perpetual inventory system and periodic inventory system, listing and describing the pros and cons of each, explaining when each may be most appropriate in practice. Inventory costs and cost flows, including what is included in the cost of inventory and how to account for inventory freight costs, inventory insurance costs, and discount. We also discuss inventory flow assumptions including specific identification, first in first out (FIFO), last in first out (LIFO), and weighted average methods. FIFO, LIFO and weighted average methods will be discussed using both a periodic inventory system and a perpetual inventory system. Who will we be learning from?You will be learning from somebody who has technical experience in accounting concepts and in accounting software like QuickBooks, as well as experience teaching and putting together curriculum.You will be learning from somebody who is a:• CPA - Certified Public Accountant• CGMA - Chartered Global Management Accountant• Master of Science in Taxation• CPS - Certifies Post-Secondary Instructor• Curriculum Development ExportAs a practicing CPA the instructor has worked with many technical accounting issues and helped work through them and discuss them with clients of all levels.As a CPS and professor, the instructor has taught many accounting classes and worked with many students in the fields of accounting, business, and business applications.The instructor also has a lot of experience designing courses and learning how students learn best and how to help students achieve their objectives. Experience designing technical courses has also benefit in being able to design a course in a logical fashion and deal with problems related to technical topics and the use of software like QuickBooks Pro.Summary of what will be covered: Merchandising TransactionPurchase of merchandise or inventorySale of merchandise or inventoryPerpetual and Periodic Inventory SystemWe will compare and contrast the perpetual and periodic inventory systems. Sales Discount & Purchase DiscountIt is easy to get the sales discount and purchase discount confused and mixed up. We will discuss both transactions and how to record them. Inventory Shrinkage & Sales Returns. Inventory Shrinkage has do do will loss of inventory, the problem being how to know it is lost and how to record the loss. Sales return are when inventory is returned after a sale. We will record transactions related to sales returns. Financial Statements - Merchandising CompanyFinancial statements, especially the income statement, are typically more complex for merchandising companies then service companies. Comprehensive ProblemsWe will have to comprehensive problems, on focused on financial transactions, more of a mid sized problem. The second comprehensive problem will cover the full accounting cycle for a merchandising company, the recording of financial transaction, adjusting entries, financial statements, and closing process. Inventory Tracking methodsSpecific identification methodFirst in first out (FIFO) methodLast in first out (LIFO) methodWeighted average methodInventory costsFrightInsurancePurchase discountsPeriodic system verses a perpetual system. We discuss FIFO, LIFO, and weighted average under each system.

课程标签

0人关注该课程

主题相关的课程