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 how one can create a well-designed accounting worksheet, full with a basic journal, trial steadiness, basic ledger, and subsidiary ledgers for accounts receivable, accounts payable, & stock.

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

For many new steps within the course of, you’ll have entry to a downloadable Excel Workbook, containing at the least 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 ready up, we’ll add journal entries to enter starting balances to our accounts, imagining we’re shifting from a previous accounting system to our new Excel worksheet system.

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

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

And after 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.