CPE Catalog & Events
Clean, Transform & Load Data in Power BI
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Introduction to Power Query in Power BI: Understanding the interface and basic functionalities.Data Cleaning Techniques: Removing duplicates, handling null values, and data type conversions.Data Transformation: Advanced methods for manipulating data, including pivoting, merging, and appending queries.Data Loading: Efficiently loading data into the Power BI data model.Document the Process Steps: Setting up details for each step in the process so you can document what is happening and why.
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
Linking Risk Management to Strategy
-
Virtual
1.00 Credits
Enterprise risk management Strategic planning Key challenges organizations face The finance professional's expanding role Black Swan events
Annual Update on the 2024 Revised Uniform Guidance And Time & Effort Reporting
-
Online
2.00 Credits
The definitions in 2 CFR 200.1 are the building blocks of the regulation and so we will provide you the impactful revisions to the citation language This session will provide you the precise wording changes, showing parts that were changed or new requirements that were added We will discuss universal wording changes as well as the effective date for implementation We will discuss impactful changes and how it will affect compliance The session will cover a new requirement for whistle blower protection We will discuss a unique insight of how time reporting is a claim and how claims can have detrimental consequences if not aware What should an organization do if they did not keep time records for a grant A "war" story when a university did not take the time reporting requirements seriously
International Tax Treaties
-
Online
2.00 Credits
Tax treaties Tax impact of cross-border transactions
The ABCs of Advisory Services
-
Online
2.00 Credits
Understanding the concept of “Integrated Planning” (financial, estate, asset protection, and tax planning) Changes in the landscape of a tax practitioner’s practice The bridging of services Getting started – Where do your clients fail? Understanding the primary planning issues for all clients Estate and Gift issues Traps, pitfalls, and tips in planning Practical steps in establishing a tax advisory and wealth management services practice Domicile issues
2025 AICPA Regulatory Ethics Update
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The Professional Ethics Executive Committee's updated ethics rules.An overview of recently issued ethics rules that CPAs need to know to be compliant.
Unlocking Deep Secrets: Case Studies in Financial Analysis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of financial statement analysisThe impact of GAAP on financial analysisOverview of the Balance SheetOverview of the Income StatementThe importance of the Statement of Cash FlowsCommon Size AnalysisTrend AnalysisProfitability Ratio AnalysisLiquidity Ratio AnalysisSolvency Ratio Analysis
AI & You
-
Online
1.00 Credits
Leadership Future of Work Workforce Planning Change Management Technology in HR Job Redesign
Accountants and Malpractice: Can We Get Sued for This?
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:How accountant liability is a very real threat in today's litigious society.A discussion of scenarios in which accounting professionals can find themselves inadvertently involved in a lawsuit.Pitfalls in which the accountant may find him- or her- self while dealing with clients.Real-life examples from the speaker's extensive experience as a practitioner and as an expert witness in accounting malpractice cases.
Surgent's Managing Millennials
-
Virtual
2.00 Credits
Understanding who millennials are and what distinguishes them from other sectors of the workforce Changes millennials seek in the workplace Suggestions on engaging and developing millennials Best practices by organizations who have successfully integrated millennials Expectations as to learning, development and training Work environments and schedules School to work transitions Views on salary, benefits and corporate ethics Whether millennials’ expectations are significantly different from any other generation Strengths millennials offer which set them apart from others Common myths pertaining to millennials Definitions of success
Surgent's Tax Research - Intermediate Concepts
-
Virtual
2.00 Credits
Tax code hierarchy Organization of an Internal Revenue Code section Special rules for IRC citation Citing other primary authorities Private letter rulings Primary vs. secondary authority Secondary sources of authority Steps in the tax research process Research memoranda
The Ethic of Teamwork
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Virtue ethicsTeam dynamicsCharacteristics of highly effective teamsMeeting managementTeam communicationDecision making
Surgent's Internal Controls and COSO in a Post-COVID Landscape
-
Virtual
4.00 Credits
ACFE's Occupational Fraud 2022: A Report to the Nations and the most commonly found controls in fraud victim organizations Internal controls in relation to COSO principles How to employ controls to cut losses How to modify controls in the post-COVID era Remote work circumstances and considerations
Building a Better Budget in a Time of Uncertainty
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Budgets vs. ForecastsCyclicalityCore Earnings & Sustainable GrowthIdentifying Key Forecast DriversReasonableness in ForecastingApproaches to BudgetingBudgeting VariancesHorizontal AnalysisFlexible Budgeting
Practical Tools and Tips to Help CPAs Manage Risk (Tax Services Focus)
-
Virtual
4.00 Credits
AICPA Professional Liability Insurance Program claim data Client and engagement acceptance Engagement letters and fee management Client continuance and termination Firmwide quality control and team management Causes of loss Risk management tips to assist claim defense when providing tax and client accounting services Data security
Proper Financial Accounting for Partnerships and LLCs
-
Online
4.00 Credits
Importance of Partnership capital accounts Book vs tax capital accounts Partnership capital contributions Section 704(b) capital rules and OCBOA GAAP balance sheet impact of capital contributions Bonus and Goodwill methods Ceiling Rule and Remedial allocations GAAP partner capital accounts
Tax Depreciation: Review and Update
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Recent tax legislation and developments related to capitalizationEligible property for Section 179 and Section 168(k)Discussion of the Section 179 deduction and its use to depreciate real propertyThe Section 168(k) deduction and its use to depreciate real propertyDisposition of segments of real propertyExchanges of tangible personal property after repeal of the like-kind exchange rulesOther related topics
Surgent's Avoiding Deficiencies in Peer Reviews: Focus on Engagement Quality
-
Virtual
4.00 Credits
AICPA’s Enhancing Audit Quality initiative Recent revisions to Quality Management standards Feedback from peer reviews, including areas driving deficiencies in audit Elements of an effective risk assessment and how to link to audit procedures performed Understanding internal controls and making the decision whether or not to test them Best practices in documentation
Leadershift: Drive Results Through Ethical Performance Mgmnt
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:How Inspirational leadership is the foundation that ethically drives results.Simplify the complex: Walk through the Results Model and discover practical how-to examples of execution.Hacks for getting great results with specific examples you can leverage in your business:The How: Empower your people to feel like an owner, managing difficult conversations well, leading with empathy and what that looks like, how it should feel, motivational coaching techniques to get your employee relationships back on track, and unleashing the power of appreciation and gratitude.The What: Powerful score-carding, transformational goal-setting conversations, and positive accountable follow- up.
