Excel Accounting Problem

Learn How to Create an Accounting Worksheet Using Microsoft Excel from a Certified Public Accountant (CPA)

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

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

Requirements

• None

Target audience

• Anyone who wants to learn Excel, real world practice problems being the best tool
• Anybody learning accounting or bookkeeping
• Anybody who uses accounting software like QuickBooks and wants to understand what the software is doing
• Accounting students and professionals