We may earn an affiliate commission when you visit our partners.
Course image
Robert (Bob) Steele

This is a project based income tax course.

We will construct a complex tax return in a step by step format, beginning with a basic return & building complexity as we move forward.

The course will demonstrate the data input within 2020 income tax forms as well as the use of an Excel worksheet to check the numbers and demonstrate the use of tax software.

Using tax software & an Excel worksheet, formatted as the income tax equation, are common, and best practices for many tax professionals, practices that greatly increase understanding and accuracy.

Read more

This is a project based income tax course.

We will construct a complex tax return in a step by step format, beginning with a basic return & building complexity as we move forward.

The course will demonstrate the data input within 2020 income tax forms as well as the use of an Excel worksheet to check the numbers and demonstrate the use of tax software.

Using tax software & an Excel worksheet, formatted as the income tax equation, are common, and best practices for many tax professionals, practices that greatly increase understanding and accuracy.

The practice problem with start by using basic tax data input forms such as W-2 forms and Form 1099s. We will then add a Schedule A Itemized Deductions. The problem will eventually include a Schedule C Sole Proprietorship and Schedule E Rental Income or Loss.

The materials for the course will include example tax forms after many of the steps in the practice problem. We will also include an Excel worksheet template that will be used in the instructional videos.

We will be using Lacerte tax software. You are not required to have Lacerte tax software to follow along. If you do not have tax software you can still follow along using tax forms from the IRS website and use the Excel worksheet. Other tax software can also be used in a similar way.

In some cases Lacerte may offer a free 30-day trial period of the tax software.

Enroll now

What's inside

Learning objectives

  • How to complete at tax return
  • How to calculate taxes using a tax formula
  • How to use tax software to help complete a complex return
  • How to use an excel tax worksheet to check work

Syllabus

Income Section
310 Practice Problem 1 Part 1 Introduction Organizing Documents
315 Practice Problem 1 Part 2 Data Input Form W-2
320 Practice Problem 1 Part 3 Data Input Form W-2 Tax Formula – Excel Worksheet
Read more

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Uses a step-by-step approach to building a complex tax return, which mirrors the workflow of professional tax preparation
Demonstrates the use of both tax software and Excel worksheets, reflecting common practices in the tax profession
Covers a range of tax forms and schedules, including W-2, 1099, Schedule A, Schedule C, and Schedule E, providing a comprehensive overview
Employs Lacerte tax software, which is a professional tool, but the course can still be followed using IRS forms and Excel
Focuses on the 2020 tax year, which may not reflect current tax laws and regulations, so learners should confirm updates

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Comprehensive 1040 tax problem solving

According to learners, this course offers a positive and hands-on approach to understanding and preparing a complex individual income tax return (Form 1040). Students appreciate the step-by-step breakdown of a comprehensive problem, which helps solidify their knowledge of various tax forms and schedules, including Schedule A, Schedule C, and Schedule E. The course is noted for demonstrating the use of tax software (specifically Lacerte) and providing an Excel worksheet template to check calculations, which many find very helpful for increasing accuracy and understanding the tax equation. Some learners found the pace suitable for beginners in tax preparation, while others wished for more depth on certain complex topics or noted the software version used might be outdated.
Good for foundations, might lack advanced detail.
"This course is perfect if you're new to preparing returns with varied income/deductions. It gives a strong foundation."
"For experienced preparers, some parts might feel slow, but the comprehensive problem is still a good review."
"I wish there was more detail on some of the less common or more complex tax situations that can arise."
Clear, sequential breakdown of the tax process.
"The instructor breaks down each section of the tax return very clearly, making a complex topic manageable."
"Each step in the problem-solving process was logically presented and easy to follow."
"I felt guided through the entire process, which was essential for someone new to preparing complex returns."
Practical demonstration of tools used by professionals.
"Seeing how to input data into Lacerte and then verify it with the Excel sheet was incredibly useful. It showed me best practices for tax professionals."
"The Excel worksheet provided a clear visual of the tax formula and helped me double-check the software's output."
"Even without Lacerte access, following along with the tax forms and Excel template provided a solid understanding."
Focuses on building a complex return incrementally.
"The course really builds the tax return piece by piece, starting simple and adding complexity. This step-by-step approach was great for understanding how everything fits together."
"Working through the full comprehensive problem from start to finish made the concepts much clearer than just reading about them."
"I appreciated using a single complex scenario throughout the course. It felt like preparing a real-world return."
Based on 2020 forms; potential for outdatedness.
"The course uses 2020 tax forms and software. While the principles are similar, users need to be aware that tax laws and forms change yearly."
"I understand the basics taught are enduring, but it would be more helpful if the examples used the most current tax year's forms."
"While the comprehensive problem is great, the examples being from 2020 means some specific numbers or rules might be slightly different now."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Individual Income Tax Form 1040 Comprehensive Problem with these activities:
Review Basic Tax Concepts
Strengthen your understanding of fundamental tax concepts before diving into complex scenarios. This will help you grasp the nuances of Form 1040 more effectively.
Browse courses on Tax Deductions
Show steps
  • Review IRS Publication 17.
  • Define key tax terms.
  • Summarize common deductions.
Read J.K. Lasser's Guide to Self-Preparing Your Income Tax
Supplement your learning with a comprehensive guide to tax preparation. This book will provide additional context and examples to reinforce the concepts covered in the course.
Show steps
  • Read relevant chapters.
  • Take notes on key concepts.
  • Work through example problems.
Complete Practice Tax Returns
Reinforce your understanding by working through multiple practice tax return scenarios. This will help you become more comfortable with the data input process and tax calculations.
Show steps
  • Find practice tax scenarios.
  • Complete the tax returns.
  • Compare your results to solutions.
  • Identify areas for improvement.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Build an Excel Tax Worksheet Template
Solidify your understanding of the tax formula by creating your own Excel worksheet template. This will allow you to visualize the calculations and identify potential errors.
Show steps
  • Outline the tax formula.
  • Create Excel formulas.
  • Test the worksheet with data.
  • Refine the worksheet template.
The Tax Book
Deepen your understanding of tax law with a comprehensive reference guide. This book will provide detailed explanations and examples to help you navigate complex tax situations.
Show steps
  • Identify key tax topics.
  • Read relevant sections.
  • Take notes on key concepts.
Analyze Tax Law Changes
Stay up-to-date on the latest tax law changes by researching and analyzing recent legislation. This will help you understand the evolving landscape of individual income tax.
Show steps
  • Identify recent tax law changes.
  • Research the impact of changes.
  • Summarize the key findings.
  • Present your analysis.
Help Others with Tax Questions
Reinforce your knowledge by helping others with their tax questions. This will force you to articulate your understanding and identify any gaps in your knowledge.
Show steps
  • Find online tax forums.
  • Answer tax questions.
  • Explain your reasoning.
  • Seek feedback on answers.

Career center

Learners who complete Individual Income Tax Form 1040 Comprehensive Problem will develop knowledge and skills that may be useful to these careers:
Tax Associate
Tax associates assist senior tax professionals with preparing and filing tax returns for individuals and businesses. Tax associates need a strong understanding of tax laws, regulations, and procedures. This "Individual Income Tax Form 1040 Comprehensive Problem" course helps tax associates gain practical experience constructing a complex tax return using tax software, which is a common tool in the field. The course's focus on various tax forms, such as W-2s, 1099s, Schedule A, Schedule C, and Schedule E, provides a comprehensive understanding of individual income taxation. As a tax associate, following along with the Excel worksheet will help you check your numbers.
Tax Preparer
A tax preparer helps individuals and businesses file their taxes accurately and on time. This career involves understanding tax laws, completing tax forms, and using tax software. This "Individual Income Tax Form 1040 Comprehensive Problem" course helps build a foundation for this role as it provides hands-on experience completing a complex tax return step by step. Tax preparers must be able to work with various tax forms, including W-2s, 1099s, Schedule A, Schedule C, and Schedule E, all of which are covered in this course. The course's emphasis on using Excel worksheets to check numbers and tax software aligns with the best practices used by tax preparers.
Tax Staff Accountant
Tax staff accountants assist with the preparation of tax returns for individuals and businesses, under the supervision of senior tax professionals. This role requires a solid understanding of tax laws, accounting principles, and tax software. This "Individual Income Tax Form 1040 Comprehensive Problem" course helps tax staff accountants gain practical experience in preparing individual income tax returns by using tax software. The course demonstrates the use of Excel, which is also helpful. The tax staff accountant will gain a more comprehensive understanding of the income tax equation.
Certified Public Accountant
Certified Public Accountants provide a wide range of accounting, auditing, and tax services to individuals, businesses, and organizations. While CPAs handle complex financial matters, understanding individual income tax is a fundamental skill. This "Individual Income Tax Form 1040 Comprehensive Problem" course helps CPAs ensure their proficiency in individual income tax preparation. CPAs can use this course to build fundamental knowledge on the elements of form 1040. The course's focus on using tax software and Excel worksheets aligns with the tools and techniques used by CPAs in practice.
Financial Advisor
Financial advisors provide guidance to individuals and families on managing their finances, including investments, retirement planning, and tax planning. The financial advisor uses this knowledge to create personalized financial plans that help clients achieve their financial goals. This "Individual Income Tax Form 1040 Comprehensive Problem" course helps financial advisors build a foundation in tax planning, which is an important aspect of financial advice. Understanding how to prepare individual income tax returns, calculate taxes using a tax formula, and use tax software will help financial advisors provide informed advice to their clients. Financial advisors should always be aware of the tax implications of their recommendations.
Bookkeeper
Bookkeepers are responsible for recording financial transactions, maintaining financial records, and preparing financial reports for businesses. While this role entails a broader scope than strictly tax preparation, understanding individual income tax is crucial. This "Individual Income Tax Form 1040 Comprehensive Problem" course helps bookkeepers understand the tax implications of various income and expense items, especially those related to sole proprietorships and rental income or loss (Schedule C and Schedule E), which can be particularly valuable. Further, as a bookkeeper you may find that the course's use of Excel contributes to a stronger grasp of financial information.
Tax Analyst
Tax analysts are responsible for researching and interpreting tax laws, and ensuring compliance with tax regulations. The tax analyst develops and implements tax strategies to minimize tax liabilities and optimize financial performance. This "Individual Income Tax Form 1040 Comprehensive Problem" course may be useful to those who wish to become tax analysts, particularly those who have little experience with tax forms and individual income tax. Tax analysts will find that this course will demonstrate data input within 2020 income tax forms, making them more familiar.
Accounting Assistant
Accounting assistants provide support to accountants and other financial professionals. They assist with tasks such as data entry, record keeping, and preparing financial reports. Although the role may not focus solely on tax preparation, understanding individual income tax is helpful. This "Individual Income Tax Form 1040 Comprehensive Problem" course may be useful for an accounting assistant because it emphasizes accuracy and attention to detail in tax preparation, skills that are transferable to other accounting tasks. Additionally, the course's focus on using Excel worksheets to check numbers is beneficial for data analysis and reconciliation. The course demonstrates data input within tax forms, which is similar to data input in bookkeeping.
Payroll Specialist
Payroll specialists manage the payroll process for companies, ensuring that employees are paid accurately and on time. While this role focuses on payroll taxes and compliance, understanding individual income tax is beneficial. Specialists use accounting software or spreadsheets to manage all of the company's payroll functions. This "Individual Income Tax Form 1040 Comprehensive Problem" course may be useful to payroll specialists as it provides insights into how individual income taxes are calculated and reported. The course's emphasis on using Excel may be helpful for payroll specialists as it provides a foundation for using spreadsheets. The course will show you how to use Excel to check the numbers.
Tax Consultant
Tax consultants provide expert advice to individuals and businesses on tax planning, compliance, and optimization. In this role, it is common to need a master's degree. The tax consultant assists clients in understanding tax laws and regulations, minimizing their tax liabilities, and ensuring compliance with tax requirements. This "Individual Income Tax Form 1040 Comprehensive Problem" course may be useful to tax consultants. While tax consultants are not necessarily preparing individual income tax returns, understanding how tax returns are prepared helps them serve their clients. This course can help a tax consultant improve their understanding of individual income taxation.
Estate Planner
Estate planners help individuals and families develop strategies for managing and transferring their assets, minimizing taxes, and ensuring their wishes are carried out after their death. Estate planners must have a strong understanding of tax laws, estate planning techniques, and legal principles. This "Individual Income Tax Form 1040 Comprehensive Problem" course helps estate planners build a foundation in individual income taxation, which is relevant to estate planning. This course will improve their understanding of individual income tax preparation.
IRS Agent
IRS Agents are responsible for investigating and auditing tax returns to ensure compliance with tax laws. A strong understanding of tax laws, accounting principles, and investigative techniques is required for this role. This "Individual Income Tax Form 1040 Comprehensive Problem" course may be useful to IRS agents, and may help them gain a deeper understanding of how tax returns are prepared and what issues to look for during audits. IRS agents may find the course is most relevant to their field because it demonstrates the use of Excel worksheets and tax software. Also, this course helps IRS Agents understand the various tax forms that individuals use to file their taxes.
State Tax Auditor
Tax auditors examine financial records of individuals or businesses to determine whether they have accurately reported their tax obligations. This role requires a thorough understanding of state tax laws and accounting principles. This "Individual Income Tax Form 1040 Comprehensive Problem" course helps state tax auditors gain insights into how individuals prepare their tax returns and what issues to look for during audits. The state tax auditor will find that this course helps them understand the various tax forms that individuals use to file their taxes. This course is a good way to help build a foundation in tax knowledge.
Retirement Planner
Retirement planners advise individuals on how to save, invest, and manage their assets for retirement. This process requires understanding of tax laws, investment strategies, and retirement planning concepts. This "Individual Income Tax Form 1040 Comprehensive Problem" course may be useful to retirement planners, especially those who are new to this field. Many taxpayers have questions about how retirement income gets reported on taxes. Because this course focuses on an income tax problem, it can help retirement planners better understand the forms and calculations involved in retirement income.
Budget Analyst
Budget analysts are responsible for developing and managing budgets for organizations, ensuring that financial resources are allocated effectively. While this role focuses on budgeting and financial analysis, understanding individual income tax may be useful. This "Individual Income Tax Form 1040 Comprehensive Problem" course may be useful to budget analysts because it helps illustrate how individuals are impacted by the tax system and what tax considerations they should keep in mind. This course can help budget analysts understand individual income taxes.

Reading list

We've selected two books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Individual Income Tax Form 1040 Comprehensive Problem.
Comprehensive tax reference guide used by many tax professionals. It provides detailed explanations of tax laws and regulations, along with examples and practical guidance. It valuable resource for understanding the complexities of individual income tax and can be used to supplement the course materials. It is best used as a reference tool to clarify specific tax issues that arise during the course.
Provides a comprehensive overview of individual income tax preparation. It useful reference for understanding the various forms and schedules involved in filing taxes. While not specific to any tax software, it offers valuable insights into tax law and common deductions and credits. It is particularly helpful for those who want a deeper understanding of the 'why' behind the tax calculations.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Similar courses are unavailable at this time. Please try again later.
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser