CPE Catalog & Events
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Online
2.00 Credits
Member Price: $99
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. Delivery Method: Individual webcastCPE Credit: 2Program Level: IntermediateThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Tactical Finance Leadership – Building the Finance Team of Tomorrow
-
Online
2.00 Credits
Member Price: $89
The finance function is changing rapidly, driven by technology, demographics, and evolving business expectations. This session focuses on the tactical leadership skills CFOs and CPAs need to build and lead high-performing finance teams in the years ahead. Participants will explore how roles, skills, and expectations are shifting, and how leaders can prepare their teams for increased automation, real-time reporting, and greater strategic involvement. The session blends practical leadership guidance with forward-looking insights. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Measuring Audit Risks
-
Online
3.00 Credits
Member Price: $109
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. Delivery Method: Individual webcast CPE Credit: 3Program Level: Intermediate
OBBA 2025 Unpacked: Impact for Taxpayers and Business Owners
-
Online
4.00 Credits
Member Price: $149
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 Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Everything You Need to Know About the Pass-Through Entity Rules: IRC §199A The Code and Regulations
-
Online
4.00 Credits
Member Price: $149
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. Delivery Method: Individual webcast CPE Credit: 4Program Level: Update
Proper Financial Accounting for S Corporations
-
Online
4.00 Credits
Member Price: $149
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. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Fundamentals of Form 1040 -- Business
-
Online
4.00 Credits
Member Price: $149
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.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
S Corporation (Form 1120S) – Formation to Liquidation
-
Online
8.00 Credits
Member Price: $300
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 Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate
Estate and Financial Planning for the Older Client
-
Online
8.00 Credits
Member Price: $250
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 Delivery Method: Individual webcast CPE Credit: 8Program Level: Basic
Understanding and Creating an Internal Control System
-
Online
8.00 Credits
Member Price: $239
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.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Invest in Your Mental Health and Avoid Burnout
-
Online
2.00 Credits
Member Price: $89
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.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Supervised AI Agents as Public CPA Audit Team Members
-
Online
1.00 Credits
Member Price: $39
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. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
The Controllership Series - Managerial Accounting Basics and Costs
-
Online
1.20 Credits
Member Price: $39
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. Delivery Method: Individual webcast CPE Credit: 1.2Program Level: Basic
K2’s Microsoft Copilot, Including Agentic AI
-
Online
2.00 Credits
Member Price: $89
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. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Better Business Writing: Improve Your Speed and Quality
-
Online
2.00 Credits
Member Price: $89
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. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Comprehensive Roth IRA Strategies Analysis 26-27
-
Online
2.00 Credits
Member Price: $99
There is a lot of buzz and rules of thumb about Roth strategies, but very little discussion on what the fiduciary-level analysis methodology should be. This course will provide insights on creating and evaluating an analysis and recommendations with targeted vetting questions. Rules of thumb can sometimes be detrimental, causing families to pay much more in taxes over their lifetimes than necessary. A very significant portion of the population is prevented from executing a straight-forward Roth Contribution due to the income restrictions. What was once a risky way to thwart that rule has now become accepted, and many clients can benefit. These contributions should typically take precedence to saving to a brokerage/taxable account, but there are some steps that need to be addressed to prevent unwanted taxation. In addition, you'll learn about the mega-backdoor Roth. SECURE 2.0 includes many new rules, and some of them address Roth IRA/401k. We'll cover these and how they can help your clients.Delivery Method: Individual webcastCPE Credit: 2Program Level: Intermediate
Strategic CFO – Strategic Risk Management
-
Online
2.00 Credits
Member Price: $89
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. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
The Role of Internal Control in the Risk-Based Audit
-
Online
4.00 Credits
Member Price: $149
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. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
AI Lessons Learned for Accountants
-
Online
2.00 Credits
Member Price: $89
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.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Erase the Mark: Best Practices in Penalty Abatement
-
Online
2.00 Credits
Member Price: $89
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.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.