CPE Catalog & Events
Complete Guide to Analyze Data with Excel PivotTables
-
Online
4.00 Credits
Member Price: $149
Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. 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.
Federal Tax Update - C & S Corporations, Partnerships & LLCs (Forms 1120, 1120S & 1065)
-
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 one-day update course focusing on business income tax issues with an emphasis of newly enacted income tax legislation. This comprehensive class will not only review the current Federal business income tax laws but will also update tax return preparers of new tax forms, changes to existing tax forms, as well as tax planning opportunities and pitfalls. This is a “must-attend” course for all tax practitioners who want to be up to speed quickly and have a successful Federal business income tax filing season. *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: Update
S Corporations: Comprehensive walk through of Form 1120S
-
Online
8.00 Credits
Member Price: $239
This course is designed for financial professionals looking to understand Form 1120S. It covers the essential aspects of S corporation taxation, including the preparation of Form 1120S, determining taxable income, and accurately reporting and allocating income, deductions, and credits. Electing Subchapter S status as well as reviewing the mechanics of electing Subchapter S status will be discussed. It will further compare the S Corporation to other forms of entities, along with compliance with corporate formalities. Highlights of Form 1120S will be discussed, including build-in capital gains, accountable plans, taxable fringe benefits, officer reasonable compensation 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.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.
Surgent's Social Security and Medicare: Planning for You and Your Clients
-
Online
8.00 Credits
Member Price: $279
Social Security seems poised for changes in benefits and eligibility age. The leading edge of the baby boomer generation has already reached retirement age. Financial and tax planners can expect increased demand for strategies that dovetail Social Security with other retirement and estate planning objectives. This course provides tax and financial planning professionals with both the background information on the Social Security system and the strategies clients will need in dealing with Social Security, and the myriad other related retirement planning issues.Delivery Method: Individual webcastCPE Credit: 8Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
The Best Federal Tax Update Course by Surgent
-
Online
8.00 Credits
Member Price: $299
In this continually revised course, tax advisors will be fully updated on the most recent enacted legislation and IRS guidance, as well as major trends on the horizon with a view toward planning considerations. This update course is designed for all practitioners, both those working in public accounting as well as those in private industry, who need the latest information on tax changes. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BITU.Delivery Method: Individual webcastCPE Credit: 8Program Level: UpdateThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Taxation of the Cannabis Industry
-
Online
2.00 Credits
Member Price: $89
This course offers a comprehensive exploration of the cannabis industry, delving into essential topics such as cannabis regulations, business models, financial management, and ethical considerations. A key focus is on distinguishing between Marijuana and Industrial Hemp, including their respective tax treatments. Participants will gain a thorough understanding of the unique challenges and opportunities within the cannabis sector, covering federal and state tax implications, licensing requirements, and market trends. 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.
How Fraud Can Affect Smaller Organizations
-
Online
4.00 Credits
Member Price: $149
Many small to medium sized companies do not properly address the risk that arises related to fraud because these organizations do not have the resources needed to mitigate this risk or because owners or those in top level management underestimate the scope of the issue. All organizations, regardless of size, must be aware of the risks associated with intentional fraudulent acts and know that a significant and effective fraud scheme could even create going concern issues for some entities. In this session, we delve into the reasons that fraud takes place. The material discusses the types of defalcations that are often executed against smaller entities and then explores measures that organizations can implement to help stop fraud activities and add security. 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.
The Controllership Series: The Controller's Role in Artificial Intelligence
-
Online
1.40 Credits
Member Price: $39
Here's a more detailed look at the controller's role in AI: 1. Data Integrity and Quality: • Controllers are responsible for ensuring the quality and integrity of data used to train and inform AI models. • They work to establish data governance frameworks, implement data quality initiatives, and ensure data lineage (tracking data from source to downstream systems). 2. Risk Management: • Controllers assess potential risks associated with AI implementation, including inaccuracies, vulnerabilities, and ethical considerations. • They help define and implement risk management frameworks for AI, ensuring that AI systems are used responsibly and ethically. 3. Compliance: • Controllers stay informed about relevant regulations and ensure AI systems are compliant with those regulations. • They monitor AI systems to ensure they are not violating any laws or policies. 4. Transparency and Auditability: • Controllers work to ensure that AI decisions are transparent and auditable. • They establish processes to review AI decisions and identify potential biases or errors. 5. Collaboration and Training: • Controllers work with IT and business teams to understand AI's capabilities and limitations. • They provide training to teams on how to use and manage AI tools effectively. 6. Value Creation: • Controllers can leverage AI to identify areas for automation, improve efficiency, and gain real-time insights into financial operations. • They can use AI to make more informed decisions and create more strategic recommendations for action. 7. Emerging Role: • The role of the controller is evolving with the rise of AI, with controllers becoming more hands-on throughout the implementation process. • They are increasingly seen as catalysts for AI-enabled transformation, helping to identify potential use cases and build confidence in the technology This course will explore many of these topics. Delivery Method: Individual webcast CPE Credit: 1.4Program Level: Basic
Understanding the 4 W's in Budgeting: Who, What, When, and Which?
-
Online
2.00 Credits
Member Price: $89
This session introduces a structured approach to government budgeting using the four W’s: Who, What, When, and Which. Participants will explore WHO should be involved in the budgeting process, including internal teams and external stakeholders, while learning effective communication strategies to foster collaboration. The session examines WHAT the budgeting process entails, covering essential phases, components, legal requirements, and common challenges. Attendees will also learn WHEN to engage the public through strategic planning, workshops, and outreach initiatives. Finally, the session highlights WHICH departments play key roles, from financial planning to managing capital projects. By the end of this session, participants will have a comprehensive understanding of government budgeting and how to align financial planning with community priorities. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
ChatGPT and Advanced Financial Analysis for Accountants
-
Online
2.00 Credits
Member Price: $89
This course provides a concise overview of how to utilize ChatGPT for advanced financial analysis in accounting. The session reveals how to combine sophisticated evaluation and interpretation of financial data with the cutting-edge AI capabilities of ChatGPT. Aimed at enhancing the understanding of an entity's performance, predicting future financial health, and aiding in informed business decision-making, this course goes beyond basic financial statement analysis to include a wide array of techniques and tools. 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.
Surgent's Comparing and Contrasting Retirement Plans for Small- and Medium-Sized Businesses
-
Online
2.00 Credits
Member Price: $99
Clients often ask accounting and finance professionals whether they have the "best" pension plan and whether they are using it to its maximum advantage. This program explains how various pension plans work and analyzes why a small or medium-sized business owner would choose one plan over another.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.
Surgent's Excel Budgeting Ideas
-
Online
2.00 Credits
Member Price: $99
Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.Delivery Method: Individual webcastCPE Credit: 2Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's Review and Analysis of Crucial OBBBA Changes
-
Online
2.00 Credits
Member Price: $119
Accounting and finance practitioners are still grappling with the many changes OBBBA has made to the tax laws, many of which will impact tax filings. This program is an introduction to and review of some of these critical changes and their impact on taxpayers. Accounting and finance practitioners will gain a better understanding of this very complex set of new tax rules. Practitioners will grasp what is new and what is a continuance of prior rules to develop deeper insights into the many changes that the OBBBA made to the law. If you still feel you need to learn more about how OBBBA works, this program is for you. We have assembled a two-hour review and analysis of what we consider the most important changes from OBBBA that impact client transactions. To the extent that Treasury has provided guidance relating to these new OBBBA changes, we will discuss that guidance. Where guidance is lacking, we will point out areas that require future attention from Treasury.Delivery Method: Individual webcastCPE Credit: 2Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Surgent's The AI-augmented Professional: Practical Tools, Real Risks, and Immediate Use Cases
-
Online
2.00 Credits
Member Price: $99
Artificial Intelligence is no longer a future concept; it is a current necessity. This session provides a practical roadmap for practitioners to leverage AI safely and effectively. We move from a survey of available tools (from free apps to specialized software) to a deep dive into the ethical guardrails required to protect client data and maintain professional standards. Participants will leave with a playbook of real-world use cases that can be implemented immediately.Delivery Method: Individual webcastCPE Credit: 2Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Data Analytics & Journal Entry Testing for Auditors
-
Online
3.00 Credits
Member Price: $109
This course provides a practical understanding of IT controls and SOC reporting within financial audits. Participants will learn how to interpret SOC reports, evaluate control effectiveness, and determine reliance strategies. Real-world examples will demonstrate how IT controls tie directly to relevant financial statement areas and alignment with Complementary User Entity Controls (CUECs). Delivery Method: Individual webcast CPE Credit: 3Program Level: Intermediate
IT Controls & SOC Reporting in Financial Audits
-
Online
3.00 Credits
Member Price: $109
This course provides a practical understanding of IT controls and SOC reporting within financial audits. Participants will learn how to interpret SOC reports, evaluate control effectiveness, and determine reliance strategies. Real-world examples will demonstrate how IT controls tie directly to relevant financial statement areas and alignment with Complementary User Entity Controls (CUECs). Delivery Method: Individual webcast CPE Credit: 3Program Level: Intermediate
CFO Solutions to IRS Problems
-
Online
4.00 Credits
Member Price: $149
Many CPAs are becoming full-time or fractional CFOs for small businesses. In that position, they are the resident expert in finances, cash flow planning, and budgeting. But what about dealing with the IRS? The IRS has broad powers to administer the assessment and collection of taxes. From removing penalties to criminal prosecutions, this presentation focuses on how CFOs can prevent problems with the IRS and how to develop winning strategies if the IRS knocks on the door. 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.
The CPA as Strategic Advisor: Leading the Client Advisory Team
-
Online
4.00 Credits
Member Price: $149
This course provides tax and accounting professionals with a framework for serving as the lead advisor in a multidisciplinary planning environment. Participants will explore how to coordinate with attorneys, financial planners, insurance professionals, and bankers to deliver integrated planning strategies. The course emphasizes identifying opportunities across estate, financial, retirement, and tax planning while managing collaboration and delivering cohesive client solutions. Delivery Method: Individual webcast CPE Credit: 4Program Level: Overview
A&A Update for Nonprofits and Single Audit - 2026
-
Online
8.00 Credits
Member Price: $239
This course provides a high-level overview of the most important accounting, financial reporting, compliance and audit issues facing nonprofit entities and their accountants. The focus is on explaining the basis behind major issues and trends in executive summary (yet practical) form, enabling professionals to understand the most important aspects of relevant standards, and the basis for any potential changes on the horizon. 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.
ACPEN Signature 2026: Partnership and LLCs Update
-
Online
8.00 Credits
Member Price: $250
LLCs and partnerships continue to present some of the greatest challenges for return preparers and advisors. This program addresses the latest developments affecting these entities, including new IRS audit initiatives, updates on self-employment tax for LLCs and partnerships, disregarded entity rules and transactions, and common allocation issues. Participants will also review how to properly identify various types of partnership debt for basis purposes, understand the use of the §754 election in the sale of interests and at death, and explore reporting requirements for LLC and partnership interests on gift and estate tax returns, including valuation considerations for closely held businesses and minority interests. The session also examines the impact of the recent Sirius Solutions decision. Join us for the course! And as with all ACPEN courses, your questions to the panelists are encouraged. 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: Update