Excel Accounting 2–Worksheet, Opening Balances, & Subledger [Udemy Coupon Code]

"When you purchase something through one of the links on our site, we may earn an affiliate commission at no additional cost to you."

Limited offer hurry up

Excel Accounting 2–Worksheet, Opening Balances, & Subledger is a top-rated Udemy course taught by Robert (Bob) Steele — with over 39056+ students enrolled since it launched.

Learn how to set up an accounting system in Excel and add beginning balances from a Certified Public Accountant (CPA)

Don’t wait! This special offer won’t last long.

Click the button below to Get up to 100% OFF the regular price.

(The discount will be applied automatically at checkout — no code needed!)

Hurry — this discount on Excel Accounting 2–Worksheet, Opening Balances, & Subledger won’t be around forever. Take action now!

100% off Udemy coupon code

Why enroll in the Excel Accounting 2–Worksheet, Opening Balances, & Subledger Udemy Course?

  • Udemy gives you access to over 250,000 courses and 85,000 expert instructors worldwide.
  • Courses are led by experienced professionals dedicated to delivering a high-quality learning experience.
  • Many of Udemy’s most popular courses have hundreds of thousands of students enrolled.
  • Udemy offers online coupons, promo codes and voucher for the majority of its courses.

Excel Accounting 2–Worksheet, Opening Balances, & Subledger Udemy Promotion code

Course Sections
Create Worksheet for New Company Accounting Transactions
Adding Inventory Items & Related Inventory Account Balances
Add Customers, Add Vendors, & Accounts Receivable & Accounts Payable Balances
Add Opening Account Balances
Course Description
Requirements
None – If you do not have access to Microsoft Excel you can use Google Sheets or another electronic spreadsheet program

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.