CPE Catalog & Events
Smart Formula Selection in Excel: What to Use When
-
TBD
0.0 Credits
Member Price: $89
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
2026/27 Annual Update for Not-for-Profit Accountants & Audit
-
TBD
0.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Overview of accounting developments affecting not-for-profit organizations, including recently issued Accounting Standards Updates (ASUs) from the Financial Accounting Standards Board and an introduction to the International Non-Profit Accounting Standard (INPAS).Auditing and attestation developments from the AICPA, including the next phase of quality management with a focus on monitoring and remediation responsibilities. Recent and upcoming standards affecting audit, attestation, and consulting engagements, including updates related to SSAEs, SSARSs, exposure drafts on confirmations and fraud, and changes affecting group audits.
ACPEN: Preparing for & Conducting Discharge Meetings
-
TBD
1.0 Credits
Member Price: $39
Issues to be evaluated pre-discharge Off-site/off work-misconduct Pre-discharge interviews Resignations Discharge meetings Exit Interviews Reference checks
ACPEN: Embracing Neurodiversity in the Workplace
-
TBD
1.0 Credits
Member Price: $39
Neurodiversity
ACPEN: Resolving Ethical Dilemmas—You Make the Call
-
TBD
1.5 Credits
Member Price: $79
Ethical frameworks Threats and safeguards to objectivity and independence
ACPEN: Identifying and Implementing the Proper Balance of Internal Controls
-
TBD
2.0 Credits
Member Price: $85
Introduction to identifying and implementing the proper balance of internal controls Concepts, myths and facts of internal controls Risks vs controls Typical control types Understanding controls and why they fail Framework for controls identification
ACPEN: Scared Straight: White Collar Crime and Beyond
-
TBD
2.0 Credits
Member Price: $89
Fraud Prevention Accounting Business Ethics
ACPEN: Leveraging Analytical Procedures to the Fullest on Audits - Case Studies in Strengthening Audit Evidence
-
TBD
2.0 Credits
Member Price: $89
How well-designed analytic procedures enhance audit quality Elements of strong analytic procedures Selecting the proper analytic, and altering the strength for the intended purpose Evaluating the data used in generating expectations Improving documentation, including evaluating sufficiency and appropriateness of the audit evidence obtained
ACPEN: Common Audit and Financial Reporting Deficiencies in State and Local Governments
-
TBD
1.0 Credits
Member Price: $89
Financial Statement Preparation Common Mistakes made in Preparing Financial Statements GASB Financial Statement Preparation Standards
ACPEN: Partnership/LLC Taxation: Understanding Tax Basis Capital Accounts
-
TBD
2.0 Credits
Member Price: $89
Discussion of the impact of the Section 199A flow-through entities deduction on partnerships and their partners The meaning of a "tax basis capital account" - how do the financial accounting and tax capital accounts differ from one another How to determine a partner's share of the partnership's liabilities Distinguishing "recourse" loans from "nonrecourse" loans What are "qualified nonrecourse financing" & loans and how they affect partners Section 704 "built-in gain or loss" & ules and how they impact Schedule K-1 reporting Section 465 "at risk" rules and how they impact Schedule K-1 reporting
Surgent's Guide to Partner Capital Account Reporting
-
TBD
2.0 Credits
Member Price: $99
How a partner’s outside basis and capital account differ Reconciling Schedule M-2 Form 1065 with Partnership K-1 Schedule L IRS requirement to report partner tax basis on the transactional approach Implications if a capital account is negative Deficit restoration accounts and qualified income offsets Modified outside basis method and modified previously taxed capital method Determining a partner’s beginning capital account Beginning capital account for partnerships and partners consistently reporting on the tax basis The two types of adjustments under 754 and how 743 and 734 require different capital account presentations
Surgent's Navigating AI Compliance: The EU AI Act for U.S. Finance and Accounting Leaders
-
TBD
2.0 Credits
Member Price: $119
Introduction to the EU AI Act: background, objectives, global relevance, and extraterritorial scope Key provisions and risk classifications: prohibited, high-risk, limited-risk, and general-purpose AI systems; prohibited AI practices Compliance requirements for high-risk AI systems: technical documentation, data governance, and human oversight requirements; importance of risk management and transparency obligations Practical steps for U.S. professionals: strategies to align with EU compliance standards; anticipating future regulatory developments
Surgent's New and Expanded Tax Benefits Associated with Section 1202 – Qualified Small Business Stock
-
TBD
2.0 Credits
Member Price: $99
The graduated holding periods and the related graduated capital gain exclusions Raising the per-issuer gain exclusion cap to $15 million Raising the corporate-level aggregate gross asset threshold to $75 million Qualifications for a corporation to issue Section 1202 stock Using multiple non-grantor trusts to unlock the $15 million exclusion cap The 10% test associated with non-operating real estate and investment securities The 50% working capital test The 80% test relative to an active qualified trade or business QSBS attestation letter Excluded businesses Permissible businesses, including manufacturing, retailing, technology, and wholesaling How Section 1202 applies in the context of a transfer to other taxpayers
The Art of Engaging in Difficult Conversations
-
TBD
2.0 Credits
Member Price: $89
The major subjects that will be covered in this course include:Awareness of your mindset entering the conversationTactics to build a pool of meaningClarity around story tellingBiggest mistakes to avoid
ACPEN: Enhancing Performance Through Effective Coaching
-
TBD
4.0 Credits
Member Price: $149
Coaching Effective Communication Problem Solving Use of AI as a coaching tool
ACPEN: Impact of OBBBA 2025 on the Individual Taxpayer
-
TBD
6.0 Credits
Member Price: $189
OBBBA 2025 – New law provisions, those extended or made permanent with and without changes, and those repealed Illustrative example of how the OBBA changes may impact the everyday taxpayer Inflation adjusted rates for 2025 and 2026 Dependent care credit Student loan deduction Review of other individual credits and deductions
ACPEN: Preparing and Reviewing Workpapers – Essential Tips for Avoiding Deficient Audit and Other Attest Engagements
-
TBD
8.0 Credits
Member Price: $250
Best practices for documenting complex and subjective procedures and conclusions, such as estimates, substantive analytic procedures, etc. that impact the nature and extent of audit documentation needed to support audit conclusions Discussing the financial statement audit risk concept, including how proper application better ensures a higher quality audit Tips for an efficient workpaper review process that complies with relevant standards Understanding the quality control standards and guidance related to a CPA firm’s responsibilities for its system of quality control Explain the importance of establishing, applying, and monitoring quality control policies and procedures related to audit documentation
Financial & Tax Accounting for S Corporations & Partnerships
-
TBD
0.0 Credits
Member Price: $239
The major topics that will be covered in this class include:Review the Accounting Standards Codification, OCBOA/Special Purpose Frameworks, and AICPA financial reporting framework and their application to partnerships, LLCs and S corporationsFinancial accounting issues arising from changes in ownershipFinancial vs. tax accounting for partnership/LLC capital accountsSection 704(b) substantial economic effect rules and their relation to financial accountingThe integration of financial accounting with Forms 1065 and 1120SFinancial accounting basis for ownership interests vs. tax accounting basis for ownership interestsDeferred tax accounting for partnerships/LLCs and S corporationsFinancial accounting for the operations of a partnership/LLCFinancial accounting impact of the C to S election and the S to C electionFinancial and tax accounting for S corporation shareholder equity and partner capital accountsFinancial vs. tax accounting for loans to and from S corporations and their shareholders
Cybersecurity: Protecting Your Firm's Data and Reputation
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this course include:Assessment of the current cybersecurity threat level and vulnerabilitiesDeveloping your WISP (Written Information Security Program) Deploying a password management app (PMA) to fortify the security of your login credentialsImplementing an incident response plan to minimize the damage from a cybersecurity attackUnderstanding the role of cybersecurity insurance
ACPEN: K2’s Getting Control Of Your OneDrive Account
-
TBD
1.0 Credits
Member Price: $39
Comparing OneDrive, OneDrive for Business, and SharePoint OnlineManaging documents stored in OneDrive Using OneDrive as a collaboration tool Integrating OneDrive with other applications and services