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)

Created by: Robert (Bob) Steele
CPA, CGMA, M.S. Tax, CPI

What Will I 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

Requirements

• None - If you do not have access to Microsoft Excel you can use Google Sheets or another electronic spreadsheet program

Target audience

• Anybody who wants to learn accounting
• Anybody who wants to learn Microsoft Excel
• Accounting and business students