CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Online
2.00 Credits
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.
Surgent's Understanding Partnership Taxation: Debt Allocations
-
Online
2.00 Credits
How debt is allocated to the partners in a partnership is important. It dictates how much money may be taken tax-free as a distribution, the losses that flow down to the partners, and the gain or loss on the sale of a partnership interest. However, the allocation of debt can differ depending on the type of debt it is and the type of partner we are talking about. Furthermore, 704(c) can complicate things. And what in the world is a constructive liquidation scenario? In this course, we will tackle the concept of debt allocations - how you do it, what it means, and why you do it.
Viewing A&A Through the Eyes of a Tax Practitioner
-
Online
2.00 Credits
This session offers insight for tax practitioners beyond merely checking a box to satisfy accounting and auditing requirements for license renewal. We devote significant attention to extracting utility from financial statements to support decision needs of both external financial statement users and internal stakeholders. We explore best practices for cross-functional support within firms that perform tax, accounting solutions, financial statement, and consulting services. We also highlight similarities and differences between U.S. GAAP and tax-basis accounting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Essential Depreciation and Expensing Update
-
Online
4.00 Credits
This course offers a comprehensive analysis of the evolving rules surrounding depreciation, amortization, and property transactions, incorporating the latest inflation adjustments and technical corrections. It offers practical guidance through real-world examples and case studies to clarify complex rules and help professionals stay compliant and informed amid ongoing change.
The One Big Beautiful Bill: 2025 tax legislation
-
Online
4.00 Credits
The President signed on July 4, 2025, one of most consequential tax legislation in recent years. The well-informed tax practitioner will want to stay abreast of these developments! This course will start with a short background of this legislation as it made its way through Congress and to the President's desk. We will then review the final provisions that was approved by the Senate and passed by the House. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
LLC's & S Corporations: a Comparative Analysis
-
Online
8.00 Credits
This course focuses on the most common aspects and tax implications of Limited Liability Companies and S Corporations. It will further compare forms of entities, along with corporate formalities compliance issues of each entity type. Electing Subchapter S status as well as reviewing the mechanics of electing Subchapter S status will be discussed. Highlights of entity specific tax forms will be discussed, as well as accountable plans, taxable fringe benefits, officer reasonable compensation, estate planning, business continuation planning and audit strategies. Schedules K-1, K-2, K-3, and effectively connected income will be reviewed in this course as well. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Schedule K-1: What is it & What do I do with it?
-
Online
2.00 Credits
This seminar offers a practical and in-depth exploration of IRS Schedule K-1, a critical reporting document issued to taxpayers with interests in pass-through entities such as Partnerships, S Corporations, and Estates or Trusts. Participants will gain a clear understanding of how to interpret and accurately report Schedule K-1 data on Form 1040, with emphasis on common income, deduction, and credit items. The course also demystifies the Qualified Business Income (QBI) Deduction, including eligibility criteria, reporting mechanics, and integration with K-1 data. Key compliance topics-such as basis and loss limitations, material participation rules, and passive activity considerations-will be addressed through practical examples. In addition, attendees will be briefed on recent developments affecting Schedules K-2 and K-3, ensuring they are equipped to navigate evolving international reporting requirements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Retaining Top Talent: Strategies for CPA Firms
-
Online
1.00 Credits
In today's challenging talent market, accounting firms face unprecedented pressure to retain their best performers. This course provides actionable, research-backed strategies to help firms keep their top talent from leaving. Based on comprehensive surveys of both current accounting professionals and those who have recently left the profession, participants will learn the real reasons employees stay or go-and what firms can do about it. The course goes beyond simple solutions like "pay more, expect less" to explore comprehensive retention strategies including whole-person compensation, work-life balance improvements, career development pathways, and necessary business model transformations. Participants will discover why 73% of surveyed professionals want to stay with their current firm, yet many still leave-and how to bridge that gap. Key topics include understanding the true cost of turnover versus retention, implementing flexible work arrangements that actually work, creating meaningful career paths for non-partner track professionals, and transforming firm operations to support both profitability and employee satisfaction. Special attention is given to retaining diverse talent and adapting to the expectations of younger professionals who will comprise 27% of the workforce by 2025. Whether you're a firm leader, HR professional, or manager responsible for team retention, this course provides the insights and tools needed to build a sustainable talent strategy in an evolving profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Monthly Federal Tax Updates - November 2026
-
Online
2.00 Credits
Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Leverage PowerBI.com to Create Data Analysis for Others
-
Online
2.00 Credits
Unlock the full potential of data analytics with our specialized course, "Leverage PowerBI.com to Create Data Analysis for Others". This two-hour, intensive training is specifically designed to empower professionals in harnessing the powerful features of Microsoft PowerBI.com. Whether you're a data analyst, business intelligence professional, or someone keen on mastering data visualization and report creation, this course is your gateway to becoming a proficient Power BI user. Dive into the dynamic world of data analytics and learn to transform raw data into visually compelling stories that drive decision-making. Our expertly crafted program offers a deep dive into the essentials of PowerBI.com, starting with a comprehensive tour of its interface and core concepts. You'll gain experience in connecting to diverse data sources, creating stunning visualizations, and building interactive dashboards that communicate insights effectively. The course also covers the innovative Q&A feature of PowerBI.com, allowing you to explore data with natural language queries. By mastering the art of sharing datasets, reports, and dashboards, and creating comprehensive apps, you'll be equipped to deliver top-tier data analysis solutions to colleagues and clients alike. Through this course, attendees will gain a deep understanding of how to leverage the PowerBI.com platform to disseminate datasets, reports, and dashboards, catering to the specific needs of their audience. Our course is tailored for those who aspire to lead in the data-driven landscape, offering not just theoretical knowledge but real-world applications. Upon completion, participants will not only have a thorough understanding of PowerBI.com but also the confidence to apply this tool in creating impactful data analysis for diverse audiences. Join us to elevate your professional skillset, make data-driven decisions with ease, and add a valuable credential to your portfolio. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Noble Leadership: An Ethical Approach
-
Online
2.00 Credits
Research tells us that leaders, supervisors and managers have more impact on an employee than does a therapist and/or life partner. Being a leader is a huge opportunity and privilege and requires introspection and personal growth. This webinar is infused with values of fairness, compassion, respect and more and will be of most value to individuals who believe that everyone, regardless of circumstance, deserve "certain general conditions that are ...equally to everyone's advantage" (John Rawls). The Noble leader believes in people. The Noble leader is curious and humble and invites challenge and feedback into his/her/ world. The Noble leader is a true believer in seeing the good in others, helping them to be their best which in turn helps the Leader grow as well. The Noble leader does not shy away from confronting bad behavior/performance in a respectful and clear way while believing in the inherent dignity of each individual This workshop based on ethical principles offers a glimpse into what it takes to become a Noble Leader and how one can journey through for increased self awareness and skill development. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2026/27 Annual Update for Governments and Not-for-Profits
-
Online
4.00 Credits
This comprehensive annual update brings together key accounting and auditing developments affecting governmental and not-for-profit organizations. The course integrates recent standard-setting activity, emerging global frameworks, and major compliance updates to provide a well-rounded view of changes impacting financial reporting and audit requirements. Participants will begin with an overview of recent accounting developments affecting not-for-profit organizations, including Accounting Standards Updates issued by the Financial Accounting Standards Board and an introduction to the International Non-Profit Accounting Standard (INPAS). Emphasis is placed on understanding the purpose of INPAS and how it compares conceptually to U.S. GAAP for not-for-profit entities. The course then shifts to governmental accounting developments, covering recent pronouncements issued by the Governmental Accounting Standards Board, including GASB Statements No. 103, 104, and 105, along with a high-level overview of active GASB exposure drafts and projects. Participants will gain insight into how these changes affect financial reporting, disclosures, and communication with governing bodies. Finally, the course addresses recent developments affecting Single Audits, including the 2024 Uniform Guidance overhaul, updates to Appendix B of the AICPA GAS/Single Audit Guide, and recent guidance issued through the Office of Management and Budget (OMB). Reporting changes related to SAM.gov are also discussed. Designed for auditors, preparers, and financial leaders working with governmental and not-for-profit entities, this course helps participants understand how recent accounting and auditing changes intersect-and what to monitor as requirements continue to evolve. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Accounting & Attestation for ESG
-
Online
2.00 Credits
Environmental, Social, and Governance (ESG) reporting has become an increasingly important area of focus for standard setters, regulators, and stakeholders. This course provides an overview of how ESG considerations intersect with accounting and attestation services, with attention to developments affecting both preparers and assurance providers. Participants will review current ESG-related initiatives and projects underway at the Financial Accounting Standards Board, Governmental Accounting Standards Board, and the AICPA. The course also explores the types of services CPAs may provide in connection with ESG reporting, including advisory and attestation engagements, and discusses how these engagements differ in scope and responsibility. Designed for CPAs seeking to understand the evolving ESG landscape, this course helps participants recognize where ESG fits within existing professional standards and how CPAs can support organizations seeking credibility and assurance over ESG information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2026/27 Not-for-Profit GAAP Update
-
Online
1.00 Credits
Stay current on the latest accounting developments affecting not-for-profit organizations with this timely GAAP update. This course reviews recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline. The course also introduces the International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025. Participants will gain perspective on the purpose and structure of INPAS and how it compares conceptually to U.S. GAAP requirements for NFPs. This course is designed to help practitioners, financial leaders, and auditors of not-for-profit organizations understand both current GAAP requirements and emerging global developments shaping the future of nonprofit financial reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Excel Tables and Conditional Summing
-
Online
2.00 Credits
In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.
What's Changing in A&A for Governmental Entities (2026/27)
-
Online
4.00 Credits
This comprehensive course provides a timely update on key accounting and auditing developments affecting governmental entities, bringing together recent standard-setting, auditing, and compliance changes into a single, cohesive learning experience. Participants will begin with an update on major pronouncements issued by the Governmental Accounting Standards Board, including GASB Statements No. 103, 104, and 105, along with a high-level overview of active GASB exposure drafts and ongoing projects. Emphasis is placed on understanding how these changes affect governmental financial reporting, disclosures, and communication with stakeholders. The course then shifts to auditing developments, covering significant updates to the Yellow Book issued by the U.S. Government Accountability Office, including changes related to quality management, effective dates, and recent updates to the Green Book. Participants will also gain insight into the GAO's implementation delay and its implications for audit planning. Finally, the course addresses recent changes affecting Single Audits, including the 2024 Uniform Guidance overhaul, updates to Appendix B of the AICPA GAS/Single Audit Guide, recent Office of Management and Budget (OMB) memoranda, and reporting changes related to SAM.gov. Designed for auditors, preparers, and financial leaders working with governmental entities, this course helps participants understand how recent accounting and auditing changes intersect-and what to watch for as expectations continue to evolve. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Best Practices: Conducting Meaningful Walkthroughs
-
Online
2.00 Credits
This course will serve as an introduction to conducting effective walkthroughs to gain an understanding of the client's transaction processes as well as identifying internal controls within each process. This course will review the procedures, questions to ask, and documentation requirements of walkthroughs. It will also include real-world examples of the red flags that may arise while executing a walkthrough. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Managerial Accounting: Your Prescription for Better Decision
-
Online
4.00 Credits
This session revisits useful, but potentially underutilized, managerial accounting techniques. You will appreciate a fresh look at concepts you may not have considered since your college days. We will illustrate practical ways you can immediately implement managerial accounting analysis in your professional endeavors. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Corporate Finance Technology Selection: Practical Frameworks
-
Online
1.00 Credits
Finance technology decisions (ERP, FP&A, AP/expense automation, close/consolidation, bank integrations, and AI-enabled tools) can dramatically improve close speed, forecasting, and control execution-but vendor demos and "AI" marketing often hide integration complexity, data readiness gaps, governance risk, and long-term total cost. This course provides a practical, vendor-neutral approach for CPAs and finance leaders to evaluate and implement corporate finance technology with an audit-ready mindset. Participants learn how to cut through AI claims using an AI capability framework, apply a weighted vendor evaluation scorecard focused on controls and assurance, build a five-year total cost model that captures hidden and ongoing costs, and follow an implementation roadmap with checkpoints and red flags to reduce failure risk and improve ROI realization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Written Information Security Plans
-
Online
1.00 Credits
Thsi course provides a comprehensive overview of Written Information Security Plans (WISP), focusing on their purpose, requirements, and implentation. All PTIN holders must certify they have a WISP prior to renewal, along with certifying the training of employees, staff and contractors as necessary. Participants will explore the history and legal foundation of WISP under the Gramm-Leach-Bliley Act, and how compliances is enforsed through IRS Circular 230, AICPA Statments of Standards, The American Bar Associations and the Federal Trade Commission (FTC). This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.