Tax & Adjusting Entry Year-End Accounting Excel Worksheet

Build Excel worksheet for adjusting adjusting & tax entries, reconciling net income calculated on a book and tax basis

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

What Will I Learn?

• How to build an adjusting and tax worksheet from scratch in Excel
• What the benefits of an adjusting and tax worksheet are
• How to enter adjusting entries into an adjusting and tax Excel worksheet
• How to enter tax entries into an adjusting and tax Excel worksheet
• How to reconcile book net income and tax net income using an Excel worksheet

Requirements

• Should understand debits & credits and have some experience with Excel

Target audience

• Tax professionals who want to reconcile book net income and tax net income
• Public accountants who work with adjusting entries
• Any accountant who wants to learn how to set up a practical worksheet to work through accounting transactions
• Any accountant who wants practical practice formatting Excel Worksheets