CPE Catalog & Events
ACPEN: Mastering Charitable Remainder Trusts and Form 5227 Compliance
-
Online
2.00 Credits
Introduction to Charitable Remainder Trusts (CRTs) Types of CRTs and their Benefits Formation and Funding of CRTs Identifying Suitable Candidates for CRTs Understanding Form 5227: An Overview Line-by-Line Breakdown of Form 5227 Reporting Trust Assets and Income Distributions and Charitable Beneficiaries Compliance Updates and Recent Changes to Form 5227 Best Practices for Accurate Completion and Filing
AI & Accounting in Retail
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:AI-powered personalization and its impact on revenue recognitionDynamic pricing models and tax compliance risksAI in demand forecasting, inventory valuation, and COGS calculationsIntegration challenges with ERP and POS systemsGovernance, ethics, and auditability of AI decisionsData quality, audit trails, and regulatory documentationAI-assisted fraud detection, financial controls, and oversight
Smart Formula Selection in Excel: What to Use When
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Introduction to Strategic Formula Use:Why choosing the right formula matters: clarity, performance, and maintenanceCommon traps: overusing IF, defaulting to familiar tools, ignoring modern functionsHow Excel offers multiple ways to solve the same problem and how to pick wiselyConditional Logic and Branching Tools:IFS vs SWITCH vs nested IF: comparing readability and structureWhen to simplify logic and how to avoid nested nightmaresSummarizing Data:SUMIFS vs SUMPRODUCT: multiple conditions, weighted sums, totalsFiltering and Output Control:FILTER vs IF + INDEX: dynamic data extraction with vs without Excel 365Trade-offs in backward compatibility and ease of useCustom Output and Decision Trees:CHOOSE vs SWITCH vs LOOKUP: logic trees and category mappingEmbedded Variables and Reusability:LET vs named ranges: clarity and efficiency for long formulasUsing LAMBDA with LET to create custom functionsSimplifying and documenting complex calculationsBest Practices for Formula Selection:Criteria for deciding: readability, flexibility, future maintenanceTips for avoiding overengineering and formula bloat
Numbers to Narrative: Storytelling in Business Communication
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Role of narrative in professional communicationSituation–complication–resolution frameworkNarrative arcs in business contextsIntegrating data within a structured storyDefining tension and resolution logicallyMaintaining accuracy while improving clarityApplication of storytelling framework to a workplace scenario
ACPEN: Liquidity & Uncertainty Disclosures for Nonprofits
-
Online
2.00 Credits
Required disclosure related to liquidity and other significant uncertainties for fair presentation of financial statements Evaluating the need for going concern and other uncertainty disclosures in the current environment
ACPEN: Viewing A&A Through the Eyes of a Tax Practitioner
-
Online
2.00 Credits
The role of financial reporting for a myriad of users Fundamentals concepts Special Purpose Frameworks Financial statement analysis Cross-functional collaboration
Streamlined Excel Reporting Series Session 4: External Data and PivotCharts
-
Virtual
2.00 Credits
GETPIVOTDATA Text Files and Power Query Data Preparation PivotCharts
Business Tax Update: OBBA and Recent Developments
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Recent legislation impacting business taxpayersThe One Big Beautiful Bill ActExtenders legislation updateMeals and entertainment expense reportingPartnership and S corporation updateIncome and deductions
ACPEN: Tricks and Treats to Avoid Litigation
-
Online
1.00 Credits
Key concepts of effective employee relations Balancing employee and employer rights Handling employee complaints Addressing personality & attitude problems
Workforce Transformation and Talent Management in 2025
-
Virtual
1.00 Credits
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: Understanding why the traditional pyramid structure is failing firms The inverted pentagon framework and its talent retention advantages Impact of technology and AI on entry-level accounting roles The 6 Ps of Business Model Transformation implementation Accelerating specialized skills acquisition in your workforce Effective knowledge transfer through mentorship and job rotation Technology-driven training and development strategies Best practices from other industries for workforce transformation Building and retaining specialized middle layers of expertise Strategic pricing models to support the pentagon structure
ACPEN: Mergers and Acquisitions: Complete Guide to Relevant Issues
-
Online
2.00 Credits
Taxable asset acquisitions vs. non-taxable stock/equity acquisitions What happens in an asset acquisition What happens in a stock or equity acquisition 338 and 336 elections Basics of 382 Basics of 280G Earnouts and contingent payments Assumed liabilities Acquired reserves Acquired deferred revenue Treatment of transaction costs Basics of mixed entity transactions, examples such as: C-Corp buys an interest in a partnership C-Corp buys an S-Corp C-Corp buys an interest in an LLC (lots of possibilities here) S-Corp buys a partnership S-Corp buys a C-Corp S-Corp buys an interest in an LLC Partnership acquisitions of various entity types Very basic overview of tax-free re-organizations High level overview of entity formations High level overview of entity liquidations or termination
Microsoft 365 for CPAs: Unlocking Hidden Productivity Tools
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Round robin review of lesser known M365 appsReduce / eliminate internal email communications with Teams and SharePointCollaborate on spreadsheet and documents with your colleagues in real timeGet control of your appointment schedule with the Bookings appTap the full potential of OneNote as your primary repository for notes, correspondence and moreReplace email attachments with secure file sharing linksDocument business processes with the Stream appLeverage the power of AI in M365 with Copilot
Surgent's Exploring Business Valuation Fundamentals
-
Virtual
0.00 Credits
What does value mean? Technical vs. fundamental analysis Intrinsic value Other discounted cash flow models Assumptions in the Gordon Growth Model Valuations using free cash flows Residual income model Enterprise value Value in mergers and acquisitions Small business valuations and discounts Advanced valuation models
Comprehensive Accounting and Financial Reporting Update
-
Virtual
4.00 Credits
The major topics covered in this class include:CECL for nonfinancial institutions.Accounting for Paycheck Protection Program loans.Accounting for web-hosting services.Revenue recognition.Leases.FASB projects in progress.
ACPEN: Beyond the Basics of SSARS and Nonattest Services: Are You Certain You Are in Compliance?
-
Online
8.00 Credits
Preventing malpractice claims related to nonattest accounting services Identifying and safeguarding independence threats when issuing attest reports Establishing an understanding with the client regarding non-audit services Defining the varying levels of responsibility for accountants performing non-audit services Performing compilations and reviews effectively and efficiently, including nature and extent of documentation considerations Practice performing analytical review procedures appropriately, including developing proper advance expectations for review engagements Properly considering going concern, subsequent events, and other disclosure matters Common issues related to peer reviews, including recurring reporting problems Applying financial analysis best practices to help your clients better interpret their financial results
Surgent's Real Estate Taxation: Critical Considerations
-
Virtual
4.00 Credits
The impact of recent tax legislation on the real estate industry Depreciation and recapture Determining the basis when acquiring real estate Passive activity losses Calculation of gain or loss on sale of real estate Rental operations Installment sales
Internal Controls Over Compliance vs Compliance
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Testing internal ControlsAlign internal controls with specific compliance requirementsThe misidentification of controls and the confusion between compliance and control processes
Surgent’s Weekly Expert Hour
-
Virtual
1.00 Credits
Each week’s topics will change based on the most critical issues affecting financial professionals
ACPEN: Tax Procedure
-
Online
2.00 Credits
Filing a tax return IRS audit RS Appeals Collections and litigation at courts of original jurisdiction
Surgent's Leveraging AI for Data Analytics in Accounting
-
Virtual
0.00 Credits
Transforming data analytics with AI Understanding the impact of AI on data analytics processes How AI enhances data accuracy, efficiency, and decision-making AI tools and techniques for data analysis Overview of AI-powered data analytics tools Techniques for improving data analysis accuracy and efficiency with AI Integrating AI into existing data analytics workflows Case studies on AI implementations for data analytics Success stories of AI-driven data analytics in accounting Challenges and lessons learned from AI integration Measuring the ROI of AI in data analytics Developing AI-powered data analytics skills Hands-on lab sessions using AI tools (e.g., ChatGPT, Excel) Practical exercises in filtering, sorting, summarizing, and visualizing data Applying AI insights to optimize data-driven decision making in accounting
