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.
Communicating in a Virtual and Live Environment - Numbers Matter But So Do Words
-
Online
2.00 Credits
Tackling the emotions of presenting Use of visuals in presentations Telling stories Who is your audience and why is it crucial? Defining presentations in a virtual and live world dynamic Discuss the overarching themes of effective presentations Building out a presentation with a roadmap order Discuss the types of presentations, including the good and the bad Tips on the right considerations in being effective in virtual presentations
Effectively Responding to IRS Letters
-
Online
2.00 Credits
Types of IRS letters: General notices, audits, collections, return requests, and errors Deadlines for responding to IRS correspondence Communication best practices for dealing with the IRS Avoiding escalation and penalties through proactive responses Ensuring compliance when addressing IRS correspondence Real-world examples of successful IRS communications Common pitfalls in handling IRS letters and how to avoid them
Surgent's Stock vs. Asset Acquisitions of C Corporations
-
Virtual
2.00 Credits
Advantages and disadvantages to buyer and seller of an asset acquisition and a stock acquisition Tax treatment of consulting agreements and covenants not to compete Sale of personal goodwill associated with an asset acquisition Tax consequences associated with a stock acquisition and an asset acquisition Acquisitive reorganizations Non-tax issues that must be considered when a corporation is acquired
What You Can Learn From the Statement of Cash Flows
-
Virtual
2.00 Credits
The major topics covered in this course include:Preparation of the statement of cash flowsImportance of identifying sources and uses of cash in financial reportingFinancial statement analysisCash-related financial statement disclosures
ACPEN Signature 2025: Financial Statement Preparation: Compilation and Review Update
-
Online
8.00 Credits
Ethics Update Preparation Engagements Compilation Engagements Review Engagements Hot GAAP Topics New Quality Management Standards
2024 PCAOB and SEC Update
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Developments at the PCAOB.Recent trends in SEC comment letters.Enforcement actions and administrative proceedings.Conclusions and predictions for the future.
The Controllership Series - The Role of the Controller in ESG
-
Online
1.50 Credits
Accounting Finance SG Operations
Big Picture Mega-Trends, Big Data, and World We Now Face
-
Online
2.00 Credits
On-going world economic trends Demographic changes and their impact on the economy Global technology influences Post Covid workplace Big data understanding and where is it going Learn to adapt to changing situations
K2's CRM - The Ultimate Business Automation Tool
-
Online
2.00 Credits
Overview of CRM functionalities tailored to accounting, including customizations and integrations Integrated tools that leverage CRM data for automating tasks and improving efficiency Strategies for successfully adopting a CRM platform and solutions to overcome common challenges
S Corporation Essentials: Stock & Loan Basis Reporting
-
Online
2.00 Credits
Basis of stock and debt Form 1040, Schedule E Shareholder basis of indebtedness Limitation of deduction of losses AAA and distributions
Operations Level Internal Control
-
Virtual
4.00 Credits
The major topics covered in this course include:An overview of controls that drive proceduresConsiderations for procedural control developmentUnderstanding and controlling risk that arises when organizations change
Estate Planning for Today and Beyond
-
Online
8.00 Credits
Analysis of upcoming trends and anticipated shifts in estate planning practices Review of legislative updates affecting estate planning strategies Advanced techniques for minimizing estate taxes and maximizing wealth transfer efficiency Integration of digital assets and technology into estate planning frameworks Consideration of unique challenges presented by blended families, same-sex marriages, and non-traditional relationships
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Discuss the impact of the Section 199A flow-through entities deduction on partnerships and their partnersThe meaning of a "tax basis capital account"How the financial accounting and tax capital accounts differ from one anotherDetermine a partner's share of the partnership's liabilitiesDistinguish "recourse" loans from "nonrecourse" loansWhat are "qualified nonrecourse financing" loans and how they affect partnersSection 704 "built-in gain or loss" rules and how they impact Schedule K-1 reportingSection 4655 "at risk" rules and how they impact Schedule K-1 reporting
The Best S Corporation, Limited Liability, and Partnership Update Course by Surgent
-
Virtual
8.00 Credits
Comprehensive coverage of the Inflation Reduction Act, including: The Corporate Alternative Minimum Tax, The Clean Vehicle Credit, Credit for Previously Owned Clean Vehicles, Credit for Qualified Commercial Clean Vehicles, §45L New Energy Efficient Home Credit, Elective Payment, Transferability, and Prevailing Wage and Apprenticeship Requirements Principles and considerations for nonresident withholding, composite payments, and passthrough entity taxes Comprehensive coverage of the SECURE 2.0 Act with a focus on provisions applicable to employers Thinking beyond §163(j) -- Interest Allocation Rules, Original Issue Discount, Applicable High Yield Discount Obligations, Convertible Corporate Debt Instruments, and Debt-Financed Distributions Retirements and redemptions: considerations for partnerships and S corporations Timely coverage of breaking tax legislation Selected Practice and Reporting Issues: What’s new? A review of recent cases and tax law changes and IRS guidance affecting S corporations, partnerships, limited liability companies, and limited liability partnerships Form 1099-K reporting requirements Bonus depreciation Section 174 Research & Experimental Expenditures -- new guidance under Notice 2023-63 and Notice 2024-12 FinCEN reporting requirements A review of like-kind exchange transactions under §1031
Common Sense CFO: Decoding and Mitigating Internal and External Risks
-
Online
2.00 Credits
Defining risk as it impacts organizations Understanding external and internal risks Examples of these risks How do we identify and assess? What can be done about the risks? Developing a risk mitigation strategy Monitoring and mitigating risk
Leveraging ChatGPT for Innovative Business Advisory Services
-
Virtual
2.00 Credits
The major topics covered in this course include:Introduction to ChatGPT and its applications in the business advisory contextIn-depth exploration of enterprise evaluation methodologies like SWOT, PESTLE, BCG Matrix, McKinsey 7S Model, Ansoff Matrix, etc.Practical case studies demonstrating application of ChatGPT in accounting business analysisKey challenges faced by accounting firms and how ChatGPT can help overcome theseBest practices for implementing AI tools in the accounting sectorFuture opportunities and trends in AI-enhanced business advisory services
More Money: Strategic Ways to Improve Cash Flow
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:How do I optimize cash flow?Qualitative Evaluations – Core Earnings & Sustainable GrowthQuantitative Evaluations – Liquidity RatiosIncreasing Customer Base vs. Payment TermsBusiness Cycle & CashInvesting Company CashWhat keeps companies from becoming streamlined?Behavioral Finance BiasesInformation Processing BiasesEmotional BiasesDealing with Behavioral Biases
Surgent's Compilations, Reviews, and Preparations: Engagement Performance and Annual Update
-
Virtual
8.00 Credits
SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services -- 2018 SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions SSARS No. 26, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Sample comprehensive engagement work programs for preparation, compilation and review engagements Reporting and disclosure illustrations for each level of service, including attesting on personal financial statements, prescribed form, special purpose framework and other engagement variations Other communication requirements, such as sample engagement letters and management representation letters
Unlock the Power of AI with Copilot in Excel
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Copilot in ExcelAutomating Tasks and Enhancing ProductivityAdvanced Data Insights with Copilot
