CPE Catalog & Events
Build a Data Model for Analysis in Power BI
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Data Modeling Essentials: Understanding the core concepts of data modeling in Power BI, including integration of various data sources.Building Relationships: Techniques to establish and manage relationships between different data sets.Calculated Columns and Basic DAX Measures: Introduction to DAX (Data Analysis Expressions) and its application in creating calculated columns and basic measures.Calculated Columns vs Measures: Insights into when to use calculated columns and when to opt for measures.Explicit vs Implicit Measures: Understanding the difference and appropriate application of explicit and implicit measures in data analysis.Hierarchies in Data: Creating and utilizing hierarchies to enhance data analysis and reporting.Using Pivot Tables to Validate Measures: Practical skills in using pivot tables within Power BI to validate and refine measures.
An Ethical Approach to Mental Health Issues at Work
-
Virtual
2.00 Credits
The major topics covered in this class include:Virtue Ethics and Mental HealthDefinition, Myths and Bias of Mental HealthSuicide: Facts and ResourcesRecognizing signs of potential mental health challengesEmpathy and ListeningMental Health and Generational ExpectationsBecoming a Mental Health Ally
Steps to Stop External Fraud
-
Virtual
2.00 Credits
The major topics covered in this course include:Types of external fraudConsiderations as organizations work to reduce fraud riskExternal fraud and known parties/External fraud unknown perpetrators
Mastering Partnership Basis: Inside and Outside Basis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Explain the use of both "inside" and "outside” basis determination.How to calculate tax basis capital accounts, including when the entity is formed, including the impact of contributed property.Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis.Explanation of how basis is impacted distributions and by sale and/or liquidation of the partnership interest.Comprehensive example to illustrate the mechanics of the basis determination process.
Securing Your Data with a Password Management App - Updated
-
Virtual
2.00 Credits
The major topics covered in this course include:Introduction to the world of password management apps and what makes them so secureReview and demonstration of top selling password management appsSoftware features that will be reviewedPassword generationEmergency user accessEntity vs. individual password managementDesktop vs. cloud basedMulti device synchronizationPII (personally identifiable information) forms fillerCredit card storageDigital data vault
Learning to Teach "Tax" as a Second Language
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Accounting as a foreign languageCommonly misunderstood conceptsCommunicating tax mattersClient-practitioner interactionsInteracting with tax authorities
Hot Topics Accounting Update
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:New accounting standards.The impact on Financial Reporting.Hot topics in financial reporting.Current and emerging US GAAP requirements.
Surgent's Understanding S Corporation Taxation: Compensation Issues and Entity-Level Taxes
-
Virtual
2.00 Credits
Reasonable compensation Fringe benefits for S corporation shareholders Built-in gains tax Excess passive income tax Notice 2020-75: PTE elections
Managerial Accounting: Your Prescription for Better Decision
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Target profit and Break-even analysis.Relevant costs and decision-making.Standard costs and variances.Activity-based costing.Segment reporting and analysis.Budgeting.
Construction Contractors: Non-Revenue and Non-Lease Accounting Considerations
-
Virtual
4.00 Credits
Types of contractors Non-revenue GAAP accounting for contractors Contractor financial statements Sureties and their place in the construction relationship
LLC's & S Corporations: a Comparative Analysis
-
Virtual
8.00 Credits
The major topics that will be covered in this course include:Comparative analysis of LLCs and S CorporationsEntity formation, compliance, and operational structuresSelf-employment tax and its implications for LLCs and S CorporationsForm 2553 preparation and relief for late filingsRev. Proc. 2022-19 and Rev. Proc. 2023-3: analysis and applicationS Corporation eligibility errors and corrective measuresCorporate governance and formalities for both entity typesShareholder stock and debt basis for S CorporationsForms 1120S, 1065, and related schedules (K-1, K-2, K-3)Officer reasonable compensation and general partner guaranteed paymentsAudit strategies, estate planning, and business continuation planning
Surgent's Technical Business Practice Issues and Tax Forms for Experienced Practitioners
-
Virtual
8.00 Credits
Schedules K-2 and K-3 and filing exceptions Form 7203 IRS Tax Pro Account IRS modernization initiatives Information Returns Intake System (IRIS) Identity Theft warnings IRS guidance for the marijuana industry “Recycled” Form 1099-NEC to report nonemployee compensation Form 1065 steps for reporting capital Centralized audit regime; late filing penalties and small partnership relief “Substance over Form” argument of shareholder loans Advanced study of “At-Risk” loans Employer W-2 correction requests White House 2025 Budget Points Don't get caught watching the paint dry -- What is hot and new What is terminating S corporations today? Special allocation issues of §704 Final regulations for allocating depreciation recapture to partners and members of LLCs
The Best Federal Tax Update Course by Surgent
-
Virtual
8.00 Credits
Comprehensive coverage of the Inflation Reduction Act, including: The Clean Vehicle Credit, Credit for Previously Owned Clean Vehicles, Credit for Qualified Commercial Clean Vehicles, Residential Clean Energy Credit, Energy Efficient Home Improvement Credit, Premium Tax Credit, Elective Payment, Transferability, and Prevailing Wage and Apprenticeship Requirements Comprehensive coverage of the SECURE 2.0 Act, including: Expanding Enrollment in Retirement Plans, Increase in Age for Required Beginning Date for Mandatory Distributions, New Exceptions to Penalty-Free Withdrawal from Retirement Plans, and recent IRS guidance Timely coverage of breaking tax legislation Form 1099-K reporting requirements Detailed analysis and examples of Sale of Passthrough Entity Interest and Net Investment Income Tax The Gig Economy -- Tax implications, Independent Contractor vs. Employee Classification, and the DOL Final Rule FinCEN reporting requirements under the Corporate Transparency Act Employee Retention Tax Credit updates Practice aids, including all the numbers applicable for the current year -- inflation-adjusted amounts, mileage rates, retirement contributions, and more Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas
Tax Implications of Retirement Plan Distributions
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Required minimum distributions for a deceased’s heirs2025 retirement plan contribution limitsRequired minimum distributions and contributions to charityKey provisions of Secure Act 2.0
Advanced Excel for Staff - Build Reports and Analyze Data
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Building Reports Workflow: Understand the steps for creating professional and functional reports.Gather and Organize Data: Learn best practices for compiling and cleaning data for accurate analysis.Set Calculations and Key Metrics: Apply formulas and functions to calculate meaningful insights. Format and Structure Report: Use formatting tools to create visually appealing and structured reports.Review and Validate: Verify data accuracy and troubleshoot potential errors.Share the Report: Learn methods for distributing reports effectively within your organization.
Yellow Book Independence and Single Audit Fundamentals
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:The conceptual framework approach to independenceIndependence threats related to preparing financial statements and accounting recordsConsideration of specific non-audit services that would and would not impair independenceDocumentation necessary to support adequate consideration of auditor considerationFundamentals of a compliance audit performed under the Uniform GuidanceSchedule of expenditure of federal awardsDetermination of major programsUsing the Compliance Supplement Uniform Guidance administrative requirements and cost principles Testing internal control over complianceTesting complianceWriting an audit findingReporting requirements of a single audit
2025 Single Audit Update
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Review of the impact of the 2024 Compliance Supplement on Single AuditsReview of the changes to the Uniform GuidanceReview of common audit deficiencies found in Single Audits
Surgent's A Complete Guide to Reporting Form 1099-DA
-
Virtual
2.00 Credits
Definition of a digital asset for purposes of Form 1099-DA What is a sale of a digital asset affected by a broker on behalf of another person? Mandatory 2025 reporting of gross proceeds information and voluntary reporting of basis information Treatment of sales of digital assets Who is a broker for purposes of Form 1099-DA? Information required to complete Form 1099-DA Reporting closing transactions and covered securities Who is a processor of digital asset payments? How many transactions to report on each Form 1099-DA and how many forms to file for each transaction Optional reporting methods for digital asset transactions Substitute statements for the Form 1099 Reporting a disposition of digital assets held by a widely held fixed investment trust
Surgent's Key Roth IRA and Roth 401(k) Rules for Funding and Tax-free Distributions
-
Virtual
2.00 Credits
Funding options for Roth accounts 529 plans to Roth IRAs Backdoor Roth strategies The new Roth SEP and Roth SIMPLE IRAs Roth 401(k) contribution rules The tax impact of rolling a 401(k) to a Roth IRA Who can start the Roth IRA 5-year clock? The 5-year rules for Roth 401(k)s and Roth IRAs Direct and indirect Roth conversions Direct and indirect rollovers from Roth 401(k) plans The risky recapture of the 10% penalty How the ordering rules work and when they apply FIFO rules for Roth IRAs Case studies and cheat sheets to reinforce concepts
Surgent's Tax Reporting for Executive Compensation
-
Virtual
2.00 Credits
Nonqualified deferred compensation (NQDC) Nonqualified stock options (NQSOs) Incentive stock options (ISOs) Restricted stock/restricted stock units (RSUs) Stock appreciation rights (SARs) and phantom stock Employee stock purchase plans (ESPPs) Applicable tax forms and schedules Stock sale reporting Estimated taxes Filing deadlines and extensions State taxation
