CPE Catalog & Events
Excel Essentials for Today's Accountant: How To Become an Expert in One Day
-
Online
4.00 Credits
Member Price: $159
Using formulas to manipulate and transform data Using formulas and reference formulas such as =VLOOKUP Using pivot tables Understanding Solver to perform multivariate analysis Awareness of advanced functions Creative methods for data manipulation Using intellectual curiosity and professional skepticism to develop a problem-solving mentality Real-life examples of innovative ways to analyze and report data with Excel Using Excel to perform e-mail merges Enhance creativity in your approach to developing Excel models Computer software and application
Strategies for Guiding Clients Through Challenging Situations: Tax Insights
-
Online
8.00 Credits
Member Price: $275
Navigating the tax and non-tax dimensions of divorce. Unveiling tax and non-tax considerations in personal bankruptcy, debt cancellation, foreclosure, repossession, and bad debt reporting. Exploring the tax and non-tax aspects of personal relationship matters, encompassing cohabitation, property rights, premarital agreements, filing status, exemptions, and dependents. Grasping the intricacies of support considerations for spouses and former spouses. Addressing support matters for children of divorced or separated parents, alongside the tax treatment of back child support. Delving into the business implications in instances of business dissolution. Tackling specialized topics, including marital property rules, tax rate comparisons for married and unmarried individuals, head of household status, and treatment of refunds and deficiencies.
Controller Series: Communicating for Connections with Coworkers, Customers, and Stakeholders
-
Online
1.00 Credits
Member Price: $75
What are the three types of misconceptions of communication? What are the different types of personality styles in the workplace? Recognize how to communicate with the different types of personality styles effectively Key takeaways
Roadmap to Ethical Decision Making
-
Online
2.00 Credits
Member Price: $109
Provide best practice tips and practical strategies for preserving independence when assisting clients with technical matters Discuss the principles of professional conduct Address compliance with professional standards Use case studies to address circumstances that may create threats to independence
State Tax Nexus: Frequently Awkward Questions
-
Online
2.00 Credits
Member Price: $109
Frequently asked questions about income tax and sales tax nexus New developments Key factors in reviewing potential nexus consequences Nexus road trip to eight large states Tax impacts of remote work Free, multistate resources
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: $99
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
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.
Learning to Teach "Tax" as a Second Language
-
Online
1.00 Credits
Member Price: $59
Accounting as a foreign language Commonly misunderstood concepts Communicating tax matters Client-practitioner interactions Interacting with tax authorities
Indirect Rate Recovery for Non-Profits & Pass-Through Entities
-
Online
1.00 Credits
Member Price: $59
Indirect rates Sub-recipient relationship with PTEs PPP loan forgiveness credit The District of Columbia and MD laws on settlement of indirect rates with PTEs 10% de mnimis rate vs. indirect rate negotiation