CPE Catalog & Events
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Online
2.0 Credits
Member Price: $99
How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.
Balance Sheet Management: The Least Understood Risk” 26-27
-
Online
4.0 Credits
Member Price: $99
Most organizations manage their income statement, but many virtually ignore the balance sheet until balance sheet problems create seemingly insurmountable emergencies. This session discusses how to analyze and manage your financial statements more holistically, allowing you to identify and correct balance sheet issues early. How do you choose whether to raise debt or equity" What are the key considerations and the advantages of each" What is the cost of capital" What are the "hidden" balance sheet risks" We will also examine several crucial ideas you can incorporate into your analyses to enhance performance and reduce risk. If you want to enhance your corporate finance skills, this session is for you.
Surgent's Guide to Understanding the At-Risk Basis Rules and Forms 6198 and 7203
-
Online
2.0 Credits
Member Price: $99
Many tax clients with losses from their S corporations, partnerships, and multiple-member LLCs treated as partnerships will want to use these losses to offset their other income from other sources. This program explains when, why, and how the at-risk rules apply to allow or to prevent the owner of a pass-through entity from taking a loss from a pass-through entity and using it to offset other income. This program is extremely helpful for anyone with pass-through entity clients.
Surgent's Hiring New Workers and Payroll Taxes
-
Online
2.0 Credits
Member Price: $99
When a new employee is hired, there are a lot of things the employer needs to take care of. Aside from getting employment contracts signed, training lined up, and the new hire breakfast planned, employers are tasked with making sure all of the payroll forms are filled out. For many small business owners, this can be a source of anxiety. They often wonder if they have everything they need. They also hear horror stories about potential IRS penalties for not having all of the boxes checked. In this course, we will explore the payroll compliance side of hiring new employees. From the alphabet soup of forms that need to be filled out to the initial payroll tax forms, we have you covered if you are a new practitioner or new business owner. We will even discuss the surprisingly difficult-to-navigate world of unemployment insurance.
Surgent's Current Issues in Accounting and Auditing: An Annual Update
-
Online
4.0 Credits
Member Price: $159
Designed for accounting, auditing, and attestation practitioners at all levels in public accounting and business and industry, this course provides a detailed review of the multitude of FASB and AICPA standards and reports issued over the past few years, including a discussion of the FASB's Stage 3 PIR report on ASC 606. It also provides an overview of recent PCAOB inspection report findings and SEC rulemaking activity. Through hands-on examples and illustrations, this course will help you apply the guidance in practice. We further discuss other important A&A practice matters to be aware of, including an update on the quality management standards and soon-to-be-effective requirements for engagement quality reviews.
Surgent's Basics of Employment Law for Non-HR Professionals
-
Online
4.0 Credits
Member Price: $159
Learn the basics of employment law and how they affect best practices to help control the interview and discover hidden talents of applicants.
Surgent's Achieving High Levels of Compliance and Customer Service in Your Organization
-
Online
4.0 Credits
Member Price: $159
Probably one of the greatest conflicts in an organization is determining which is more important: compliance or customer service. This program digs deeply into the issue and prepares the finance professional to achieve high levels of compliance and customer service in the department and in the entire organization. We will examine both disciplines from an analytical standpoint, proving why they are necessary for both for-profit and nonprofit organizations to achieve success.
Comprehensive FASB & AICPA Update for Tax Professionals 26-27
-
Online
6.0 Credits
Member Price: $259
This 6-hour program covers recent promulgations of the FASB and AICPA with broad applicability. In addition, the course includes the 2-hour Tax Basis Financial Statements, and 2-hour SSARS Highlight Reel, programs available as stand-alone courses.
Fundamentals of 1031 Exchanges 26-27
-
Online
8.0 Credits
Member Price: $329
Cover critical aspects, common problem areas and strategies for successful 1031 exchanges. Examine Form 8824 preparation, replacement property adjusted basis computations, advanced 1031 strategies and more. Study advanced 1031 exchange strategies such as reverse exchange, partners/TIC structures, and improvement exchanges (including "Bartell" parking arrangements). Bring questions and increase your expertise.
Surgent's Adapting to OBBBA Changes: A Strategic Review
-
Online
2.0 Credits
Member Price: $119
Accounting and finance practitioners are continually asked for strategic planning advice. In this course, we will cover topics that will make clients, and their advisors, tax smart and tax prepared for the coming year and beyond. This program is a two-hour review and analysis of what we consider some of the most important changes from the OBBBA impacting both individual and business clients.
Surgent's International Tax Challenges and Opportunities for U.S. Filers
-
Online
3.0 Credits
Member Price: $149
Globalization continues to make it easier for taxpayers to live abroad, do business in other countries, or invest in foreign enterprises. This creates significant complications and tax planning opportunities when it comes to filing U.S. tax returns. This course provides an overview of the unique tax challenges and solutions presented to U.S. expats or investors living or investing abroad. It examines how foreign-source income is taxed in the U.S. and how the tax consequences could be mitigated by applying the tax treaties, claiming credit for foreign taxes paid, or excluding foreign-earned income. Additionally, the course discusses the numerous foreign informational form reporting requirements and the significant penalties that could be imposed by the IRS. Examples from real-life client scenarios are included.
Comprehensive FASB & AICPA Update for Tax Professionals 26-27
-
Online
6.0 Credits
Member Price: $259
This 6-hour program covers recent promulgations of the FASB and AICPA with broad applicability. In addition, the course includes the 2-hour Tax Basis Financial Statements, and 2-hour SSARS Highlight Reel, programs available as stand-alone courses.
Fundamentals of 1031 Exchanges 26-27
-
Online
8.0 Credits
Member Price: $329
Cover critical aspects, common problem areas and strategies for successful 1031 exchanges. Examine Form 8824 preparation, replacement property adjusted basis computations, advanced 1031 strategies and more. Study advanced 1031 exchange strategies such as reverse exchange, partners/TIC structures, and improvement exchanges (including "Bartell" parking arrangements). Bring questions and increase your expertise.
FASB Update: What's New in Q3 - February 2027
-
Online
1.5 Credits
Member Price: $55
Stay current on FASB's activities, with this LIVE quarterly update. This course delivers an overview of Accounting Standards Updates (ASU) released over the past three months (up to the course delivery date) and addresses proposed ASUs issued and the deadline for comments. The course also covers changes to the FASB Workplan. Be sure to register for each quarterly update: FASB Update: What's New in Q1 - August 2026 FASB Update: What's New in Q2 - October 2026 FASB Update: What's New in Q3 - January 2027 FASB Update: What's New in Q4 - April 2027
Surgent's Artificial Intelligence for Accounting and Finance Professionals
-
Online
2.0 Credits
Member Price: $99
Artificial intelligence (AI) is transforming the accounting and finance profession at an unprecedented pace. What began as automation of repetitive tasks has evolved into systems capable of complex data analysis, natural language processing, and predictive modeling. Modern AI tools — such as generative AI, machine learning, and intelligent automation — are reshaping how professionals audit, forecast, analyze risk, and deliver client insights. This course provides accounting and finance professionals with a comprehensive understanding of how AI is reshaping workflows, client services, and decision-making. Participants will explore current applications of AI within firms and corporate finance, assess risks and governance considerations, and learn strategies for adapting professional roles in an increasingly automated landscape. The program also examines the emerging ethical, regulatory, and data privacy challenges associated with AI adoption.
Surgent's Understanding S Corporation Taxation: Shareholder Basis, AAA, and Retained Earnings
-
Online
2.0 Credits
Member Price: $99
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. Given the rising popularity of S corporations, understanding how shareholder basis and the equity section of the balance sheet work together for tax purposes is imperative for nearly any tax practitioner. In this course, we will discuss this relationship. Using examples and illustrations, we will show how contributions, operating transactions, and distributions affect shareholder basis as well as equity.
Surgent's Fundamentals of Public Charity Taxation and Form 990
-
Online
4.0 Credits
Member Price: $159
If you work for or with not-for-profit entities and have questions about the IRS Form 990, Return of Organization Exempt From Income Tax, and the related schedules, this is the course for you! The program focuses on common issues that professionals will likely encounter when they prepare the Form 990 and additional tax rules applicable to not-for-profits.
Surgent's IRS Tax Examinations and Hot Issues
-
Online
4.0 Credits
Member Price: $159
The IRS began replenishing its workforce with the additional funding only to have to terminate workers or lay them off due to mandated federal workforce reductions. The IRS trains its audit workforce by examining the tax returns of individuals and small businesses. As the IRS continues to examine tax returns, Accounting, Tax, and Financial Professionals need clients to understand the need for documentation and procedures to substantiate what IRS examiners are pursuing. Learn the high audit risk areas and ways to help clients survive an IRS audit with little or no change. It is critical for Accounting, Tax, and Financial Professionals in public accounting to understand the risk to clients and to themselves in tax return preparation and planning since the IRS continues to increase its audit coverage and is examining more taxpayers than it has in the recent past.
Surgent's S Corporation Taxation: Advanced Issues
-
Online
4.0 Credits
Member Price: $159
This course goes beyond the basics and addresses important practical issues that an experienced practitioner must know about S corporations.
Surgent's Understanding How the IRS Rewards Whistleblowers
-
Online
2.0 Credits
Member Price: $99
In 2006, Congress passed the Tax Relief and Health Care Act. Prior to the Act's passage, rewards to individuals who provided information to the IRS regarding tax fraud were capped at $10 million. The Tax Relief and Health Care Act authorized the IRS to create a Whistleblower Office dedicated to investigating, processing and recovering claims concerning the underpayment of taxes. Under the IRS' new program, whistleblowers may recover 15 to 30 percent of the amount collected provided the taxes and amounts in dispute exceed $2 million. If the whistleblower's claim does not meet these criteria, the IRS may still consider granting an award under its pre-2006 Tax Relief Act discretionary authority. Given the rapid growth of this program, practitioners should have a basic understanding of the procedure and content for IRS Whistleblower claims, both from the perspective of a claimant's potential to recover and a taxpayer's exposure to liability.