CPE Catalog & Events

Arguably the most discussed topics to come out of the One Big Beautiful Bill Act (OBBBA) are the taxation of tips and overtime. Practitioners need to understand these provisions now, as they are effective for 2025 tax returns. This program provides practitioners with the background currently available to advise clients regarding these two important tax developments. Both employers and employees need to understand these timely changes to taxation.

Mastering two leadership skills will decrease your stress, and give you room to enjoy your career. Delegating and listening are key essential skills to hone to elevate your career. You were born with two ears and one mouth. And yet, good listeners aren't born. World-class listeners deliberately practice this skill, even when their audience is challenging. This is a skill which can be learned. Participants will gain awareness into their blind spots to listening, strategies to regain focus, how to stop interrupting, and demonstrate to their audience they are listening. How often have you said, "It would just be easier if I did this myself?" or "Nobody can do this task as well as I can, so I'll just do it myself." If this sounds like you, then it's time to start working on your delegation skills. Delegation is not only important as a means to save you time, but it is also about developing the next generation of leaders. 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 concise overview of the emerging liability, malpractice, regulatory, insurance, and professional-conduct risks associated with CPAs' use of artificial intelligence. Participants will examine how traditional duties of care, competence, confidentiality, verification, and professional accountability apply when AI is used in accounting, tax, audit, and advisory work. Drawing on developments in the United States, Canada, and the United Kingdom, the course explores documented AI failures, regulatory expectations, insurance coverage gaps, data exposure, and practical controls CPAs can implement to make AI-assisted work more defensible This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Answering clients' tax questions accurately and on time is a key challenge for tax practitioners. Through simple, plain language explanations and examples, this course will help practitioners perform tax research more efficiently by describing the structure of the primary sources, highlighting the differences between primary and secondary sources, and detailing the steps in the tax research process.

This interactive professional development course explores the concept of unconscious bias and its impact on workplace dynamics, decision-making, and organizational culture. Through engaging exercises, real-world case studies, and reflective activities, participants will gain a deeper understanding of how implicit attitudes shape perceptions and behaviors — often without conscious awareness. The course empowers learners to recognize their own biases, understand their origins, and develop strategies to mitigate their effects in professional settings. Participants will leave with actionable tools to foster a more inclusive, equitable, and respectful workplace.

In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. 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 concise overview of critical thinking and professional skepticism in AI-augmented CPA work. As artificial intelligence increasingly performs drafting, analysis, calculation, research, and other preparation tasks, CPAs are shifting toward higher-value roles involving review, verification, challenge, and professional judgment. Participants will examine professional standards, human cognitive biases, AI failure modes, evidence requirements, questioning techniques, vendor claims, documentation practices, and firm-level controls. The course emphasizes a central principle: AI output should be treated as an unverified claim requiring appropriate human challenge before professional reliance. 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 thorough examination of qualified tuition programs (Section 529 plans), focusing on their tax treatment, planning applications, and recent legislative changes. Participants will learn how 529 plans operate, what qualifies as education expenses, and how contributions, distributions, and beneficiary changes are treated under federal law. The course explores practical planning strategies, including 529-to-Roth IRA rollovers, multigenerational "dynasty" 529 planning, grandparent-owned account considerations, and interplay with financial aid. It also addresses state-level variations, compliance issues, and common pitfalls. Using real-world scenarios, the course evaluates when 529 plans are advantageous, the limitations families may encounter, and alternative approaches to education and long-term savings. Participants will gain a clear understanding of tax benefits, penalties, strategic funding approaches, and planning opportunities for high-net-worth families as well as typical households.

When a purchaser buys an existing partner's partnership interest or the interest of a member of a limited liability corporation (LLC) taxed as a partnership, the amount paid becomes the basis for the purchaser's partnership interest (outside basis). If the partnership's assets have appreciated sufficiently, the difference between the new partner's inside and outside basis can be substantial. This disparity can deprive the new partner of depreciation deductions and inflate his or her share of the gain from subsequent property dispositions unless a Section 754 election is in effect. The Section 754 election can also apply when a partnership makes a distribution of property and the basis of the distributed property to the partnership and the basis the partner/distributee will take in the distributed property are not equal. In this case, a partnership can recover basis it would otherwise lose if the 754 election were not in effect.

As Americans live longer and increasingly move away from traditional pensions, Social Security has become the main source of retirement income for many clients. Meanwhile, concerns about solvency and a lack of understanding of key rules have led to confusion and sometimes misguided decisions. This program offers tax practitioners the knowledge they need to help clients make informed choices about Social Security and retirement income.

Artificial intelligence is revolutionizing forensic accounting, giving professionals powerful new ways to trace funds, uncover fraud, and analyze massive volumes of financial data in minutes instead of weeks. In this engaging course, you'll discover how AI can enhance financial investigations, strengthen expert witness reports, and support litigation and discovery efforts. Learn where AI can create strategic advantages in the courtroom, as well as the disclosure, reliability, and admissibility challenges that every expert must understand. Through practical examples and real-world applications, you'll see how AI can uncover hidden patterns, identify critical evidence, and generate actionable insights. Whether you investigate fraud, support litigation, or serve as an expert witness, this course will help you harness AI with confidence, credibility, and defensible results. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The newest evolution of AI technology is Agentic AI. This technology enables you to deploy AI agents to take action on your behalf and execute tasks. Agentic AI is the key enabler to using AI technology to automate your workflows. Learning how to take advantage of AI agents provides a substantial competitive advantage. This course will teach you the fundamentals of agentic AI and how you can put them to work in your firm or business.

Boosting productivity with Excel For those unfamiliar with conditional summing, you're in for a revelation —it's an impactful technique that improves productivity in creating reports. You'll learn how to optimize Excel efficiency by managing duplicates, selecting appropriate shortcuts, and performing lookups. Practical hands-on Excel learning exercises taught by highly engaging expert in the field You'll also deepen your skills and tackle real-world Excel workbooks that address the following: Benefits of using lookup functions over direct cell referencing A comprehensive exploration of the popular VLOOKUP function Techniques for removing duplicates to create a distinct set of report labels *Session 4 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 5: Error Trapping and Improving Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-5--error-trapping-and-improving-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*

Each year, more states legalize cannabis (i.e., marijuana) for medical or recreational purposes. As legalization grows, so too does the cannabis industry. While some financial professionals have stayed away from this growing sector of the economy, others have embraced the opportunities the cannabis industry has to offer. The legalization of cannabis brings with it a complex regulatory landscape, which includes strict compliance with federal and state regulations. However, the complexity of this emerging market provides opportunities for accountants and other financial professionals. Behind the cannabis dispensaries are scores of related business sectors including food production, retail, farming, and chemical production, as well as facilities, design, and construction. Simply stated, the commercialization of marijuana offers financial professionals an opportunity to participate in an industry expected to reach $73 billion worldwide within six years.

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.

Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.

Leaders in CPA firms often spend time on work that sits below their highest and best use: meetings they do not need to attend, work delegated upward by their teams, client scope creep, administrative tasks, and avoided accountability conversations. Survey data cited in the course indicates that most leaders say yes to commitments they know they should decline, at a cost of hundreds of hours per year. This course introduces the distinction between hard work (time-bound), smart work (skills-based and intellectual), and uncomfortable work (emotional), and shows why avoided "Uncomfortable Work" is the common root of these low-value commitments. Participants complete a structured 32-item self-inventory across five categories: meetings and events, unrealistic expectations, strategies and opportunities, tasks and projects, and suboptimal performance. They then quantify the estimated annual hours lost to the commitments they identified, select one commitment to decline over the next month, and name the higher-value leadership activity (such as delegation, business development, project oversight, or performance management) that the reclaimed time will support. With the self-awareness and clarity gained through this program, you will know exactly which gaps need closing before work ramps back up. 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 data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. 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 examines how agentic AI is revolutionizing tax compliance, planning, and advisory services. Participants will explore real-world deployments by leading firms such as EY, which has developed agents that handle millions of global tax transactions. The course also delves into cross-border compliance issues, transfer pricing automation, and emerging advisory models powered by agent-led simulations. Risks related to bias, unauthorized practice, and data privacy will be addressed, with guidance on aligning autonomous operations with professional and regulatory standards. CPAs must understand these advancements to ensure tax compliance, manage client expectations, and mitigate professional liability risks when providing agent-assisted advisory services.

This session provides a comprehensive analysis of meals and entertainment regulations under IRC 274 as amended by the Tax Cuts and Jobs Act. Participants will learn how to identify deductible vs. nondeductible expenditures, interpret the regulatory definitions surrounding "entertainment," "business associate," and reimbursement arrangements, and apply the numerous exceptions under IRC 274(e), including compensation, recreational activities, public availability, and goods or services sold to customers. Using examples from the final regulations, we will dissect key distinctions such as separately stated food and beverage costs, employer-provided meals, and the treatment of per diem reimbursements. This course equips practitioners with the technical precision required for compliance, documentation, and audit defense. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.