CPE Catalog & Events
Surgent's How to Effectively Represent Clients Under IRS Audit
-
Virtual
2.00 Credits
Why the IRS selects a tax return for audit What happens when the taxpayer disagrees with the results of the audit IRS employees who interact with taxpayers during an audit FATCA audits Types of IRS examinations Potential IRS audit outcomes Substitute for returns Large Partnership Compliance Program IRS’s shift in audit strategies Responding to IRS Notices online Audits of high income and high net-worth individuals The Bipartisan Budget Act of 2015 (BBA) and its impact on auditing partnerships IRS Letters of Concern
Taking Advantage of Array Formulas in Excel
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Array Formulas: This segment establishes the foundation by differentiating array formulas from regular Excel formulas and explaining their significance.Using Array Formulas: This section focuses on the practical application of array formulas, teaching participants how to effectively implement and utilize these formulas in a variety of common Excel tasks and scenarios.Dynamic Arrays and Spill Functions: This part covers the utilization of dynamic arrays and spill functions, highlighting their role in modern Excel data handling.Advanced Array Functions: Participants will delve into complex functions such as SUMPRODUCT, UNIQUE, SORT, and FILTER, focusing on multi-condition summing and data management.Using Array Constants: This section teaches how simplify the use of static values called Array Constants
The Preparation of Form 709 - Line-by-Line
-
Online
2.00 Credits
Gift tax fundamentals and exclusions Completing Form 709 accurately Gift-splitting and its tax implications Lifetime exemption and GSTT considerations Valuation of gifted assets Common filing mistakes and IRS audits Updates on new legislation impacting gift taxation
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.
ChatGPT Bootcamp for CPAs with John Higgins
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Review the history of ChatGPTTour of the ChatGPT app and how to use itSetting up a ChatGPT account (free & premium)Variety of hands-on case study examples for accounting, finance and taxA look under the hood at how ChatGPT worksCaution - how to avoid risks in using ChatGPTA look into the future potential for AI in business
Walkin', Talkin', Lookin' & Listenin' - Or Things Most of Us Don't Do Well
-
Online
2.00 Credits
The importance of making yourself available How to start a conversation and what to NOT talk about The art of how to listen When you don’t understand what they just said Don’t fool by equivocations when they respond to a question Materiality and perception
Common Sense CFO: Dealing with Ever Changing Accounting Standards and Strategy Demands
-
Online
2.00 Credits
Understanding the modern finance and accounting organization chart GAAP accounting changes Why so many changes? The speed of change and complexity Accepting reality Recognizing and fixing the top five accounting problems and errors Leases Revenue Management estimates Why is strategy necessary? What is strategy? The two keys to strategy? Why do some financial leaders lack strategic skills? Balancing strategy with our day-to-day roles
Everyday Ethics at Work: Don't be the Next News Story!
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Discuss ethics from an every-day real-world perspectiveHow to prevent an ethical lapse that can turn your business into the next news story
The Ethical Management of Conflict
-
Virtual
2.00 Credits
The major topics covered in this class include:Professionalism, Conflict and EthicsSources and approaches to conflictManaging Conflict from the Inside: Awareness of human tendencies, human emotions, and gossipGuidelines for managing conflict collaboratively
Taxation of Judgements and Settlements
-
Online
2.40 Credits
Types of damages or remedies that can be awarded or agreed upon pursuant to litigation. Review of the Internal Revenue Code and regulations governing the taxation of various types of litigation payments. Suggestions for drafting pleadings or settlement agreements.
Individual Tax Update: Key Considerations for 2025
-
Online
8.00 Credits
2025 Tax Provision Sunsets Proposed individual tax provisions Recent legislative developments, cases and rulings impacting individual taxpayers ACA premium tax credit Inflation Reduction Act update 2026 inflation rates FBAR update Virtual currency and enforcement Property transactions Gross income and deductions
SEC Case Studies: Ethical Dilemmas in Finance and Accounting
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Ethics and Ethical DilemmasEthical Codes and Professional StandardsFraud and the Fraud TriangleEthical Decision-Making ModelsFinancial Statement Manipulation TacticsCash Flow and Key Metrics Misrepresentations
Introduction to Ethics & Professional Skepticism
-
Online
2.00 Credits
Code of Ethics for Professional Accountants Yellowbook Auditing
Ethics: IRS Criminal Investigations: Key Lessons for Accountants
-
Virtual
2.00 Credits
Snapshot of IRS Criminal InvestigationsGeneral tax fraudAbusive tax schemesRefund fraudEmployment tax fraudIdentity theftData compromisesMoney launderingPublic corruptionCorporate fraudGeneral fraudsCyber crimesGlobal tax and economic crimesNarcotics, counter-terrorism and transnational organized crimeSelected Field Office Case Files from Across USNew EnglandMiddle AtlanticEast NorthCentralWest North CentralSouth AtlanticEast South Central West South CentralMountainPacificHow accountants can add value to their operations by aiding law enforcement and fighting economic crime
Surgent's Excel Shortcuts for Accountants
-
Virtual
2.00 Credits
Explore the function that sums better than the SUM function Discover a variety of time-saving features, functions, and techniques Learn the workaround to a major Excel pitfall
Surgent's Guide to Calculating S Corporation Shareholder Stock and Loan Basis
-
Virtual
2.00 Credits
Introduction to Form 7203 Introduction to the calculation of stock basis Introduction to the calculation of loan basis Taxable and nontaxable S corporation distributions to shareholders The election to reduce basis by deductible losses and expenses before reducing basis by nondeductible expenses
Surgent's Successfully Completing an Income Tax Return for a Trust or Estate -- Form 1041
-
Virtual
2.00 Credits
Passive activity rules for trusts including the NIIT The different types of trusts for income tax purposes (e.g. simple, complex, grantor, charitable) The critical categorization of income (taxable income vs. fiduciary accounting income) Distributable net income (DNI) and how it works The “Tier” Rules The Separate Share Rule IRC 663(b) “65-Day” Rule IRC §691(c) Deduction QSST and EBST elections How to treat excess deductions on termination Grantor trust rules and how they impact planning and return preparation The income tax side of Domestic Asset Protection Trusts
Tax Practice Ethical Challenges and Circular 230
-
Online
2.00 Credits
Circular 230 (IRS) rules for conducting a "best" tax practice How to avoid tax return preparation penalties Recent developments impacting today's tax practice Review of tax return preparer's registration rules Explanation of the revised AICPA Code of Professional Conduct Contingent fees
Surgent's Understanding Partnership Taxation: Types of Basis, Contributions, and Distributions
-
Virtual
4.00 Credits
Three different types of basis Contributions of property IRC 704(b) – Capital Accounts and Special Allocations Contributions of property and debt Contributions of services IRS Notice 2020-43
Becoming Conflict Competent
-
Virtual
2.00 Credits
Major topics covered in this course include:Levels of conflictStrategies to de-escalate conflictDistinction between miscommunication and conflictResponses to conflictTactics to address, rather than avoid, conflict
