CPE Catalog & Events
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
TBD
2.0 Credits
Member Price: $99
Using lookup functions as an alternative to direct cell references Understand the limitations of the VLOOKUP function Discover ways to move beyond these limitations
Surgent's Hiring and Firing of Employees - What You Can and Cannot Do
-
TBD
2.0 Credits
Member Price: $99
Employment at will — what this means in a practical sense Implied employment contracts What a prospective employer can ask about, and test for, during employment interviews Federal anti-discrimination rules applicable to hiring and firing How to discipline or fire an employee and not get sued FMLA/ADA/PWFA — Pregnant Worker’s Fairness Act Constructive discharge — what is it and how it affects your business?
Using AI to Instantly Transform Ideas into Revenue Streams
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this course include:AI-powered ideation and opportunity identification techniquesDigital asset creation workflows using generative AI toolsAudio and video content generation using AI avatars and synthesisE-commerce integration and product development strategiesAI-driven presentation and visual content creationSocial media content optimization and distributionMulti-format content transformation (articles, songs, comics, storyboards)
Taxation of Business Entities
-
TBD
2.5 Credits
Member Price: $79
Types of business entities (Sole proprietorship, Partnership, Corporation, Limited Liability Company and Limited Liability Partnership) Considerations in choosing a business entity, including taxes, limited liability protection, management & control, funding options & opportunities, tax consequences for the owners and the business. Future tax considerations that will impact various business entities.
Financial Statement Presentation and Disclosure
-
TBD
4.0 Credits
Member Price: $129
U.S. GAAP and Special purpose frameworks Form and content of financial statements: Balance sheets Income statements; Statements of cash flows Retained earnings and/or owners’ equity statements Comprehensive income Supplementary information Comparative vs. single-period financial statements Sufficiency of disclosures Illustrative disclosures frequently encountered in small-to-medium reporting entities Industry-specific nuances
Data & Predictive Analytics & Business Intelligence for Controllers/CFOs
-
TBD
4.0 Credits
Member Price: $129
DA and BI relationship to accountant value. Current trends in BI and DA, including the emergence of AI tools like ChatGPT. The changing accountant roles: data analyst, data scientist, and data storyteller, with an emphasis on how ChatGPT can be utilized in these capacities. Obtaining datasets to compare and contrast with their organization's data, and how ChatGPT can assist in analyzing and interpreting this data. BI tools and the inclusion of AI technologies such as ChatGPT to streamline processes and improve analytical capabilities.
Forensic Accounting: Crafting Expert Reports
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Introduction to Forensic Accounting: Gain an understanding of the fundamentals, roles, and responsibilities of forensic accountants in uncovering financial discrepancies, fraud, and economic damages.Maintain Ethical Integrity: Learn the importance of ethics in forensic accounting and strategies for ethical decision-making.Expert Report Preparation: Learn the essential components, best practices, and common pitfalls in writing clear, concise, and objective expert reports for legal proceedings.Investigation Report Writing: Explore the methodologies for conducting investigations, gathering evidence, and crafting thorough and accurate investigation reports.Economic Damages Writing: Understand the methodologies and best practices for calculating economic damages, including lost profits, business valuation, and other financial impacts.Reviewing Investigation Reports and Economic Damages: Analyze real-world examples to review and critique investigation reports and damage calculations, highlighting key insights and lessons learned.
2025 Annual Update for Accountants & Auditors
-
TBD
6.0 Credits
Member Price: $189
Accounting Standards Updates Auditing & Accounting Yellowbook
Hands-On Tax Return Workshop - Partnerships & LLCs (Form 1065)
-
TBD
8.0 Credits
Member Price: $300
Extensive review of the partnership income tax laws with an emphasis on any new legislative changes Comparison of partnerships, LLCs and LLPs Overview the formation of a partnership/LLC and the §704(c) pre-contribution gain or loss rules Schedule K analysis– determine if income statement items are separately (i.e. schedule K) or non-separately stated income and expense items How schedule K items get allocated to partners on schedule K-1s Look at detailed Schedule K-1 information reporting to partners needed for the qualified business income (QBI) deduction, 3.8% net investment income tax and business interest expense limitations Learn the special tax treatment of fringe benefits paid on behalf of the partners and LLC members Comparing the tax and §704(b) book capital account computations Discuss partner guaranteed payments and self-employment tax issues Schedule M-1 – reconciliation of income or loss per books with income or loss per income tax return Schedule M-2 – analysis of partners’ capital accounts Review the importance and basics of calculating a partner/member’s outside tax basis. Overview of the tax treatment of distributions, recourse and nonrecourse debt allocations, §754 election for optional basis adjustments and §743/§734 mandatory basis adjustments
ACPEN Signature 2025: The Risk of Fraud in State & Local Government
-
TBD
8.0 Credits
Member Price: $250
Risk assessment Internal controls Forensic accounting Reporting mechanisms
Estate Planning Strategies: Advanced Techniques and Tools
-
TBD
8.0 Credits
Member Price: $245
Legislative and regulatory changes in estate and gift taxation Wealth transfer strategies under the new administration Charitable deduction planning and compliance requirements Advanced estate planning tools, including split-interest trusts Using closely held stock for charitable contributions Generation-skipping transfer tax planning Strategic use of life insurance in estate planning
How to Get a Better Return on Yellow Book and Single Audits - Avoiding the Most Misapplied Audit Concepts
-
TBD
8.0 Credits
Member Price: $225
Discover the fundamental differences in the auditor's responsibilities between financial statement audits performed in accordance with the SASs and Yellow Book Understand risk assessment factors above those associated with a financial statement audit only Learn what must be done beyond the financial statement audit in order to issue required Yellow Book and Single Audit reports on internal controls and compliance Master designing, performing and documenting effective and efficient tests of compliance requirements Practice identifying, documenting and communicating the impact of internal control deficiencies and compliance audit findings to the client Common peer review deficiencies
Tax Season Update for Individuals with Steve Dilley
-
TBD
4.0 Credits
Member Price: $129
Update and integration of recent tax legislation impacting 2025 individual returns Update on significant individual tax developments related to cases and rulings Individual tax changes including the earned income credit, child credit, and child and dependent care credit Section 199A changes, including use of carryforward passive activity and 199A losses and latest tax forms Crypto reporting update 2026 tax rate schedule and other inflation adjusted items Passive activity and hobby loss rules changes
Becoming Conflict Competent
-
TBD
2.0 Credits
Member Price: $89
Major topics covered in this course include:Levels of conflictStrategies to de-escalate conflictDistinction between miscommunication and conflictResponses to conflictTactics to address, rather than avoid, conflict
K2's Excel Charting And Visualizations
-
TBD
4.0 Credits
Member Price: $129
Understanding the best types of visualizations to use in specific situations Creating compelling visualizations using Excel Adding interactivity to your Excel-based visualizations
K2's Six Essential Teams Features
-
TBD
1.0 Credits
Member Price: $39
Create a filing system that does not include endless sub-folders Manage staff delegation and follow-ups with ease Define what Lists need to be available to your Team Discover how to create automatic Flows that can notify others of update Utilize survey Forms or questionnaires from within Teams
Revenue Recognition Determine the Transaction Price Part 2
-
TBD
1.0 Credits
Member Price: $39
Revenue Recognition Accounting
Minimizing Workplace Warfare
-
TBD
1.2 Credits
Member Price: $39
Sources of Workplace Conflict Conflict Resolution Strategies Communication Skills and Active Listening Conflict Management Techniques
Powerful Public Speaking
-
TBD
1.5 Credits
Member Price: $39
Communications
Self-Rental Real Estate Passive Activity Rules
-
TBD
2.0 Credits
Member Price: $79
Definition of self-rental property - both for Sections 199A and 469 Self-rental income from directly owned properties and reporting on Form 1040, Schedule E, page 1 Self-rental income from indirectly owned (partnerships, S corporations) and reporting on Form 1040, Schedule E, page 2 Self-rental property and the Form 8582 (passive activity) Self-rental property and the flow-through entity grouping election Real-life situations illustrate the various possibilities and discuss the consequences of failing to comply with the reporting standards