Excel Accounting Problem
Learn How to Create an Accounting Worksheet Using Microsoft Excel from a Certified Public Accountant (CPA)What you'll learn
- How to navigate Microsoft Excel or other computerized spreadsheet like Google Sheets
- How to create an accounting system in Excel from a blank worksheet including a general journal, trial balance, general ledger, subsidiary ledgers and more
- How to enter journal entries related to common transactions and list the data input forms often used to enter them into accounting software like QuickBooks
- How to enter two months worth of data input into our accounting system
- How to do two month of bank reconciliations, comparing the process to how accounting software like QuickBooks would accomplish the task
- How to enter period end adjusting journal entries
- Create financial statements