CPE Catalog & Events
Comprehensive S Corporation Taxation Form 1120S 26-27
-
Webinar
8.00 Credits
Member Price: $329
Learn how to qualify and to make the S corporation election Determine how to calculate initial and annual stock and debt basis amounts and the three reasons why they are maintained Understand the four loss limitation rules applied on the shareholder's individual income tax return (i.e., basis, at-risk, passive, and excess business loss limitations) Understand the proper tax treatment and reporting of a distribution from the S corporation to a shareholder Determine how to calculate AAA and OAA account for an S corporation as well as the 3 potential taxes Determine the impact of health insurance, the net investment income tax, qualified business income tax deduction and unreasonable compensation issues on the reporting function of the S corporation
Pass-Thru Entity Owners Schedule K-1 Analysis 26-27
-
Webinar
8.00 Credits
Member Price: $329
Detailed coverage of any new legislation affecting basis computations and distributions and changes to the schedule K-1s (including the Form 7203—S Corporation Shareholder Stock and Debt Basis Limitations) Line-by-line analysis of the Schedule K-1s to determine how the items affect an S shareholder's stock and debt basis and a partner/member's outside basis and where the items get reported on Federal individual income tax return The three loss and deduction limitations on the owner's individual income tax return (i.e. basis, at-risk and other Form 1040 limitations) How cash or non-cash distributions affect the basis calculations and whether or not they are taxable to the owners Compare the tax treatment of the sale of a shareholder's stock in an S corporation and a partner's interest in a partnership What constitutes debt basis for an S corporation shareholder under the final regulations The tax ramifications of repaying loans to S corporation shareholders and on open account debt How recourse and non-recourse debt affect a partner or member's basis calculations and amount at-risk
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
Numbers to Narrative: Storytelling in Business Communication
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Role of narrative in professional communicationSituation–complication–resolution frameworkNarrative arcs in business contextsIntegrating data within a structured storyDefining tension and resolution logicallyMaintaining accuracy while improving clarityApplication of storytelling framework to a workplace scenario
Risk Wrangling: Surviving the Modern Business Rodeo
-
Webinar
1.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Risk is the common thread in an evolving landscapeRisk assessmentResponding to assessed risksAuditing standardsOther insights from AICPA guidanceFraud considerationsThe role of analyticsFinancial reporting considerationsRisk mitigation
Streamlined Excel Reporting Series Session 4: External Data and PivotCharts
-
Webinar
2.00 Credits
Member Price: $89
GETPIVOTDATA Text Files and Power Query Data Preparation PivotCharts
Business Tax Update: OBBA and Recent Developments
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Recent legislation impacting business taxpayersThe One Big Beautiful Bill ActExtenders legislation updateMeals and entertainment expense reportingPartnership and S corporation updateIncome and deductions
Workforce Transformation and Talent Management in 2025
-
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: Understanding why the traditional pyramid structure is failing firms The inverted pentagon framework and its talent retention advantages Impact of technology and AI on entry-level accounting roles The 6 Ps of Business Model Transformation implementation Accelerating specialized skills acquisition in your workforce Effective knowledge transfer through mentorship and job rotation Technology-driven training and development strategies Best practices from other industries for workforce transformation Building and retaining specialized middle layers of expertise Strategic pricing models to support the pentagon structure
Microsoft 365 for CPAs: Unlocking Hidden Productivity Tools
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Round robin review of lesser known M365 appsReduce / eliminate internal email communications with Teams and SharePointCollaborate on spreadsheet and documents with your colleagues in real timeGet control of your appointment schedule with the Bookings appTap the full potential of OneNote as your primary repository for notes, correspondence and moreReplace email attachments with secure file sharing linksDocument business processes with the Stream appLeverage the power of AI in M365 with Copilot
Surgent's Exploring Business Valuation Fundamentals
-
Webinar
2.00 Credits
Member Price: $119
What does value mean? Technical vs. fundamental analysis Intrinsic value Other discounted cash flow models Assumptions in the Gordon Growth Model Valuations using free cash flows Residual income model Enterprise value Value in mergers and acquisitions Small business valuations and discounts Advanced valuation models
Comprehensive Accounting and Financial Reporting Update
-
Webinar
4.00 Credits
Member Price: $149
The major topics covered in this class include:CECL for nonfinancial institutions.Accounting for Paycheck Protection Program loans.Accounting for web-hosting services.Revenue recognition.Leases.FASB projects in progress.
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
Surgent's Real Estate Taxation: Critical Considerations
-
Webinar
4.00 Credits
Member Price: $159
The impact of recent tax legislation on the real estate industry Depreciation and recapture Determining the basis when acquiring real estate Passive activity losses Calculation of gain or loss on sale of real estate Rental operations Installment sales
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
Surgent’s Weekly Expert Hour
-
Webinar
1.00 Credits
Member Price: $59
Each week’s topics will change based on the most critical issues affecting financial professionals
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 Leveraging AI for Data Analytics in Accounting
-
Webinar
2.00 Credits
Member Price: $99
Transforming data analytics with AI Understanding the impact of AI on data analytics processes How AI enhances data accuracy, efficiency, and decision-making AI tools and techniques for data analysis Overview of AI-powered data analytics tools Techniques for improving data analysis accuracy and efficiency with AI Integrating AI into existing data analytics workflows Case studies on AI implementations for data analytics Success stories of AI-driven data analytics in accounting Challenges and lessons learned from AI integration Measuring the ROI of AI in data analytics Developing AI-powered data analytics skills Hands-on lab sessions using AI tools (e.g., ChatGPT, Excel) Practical exercises in filtering, sorting, summarizing, and visualizing data Applying AI insights to optimize data-driven decision making in accounting
Surgent's Working Remotely: Best Practices, Challenges, and Opportunities
-
Webinar
2.00 Credits
Member Price: $99
Technology and workstation arrangements Maximizing productivity Establishing procedures that can be implemented throughout the organization Understanding the relationship between remote work and employee retention Effective communication strategies for staying connected with colleagues and clients The productivity challenges unique to working from home Time management The importance of distinguishing between the “home office” and “home” Data privacy concerns Other ethical considerations that arise when working from home
Complete Guide to Analyze Data with Excel PivotTables
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Introduction to PivotTables: Gain a solid understanding of what PivotTables are, their benefits in Excel, and how to prepare your data for creating effective PivotTables.Creating and Customizing PivotTables: Learn step-by-step how to build and format PivotTables, including filtering, sorting, and customizing layouts for optimal data analysis. Focus on Using PivotTables to Analyze Data: Explore techniques to summarize, group, and compare data with PivotTables, uncovering trends and insights for better decision-making.Advanced PivotTable Features: Discover advanced tools such as slicers, timelines, and using PowerPivot for deeper analytical capabilities. Data Visualization with PivotCharts: Learn to create PivotCharts from your PivotTables and customize them to visually present data insights effectively to stakeholders.
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.