Excel Accounting 6–Adjusting Entries & Financial Statements

Learn how to enter adjusting entries into an Excel worksheet from a certified public accountant (CPA)

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

What Will I Learn?

• Know what adjusting entries are and how they fit into the accounting process
• How to enter adjusting and reversing entries for accrued interest
• Ho to enter adjusting and reversing entries for accounts receivable or revenue
• How to enter adjusting entries for prepaid insurance
• How to enter adjusting entries for depreciation
• How to enter adjusting and reversing entries for unearned revenue
• How to enter adjusting entry to break out the short-term and long-term portion of loans
• How to create financial statements from an adjusted trial balance

Requirements

• None

Target audience

• Accountants and business professionals
• Students practicing accounting or business