CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Online
2.00 Credits
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.
ACPEN: Measuring Audit Risks
-
Online
3.00 Credits
SAS 122, AU 240 requires that auditors determine if there is a significant risk that the financial statements are materially misstated due to either error of fraud. This presentation is an overview of how to determine if there is a significant risk of a material risk; whether it is due to error or fraud; and what to do in designing your audit program to address such risk. It’s important to know that without documentation as to such determination, an auditor has no basis for performing any specific audit procedure and thus would be performing a substandard audit. The standards require that each procedure be designed to decrease the possibility of a material misstatement. This program is an overview of how an auditor determines if there is a risk of a material misstatement; how document such determination; and how to address the risk if it is due to error vs fraud, because there is a big difference. Presented by: Dennis DycusType: Live Webcast Replay
ACPEN: OBBA 2025 Unpacked: Impact for Taxpayers and Business Owners
-
Online
4.00 Credits
Whether you asked for it (or not) and its here! The One Big Beautiful Bill Act was signed on July 4. This program will dig into the meat of the Act that will matter to your clients, including No Tax on Tips, No Tax on Overtime, increased Section 199A Deduction, 100% Section 168(k) Bonus and much, much more! *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com Presented by: Doug Van Der AaType: Live Webcast Replay
ACPEN: Everything You Need to Know About the Pass-Through Entity Rules: IRC §199A The Code and Regulations
-
Online
4.00 Credits
As part of the Tax Cuts and Jobs Act (TCJA), IRC § 199A was added. This Internal Revenue Code section allows certain pass-through entities the ability to has made it deduct up to 20% of their qualified business. Although practitioners have had over three years of “experience” utilizing IRC § 100A, many practitioners still do not feel comfortable with this part of the Internal Revenue Code. The purpose of this presentation is to provide the practitioner with an understanding of the rules of IRC § 199A as well as an understanding of the IRC § 199A regulations. **Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com. Presented by: Arthur Werner, Shelli HustonType: Live Webcast Replay
ACPEN: Proper Financial Accounting for S Corporations
-
Online
4.00 Credits
Proper financial accounting for S corporations involves adhering to specific accounting principles and tax regulations designed for this unique business structure. This course examines the proper financial accounting for S Corporations. Presented by: Doug Van Der AaType: Live Webcast Replay
Fundamentals of Form 1040 -- Business
-
Online
4.00 Credits
This course builds on the foundational knowledge from Part 1, Fundamentals of the 1040 - Core Concepts. It expands into business income taxation and additional reporting requirements. Participants will learn how to accurately report self-employment income, income from pass-through entities on Form 1040. This course covers Schedule C, Schedule E, and essential forms such as Form 7203 and Form 7217 to ensure accurate tax preparation for clients with business activities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: S Corporation (Form 1120S) – Formation to Liquidation
-
Online
8.00 Credits
With the increasing complexity and ever-changing nature of tax laws and issues, today’s accountant needs a S corporation course focusing on the birth, growth, maturity, and death of a closely held S corporation. This case driven course will deal with S corporation income tax laws from formation to liquidation. *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to terri.storer@acpen.com Presented by: J. Patrick GarverickType: Live Webcast Replay
ACPEN: Estate and Financial Planning for the Older Client
-
Online
8.00 Credits
Enter the complex world of elder planning with this comprehensive course tailored for financial professionals. Gain invaluable insights into estate and financial strategies designed specifically for older clients, equipping you with the knowledge and skills to address their unique needs and challenges. Throughout the course, participants will explore a wide range of topics, from understanding the complexities of Medicare and various life insurance types to navigating Social Security considerations and exploring Medicaid planning details. With a focus on practical application, attendees will learn to customize estate planning strategies, explore housing and care alternatives, and address gifting complexities relevant to older clients. By the end of the program, you'll develop expertise in executing specialized planning requirements for mature clients, ensuring you're well-prepared to provide informed counsel and support in this important aspect of financial practice. Join us and enhance your knowledge in estate and financial planning for the older client today. *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Handouts Tab and submit to kori.herrera@acpen.com Presented by: Arthur WernerType: Live Webcast Replay
Understanding and Creating an Internal Control System
-
Online
8.00 Credits
Successful organizations, both large and small, must understand the importance of effective internal controls and be able to develop a system of controls that will keep the entity on its intended course. Moreover, those that design policies and procedures benefit by knowing why control measures are necessary. This session sets forth internal control concepts and explains the importance of strong internal control policies. The material highlights some of the reasons that measures are needed and it also provides an overview of control creation methods. Finally, it discusses ways to successfully implement the developed policies and procedures. Participants that take this course will gain a well-rounded understanding of internal control procedures of all types. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Invest in Your Mental Health and Avoid Burnout
-
Online
2.00 Credits
For the ambitious female finance professional, working hard and going above and beyond are necessary for success. Sadly, taking time to care for themselves can be seen as counter-productive to meeting their career goals. Over ninety percent of women executives are feeling significantly higher levels of stress that they attribute to increased responsibilities and priorities outside the workplace compared to life before the pandemic. Burnout is a syndrome resulting from chronic workplace stress that causes exhaustion, negativity toward one's job and reduced professional efficacy. It has become so pervasive that it's now recognized as an occupational phenomenon by the World Health Organization. To reignite your enthusiasm at work, you don't necessarily need to find a new job or time for a spa day or bubble bath. You need concrete strategies to invest in your mental health without compromising your ability to rise to the next level in your career. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Supervised AI Agents as Public CPA Audit Team Members
-
Online
1.00 Credits
Should CPAs in public practice use Agentic AI? How? What should I not do? Join us to review how to use AI to assist in Assurance engagements, including testing internal controls. Agentic AI (‘Artificial Intelligence’) is rapidly being deployed by leading audit, compliance, and finance teams. While AI agents are not yet replacing all of today’s knowledge workers like auditors, accountants, and IT security professionals, the knowledge workers that effectively use Agentic AI may soon be replacing those knowledge workers who do not use these tools to drive high quality business growth and scale. AI is moving beyond automation to become a true teammate, especially in the governance, risk, and compliance processes. This session will show how supervised AI agents can work alongside accountants, auditors and IT security professionals to enhance efficiency, consistency, and assurance quality. Of critical importance is training and supervision so that the AI agents accomplish their testing to the intended quality standards. Attendees will leave with a practical view of how AI-powered testing can be applied to both internal and external assurance. Presented by: Joe OringelType: Live Webcast Replay
ACPEN: The Controllership Series - Managerial Accounting Basics and Costs
-
Online
1.20 Credits
Managerial accounting provides economic and financial information for managers and other internal users. Managerial and Financial Accounting have similarities and differences. Each field of accounting deals with the economic events of a business. Both managerial and financial accounting require that a company’s economic events be quantified and communicated to interested parties. This another course in our series on the controller’s role. The controller’s role encompasses many traditional functions. Within this segment of our controllership series, we discuss the area of managerial accounting and the basic concepts that surround this discipline as it primarily relates to cost accounting issues. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: K2’s Microsoft Copilot, Including Agentic AI
-
Online
2.00 Credits
Discover how artificial intelligence is transforming the accounting profession in this dynamic, intermediate-level CPE session. Microsoft Copilot for Accounting and Financial Professionals explores how AI-powered tools in Microsoft 365-like Excel, Outlook, and Teams-can streamline workflows, enhance data analysis, and improve client service. Learn how to harness Copilot to automate tasks, generate financial insights, and collaborate more effectively, while maintaining compliance and data integrity. Whether you're in public accounting, corporate finance, or advisory services, this course will equip you with practical strategies to integrate Copilot into your daily work and prepare for the future of intelligent accounting. Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: Better Business Writing: Improve Your Speed and Quality
-
Online
2.00 Credits
Technology has given us many new writing tools, but they may just allow an inexperienced novice to turn out poor communications more quickly. Whatever your expertise level, this webinar will help you take your writing skills to another level, saving your time and making it far more likely your reader will read and understand your message. Presented by: John DalyType: Live Webcast Replay
ACPEN: Strategic CFO – Strategic Risk Management
-
Online
2.00 Credits
Risk management is no longer a compliance exercise-it is a core strategic responsibility of today's CFO and CPA. This session demystifies Enterprise Risk Management (ERM) by walking through the COSO framework in clear, practical terms. Participants will learn how risk integrates with strategy and performance, how organizations identify and assess risk, and how leaders respond to uncertainty in a disciplined way. Using examples, polling, and case discussions, this session equips financial professionals to communicate risk effectively and help organizations protect and create value. Some funny video clips will be used to focus on the learning material. Presented by: Bob MimsType: Live Webcast Replay
Accountants and Malpractice: Can We Get Sued for This?
-
Online
2.00 Credits
This seminar reviews situations in which a CPA or accounting professional may be in danger of being sued. We cover common law causes of action, such as negligence, and the relevant standards and case law defining what constitutes reasonable practitioner behavior. This course is ideal for lawyers, CPAs, EAs, tax preparers, accountants and insurance personnel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: The Role of Internal Control in the Risk-Based Audit
-
Online
4.00 Credits
This program explores the role of client internal controls for balancing efficiency and effectiveness in a risk-based audit. We offer practical insights regarding an auditor's assessment of the risk of material misstatement when auditing financial statements of non-issuers, with particular emphasis on internal controls of small-to-medium clients. Presented by: Dr. Chris HarperType: Live Webcast Replay
AI Lessons Learned for Accountants
-
Online
2.00 Credits
This course provides accountants with the leading AI insights and strategies drawn from real-world experience, empirical studies, countless CPA case studies, and social media commentary. It goes beyond theory, offering practical lessons learned from the front lines of AI implementation in the business world and accounting industry. Participants will gain actionable knowledge on bridging the theory-application gap, navigating exponential technological changes, and creating secure, adaptive AI policies. By the end of the session, accountants will be equipped to leverage AI responsibly and innovatively in their roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Erase the Mark: Best Practices in Penalty Abatement
-
Online
2.00 Credits
If there is a potential error, the IRS will assess a tax and add a hefty penalty, without even knowing the facts. As a tax professional, you will be exposed to the IRS and their methods of penalizing taxpayers for the smallest of violations. This presentation will focus on the rules and regulations that create the penalty, and the reasons that exist that the IRS will consider to remove those penalties. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: The Controllership Series - Overhead, Direct and Indirect Costs and Allocation Methods
-
Online
1.00 Credits
Managing expenses is a key for business success, and overhead costs play a pivotal role in realizing favorable profit margins. Almost all companies have some form of overhead consisting of specific categories of indirect expenses. The better organizations are able to manage overhead costs, the more competitive they are in the marketplace. It is incumbent in the Controller’s role to effectively manage, monitor and perform ongoing assessment of overhead costs, allocations and rates. Overhead refers to the ongoing business expenses not directly attributed to creating a product or service. A company must pay overhead on an ongoing basis, regardless of how much or how little the company sells. It is important for budgeting purposes but also for determining how much a company must charge for its products or services to make a profit. Overhead can be fixed, variable, or a hybrid of both. There are different categories of overhead, such as administrative overhead, which includes costs related to managing a business. In short, overhead is any expense incurred to support the business while not being directly related to a specific product or service. Presented by: Lynn FountainType: Live Webcast Replay