CPE Catalog & Events
Surgent's Excel Shortcuts for Accountants
-
Online
2.0 Credits
Member Price: $99
This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.
Surgent's The Road Ahead: Critical OBBBA Changes Impacting Accounting and Finance Professionals
-
Online
2.0 Credits
Member Price: $119
It is important for accounting and finance practitioners to help their clients understand and apply the many new provisions of OBBBA. Many of these changes are effective for the 2025 tax year and beyond. This program is an introduction to and review of some of these critical changes and their impact on taxpayers. This program is a two-hour review and analysis of what we consider some of the most current and important changes from the OBBBA. If you want the latest OBBBA information to relay to your clients, this course is for you.
Surgent's Top 20 Questions Advisors Ask About the SECURE Acts and Other IRA Rules
-
Online
2.0 Credits
Member Price: $99
Advisors often ask clarifying questions as they increasingly gain an understanding of new and existing tax laws that govern IRAs. Some provisions see more questions than others due to their complexity, popularity, and level of impact on tax benefits. This course focuses on the top 20 of these questions and on SECURE Act 1.0, SECURE Act 2.0, and other hot topics. This course aims to help the advisor provide clients with the correct responses based on their IRA profiles.
Surgent's Engagement and Client Retention Best Practices
-
Online
2.0 Credits
Member Price: $119
Positive client relationships require work. Miscommunication, unrealistic expectations, and differing personality styles may strain a client's relationship with professional advisors. Fortunately, there are tested strategies that foster and strengthen client relationships. Creating appropriate boundaries early on is one of many effective strategies that can help. This course explores actions accounting and finance professionals can take to create and grow their client relationships. This webinar provides actionable insights on how to engage new and old clients alike. Strained client relationships can harm both the client and the firm's profitability. Yet automation, for example, allows some firms to remain more engaged while others miss the mark. There is a science underlying client retention that involves understanding the client journey, ensuring consistent client interactions, and equipping employees with the tools needed to satisfy client needs. Understanding these skills should help you protect the relationships that sustain your business.
Surgent's Workplace Harassment: How to Prevent Harassment and Reduce Liability Risks in Today's Changing Environment
-
Online
2.0 Credits
Member Price: $99
Workplace harassment — especially sexual harassment — has dominated headlines in the last several years. With discussions of workplace harassment in the news, employees better understand their rights and feel more empowered to speak out, and the standard of appropriate workplace conduct is changing. With workplace harassment claims continuing to be filed at a steady pace with the United States Equal Employment Opportunity Commission, state agencies, and the courts, it is more important than ever to understand how to prevent and avoid harassment in the workplace.
Surgent's Taxation of Tips and Overtime Under OBBBA
-
Online
2.0 Credits
Member Price: $119
Arguably the most discussed topics to come out of the One Big Beautiful Bill Act (OBBBA) are the taxation of tips and overtime. Practitioners need to understand these provisions now, as they are effective for 2025 tax returns. This program provides practitioners with the background currently available to advise clients regarding these two important tax developments. Both employers and employees need to understand these timely changes to taxation.
Surgent's Avoiding Deficiencies in Peer Reviews: Focus on Engagement Quality
-
Online
4.0 Credits
Member Price: $159
With the AICPA's heightened focus on enhancing audit quality, increased oversight of the peer review process and the auditor's overall responsibility to provide high quality services, the focus on compliance with professional standards has never been greater. Add to that the requirement to implement the revised risk assessment standards (SAS 145) and it's easy to see why it's more important than ever to ensure that auditors have a good understanding of the requirements and comply with documentation standards. Recent peer reviews have indicated that auditors are often failing to perform and/or document certain critical components of an audit such as the auditor's assessment of risk and linking the results of the assessment to substantive procedures performed. In addition, auditors are not adequately documenting their consideration of fraud, expectations in analytical procedures and the appropriate level of work needed to understand an entity's internal control. Firms were required to implement the AICPA's Revised Quality Management Standards by December 15, 2025. And the firm's evaluation of the System of Quality Management is required within one year after that. This is not just a matter of tweaking the firm's existing QM document, the standard requires a risk assessment process to identify risk and there are new quality objectives that are specified in SQMS 1-3. The AICPA further issued a SAS, SSARS and SSAE that set forth requirements for quality at the engagement level. The objective of the course is to provide the insights necessary to help auditors and accountants improve not just the quality of their work but also the perception of the accounting profession as a whole. We will focus on the most significant items resulting in deficiencies identified in the peer review process. We will also discuss the applicable audit standards, documentation requirements, and best practices. We will address the new QM standards.
Surgent's Tax Update for Client Advisory Services
-
Online
4.0 Credits
Member Price: $159
Client advisory services (CAS) professionals are becoming a more integral part of the operations of any CPA firm. As such, they must stay on top of changing tax law. In this course, we will explore tax changes in areas CAS professionals are involved with — information reporting, payroll tax issues, and tax credit and deduction documentation. We will also discuss relevant changes to individual and business tax returns so that CAS professionals can better assist clients with tax needs in the upcoming year.
Preparation, Compilations and Reviews—A Practical Workshop 26-27
-
Online
8.0 Credits
Member Price: $329
Participants will go over the changes on preparation, compilation and review engagements using SSARS rules, followed by a general overview of how to perform these services. This interactive workshop is designed for practitioners in small and medium-sized CPA firms and will include a lecture with generous time for questions and case studies.
Surgent's A Complete Guide to Reporting Form 1099-DA
-
Online
2.0 Credits
Member Price: $119
For each digital asset sale that a broker has affected for a customer in 2025, the broker must complete Form 1099-DA. A broker includes any person who, in the ordinary course of a trade or business, stands ready to affect sales of digital assets to be made by others. This program covers the required rules for reporting digital asset transactions on Form 1099-DA.
Surgent's Contract Law for Accounting and Finance Professionals
-
Online
2.0 Credits
Member Price: $99
Accounting and finance professionals routinely encounter a broad range of legal issues while advising clients or performing routine job functions. Contract law tops the list as the most frequent issue that intersects with the accounting and finance professions. As trusted advisors, it is wise to understand the fundamentals of contract law for both personal and professional benefit. This course provides a broad overview of contract law basics geared specifically toward the accounting and finance professions. From contract formation to enforceability, this course offers an interesting look at how contract law intersects with accounting and finance. Participants should walk away with a better understanding of common issues that arise when reviewing contracts.
Surgent's Controllership Skills Update - Budgeting, Forecasting, and Big Data
-
Online
2.0 Credits
Member Price: $99
Budgets are the vehicle for allocating resources, measuring activities, and identifying needed changes and improvements. An organization's strategy is the primary driver of costs. To be effective, the budget must be linked to strategy and long-term plans. Numerous organizations have achieved a series of short-term targets (budgets) but failed longer term, demonstrating the lack of this necessary linkage. Forecasting, a critical part of any successful budgeting process, can be flawed by technical errors, organizational structure, or emotional forces. The establishment of a system to collect, process, and analyze big data can provide significant insights into the budgeting and forecasting process. An efficient system of incorporating big data and analytics into normal activities will improve management's decision-making. This brief program offers specific actions to improve your forecasting and budgeting activities. In addition, more advanced techniques are identified for the participant's further review, which can be applied throughout an organization. Good budgets effectively allocate resources, provide information for decision-making and serve as an early warning system for unforeseen events. A poor budgeting process fosters a false sense of security, provides inappropriate or inaccurate data, and reinforces the status quo. Budgets are about the organization's story, not just the raw numbers!
Surgent's Excel: Mastering PivotTables
-
Online
2.0 Credits
Member Price: $99
PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.
Audits Under Uniform Guidance—Single Audit & NPOs 26-27
-
Online
4.0 Credits
Member Price: $175
Audits conducted under the Uniform Guidance for Federal Awards continue to be among the most challenging audit engagements as the number of federally funded programs for not-for-profit organizations continues to increase. This course will provide you with what you need to know to prepare for Single Audits conducted during 2026, including performing the compliance audit and auditor reporting responsibilities.
Preparation, Compilation & Review Services 26-27
-
Online
4.0 Credits
Member Price: $175
SSARS 21 significantly changed the way CPA services are being offered. There is still confusion about CPA responsibilities and procedures. The course will discuss differences between bookkeeping, preparation and compilation engagements and how they differ. It will also discuss financial statement frameworks and how they influence the engagement as well as analytical procedures in review engagements.
Preparation, Compilations and Reviews—A Practical Workshop 26-27
-
Online
8.0 Credits
Member Price: $329
Participants will go over the changes on preparation, compilation and review engagements using SSARS rules, followed by a general overview of how to perform these services. This interactive workshop is designed for practitioners in small and medium-sized CPA firms and will include a lecture with generous time for questions and case studies.
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Online
2.0 Credits
Member Price: $99
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.
Surgent's Trump Accounts Created by OBBBA: A Comprehensive Guide for Accounting and Finance Professionals
-
Online
2.0 Credits
Member Price: $119
Many clients are asking their advisors about Trump Accounts, one of the most anticipated yet misunderstood provisions of the One Big Beautiful Bill Act (OBBBA). This program will provide practitioners with the background to be able to advise their clients regarding how Trump Accounts operate. The course will also discuss the comparison between Trump Accounts and other accounts, such as 529 Plans and Roth IRAs. In addition, coverage will be provided on how the pilot program will function to give $1,000 to newborns.
Surgent's The One Big Beautiful Bill Act (OBBBA): What You Need To Know
-
Online
4.0 Credits
Member Price: $199
Many accounting and finance practitioners have had difficulty understanding and applying the One Big Beautiful Bill Act (OBBBA). Accounting and finance practitioners are still confused and challenged by many of the new and extended tax provisions that the OBBBA delivered. Mastering these crucial provisions requires multiple exposures to these challenging tax changes. This program is a four-hour review and analysis of the most important changes from the OBBBA that impact both individual and business taxpayers. This course affords accounting and finance practitioners an opportunity to gain a broader, deeper understanding of this wide-ranging set of new tax rules, to grasp what is new and what is a continuance of prior rules, and to develop deeper planning insights into the many changes that the OBBBA contains. To the extent that the Treasury has provided guidance relating to OBBBA changes, we will discuss that guidance. We will also point out areas where Treasury guidance would be useful and areas where guidance is expected.
Surgent's Reasonable Suspicion
-
Online
1.0 Credits
Member Price: $59
Given the opioid epidemic and the legalization of medical and recreational marijuana in a growing number of states, many employers are concerned about the impact drugs and alcohol may be having on the safety and security of their workplaces. Reasonable suspicion testing is among the best ways for employers to identify whether an employee is under the influence of drugs or alcohol while working. This webinar explores what managers and supervisors need to know to implement a Reasonable Suspicion Testing Policy.