CPE Catalog & Events

This course explores recurring PCAOB inspection themes related to Information Technology General Controls and explains why certain ITGC audit approaches consistently raise concerns. Rather than focusing on individual deficiencies, the course examines inspection patterns tied to evidence quality, professional skepticism, control clarity, scoping decisions, SOC reliance, and reviewer judgment. Participants will gain insight into how inspectors evaluate ITGC workpapers and how recurring signals of weak documentation or unsupported assumptions increase inspection risk. Understanding these themes strengthens audit defensibility and improves overall ITGC execution. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Is that business jet, RV, yacht or luxury automobile really deductible? This course tackles the tricky terrain of listed property depreciation, helping tax professionals navigate IRC 280F with confidence and clarity. Whether your client is flying high, cruising the coast, or hitting the highway, this session will help you determine what qualifies, what doesn't, and how to keep the IRS at bay. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In today's interconnected world, safeguarding information systems is crucial. This course will provide a comprehensive understanding of SOC engagements, exploring the types of reports (SOC 1®, SOC 2®, and SOC 3®) and the related management assertions. The use of the reports for internal controls over financial reporting (ICFR) and operations and compliance will be analyzed. This course equips accounting professionals with the knowledge to effectively lead in compliance reporting.

This course provides a concise overview of agentic artificial intelligence and its emerging role in audit and assurance. Participants will examine how AI agents differ from traditional generative AI by planning tasks, using software tools, taking actions, and completing multi-step workflows with limited human intervention. The course explores current audit applications, including substantive procedures, confirmations, risk assessment, disclosure testing, and continuous monitoring, while addressing new risks involving autonomy, permissions, prompt injection, multi-agent systems, and accountability. Participants will also examine regulatory developments, professional standards, controls, evidence requirements, ethics, liability, and the strategic implications of agentic AI for audit firms. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

If you or your clients are facing that stage of life where careers are passing into the background, and a new "to be determined" life is emerging, then you are entering what is called "retirement". Some people are excited, some are scared, and most are both. There are many issues and questions people face at this time - what to do with time, financial, relationships, health, identity and more. This program summarizes the key research studies, provides stories from those who have made this work, and offers thoughtful, practical exercises from my award winning book NEXT STAGE. It will help you (or your clients) address key issues and develop a Master Plan for the transition. If not now, when? This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

For CFOs and Controllers, the emergence of regulatory, fiscal, and monetary policy directly impacting their organizations' costs, competitiveness, and financing options, are causing them to understand the effect of shocks well outside of their control. The Dodd-Frank Act, health care reform, shortfalls in Social Security, unfunded pension liabilities, and deficit spending will all be explored relative to their impact on the CFO/Controller and your organization.

This course provides a concise overview of Claude and its growing role as an AI-powered productivity, analysis, and workflow platform for accounting professionals. Participants will learn how Claude differs from traditional search engines, spreadsheets, and chatbots, and how it can be used to accelerate drafting, research, document review, data analysis, and client communications while maintaining professional skepticism and accountability. The course explores practical prompting techniques, document and spreadsheet analysis, projects, artifacts, connectors, Microsoft 365 integrations, automation capabilities, and emerging AI workflows. Special emphasis is placed on confidentiality, privacy, ethics, verification, and professional judgment. By the end of the course, participants will understand how to integrate Claude into their daily accounting workflows to improve efficiency, strengthen decision-making, and support higher-value advisory services. The course is based on the Claude platform ecosystem, including Chat, Projects, Artifacts, Connectors, Microsoft Office integrations, Voice Mode, Design, Code, and Cowork capabilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

When we leave our jobs, we also leave the protection our employer provides us with regards to internet and Wi-Fi security. Hired people may be able to help with the newest applications, but they may not understand the security risks posed. This session will cover some basic information about cybersecurity weaknesses and some of the scams that target older, retired people. Many times, the perpetrator is someone close and someone who we think we can trust. In this course, you will learn some basic tools to protect against those who wish to perpetrate fraud.

How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.

Practical hands-on Excel learning exercises taught by a highly engaging expert in the field You'll develop your expertise with real-world Excel workbooks. Despite the popularity of VLOOKUP, it has its drawbacks. This session will address these drawbacks while offering alternatives. You'll walk through the VLOOKUP and IFERROR functions, and explore the following topics: Improving the use of VLOOKUP with VALUE/TEXT Improving the use of VLOOKUP with MATCH. Moving beyond VLOOKUP with INDEX Trapping errors with IFERROR Moving beyond basic Excel functions Grasping the limitations and possible enhancements for the VLOOKUP feature, along with methods to handle errors can elevate your proficiency in Excel. You'll also partake in hands-on Excel activities that showcase the integration of functions and their use in crafting spreadsheets, encompassing: Combining functions to enhance flexibility Utilizing functions for atypical data categories Perfecting sophisticated lookup functions *Session 5 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 6: List Comparisons and Indenting] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-6--list-comparisons-and-indenting) to further prepare to tackle real-world issues and build powerful workbooks.*

This section of the four-part series will cover basic Form 706 preparation and help participants develop a solid foundation in preparing the federal estate tax return. It will also cover running the engagement, administration issues and completing pages 1-4 of the form, including the portability election. For example, worksheets and practice resources will be provided. Form 706 Series: Part 1: Overview Including Portability Part 2: Reporting Assets Part 3: Reporting Deductions Part 4: GST Schedule R, Form 8971, Payments & Credits

Most organizations manage their income statement, but many virtually ignore the balance sheet until balance sheet problems create seemingly insurmountable emergencies. This session discusses how to analyze and manage your financial statements more holistically, allowing you to identify and correct balance sheet issues early. How do you choose whether to raise debt or equity" What are the key considerations and the advantages of each" What is the cost of capital" What are the "hidden" balance sheet risks" We will also examine several crucial ideas you can incorporate into your analyses to enhance performance and reduce risk. If you want to enhance your corporate finance skills, this session is for you.

This course explores provisions of Statements on Standards for Accounting and Review Engagements (SSARS) that govern review, compilation, and preparation engagements. Participants will recall foundational concepts, examine recent updates, understand practitioner responsibilities, and apply best practices for engagement performance. Attendees will learn how to efficiently perform SSARS engagements while complying with professional requirements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course provides a comprehensive exploration of cost segregation studies from both technical and compliance perspectives, emphasizing what truly distinguishes a high-quality, IRS-defensible report. Drawing from the IRS Cost Segregation Audit Techniques Guide (ATG) and the instructor's experience as a former IRS engineer and Cost Segregation subject matter expert. Participants will gain practical understanding of how to evaluate, perform, and document cost segregation studies. Topics include the fundamentals of cost segregation and depreciation methods, the differences between Section 1245 and 1250 property, and the importance of accurate cost allocations, engineering documentation, and supportable estimates. The course also covers the principal elements of a well-prepared report, common pitfalls that trigger IRS scrutiny, and practical remedies to strengthen study credibility and audit resilience. By the end of this session, tax professionals, engineers, and financial advisors will be equipped to recognize the hallmarks of a quality cost segregation study and avoid costly mistakes in the process. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This section of the 4-part series will cover basic form preparation of Form 706 and help participants develop a solid foundation in preparing the federal estate tax return. This section will cover running the engagement, administration issues and completion of pages 1-4 of the form, including portability election. For examples, worksheets and practice resources will be provided. Form 706 Series: Part 1: Overview Including Portability Part 2: Reporting Assets Part 3: Reporting Deductions Part 4: GST Schedule R, Form 8971, Payments & Credits

This program reviews and analyzes the important changes made by the One Big Beautiful Bill Act (OBBBA) to qualified small business stock (QSBS) covered under Section 1202. Effective for stock issued after July 4, 2025, there are important changes that make Section 1202 much more appealing to clients willing to run the risks associated with doing business as a C corporation. These enhanced provisions could potentially lead to exclusion of capital gains if very strict compliance rules are followed. Section 1202 application is particularly attractive for start-ups and entrepreneurial endeavors. For taxpayers willing to confront the technical challenges of this provision, Section 1202 may produce impressive tax advantages.

Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.

This session is your practical introduction to AI in the workplace. Designed for professionals in any function from Finance to HR to Marketing and Operations, this course breaks down the AI journey into clear, actionable steps. You'll discover easy-to-use tools, see real-world examples, and leave ready to take your first confident steps toward using AI to save time, boost creativity, and make smarter decisions. Whether you're new to AI or just looking to get started effectively, this session helps you move from curiosity to confident action in just one hour.

For roughly 90% of American retirees, Social Security income will be the foundation of their retirement income. Yet, many are ill-prepared and lack understanding of the critical aspects of making an informed claiming decision. Further challenged to separate fact from fiction, consumers crave accurate information from knowledgeable professionals to make the most out of these coveted monthly benefits. This course dispels common myths about Social Security that lead to confusion and replaces them with the truth to an empowered retirement. Help your clients navigate their claiming age decisions with greater confidence, equipped with the essential truths they should consider before pushing the Social Security "on" button.

Buying and selling a business can be a complex transaction with many tax issues. These issues include whether the transaction is or should be a stock or an asset sale when the business involved is a corporation, as well as the tax consequences associated with the sale of a partnership or a C or S corporation. Accounting and finance professionals who advise clients who are buying or selling a business primarily focus on the tax issues that apply. This program explains and analyzes the tax issues practitioners must address in order to properly advise clients who are either buyers or sellers of businesses.