Excel Accounting 2–Worksheet, Opening Balances, & Subledger | Free Udemy Course
Learn how to set up an accounting system in Excel and add beginning balances from a Certified Public Accountant (CPA) | Free Udemy Course
- 2.5 hours hours of on-demand video
- Full lifetime access
- Access on mobile and TV
- Certificate of completion
- 7 additional resources
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.Who this course is for:Anybody who wants to learn accountingAnybody who wants to learn Microsoft ExcelAccounting and business students
Course Content:
Sections are minimized for better readability, click the section title to view the course content
JOIN OUR WHATSAPP GROUP TO GET LATEST COUPON AS SOON AS UPDATED
JOIN WHATSAPPJOIN OUR TELEGRAM CHANNEL TO GET LATEST COUPON
JOIN TELEGRAMJOIN OUR FACEBOOK GROUP TO GET LATEST COUPON
JOIN FACEBOOKFree Online Tools And Converters for your use
URL Encoder
Input a string of text or a URL and encode the entered string
Try itURL Decoder
Input an encoded string of text or a URL and decode the entered string
Try itColor Contrast Checker (WCAG)
Calculate the color contrast ration for your website (WCAG)
Try itXML Formatter
Paste or upload an XML and have it formatted to a beautiful XML format
Try itURL Slug Generator
Convert any title or sentence into a variety of slugs for your pages URL
Try itE-Signature
Draw an e-signature or type a signature for your online signature
Try it