CPE Catalog & Events
Smart Formula Selection in Excel: What to Use When
-
Online
2.00 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
-
Online
4.00 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.
Preparing for & Conducting Discharge Meetings
-
Online
1.00 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
Embracing Neurodiversity in the Workplace
-
Online
1.00 Credits
Member Price: $39
Neurodiversity
Resolving Ethical Dilemmas-You Make the Call
-
Online
1.50 Credits
Member Price: $79
Ethical frameworks Threats and safeguards to objectivity and independence
Identifying and Implementing the Proper Balance of Internal Controls
-
Online
2.00 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
Scared Straight: White Collar Crime and Beyond
-
Online
2.00 Credits
Member Price: $89
Fraud Prevention Accounting Business Ethics
Leveraging Analytical Procedures to the Fullest on Audits - Case Studies in Strengthening Audit Evidence
-
Online
2.00 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
Common Audit and Financial Reporting Deficiencies in State and Local Governments
-
Online
2.00 Credits
Member Price: $89
Financial Statement Preparation Common Mistakes made in Preparing Financial Statements GASB Financial Statement Preparation Standards
Partnership/LLC Taxation: Understanding Tax Basis Capital Accounts
-
Online
2.00 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
Quality Management: Preparing for Peer Review
-
Online
2.00 Credits
Member Price: $89
· Early peer review readiness under the quality management standards · What peer reviewers may focus on in the first cycle of QM-informed reviews · A review of peer reviewer checklists that will be applied during the firm's review · Distinguishing isolated issues from broader quality management concerns · Practical readiness considerations for sole practitioners and small- and medium-sized firms · Current expectations, emerging questions, and what may evolve as practice develops
Surgent's Guide to Partner Capital Account Reporting
-
Online
2.00 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
-
Online
2.00 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
-
Online
2.00 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
Surgent's Private Company M&A for Accounting and Finance Professionals
-
Online
2.00 Credits
Member Price: $119
M&A deal basics: understanding customer and vendor concentration, possible liabilities, off-balance sheet issues, and how these items can affect the sale price Understanding purchase agreement terms that affect the numbers, including working-capital targets, debt-like adjustments, earnout payments, and improper transfers of company assets or funds before closing Reviewing common deal protections, including representations, warranties, and indemnification provisions from a practical business perspective Preparing for post-closing issues such as accounting controls, financial reporting priorities, escrow holdbacks, and potential disputes between buyers and sellers
The Art of Engaging in Difficult Conversations
-
Online
2.00 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
Enhancing Performance Through Effective Coaching
-
Online
4.00 Credits
Member Price: $149
Coaching Effective Communication Problem Solving Use of AI as a coaching tool
Mastering SSARS: From Compilation to Preparation Engagements
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:The SSARS landscapeReview engagementsCompilation engagementsPreparation engagementsSelecting from the menu of SSARS engagementsAICPA quality management standardsIndependence and other ethical considerationsConsiderations when changing the level of servicePitfalls to avoidBest practices to adopt
Impact of OBBBA 2025 on the Individual Taxpayer
-
Online
6.00 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
Preparing and Reviewing Workpapers - Essential Tips for Avoiding Deficient Audit and Other Attest Engagements
-
Online
8.00 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