CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Online
2.00 Credits
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.
The Best Federal Tax Update Course by Surgent
-
Online
8.00 Credits
In this continually revised course, tax advisors will be fully updated on the most recent enacted legislation and IRS guidance, as well as major trends on the horizon with a view toward planning considerations. This update course is designed for all practitioners, both those working in public accounting as well as those in private industry, who need the latest information on tax changes. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BITU.This course qualifies for CFP credit.This course qualifies for IRS credit.
Surgent's Excel Shortcuts for Accountants
-
Online
2.00 Credits
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 Essential Multistate Tax Update
-
Online
4.00 Credits
With the largest overhaul of the federal income tax code in 30 years and the repeal of the physical presence nexus standards for sales tax in the Wayfair case, the states are working fast and furious to overhaul their tax laws. As some states scramble to fund their budgets, they continue to look for additional forms of revenue. Plan to attend this fast-paced class that covers developing topics in state taxation, ranging from individuals to pass-through entities to corporate taxpayers. This class will focus on issues of small and middle-market companies and offer guidance for minimizing tax liability and negotiating the treacherous waters of compliance.
Surgent's Top Ten Questions from Partnership Clients Regarding the Section 754 Election
-
Online
4.00 Credits
This program is an in-depth analysis of the Section 754 election and the two adjustments associated with the election under Section 743(b) and Section 734(b). The 754 election is a highly technical provision that provides great tax benefits to the owners of the partnership, and particularly in the case of Section 743(b), a new partner. This course covers the most common questions encountered by practitioners in their daily practices. The program includes a number of examples that provide insights into the mechanics of the two adjustments that follow upon a Section 754 election.This course qualifies for IRS credit.
Surgent's Introduction to Forensic Accounting
-
Online
4.00 Credits
Forensic accounting encompasses fraud investigation and prevention, as well as a wide variety of functions in litigation. Forensic accountants provide services ranging from serving as an expert witness, to litigation consultant and bankruptcy trustee. As our economy grows more complex, the need for forensic accountants grows as well. One critical role of the forensic accountant is exposing and examining financial fraud. Technology expands the way companies conduct business; however, technology also provides greater opportunities for those willing to commit fraud. Forensic accountants rely on their skills in accounting, coupled with their investigative skills, to explain to clients, courts, and jurors how fraudulent schemes occur and the effect caused by fraud. Forensic accountants also provide expert opinions in calculating damages in litigation and administering bankruptcy estates, as well as a host of other services.
Surgent's Simply Auditing Not-for-Profits Efficiently
-
Online
4.00 Credits
It's crazy to try to audit not-for-profits in the same manner that you do for-profits! The sane approach to auditing not-for-profits is to incorporate what makes them unique into the planning and performance of the audit. This course is designed to help you do just that! Obtain a superior working knowledge of auditing not-for-profit entities effectively and efficiently.This course qualifies for yellow book credit.
Surgent's Top Individual Tax Planning Strategies
-
Online
2.00 Credits
The Inflation Reduction Act (IRA) and SECURE Act 2.0 both contained tax law changes that impact many individuals in 2025 and in later years. This program covers many of these changes as well as other tax topics that continue to impact individual income taxpayers.This course qualifies for IRS credit.
Surgent's Virtual Currency: Keeping Up with the Tax Code
-
Online
2.00 Credits
Whether you are an experienced veteran or new to the industry, one of the toughest parts of being a tax practitioner is keeping up with all of the changes in tax legislation. This course takes a look at recent changes to tax law from a practitioner perspective. In this session, we will explore the nuances of virtual currency and the new Form 8300 reporting requirements.This course qualifies for IRS credit.
Surgent's What Tax Practitioners Need to Know About Medicare
-
Online
2.00 Credits
Tax advisors often receive questions concerning all facets of Medicare. How does Medicare work? How do I apply? How much does it cost? Is Medicare optional or required? This program provides a basic introduction to the Medicare program and covers many of the areas of the Medicare program that clients are most interested in. If you, or some of your clients, have questions relating to Medicare, this program is a must for you.
Surgent's Ethical Considerations for the CPA
-
Online
4.00 Credits
CPAs today face greater challenges than ever to maintain the high ethical standards of their profession. It is vitally important that all CPAs understand their professional responsibilities related to all aspects of their job. This course, which focuses on key components of the AICPA Code of Professional Conduct, reviews a history of the CPA profession and focuses on ethical requirements that CPAs must adhere to in their everyday practice, including practical examples of potential ethical dilemmas that practitioners may encounter, particularly those related to objectivity and independence. PLEASE NOTE: THIS COURSE COVERS GENERAL ETHICS AND IS APPLICABLE IN STATES IN WHICH STATE-SPECIFIC ETHICS IS NOT REQUIRED. This course does not qualify for IRS credit.
Surgent's Fraud In Single Audits
-
Online
4.00 Credits
With all the planning, procedures, and reporting involved in a single audit, sometimes things can slip through the cracks. But what if the thing that slips through is fraud? Compiled from news releases, court records, and the thrilling annals of the Federal Audit Clearinghouse, this course tells the tale of six real-world frauds which seemingly dodged detection in the single audit process. Leveraging the incredible gift of hindsight, this course is designed to raise your awareness and sharpen your focus on the potential for fraud in single audits!This course qualifies for yellow book credit.
Surgent's Controllership Skills Update: Current Survival Skills
-
Online
2.00 Credits
The role of financial professionals has and continues to change in organizations. The stereotype of collecting and reporting data has been replaced by a broader vision, which focuses on improving an organization's results today and preparing it for the future. This brief program offers specific actions that can be implemented by financial personnel to expand their role through improving their organization. The actions and techniques provided build upon and improve activities that exist in many organizations (measuring, budgeting, hiring, risk management, etc.), as well as providing insights into capital allocation, cash management, valuation techniques, variables that influence capacity levels, M&A activity and actions to increase efficiency and innovation. Updated to include the impact of regulations, additional examples of M&A, alliances and strategic spin-offs/splits, methods to improve efficiency from existing activities, the impact of COVID-19, as well as current organizational changes employed to manage and accelerate growth.
Surgent's Top 20 Effective Strategies for Avoiding RMD Mistakes and Penalties
-
Online
2.00 Credits
Required minimum distributions (RMDs) must begin for the year in which the account owner reaches age 72 (older if they were born after 1950). RMDs must also be taken from inherited accounts, and the process for determining RMDs for these accounts is more complex than those that apply to RMDs for non-inherited accounts. Failure to comply with the RMD rules will result in the account owner owing the IRS an excess accumulation penalty on any RMD shortfall. Interested parties must understand the compliance requirements that apply to RMDs to be able to assist in ensuring that penalties are avoided. Additionally, the recent changes that affect RMDs must be considered when advising clients about their RMD obligations.This course qualifies for IRS credit.
Surgent's Guide and Update to Compilations, Reviews, and Preparations
-
Online
4.00 Credits
Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-25 by the ARSC. The course will also review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARSs requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform compilation, preparation, and review engagements.
Surgent's Partnership and LLC Core Tax Issues From Formation Through Liquidation
-
Online
8.00 Credits
As staff members gain more experience, they are expected to take on more complex assignments with minimal supervision. This course is designed to be a steppingstone for staff interested in pursuing more advanced partnership and LLC issues than mere preparation. The material provides a deep life-cycle study into critical areas of formation, special allocations of income and deductions, basis calculations and implications of recourse and nonrecourse debt, basis step-up under 754 on traªnsfers of ownership interest, distributions, self-employment tax issues, and termination and liquidations of an LLC. With a blend of legal and tax ramifications regarding LLC-specific issues, this course identifies all the major areas that are potential sources of increased complexity.This course qualifies for IRS credit.
Surgent's Marijuana: A Generalized Business Viewpoint
-
Online
2.00 Credits
Each year, more states legalize cannabis (i.e., marijuana) for medical or recreational purposes. As legalization grows, so too does the cannabis industry. While some financial professionals have stayed away from this growing sector of the economy, others have embraced the opportunities the cannabis industry has to offer. The legalization of cannabis brings with it a complex regulatory landscape, which includes strict compliance with federal and state regulations. However, the complexity of this emerging market provides opportunities for accountants and other financial professionals. Behind the cannabis dispensaries are scores of related business sectors including food production, retail, farming, and chemical production, as well as facilities, design, and construction. Simply stated, the commercialization of marijuana offers financial professionals an opportunity to participate in an industry expected to reach $73 billion worldwide within six years.
Surgent's Reducing a Business Owner Client's Exposure to Social Security and Self-Employment Taxes
-
Online
2.00 Credits
Many business owner clients wish to minimize their Social Security and self-employment tax liabilities. This course provides tax practitioners with the background to understand what kinds of income constitute self-employment income and earned income. It covers strategies that can be used to reduce clients' exposure to the self-employment tax and Social Security tax.This course qualifies for IRS credit.
Surgent's Schedules K-2 and K-3: Filing Requirements
-
Online
2.00 Credits
Many partnerships and S corporations are now required to complete the voluminous Schedules K-2 and K-3 to report foreign-related tax information. Updated for the 2024 tax year, this course is an essential guide for tax preparers on how to identify which entities need to complete these schedules and how to identify which parts are applicable to a given taxpayer. The filing requirements are broad and often not very intuitive, catching many practitioners unaware that more schedules and parts are applicable to more taxpayers than anticipated. This course includes a deep dive into the domestic filing exception, a discussion of filing requirements of each part of Schedule K-2, and numerous examples of common taxpayer scenarios. Please note: Surgent also offers a companion course, "Schedules K-2 and K-3: Preparation of Forms" (KPF2).This course qualifies for IRS credit.
Surgent's Understanding S Corporation Taxation: Compensation Issues and Entity-Level Taxes
-
Online
2.00 Credits
Even though they have been around for several years, the tax laws pertaining to S corporations remain some of the more difficult areas of the Internal Revenue Code. In this course, we will examine how S corporations break away from the normal tax rules for flow-through entities. We will explore which employee benefits are disallowed for S corporation shareholders, as well as which taxes are assessed at the entity level. Finally, we will discuss how state level taxation may have changed permanently with the addition of PTE elections.This course qualifies for IRS credit.