|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-accounting-2worksheet-opening-balances-subledger/
课程评论：没有评论
**课程名称：** Excel 会计 2 - 工作表、期初余额与明细账 **课程概述：** 本课程将从空白的 Excel 工作表开始，逐步构建一个完整的会计系统，并为各账户添加期初余额。学员将学习如何熟练运用 Microsoft Excel，设计一个结构清晰的会计工作表，包括总账、试算平衡表、总分类账以及应收账款、应付账款和存货的明细账。 Excel 相较于数据库程序（如 QuickBooks 等会计软件）而言，在会计应用方面具有更高的透明度，这使得它成为学习会计的优秀工具。课程将提供可下载的 Excel 工作簿，其中包含至少两个工作表，一个包含标准答案和当前步骤的完成情况，另一个则承接上一个演示的起始状态，帮助学员逐步学习。 在搭建好 Excel 会计系统后，我们将通过输入期初分录来录入会计科目的期初余额，模拟从旧会计系统迁移到新的 Excel 工作表系统。 在为会计科目表添加期初存货余额时，我们还将一并创建存货明细账，按项目、数量和成本分别报告存货信息。 添加期初应收账款余额到会计科目表的同时，我们将建立应收账款明细账，详细列出公司应收客户的款项。 同样，在录入期初应付账款余额到会计科目表时，我们也将添加应付账款明细账，报告公司应付供应商的款项。
In this course we will create an accounting system starting from a blank Excel worksheet and add begging balances to our accounts.Learners will learn how to navigate Microsoft Excel as well as how to create a well-designed accounting worksheet, complete with a general journal, trial balance, general ledger, and subsidiary ledgers for accounts receivable, accounts payable, & inventory. Excel is a very good tool to learn accounting because it is much more transparent than a database program, like accounting software, QuickBooks being a common example of accounting software.For most new steps in the process, you will have access to a downloadable Excel Workbook, containing at least two tabs, one with the answer, the new steps being completed, the other starting out where the prior presentation left off.Once our accounting system using an Excel worksheet is set up, we will add journal entries to enter beginning balances to our accounts, imagining we are moving from a prior accounting system to our new Excel worksheet system.When adding the beginning inventory balance to the chart of accounts, we will also add an inventory subsidiary ledger, reporting inventory by item and unit, as well as by cost.As we add the beginning accounts receivable balance to the chart of accounts, we will also add the accounts receivable subsidiary ledger, showing the money owed to the company by customer.And when we add the accounts payable balance to the chart of accounts, we will add the accounts payable subsidiary ledger, reporting the money owed by the company to vendors.
