Excel Accounting 1–Transactions for Common Data Input Forms

[carxproveteran]

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 CPA

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

To view the content, you need to Sign In or Register.

Click to read more...