CPE Catalog & Events
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Online
2.00 Credits
Member Price: $99
Using lookup functions as an alternative to direct cell references Understand the limitations of the VLOOKUP function Discover ways to move beyond these limitations
Surgent's Found It! Reporting Findings in Yellow Book and Single Audits
-
Online
2.00 Credits
Member Price: $99
The types of findings reported in Yellow Book and single audits The requirements for reporting findings under the 2024 Yellow Book revision and the 2024 revision to the Uniform Guidance How to really think through the elements of a finding to assist report users
Surgent's Top Individual Tax Planning Strategies
-
Online
2.00 Credits
Member Price: $99
New Clean Vehicles (CV) and the Clean Vehicle Credit What the CV seller must provide to the buyer Credit for previously owned CVs Energy efficient home improvement credit Increase in age for required beginning date for RMDs Reduction in excise tax on RMD failures Indexing IRA catch-up limit Higher catch-up limit to apply at age 60, 61, 62 and 63 Withdrawals for certain emergency expenses Qualifying longevity annuity contracts (QLACs) One-time election for qualified charitable distribution (QCD) to split-interest entity; increase in QCD limitation
Surgent's Virtual Currency: Keeping Up with the Tax Code
-
Online
2.00 Credits
Member Price: $119
Overview of virtual currency Property transactions with virtual currency Receiving virtual currency as payment Paying using virtual currency Charitable donations with virtual currency Gifting of virtual currency Form 8300 reporting
2025 Accounting & Auditing Update
-
Online
3.00 Credits
Member Price: $129
Accounting Standards Updates Auditing & Accounting Yellowbook
Forensic Accounting: Finding Hidden Treasure in Tax Returns
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:The rules of IRS disclosure of tax informationUnderstanding the role of IRS transcriptsInterpreting the actions of the IRS in transcriptsFOIA requestsAnalyzing tax information and returns for financial leads
IRAs - Contributions & Distributions for Traditional, Roth, SEP & SIMPLE IRAs
-
Online
8.00 Credits
Member Price: $400
An emphasis on newly enacted tax legislation affecting IRAs including the NEW final required minimum distribution (RMD) regulations Contribution limits to and tax treatment of distributions from Traditional, Roth, SEP and SIMPLE IRAs Deductible phase-out limits for Traditional IRA contributions for taxpayers that are active participants in qualified retirement plans Roth IRA contribution phase-out limits as well as tax-free qualified distributions Planning opportunities for conversions to ROTH IRAs Rollover rules to/from different retirement accounts and the one-rollover-per-year limitation The different options of receiving IRA distributions before age 59 ½ and avoiding the 10% early distribution penalty (including substantially equal periodic payments) The required minimum distribution (RMD) rules from IRAs needed to avoid the 50% penalty after the account owner turns age 72 or dies The tax ramifications of spouse and non-spouse beneficiaries and how this affects the RMD calculation after the account owner’s death Overview of health savings account (HSA) eligibility rules, contribution limits and distribution rules
Coaching the Next Generation of CPAs
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Building a high-performing team comprised of multi-generational workers.How to effectively communicate with the millennial worker.Leveraging younger staff in business development opportunities.Measuring the productivity of a millennial workforce.
Digging Deep with Excel Pivot Tables
-
Online
1.00 Credits
Member Price: $59
Data preparation and cleansing Pivot table creation Pivot table customization Navigating Excel’s PivotTable Analyze tab
Revenue Recognition - Topic 606 Disclosures
-
Online
1.20 Credits
Member Price: $59
Revenue Recognition Accounting
How to Gain Efficiencies in Your Accounting Processes and Program Operations
-
Online
1.50 Credits
Member Price: $99
Financial reporting, accounting operations, accounting processes, automation, outsourcing, technology.
The Controllership Series - Sales, Collections and Customer Credit
-
Online
1.50 Credits
Member Price: $79
Accounting Sales Collections
Clarifying Risk Assessment - SAS 145 and Beyond 25-26
-
Online
4.00 Credits
Member Price: $175
Assessing the risk of material misstatement Mandatory risk assessment procedures Evaluating internal controls Responding to risk assessment with appropriate audit procedures Complying with revised and expanded documentation requirements
Form 5500 Annual Update 25-26
-
Online
4.00 Credits
Member Price: $175
Forms 5500, 5500SF and 5500EZ Form 5500: nuances and schedules Reporting and disclosing compliance issues Reporting delinquent contributions Failure to file
Fraud?How to Find, How to Prevent 25-26
-
Online
4.00 Credits
Member Price: $175
Fraud and its impact on our clients Fraud prevention Internal controls Fraud risks Fraud prevention tips
Lease Implementation for Private Entities 25-26
-
Online
6.00 Credits
Member Price: $175
Analysis of requirements for lease accounting under ASC 842, including detailed schedules showing journal entries and computations Analysis of internal control and fraud risk aspects Identification of high-risk areas of lease accounting and reporting Suggested audit and review procedures for identified risks
Tax Planning for Seniors 25-26
-
Online
4.00 Credits
Member Price: $175
Income for seniors: retirement, earnings and investments Tax Deductions: planning, bunching, strategies Planning to help family members
The Generation-Skipping Transfer Tax and Dynasty Trusts 25-26
-
Online
4.00 Credits
Member Price: $175
Calculation of the GST tax, and how it relates to the estate tax and gift tax Direct skips, taxable distributions, and taxable terminations GST tax allocations, Reverse QTIP election, and Exempt and Nonexempt Trusts Calculating the benefit of and designing Dynasty Trusts
Build a Data Model for Analysis in Power BI
-
Online
4.00 Credits
Member Price: $149
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.
Understanding and Creating an Internal Control System 25-26
-
Online
8.00 Credits
Member Price: $329
Underlying concepts of internal control Defining where and why controls, policies and procedures are needed Legacy control measures that are still important for businesses today Creating control measures that address the use and protection of technology