Excel Accounting 2–Worksheet, Opening Balances, & Subledger

On this course we’ll create an accounting system ranging from a clean Excel worksheet and add begging balances to our accounts.

Learners will learn to navigate Microsoft Excel in addition to create a well-designed accounting worksheet, full with a normal journal, trial steadiness, normal ledger, and subsidiary ledgers for accounts receivable, accounts payable, & stock.

Excel is an excellent software to study accounting as a result of it’s rather more clear than a database program, like accounting software program, QuickBooks being a standard instance of accounting software program.

For many new steps within the course of, you should have entry to a downloadable Excel Workbook, containing a minimum of two tabs, one with the reply, the brand new steps being accomplished, the opposite beginning out the place the prior presentation left off.

As soon as our accounting system utilizing an Excel worksheet is about up, we’ll add journal entries to enter starting balances to our accounts, imagining we’re transferring from a previous accounting system to our new Excel worksheet system.

When including the start stock steadiness to the chart of accounts, we can even add a listing subsidiary ledger, reporting stock by merchandise and unit, in addition to by price.

As we add the start accounts receivable steadiness to the chart of accounts, we can even add the accounts receivable subsidiary ledger, displaying the cash owed to the corporate by buyer.

And once we add the accounts payable steadiness to the chart of accounts, we’ll add the accounts payable subsidiary ledger, reporting the cash owed by the corporate to distributors.