CPE Catalog & Events
Smart Formula Selection in Excel: What to Use When
-
Webinar
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
Surgent's The Road Ahead: Critical OBBBA Changes Impacting Accounting and Finance Professionals
-
Webinar
2.00 Credits
Member Price: $119
Marginal tax rates effective in 2025 and beyond The QBI deduction Qualified residential interest Child Care Credit Miscellaneous itemized deductions, including the educator deduction Rollovers from 529 plans to ABLE accounts Additional expenses treated as qualified higher education expenses for purposes of 529 accounts Termination of credits for environmentally clean autos and expenditures Other timely topics
Surgent's Unique Tax Attributes of Different Entity Types
-
Webinar
2.00 Credits
Member Price: $99
Considerations for a small business owner Self-employment taxes Guaranteed payments to partners QBI deductions: Section 199A Built-in gains tax: S corporations Excess passive income tax: S corporations PTE elections: S corporations and partnerships Taxation of fringe benefits: S corporations Double taxation of C corporation dividends Taxation of limited liability companies Which entity to choose?
Create Measures in Power BI that Define Your Metrics
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this class include:Introduction to DAX: Understanding the fundamentals of DAX and its role in Power BI.Advanced DAX Formulas: Delving into complex DAX functions and formulas for creating sophisticated measures.Time Intelligence in DAX: Exploring time-based functions to analyze data over different periods.Validating Measures with DAX: Techniques for ensuring accuracy and reliability in your DAX measures.Using PivotTables for Measure Validation: Employing PivotTables in Power BI to test and confirm the effectiveness of DAX measures.
Erase the Mark: Best Practices in Penalty Abatement
-
Webinar
2.00 Credits
Member Price: $89
The major topics covered in this course include:The authority of the IRS in assessing tax penalties.The types of penalties that can be removed.The process the IRS uses to evaluate penalty abatements.How to request penalty abatements.Best practices in asking for penalty abatement, including using appeals.
Surgent's Preparation and Compilation Engagements Under the SSARS
-
Webinar
4.00 Credits
Member Price: $159
Relevant sections of SSARS No. 21, Clarification and Recodification 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. 26, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Proposed changes to the SSARS guidance Comprehensive sample engagement work programs for preparation and compilation engagements Prescribed form, specified line item, pro forma, and other engagement variations Complete illustrations of relevant engagement letters, reporting and other required communications for preparation and compilation engagements
Understanding Internal Control Constructs
-
Webinar
4.00 Credits
Member Price: $149
The major topics covered in this course include:Underlying concepts of internal controlThe importance of control measure interdependency
Internal Controls Over Compliance vs Compliance
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Testing internal ControlsAlign internal controls with specific compliance requirementsThe misidentification of controls and the confusion between compliance and control processes
Accountants and Malpractice: Can We Get Sued for This?
-
Webinar
0.00 Credits
Member Price: $89
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 Ethical Considerations for CPAs
-
Webinar
2.00 Credits
Member Price: $99
Auditor independence and its importance to the public accounting profession Common threats to auditor independence AICPA’s framework for assessing conflicts of interest Unique threats related to non-attest services to attest clients Common safeguards to help assure compliance with relevant rules and regulations
Smarter Tax Services with Artificial Intelligence (AI) Tools
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of AI technology and how it worksIdentify where AI can be incorporated into tax research, planning, and compliance servicesDiscover new opportunities to enhance your client advisory tax services with AI toolsReview the market of emerging and AI enhanced tax software toolsLearn about the newest generation of AI enable 1040 source document collection and organizer applicationsReview specific use cases for generative AI tools (e.g. ChatGPT, Microsoft Copilot) in your tax services
How to Audit: Property, Plant, & Equipment
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:The foundation of auditing PP&E, including the related audit assertions, risks, & threats to the PP&E balance.The various substantive auditing procedures that staff should perform.Real world auditing examples.
Surgent's Cybersecurity Risk Management for Financial Professionals: Policies, Controls, and Emerging Threats
-
Webinar
2.00 Credits
Member Price: $99
Core components of a cybersecurity risk management program Overview of key policies, controls, and procedures for financial organizations Applicability of global compliance standards, like the EU AI Act and GDPR, in the U.1`S. financial landscape Case studies: financial implications of breaches and mitigation strategies Best practices for integrating cybersecurity with financial reporting
Tax Depreciation: Review and Update
-
Webinar
2.00 Credits
Member Price: $89
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
ChatGPT Vision for Financial Analysis
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Introduction to GPT Vision - Understanding the fundamentals of GPT Vision and its capabilities.Advantages of Vision Mode Research - Exploring the unique benefits of visual data analysis over traditional methods.Accessing GPT Vision - Guidance on how to access and utilize GPT Vision capabilities.Financial Screenshot Analysis - Techniques for analyzing financial documents and reports through screenshots.Operational Insights from Visual Data - Using images to gain insights into operational processes and asset management.Integration with Google Maps - Learning how to combine ChatGPT's vision capabilities with mapping technologies for enhanced spatial analysis.DDPP Analysis - Applying descriptive, diagnostic, predictive, and prescriptive analysis to visual data.Sentiment and Facial Expression Analysis - Techniques for interpreting emotions and sentiments in images to gauge client and employee feedback.Body Language Interpretation - Analyzing body language in images to understand non-verbal cues in business contexts.Effective Photo Capturing Techniques - Best practices for taking photos that provide optimal insights for financial analysis.
Internal Control Changes for Remote Workers
-
Webinar
2.00 Credits
Member Price: $89
The major topics covered in this course include:The benefits and pitfalls of remote employees.How to maximize the value provided by distance workers.Policies, procedures, and control measures designed for a more geographically dispersed workforce.
An Ethical Approach to Mental Health Issues at Work
-
Webinar
2.00 Credits
Member Price: $89
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
Retaining Top Talent: Strategies for CPA Firms
-
Webinar
1.00 Credits
Member Price: $55
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: The true cost of turnover versus retention investment Research findings on why professionals leave or stay Whole-person retention strategies beyond compensation Work-life balance solutions that maintain productivity Career development paths for non-partner track professionals Business model transformations for sustainable staffing Technology and outsourcing strategies to reduce burnout Retention strategies specific to diverse talent and younger professionals
Microsoft 365 Application Lightning Round Review-Updated
-
Webinar
1.00 Credits
Member Price: $55
The major topics covered in this course include:Lightning round review of the following apps, with an explanation and demonstration of what each of them offersTeams - the foundation of all that you do in Microsoft 365SharePoint / OneDrive - secure cloud storagePower BI - the new financial reporting modelStream - the YouTube for your organizationBookings - streamline your appointment scheduling OneNote - get your content organized for quick retrieval Lists - create custom list tracking reportsTo Do - consolidate all your Outlook, Planner and general "to do's" in one appPlanner - manage simple and complex engagements and projects in an intuitive appA quick look at many of the remaining apps
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
Webinar
2.00 Credits
Member Price: $89
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