Excel Accounting 2–Worksheet, Opening Balances, & Subledger

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

4.40 (99 reviews)
Udemy
platform
English
language
Microsoft
category
Excel Accounting 2–Worksheet, Opening Balances, & Subledger
27,734
students
2.5 hours
content
Dec 2021
last update
$44.99
regular price

What you will learn

How to create an accounting system in Excel

How to enter beginning account balances into a new accounting system

How to navigate Microsoft Excel

How to enter beginning balances for inventory and create an accompanying subsidiary ledger

How to enter beginning balances for accounts receivable and create an accompanying subsidiary ledger

How to enter beginning balances for accounts payable and create an accompanying subsidiary ledger

Description

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.

Content

Create Worksheet for New Company Accounting Transactions

6010 Set Up Excel Worksheet
6012 Set Up Excel Worksheet #2
6014 Set Up Excel Worksheet #3
6016 Set Up Excel Worksheet #4

Adding Inventory Items & Related Inventory Account Balances

6300 Inventory & Inventory Subsidiary Ledger

Add Customers, Add Vendors, & Accounts Receivable & Accounts Payable Balances

6340 Accounts Receivable & Subsidiary Ledger
6360 Accounts Payable & Subsidiary Ledger
6362 Financial Statements

Add Opening Account Balances

6380 Add New Accounts & Opening Balances
6383 Adjust Beginning Balances in Worksheet for Current Period Data Input

Reviews

Ganapathi
January 27, 2023
Nice course , may be add some shortcut keys which is useful for accounting is neccessary , thanks udemy and the author
Anuja
June 9, 2022
This course is simply speechless! It covers a wide range of topics in very detailed explanations, and by just watching one time per video, I can understand the concepts and apply them to practical problems! I highly recommend this video to anyone who wants to be an expert.

Coupons

DateDiscountStatus
1/3/2022100% OFF
expired
1/21/2022100% OFF
expired
2/7/2022100% OFF
expired
2/15/2022100% OFF
expired
2/26/2022100% OFF
expired
3/5/2022100% OFF
expired
3/22/2022100% OFF
expired
4/2/2022100% OFF
expired
4/10/2022100% OFF
expired
4/19/2022100% OFF
expired
5/14/2022100% OFF
expired
5/20/2022100% OFF
expired
6/7/2022100% OFF
expired
6/14/2022100% OFF
expired
6/21/2022100% OFF
expired
7/7/2022100% OFF
expired
8/10/2022100% OFF
expired
8/17/2022100% OFF
expired
9/8/2022100% OFF
expired
9/21/2022100% OFF
expired
10/4/2022100% OFF
expired
10/11/2022100% OFF
expired
10/17/2022100% OFF
expired
11/17/2022100% OFF
expired
12/4/2022100% OFF
expired
1/17/2023100% OFF
expired
2/23/2023100% OFF
expired
4/9/2023100% OFF
expired
7/18/2023100% OFF
expired
9/26/2023100% OFF
expired

Charts

Price

Excel Accounting 2–Worksheet, Opening Balances, & Subledger - Price chart

Rating

Excel Accounting 2–Worksheet, Opening Balances, & Subledger - Ratings chart

Enrollment distribution

Excel Accounting 2–Worksheet, Opening Balances, & Subledger - Distribution chart

Related Topics

4441152
udemy ID
12/12/2021
course created date
1/3/2022
course indexed date
Bot
course submited by