CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Taxation of Property Transactions - Tax Staff Essentials
-
Online
4.00 Credits
A fundamental understanding of the taxation of business property transactions is essential to any tax practice. This course prepares tax professionals to handle the tax effects of common property transactions, including like-kind exchanges and involuntary conversions. It also covers important property-related timing issues and planning opportunities that can lead to significant tax savings.
Current Audit Environment and ASB Activity
-
Online
2.00 Credits
Explore the current audit environment, and recognize audit challenges triggered by the current environment. Provide a comprehensive review of recent audit pronouncement and exposure drafts. Understand topics critical to success in today's rapidly changing regulatory environment. This course provides 4 hours of CPE credit in the Auditing field of study.
Performing Preparation, Compilation and Review Engagements
-
Online
2.00 Credits
Comply With All Standards As You Prepare, Compile and Review Engagements This webcast is a go-to reference for staying in compliance with all professional standards surrounding engagements performed in accordance with Statements on Standards for Accounting and Review Services (SSARSs).
Documenting Your EBP Audit: What You Need to Know
-
Online
8.00 Credits
What you document matters Understand different parts of the employee benefit plan (EBP) audit process, and learn to think holistically about your level of audit documentation. Understand the appropriate level of documentation in the performance of audit procedures of employee benefit plans, which will involve testing items that are not typically tested in audits of other types of entities. Real-life examples Learn from real-life examples and solutions, guided by a former employee benefit plan expert panel member and someone who performs peer reviews. Work in templates to truly understand documentation in an EBP audit, and learn best practices for documentation to incorporate into your audits.
Performing a Single Audit Under the Uniform Guidance
-
Online
8.00 Credits
Performing a single audit Exploring various topics related to single audits will give you the knowledge you need to perform these engagements skillfully. You can learn about: Major program determination Pass-through entity responsibilities SEFA requirements The Compliance Supplement requirements The administrative requirements and cost principles found in the Uniform Guidance Uniform Guidance compliance audit basics Gaining an understanding of the Uniform Guidance basics will prepare you for compliance audit engagements. You can examine various topics, such as: Requirements overview Applying GAAS and the Yellow Book to compliance audits Entities that must undergo this type of engagement Federal awards decoded You can also learn the different types of federal awards, along with audit implications for a recipient or subrecipient. Federal award topics covered include: Becoming aware of the SEFA Major program determination Testing and reporting responsibilities You will acquire a fundamental understanding of your responsibilities related to testing and reporting by examining topics, such as: Testing internal control over compliance Testing compliance Writing an audit finding
Reviewing Individual Tax Returns: What Are You Missing?
-
Online
4.00 Credits
The sheer mass of Internal Revenue Code provisions affecting individual taxpayers presents a considerable challenge for CPAs and tax professionals. These provisions combined with the potential for input error when utilizing the array of income tax software available, create the potential for a multitude of errors that can occur when preparing your client's tax return. Join us as we discuss the common errors practitioners make on individual tax returns that are often missed by review staff. Sharpen your reviewing skills by examining case studies discussing issues for which additional information from the client may be warranted, and areas of tax law that require additional analysis and information.
Yellow Book: Staying Compliant With Government Auditing Standards
-
Online
8.00 Credits
Based on Government Auditing Standards, 2018 Revision, this course is essential for auditors performing Yellow Book audits. It provides detailed information about conducting engagements in accordance with the Yellow Book and requirements related to independence. This course will increase your knowledge of the requirements and application guidance related to ethics, standards for financial audits, attestation engagements, performance audits, and more.
Revenue Recognition, Financial Instruments, and Leases
-
Online
1.00 Credits
Understand FASB's important accounting and reporting areas: financial instruments and leases. Learn to assess and implement the new standards and guidance that are applicable to your practice.
PCAOB Updates
-
Online
1.00 Credits
Understand the complexities of PCAOB updates. Understand the new requirements of recently approved PCAOB amendments to the auditing standards and the auditor's key responsibilities in response to the amendments. Learn to sort through the complexities to identify and apply them to the audit of a public company.
Excel for Accounting Professionals Session 5: Error Trapping and Improving Lookups
-
Online
2.00 Credits
As popular as the VLOOKUP function is, it has limitations. This session walks through the limitations and suggests how to improve the VLOOKUP function. We then discuss how to move beyond VLOOKUP altogether. We spend some time trapping errors with the IFERROR function, which was first rolled out with Excel 2007. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the webcast, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.
Audits of Employee Benefit Plans Subject to ERISA
-
Online
8.50 Credits
Employee Benefit Plan (EBP) audit engagements remain under close examination by regulators and peer reviewers, stemming from a historical pattern of noncompliance with applicable professional standards. It is imperative that auditors possess the requisite skills to carry out EBP engagements with proficiency. This involves navigating the audit process from the initial engagement acceptance through to reporting and completion. Given that 401(k) plans represent the predominant plan type subjected to audits, we engage in a comprehensive examination of these plans. Discover strategies to meticulously plan and execute risk-based plan audits, ensuring adherence to professional standards without compromising on efficiency.
Excel for Accounting Professionals Session 6: List Comparisons and Indenting
-
Online
2.00 Credits
This session opens with how to use Excel's lookup functions to perform list comparisons. Also, this webcast covers how to perform multicolumn list comparisons without first combining several columns into a single lookup column. We discuss how a minor detail like how we indent can produce major efficiency gains. We end the webcast by comparing traditional lookup functions to Excel;'s multiple condition summing function. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the webcast, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.
Applying the Uniform Guidance in Your Single Audits
-
Online
8.00 Credits
Designed to provide you with the knowledge to be more efficient and effective at planning and performing audits in accordance with the requirements of the Uniform Guidance and the Single Audit Act, this course examines how the Single Audit Act relates to OMB Uniform Guidance, as well as the different types of guidance and requirements found in the Uniform Guidance. The course also covers responsibilities and requirements of the auditor and the auditee, how to identify federal assistance and how to determine a nonfederal entity's major programs. Make sure your skills are up to date with the latest information in this challenging audit area.
Excel for Accounting Professionals Session 7: Date Driven Workbooks and Concatenation
-
Online
2.00 Credits
When we try to improve efficiency, we seek to delegate manual tasks to Excel. This implies that we seek to convert manual input cells into formula cells. When we realize that Excel can operate on and return date and text values, the opportunity for efficiency greatly expands. This webcast covers key date and text functions. It also demonstrates how to greatly improve the utility of the conditional summing function by using comparison operators. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel, since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the webcast, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.
Current Audit Environment and ASB Activity
-
Online
2.00 Credits
Explore the current audit environment, and recognize audit challenges triggered by the current environment. Provide a comprehensive review of recent audit pronouncement and exposure drafts. Understand topics critical to success in today's rapidly changing regulatory environment. This course provides 4 hours of CPE credit in the Auditing field of study.
Auditing Financial Statements of ERISA Plans
-
Online
4.00 Credits
Conduct a compliant audit Identify proper audit procedures to test the line items of the statement of net assets available for benefits, including investments. Identify proper audit procedures to test the activity in the statement of changes in net assets available for benefits, including participant testing. Plan investments Differentiate plan investment procedures based upon the type of audit and risk assessment. Identify types and classifications of common plan investments. Identify audit procedures required for investment activity, contributions and benefit payment or withdrawals at the participant level. GAAP presentation and disclosure Understand GAAP requirements for presentation and disclosure for employee benefit plan financial statements. Other audit considerations Recognize procedures needed to determine the plan's tax status Learn how to identify related parties, parties in interest, and prohibited transactions. Recognize additional audit procedures needed for Form 11-K filers.
Excel for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check
-
Online
2.00 Credits
The Excel for Accounting Professionals webcast series concludes by applying many of the items covered at the same time. We start by discussing dynamic headers, and how important they are when automating reporting workbooks. Next, we review how to transpose the orientation of the conditional summing function to produce horizontal or crosstab reports. We review the idea of mapping tables and show how they are the key to unlocking major efficiency gains. Lastly, we use data validation in our digital reports and review a critical worksheet that belongs in just about every recurring-use workbook: ErrorCk. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel, since you'll be completing the same exercises demonstrated by the instructor. A link will be provided so you can download the necessary Excel files. During the session, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.
Streamlined Excel Reporting Series Session 1: PivotTable Fundamentals
-
Online
2.00 Credits
This is part 1 of a 4 part series. The first session of the series introduces the PivotTable feature and covers the basics. We start here to ensure that all participants, regardless of previous PivotTable experience, have the skills needed for the remaining sessions. We discuss the four report layout areas, rows, columns, values, and filters. We then discuss how to update PivotTable reports and ensure that any new transactions appended to the data source are included in the report. We explore how to create monthly columns and how to properly format the values in a PivotTable.
Streamlined Excel Reporting Series Session 2: Working with PivotTables
-
Online
2.00 Credits
This is part 2 of a 4 part series. This session begins by comparing the formula-based reports we built at the end of the Excel for Accounting Professionals series to PivotTables. We'll dig into the details between these two report types so that you are comfortable applying them to specific workbooks. In this webcast, we create two versions of many reports, one version with formulas and the other with PivotTables. With this interactive practice, you will be comfortable replacing formula-based reports with PivotTables when appropriate.
Multi-State Taxation - Tax Staff Essentials
-
Online
8.00 Credits
Multistate taxation has never been a more relevant topic. This course helps professionals skillfully navigate the maze of multistate corporate tax codes.. Be the one to guide your client skillfully through the maze of multistate corporate tax codes. Rapidly develop a working knowledge of both multistate tax compliance and related planning opportunities.