Excel Accounting 1–Transactions for Common Data Input Forms

What 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

External links may contain affiliate links, meaning we get a commission if you decide to make a purchase