Excel Accounting 1–Transactions for Common Data Input Forms
Learn how to build an accounting system using Excel and how to enter common transactions from a CPAWhat you'll learn
- How to create an accounting system using Excel, starting from a blank worksheet
- How to navigate and format Excel worksheets
- How to create a general journal
- How to create a general ledger
- How to create a trial balance
- How to create subsidiary ledgers
- How to create financial statements, including a balance sheet and income statement
- How to enter transactions related to the vendor cycle, including the impact on subsidiary ledgers and financial statements
- How to enter transactions related to the customer cycle, including the impact on subsidiary ledgers and financial statements
- How to enter transactions related to the employee cycle, including the impact on subsidiary ledgers and financial statements
