CPE Catalog & Events
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Virtual
0.00 Credits
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 Understanding Partnership Taxation: Debt Allocations
-
Virtual
2.00 Credits
Recourse debt allocations Constructive liquidation scenarios Nonrecourse debt allocations Minimum gains and nonrecourse deductions Section 704(c) gains Allocations under 704(c)
Surgent's Essential Depreciation and Expensing Update
-
Virtual
4.00 Credits
New bonus depreciation and §179 changes under the One Big Beautiful Bill Act (OBBBA) Resolved technical glitches for qualified improvement property Detailed coverage of §179 expense elections and §168(k) bonus or additional first-year depreciation – maximizing deductions, definitions, limitations, and qualified property Sales of property and the depreciation recapture rules (§1245, §1250, unrecaptured §1250 gain for real estate, §291 for corporations) MACRS depreciation – finding the proper method, convention, and recovery period Listed property and the current limitations Amortization of startup, organization, and other expenditures AMT depreciation adjustments and how to avoid them Examples, cases, and rulings of depreciation and amortization issues and how they impact clients, along with useful planning opportunities
ACPEN: Building Personal Leadership Skills
-
Online
4.00 Credits
Leadership Personality Types Communication Uses of AI in the work place
ACPEN: The Essential Guide to Understanding Private Company Financial Statement Disclosures with Renee Rampulla
-
Online
4.00 Credits
Common Private Company Accounting Policy Disclosures Numerous Sample Lease and Revenue Disclosures Unique OCBOA Disclosure Requirements and examples Research Techniques
ACPEN: Hands-On Tax Return Workshop – S Corporations (Form 1120S)
-
Online
8.00 Credits
Extensive review of the S corporation income tax laws with an emphasis on any new legislative Schedule K analysis– determine if income statement items are separately (i.e. schedule K) or non-separately stated income and expense items Discuss how schedule K items get allocated to shareholders on their schedule K-1s Look at detailed Schedule K-1 information reporting to shareholders needed for the qualified business income (QBI) deduction, 3.8% net investment income tax and business interest expense limitations Talk about the unreasonably low officer compensation issues Learn the special tax treatment of fringe benefits paid to 2% shareholders and family members Schedule M-1 – calculate the reconciliation of income or loss per books with income or loss per income tax return Schedule M-2 – detailed step-by-step calculation of the AAA, PTI, E&P and OAA accounts Basic overview of the tax treatment of distributions including when a S corporation has prior C corporation earnings and profits (E&P) Review the importance and basics of calculating a shareholder’s stock and debt basis Basic overview of the potential S corporation built in gains tax from the conversion of a C to S corporation
Retaining Top Talent: Strategies for CPA Firms
-
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: The true cost of turnover versus retention investment Research findings on why professionals leave or stay Whole-person retention strategies beyond compensation Work-life balance solutions that maintain productivity Career development paths for non-partner track professionals Business model transformations for sustainable staffing Technology and outsourcing strategies to reduce burnout Retention strategies specific to diverse talent and younger professionals
ACPEN: Introduction to Not-for-Profit Accounting
-
Online
2.00 Credits
Not-for-Profit Accounting Accounting & Auditing Yellowbook
ACPEN: Schedule K-1: What is it & What Do I Do with It?
-
Online
2.00 Credits
Overview of Schedule K-1 for Partnerships, S Corporations, and Estates/Trust Reporting Schedule K-1 information on Form 1040 Basis limitations, loss limitations, and material participation rules Qualified Business Income (QBI) Deduction and Schedule K-1 integration Case studies highlighting real-world application of Schedule K-1 reporting Proposed changes to Schedules K-2 and K-3 for 2021 and beyond Best practices for avoiding errors and ensuring compliance
ACPEN: Upholding Independence While Holding Your Client's Hand
-
Online
2.00 Credits
Circumstances that may cause recent FASB pronouncements to introduce threats to independence AICP's Code of Professional Conduct Best practice tips and practical strategies for preserving independence when assisting clients with technical matters
ACPEN: Dashboard and Report Design Principles Using Excel
-
Online
4.00 Credits
Principles of Visual Design for Dashboards and Reports Chart Design for Rapid Understanding Table Design for Efficiency Effective Use of Commentary Strategic Layout Techniques Trend Analysis Methods Developing Organizational Design Standards Excel Application Techniques Critical Review Skills Best Practices for Data Presentation
Leverage PowerBI.com to Create Data Analysis for Others
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Tour of the PowerBI.com Interface: An in-depth walkthrough of the PowerBI.com environment, focusing on user interface elements, navigation, and customization.PowerBI.com Concepts: Fundamental concepts of PowerBI.com, including its architecture, data handling capabilities, and integration features.Connecting to Data: Techniques for connecting various data sources to PowerBI.com, ensuring seamless data integration and synchronization.Visualizations and Dashboards: Creating impactful visualizations and assembling informative dashboards to present data compellingly.Q&A Feature: Explore the interactive Q&A feature to derive insights through natural language queries.Sharing Datasets, Reports, Dashboards: Best practices for sharing datasets, reports, and dashboards with different audiences so they can leverage your data analysis work.Creating Apps: Learn how to package reports and dashboards into apps for easy distribution and consumption.
ACPEN: Understanding the Tax Implications of Retirement Plan Distributions
-
Online
1.00 Credits
Required minimum distributions for a deceased's heirs 2025 retirement plan contribution limits Required minimum distributions and contributions to charity Key provisions of Secure Act 2.0
ACPEN: Hiring Remotely: Using Personality Assessments for Better Hiring Decisions
-
Online
1.00 Credits
Remote Hiring Best Practices Personality Assessments in Hiring Effective Integration of Personality Assessments Minimizing Bias and Ensuring Cultural Fit
ACPEN: IFRS SMES vs IFRS
-
Online
2.00 Credits
Overview of IFRS for SMEs General pervasive similar concepts Differences with financial instruments Differences with business combinations Differences in investments in other entities Differences in intangible assets Differences in income taxes Differences in employee benefits Differences in revenue and expenses
2026/27 Annual Update for Governments and Not-for-Profits
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Key accounting and auditing developments affecting governmental and not-for-profit organizations. Accounting Standards Updates issued by the Financial Accounting Standards Board.The purpose of INPAS and how it compares conceptually to U.S. GAAP for not-for-profit entities.Recent developments affecting Single Audits, including the 2024 Uniform Guidance overhaul, updates to Appendix B of the AICPA GAS/Single Audit Guide, and recent guidance issued through the Office of Management and Budget (OMB).
ACPEN: Partnership Preparation, Basis Calculations & Distributions – Form 1065 Schedule K & K-1 Analysis
-
Online
8.00 Credits
Extensive review of the partnership tax laws with an emphasis on any new legislative changes Review the Form 1065 to learn how income statement items get reported on the partnership/LLC tax return (i.e., page 1 versus Schedule K) and flow-thru to the partner/members on Schedule K-1 Analyze the Schedule K-1 line-by-line and discuss where the items get reported on the individual’s Federal income tax return and how the items affect the partner/member’s outside basis Look at detailed Schedule K-1 information reporting to partners/members needed for the qualified business income (QBI) deduction, 3.8% net investment income tax and business interest expense limitations Formation issues including the mandatory allocation of the §704(c) pre-contribution gain or losses back to the contributing partner/member Calculating the tax and §704(b) book capital accounts Reporting recourse and non-recourse debt on the Schedule K-1Tax ramifications and reporting of cash and non-cash distributions including disproportionate distributions of “hot assets” Overview of the §754 election for optional basis adjustments triggering §743 (transfer of interests) and §734 (distributions)
Accounting & Attestation for ESG
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Current ESG-related initiatives and projects underway at the Financial Accounting Standards Board, Governmental Accounting Standards Board, and the AICPA. Types of services CPAs may provide in connection with ESG reporting, including advisory and attestation engagements.
2026/27 Not-for-Profit GAAP Update
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline.The International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025.
ACPEN: SAS 145: Modern Risk-Based Auditing
-
Online
2.00 Credits
Introducing SAS 145 Revisiting audit risk Risk assessment in the SAS 145 Era Analyzing SAS 145 Documentation requirements