(SSTX571/26) Surgent's Advanced Trust Issues: A Roadmap for Success in An Increasingly Complex Area
2026-06-30 12:00 (America/Detroit)
Event Description
Trusts are not cookie-cutter documents. In fact, they can be rather unwieldy, especially in explaining the functions to a client and then having the client comply with the trust terms. This course delves into best practices. Given common scenarios, what are the best trusts to use? And how can the client be best protected?
Designed For
Tax practitioners who advise clients on the benefits of establishing a trust
Objectives
Advise individual clients on the benefits of using a trust to achieve their personal goals Save clients money in their estate planning
Major Subjects
Key concepts of trusts, including recent trends; best practices; jurisdiction; and ways to avoid pitfalls Decanting Federal estate tax exemption and remaining relevance of trusts Irrevocable life insurance trusts The role of family dynamics Choice of trustee and other fiduciaries State trust-friendly considerations Charitable trusts Delaware Statutory Trusts Powers of attorne; Pet Trusts the emerging necessities State, county, and local issues Portability QTIP issues Creditor considerations Potential IRA problems Problems with re-titling assets
Instructions
None

(SSOT442/26) Surgent's Securing a Comfortable Retirement in the Age of Spending
2026-06-30 12:00
Event Description
This course gives CPAs the knowledge to help their clients plan for retirement by evaluating how much retirement income will be required and strategizing about how to reach retirement goals.
Designed For
CPAs looking to advise clients on retirement planning, and CPAs looking for effective strategies for their own retirement
Objectives
Help clients determine how much retirement income is necessary for the desired retirement lifestyle Identify resources available for retirement Explain how budgeting can determine retirement resources Understand how to build the three-legged retirement stool through employer retirement, savings, and Social Security Understand the need for Plan B when the ideal retirement goal is not achievable Explain ways that clients can convert the equity in a home to retirement income Explain how the value of a small business can be converted to retirement income Explain survival possibilities and how first-to-die and last-to-die survival probabilities are used in retirement planning for married couples Understand timing regarding the use of taxable retirement funds and nontaxable funds, as well as strategies to minimize income tax on Social Security Recognize the role of various investment types, such as life insurance, annuities, mutual funds, equity holdings, and bonds in retirement planning Summarize key points of recent research on the sustainability of retirement income and maintenance of desired retirement lifestyles
Major Subjects
Retirement planning using variables such as desired lifestyle, travel plans, housing plans, medical needs, and family needs to customize a retirement plan unique to the client Using a residence and other real estate as retirement assets through equity and rent Using a small business as a retirement resource through creative retirement plans Overview of asset allocation, portfolio management, portfolio rebalancing, and investment selection concepts, before and after retirement The three-legged retirement stool: employer retirement, savings, and Social Security Planning with the new retirement provisions of SECURE Act 2.0 Distribution/asset liquidation planning Analysis of the most current/important research on retirement planning and sustaining retirement income levels
Instructions
None

(SSTE407/26) Surgent's Data Analytics Readiness Series: Visualizations and Reporting
2026-06-30 12:00
Event Description
This one-hour course will serve as an introduction to data visualization and reporting using Power BI and Excel. Users will understand the benefits of using Power BI to create data visualizations and how Power BI differs from previous functions in Excel for visualizations. A hands-on exercise will be applied where the user will work alongside the instructor to create dashboarding for journal entry testing. Specific focus will be on the relation among various tools for data analytics: Power Query, Power Pivot, PivotTables, DAX formulas, and storyboarding.This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ.
Designed For
Accountants who want to transition to data analysis and have a basic knowledge of Excel and Excel formulas
Objectives
Understand the applicable Excel skills that will be required in making the transition to data analyst; Understand what data visualization tools are available in Excel and Power BI and how they are superior to previous Excel tools Apply skills learned to create a dashboard for journal entry testing data Apply skills to present the output of analytical modeling in an easy to interpret form and evaluate the output of the analytics Be able to use the camera tool in Power BI to create dashboards
Major Subjects
Visualization tools in Excel (camera, slicers, and timelines) Data view- why it went away. Power BI is the visualization tool to use All concepts learned in course are brought together in this last class to create a dashboard: Power Query- to extract transform and load data for the dashboard Power Pivot -to create the data model for the dashboard DAX formulas- for pivot tables to calculate values needed for model Pivot tables and charts- to create visualizations Camera tool to create dashboard Exercise- Using the data analytics workflow introduced in first class of series- to create dashboard for JE testing Journal entry by month and income statement accounts Descriptive statistics of journal entries Number of journal entry by month Journal entries by day of week Round journal entries Evaluate output of journal entry analytic Other approaches What are the false positives (noise)? Next steps in data analytics journey
Instructions
Install Power Pivot and Data Analysis ToolPak

(SSTX554/26) Surgent's Advanced Individual Income Tax Return Issues
2026-06-30 12:00
Event Description
Most accounting and financial professionals have been preparing individual income tax returns for years, and while many of the returns are easy, there are always a number of issues that come up in busy season of which experienced practitioners wish they had more knowledge. This course is designed to explore the tough tax issues for experienced practitioners and help them provide better planning strategies and results for their higher income clients.
Designed For
Experienced Accounting and Financial Professionals who want and need an in-depth knowledge of the most difficult individual-income-tax-return issues
Objectives
Understand the basics of Section 199A Understand how to properly report advanced transactions in financial instruments and investments Understand the special problems and new issues for the current return Identify the causes of alternative minimum tax liability and what can be done to reduce or eliminate it
Major Subjects
New issues for the current year tax return and Section 199A Installment sales – understanding the complicated issues Form 8582: Passive losses with carryovers – Complicated case with filled-in forms Puts, calls, straddling, and unusual investments – Understanding the tax laws and reporting them correctly on the tax return Capital gain and loss issues – The problem with proper reporting of installment sales issues; capital gains and losses; when is a stock worthless; and much more At-risk rules: What a return preparer really needs to know Passive loss issues – You can’t just trust your software. What to watch out for and the questions you need your clients to answer in order to do it right! Incentive and nonqualified stock options – Reporting; key strategies for planning; dealing with the alternative minimum tax Alternative minimum tax – Understanding it; planning strategies to avoid it; using the minimum tax credit; explaining it to a client Form 6251: Detailed calculation example
Instructions
None

(SSTX593/26) Surgent's Weekly Expert Hour (Original Air Date: 8/05/21)
2026-06-30 12:00
Event Description
As financial and tax professionals well know, information overload is a constant struggle we face because things change quickly, and the sheer number of changes being made on a daily basis is enormous. Of great importance to small and medium tax and advisory firms is differentiating between changes that are relevant to our practice and our clients and changes that are new but totally irrelevant. Distinguishing between the two is difficult and time-consuming. Mike Tucker and a team of experts are pleased to announce a new weekly series designed to eliminate the clutter and get you what you need to stay up to date and perform for your clients. We are all aware that the IRS, along with other state and federal regulators, is issuing guidance with increased frequency due to the coronavirus pandemic tax changes. New rules need to be analyzed, dissected, and explained more quickly than in days gone by so that our clients are kept informed of opportunities that may not last long. This weekly series will provide relevant and important tax and financial changes in a quick, concise format. Each week, Mike and his co-presenters will dispense news on current events impacting taxes, finance, and industry. The subject matter will differ each week and intermittently include topics such as Social Security and Medicare. The panelists will discuss personal and corporate tax matters as well as other late-breaking news related to practitioners’ personal finances and those of their clients.Every financial professional will benefit from this series. Please Note: CFP credit is not available for this course in 2021.
Designed For
Financial professionals who wish to be up to speed on the latest news affecting themselves and their clients
Objectives
Be well informed on current topics impacting taxes, finance, and industry
Major Subjects
Tax basis capital account reporting required for 2020 and after Tax Pro Account QR codes attached to IRS notices 1031 exchanges
Instructions
None

(SSTE409/26) Surgent's Data Analytics Readiness Series: Data Preparation Using Get and Transform
2026-06-30 12:00
Event Description
In this one-hour course, users will learn to apply Power Query to extract, transform, and load data for analysis. Users will learn how to manipulate data once it is loaded into the platform and will practice the manipulation during the course. Using the same data as the instructor, users will perform an exercise to clean and transform a basic general ledger with an emphasis on preparing the data for analysis. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ.
Designed For
Accountants who want to transition to data analysis and have a basic knowledge of Excel and Excel formulas
Objectives
Understand the applicable Excel skills that will be required in making the transition to data analyst Apply Power Query to extract, transform, and load (ETL) data Understand and apply the basics of data cleaning Understand what M Code is and how it is used Apply ETL processes to a dataset
Major Subjects
An ETL tool- Extract Transform and Load How Power Query ups your game in data analytics Interface components of Power Query Column level and table actions Power Query is a sequential macro recorder What is M Code? Exercise- cleaning and transforming a general ledger
Instructions
Install Power Pivot and Data Analysis ToolPak

(SSTX589/26) Surgent's Weekly Expert Hour (Original Air Date: 9/02/21)
2026-06-30 12:00
Event Description
As financial and tax professionals well know, information overload is a constant struggle we face because things change quickly, and the sheer number of changes being made on a daily basis is enormous. Of great importance to small and medium tax and advisory firms is differentiating between changes that are relevant to our practice and our clients and changes that are new but totally irrelevant. Distinguishing between the two is difficult and time-consuming. Mike Tucker and a team of experts are pleased to announce a new weekly series designed to eliminate the clutter and get you what you need to stay up to date and perform for your clients. We are all aware that the IRS, along with other state and federal regulators, is issuing guidance with increased frequency due to the coronavirus pandemic tax changes. New rules need to be analyzed, dissected, and explained more quickly than in days gone by so that our clients are kept informed of opportunities that may not last long. This weekly series will provide relevant and important tax and financial changes in a quick, concise format. Each week, Mike and his co-presenters will dispense news on current events impacting taxes, finance, and industry. The subject matter will differ each week and intermittently include topics such as Social Security and Medicare. The panelists will discuss personal and corporate tax matters as well as other late-breaking news related to practitioners’ personal finances and those of their clients.Every financial professional will benefit from this series. Please Note: CFP credit is not available for this course in 2021.
Designed For
Financial professionals who wish to be up to speed on the latest news affecting themselves and their clients
Objectives
Be well informed on current topics impacting taxes, finance, and industry
Major Subjects
S corporation PPP loan forgiveness Tax issues related to remote workers Family offices: an overview Investing in bitcoin and cryptocurrency
Instructions
None

(SSOT402/26) Surgent's Coaching Skills for Managers and Supervisors
2026-06-30 12:00
Event Description
This one-day course will teach effective skills for coaching and training employees. You’ll learn how to identify the characteristics of effective coaches and develop coaching strategies to support and assist your team, with the goal of helping them improve morale, productivity and quality. And, you’ll learn a five-step approach for giving constructive criticism while managing defensive reactions. (Please Note: This module is part of Surgent’s Audit Skills Training: Level 5.)
Designed For
Employees identified for advancement, team leads, supervisors, and managers
Objectives
Identify effective coaches and develop coaching strategies to support your team Give constructive criticism while managing defensive reactions
Major Subjects
The definition of coaching and the coaching process Characteristics of effective coaches Coaching strategies to support and assist others as they change ineffective behaviors Conducting one-on-one coaching sessions for setting goals and improving performance
Instructions
None

(SSAA411/26) Surgent's A Guide to Auditing Common Investments
2026-06-30 12:00
Event Description
Many small- and mid-size entities hold fewer complex investments including alternative investments. This module will provide an overview for evaluating the proper recognition, measurement, and disclosure of common investment types as well as how to audit them. Derivatives and other more complex investments will be discussed in another module. (Please Note: This module is part of Surgent’s Audit Skills Training: Level 2.)
Designed For
Accountants responsible for accounting for or auditing fewer complex investments, including alternative investments.
Objectives
Identify the proper accounting for common investments Explain audit risks associated with auditing common investments Discuss how to tailor the audit plan to assessed risks of material misstatement Explain fair value; and other presentation and disclosure requirements
Major Subjects
Overview of common investment types Typical audit risks and related audit procedures Alternative Investments Fair value disclosure, including applying the fair value hierarchy
Instructions
None

(SSAA438/26) Surgent's Financial Reporting Update for Tax Practitioners
2026-06-30 12:00
Event Description
Tax advisors will be updated on the most recently enacted legislation and IRS guidance as well as updates of recent standard-setting activities at the FASB and AICPA. To start, the course will review the significant tax, financial accounting, auditing, accounting services, and ethics guidance issued by standard setters over the past few years. The course will also focus on the unique income tax reporting implications of recently issued accounting standards, such as leases (ASC 842) and credit losses (ASC 326). The course then discusses the preparation of tax-basis financial statements. Lastly, the course will dive into the unique income tax accounting considerations which arise from certain types of transactions, such as stock-based compensation, and review the presentation and disclosure requirements of ASC 740.
Designed For
All tax practitioners desiring to remain up-to-date on recent accounting, reporting, and compilation and review activities
Objectives
Recall recent legislation with income tax implications Recognize recently issued Accounting Standards Updates (ASUs) Understand updates to ASC 842 and ASC 326 Identify financial statement presentation and disclosure requirements under ASC 740 Remember significant standards issued by the AICPA
Major Subjects
Recent standard setting and consulting activities at the FASB Proposed updates to income tax accounting and financial statement disclosures Tax basis financial statements Recently issued Statements on Auditing Standards and other audit-related hot topics
Instructions
None

(SSTX551/26) Surgent's Social Security and Medicare: Planning for You and Your Clients
2026-06-30 12:00
Event Description
Social Security seems poised for changes in benefits and eligibility age. The leading edge of the baby boomer generation has already reached retirement age. Financial and tax planners can expect increased demand for strategies that dovetail Social Security with other retirement and estate planning objectives. This course provides tax and financial planning professionals with both the background information on the Social Security system and the strategies clients will need in dealing with Social Security, and the myriad other related retirement planning issues.
Designed For
Practitioners who have clients contemplating receipt of Social Security
Objectives
Identify who is entitled to retirement benefits and in what amounts Identify factors to consider in determining when to take benefits Discuss taxation of Social Security benefits and how this impacts other income tax planning Identify and describe the potential effects of retirement and estate planning strategies and tactics that can enhance overall retirement Explain Medicare and the prescription drug provision; describe the basic supplementary insurance plans that are available to fill in the gaps in basic Medicare coverage
Major Subjects
Legislative developments A full chapter devoted to determining the best planning options for maximizing joint Social Security benefits Retirement benefits: Amount of benefits in various circumstances; how the amounts are distributed within the family unit Qualification: Has the client retired? How business entities may be used for Social Security advantage Income taxation of Social Security: avoidance tactics Spousal benefits: Should a spouse return to work? What benefits does a spouse have and when and how do they relate to benefits decisions by the client? When can hiring the spouse increase overall benefits; Why should both spouses qualify for survivor benefits? Disability benefits When to start Social Security benefits: Advantages and disadvantages at ages 62, full retirement age, and 70 Coordinating benefits: Should you take Social Security first and higher-balance IRA distributions later, or take IRA balances first and enhanced Social Security benefits later? Pensions: Distribution strategies; how to use the minimum distribution rules in concert with Social Security benefits IRAs: Is it time to convert to a Roth? Medicare, Part D prescription drugs: what retirees need to know
Instructions
None

(SSMG428/26) Surgent's Starting a Small Business: What Every Trusted Advisor and Entrepreneur Needs to Know
2026-06-30 12:00
Event Description
Starting and owning a small business has often been referred to as the “Third Pillar of Wealth,” right behind investments and owning real estate. Essentially, all businesses start off as “small businesses.” Small businesses, however, require a large amount of preparation in order to successfully launch and grow. Starting a business requires the owners and managers to address a host of issues, including an understanding of applicable laws, appropriate financing, staffing requirements, marketing, liability protection, and many more.This course provides a broad overview of the critical issues business owners, as well as their professional advisors, must consider when starting and growing a small business. There is extensive research regarding best practices in this area, and this webinar is intended to distill down such information and focus on what is critical to get a small business up and running as seamlessly as possible.
Designed For
Anyone in the accounting or financial services profession who seeks to understand proven strategies to establish and grow a small business or who counsels individuals who own, or are considering owning, a small business
Objectives
Understand how to successfully start and grow a small business or advise clients who are starting a small business Understand basic legal issues that need to be addressed when forming a business Explore marketing and financing plans to launch and develop a business Recognize ways to protect business assets and owners from different forms of liability
Major Subjects
Understanding the time commitment required to start and run a business Selecting a corporate structure to protect your personal assets Building your product or service Sales and marketing in your business Establishing your owners, investors, managers, and employees Accounting, recording-keeping, and other software programs Leases, contracts, and employee agreements Protecting intellectual property Insurance Business plans Financing Market position
Instructions
None

(SSAA445/26) Surgent's Accounting for Guarantees
2026-06-30 12:00
Event Description
Guarantees are often included within certain purchase agreements, sales agreements, commercial agreements, and many other types of agreements. This course provides an overview of the accounting, reporting, and disclosure requirements related to guarantees. The U.S. GAAP guidance related to guarantees is prescribed by ASC Topic 460.
Designed For
CPAs in need of an overview of the accounting, reporting, and disclosure requirements related to guarantees.
Objectives
Identify the primary types of guarantees Recognize the guarantees that are within the scope of ASC Topic 460 Identify the recognition, measurement, and subsequent measurement requirements of guarantees Recognize key disclosure requirements for guarantees
Major Subjects
Overview of the accounting related to guarantees Review of the reporting related to guarantees Examination of the disclosure requirements related to guarantees
Instructions
None

(SSTX547/26) Surgent's Forms 1120-S and 1065 Return Review Boot Camp for New and Experienced Reviewers
2026-06-30 12:00
Event Description
Most review techniques developed by professionals are self-taught and fine-tuned via experience. Yet how does one start? The purpose of this course is to give both new and seasoned reviewers additional and advanced procedures via a multitude of checklists to more thoroughly review S corporation and partnership tax returns. Its emphasis is not planning; rather, it is to develop a strategy to properly review a return effectively and thoroughly. The course includes dozens of “practice tips for new reviewers” and is updated for impacts of newly enacted legislation.
Designed For
Senior-level staff new to the review process or experienced staff members looking to update and/or expand their review procedures
Objectives
Expand the process involved in reviewing applicable tax returns Identify the most common areas that result in errors Document a review, including consideration of risk management
Major Subjects
Reviews of portions of error-prone staff-prepared Forms 1120-S and 1065 from client-provided information What are common errors preparers make and what are the areas generating malpractice claims? Initial administrative groundwork The importance of Schedule M-1. Learn how various schedules are related and learn how to self-review Reporting requirements and filing exceptions for Schedules K-2 and K-3 Don’t fall prey to reporting oddities When can seemingly separately stated Schedule K items actually be trade or business items to report on Forms 1120-S or 1065? Form 1120-S What exactly is terminating S elections today? How do I recognize a second class of stock? Maintaining shareholder basis schedules; beware of final IRS regulations regarding open debt; the default method of calculating basis versus the election under Section 1367; can an S corporation distribute earnings and profits from C corporation years? Form 1065 New tax reporting requirement for partners’ capital balances Why use Section 704(b) to maintain capital accounts; Section 704(c) regulations for preventing the shifting of tax consequences among partners or members; allocating recourse, nonrecourse, and qualified nonrecourse debt; a review of Section 754 step-up in basis rules Multiple checklists of efficient procedures to identify potential issues on an 1120-S or 1065 tax return
Instructions
None

(SSTX562/26) Surgent's Comprehensive Guide to Tax Depreciation, Expensing, and Property Transactions
2026-06-30 12:00
Event Description
With a greater-than-ever 179 deduction boosted by additional first-year depreciation and pandemic-related business-friendly provisions, these are unprecedented times for businesses to make major asset investments.From the most-up-to-date depreciation regulations to inflation adjustments and technical corrections, this course will help you navigate the complex maze of rules dealing with depreciation, amortization, and sales of property. This reference manual contains a wide range of case types and examples, covering common and uncommon situations to illustrate the most important points CPAs need to be aware of.
Designed For
CPAs in industry and public accounting who need a thorough grasp of this important area of tax law and who want to maximize the possible tax savings for their clients
Objectives
Understand which assets are subject to depreciation Answer advanced Section 179 and automobile depreciation questions Fully understand depreciation and MACRS cost recovery Understand installment sales and reacquisitions Complete cases related to depreciation and sales of assets
Major Subjects
Final regulations bonus depreciation and Section 1031 exchanges Technical correction Rev. Proc. 2019-13 use it or stand to lose second-year depreciation deductions for luxury automobiles What are the components for real estate depreciation? A new SUV or sedan? A study of depreciation alternatives Permanency in Section 179 depreciation rules? How to maximize its use; when to use it; and what property qualifies Sale of property and the depreciation recapture rules (Sections 1245, Section 1250, unrecaptured Section 1250 gain for real estate, Section 291 for corporations) How to depreciate like-kind exchange property May Section 121 and Section 1031 apply to the same transfer of property? Reacquired installment sale property calculating potential gain and new basis Understanding Section 197 amortization issues; how to handle intangible asset costs Depreciation issues, tax-deferred exchanges, personal property converted to business property, and an overview of home sale exclusion Guide for compliance and planning issues Cases and rulings of depreciation and amortization issues and how they impact clients, along with the useful planning opportunities
Instructions
None

(SSTX495/26) Surgent's Multistate Tax Update
2026-06-30 12:00
Event Description
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. You can’t afford to ignore recent changes in state and local tax. Even tax-savvy businesses and their advisers often neglect to consider the consequences of state and local taxes. Multistate taxation is more complex and demanding than ever before. In addition to having their own unique tax laws, states have been more focused on enforcement. 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.
Designed For
Accountants who want an update on current multistate tax issues to minimize clients’ potential state and local tax liability
Objectives
Understand changes in state statutes, regulations and case law Determine how the states will treat changes under the Tax Cuts and Jobs Act Identify areas that may require additional attention for state tax planning purposes Identify areas that may be costly for employers or clients Understand the who, what, when, and where of nexus for income and sales tax
Major Subjects
The domicile dilemma: Issues for individuals with homes in multiple states; traveling employees; where to withhold? Emerging sales tax topics: Elimination of the physical presence standard in determining nexus (Wayfair case); economic nexus for remote sellers; assisting remote sellers in determining a plan of action in states that enforce economic nexus Emerging compliance issues in the new sales tax economy Income Tax (and other forms of tax): Economic nexus (taxation without physical presence) Will states shift away from income tax and increase reliance on sales tax after Wayfair? Treatment of Tax Cuts and Jobs Act by the states: Attributional and agency nexus; presence of intangible property; is P.L. 86-272 still valid? Income-tax apportionment issues: Prevalence of the single sales factor; determining the type of property being sold; sourcing of income from intangible property and services; sourcing of service income; Market Based versus Cost of Performance Pass-through problems: Nexus issues for interest owners Treatment of the 199A deduction for pass through entities by states: Withholding issues; sourcing of income; taxation at the entity level Practical considerations in dealing with multistate taxation: Dealing with state nexus questionnaires When to consider voluntary compliance: Responsibility of officers, members, partners, and shareholders; planning ideas and opportunities; updates on pending federal legislation relative to state tax
Instructions
None

(SSTX543/26) Surgent's Buying and Selling a Business: Tax and Structuring Overview
2026-06-30 12:00
Event Description
One of the major transactions CPA clients are faced with is the purchase or disposition of a business. To help tax professionals advise those clients, this course offers a comprehensive analysis of the business and tax aspects of buying and selling a business. It is a practical guide to help practitioners and industry CPAs understand structuring techniques. All CPAs, including controllers and executives in industry, should understand how difficult the process of buying and selling a business has become.
Designed For
All practitioners who will be involved in the sale of a business
Objectives
Understand the CPA’s role in the beginning of the transaction and throughout the process Identify the different tax consequences for various forms of acquired businesses Identify the tax consequences for sellers of various forms of businesses, including the impact of the net investment income tax (NIIT) and the Section 199A pass-through deduction Appreciate Section 338 and Section 338(h)(10) elections and the benefits of installment sales Understand the impact of Sections 751, 743, 734, and 754 on the purchase or sale of a partnership
Major Subjects
An overview of the beginning of the process and documents for preliminary tax planning Recognizing the need for due diligence in acquisitions, including checklists of important points Deemed asset sales Section 338 and Section 338(h)(10) The impact of the Section 197 amortizable intangibles regulations on the acquisition and disposition of a business Allocating purchase price for tax advantage Planning to avoid double taxation under the repeal of the General Utilities doctrine Special problems and opportunities when an S corporation is the buyer or seller Installment sale and interest issues Avoiding tax pitfalls and recognizing tax planning opportunities Unique issues in buying and selling LLC/partnership interests Impact of the net investment income tax (NIIT) and the Section 199A pass-through deduction on the tax due on the sale of a pass-through entity Individually owned goodwill
Instructions
None

(SSTE459/26) Surgent's Mastering the Excel Lookup Functions
2026-06-30 12:00
Event Description
In today’s data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel’s lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you’re a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel’s full potential, this course is tailored to meet your learning needs.
Designed For
Any Excel user that wants to learn how to use the LOOKUP functions
Objectives
Identify which lookup function works for your needs Distinguish between the many lookup functions Recall how to effectively utilize Excel’s lookup functions
Major Subjects
A review of the various lookup functions, beyond VLOOKUP Which lookup works best for your situation? How to apply the many lookup functions Advanced lookup techniques like nested lookups, approximate matching, and handling errors effectively An in-depth review of the following functions: VLOOKUP/HLOOKUP, XLOOKUP, MATCH / INDEX, XMATCH, INDIRECT, FILTER, SORT/SORTBY, UNIQUE An overview of some newer functions
Instructions
None

(SSAA422/26) Surgent's Performing Effective Accounting Research
2026-06-30 12:00
Event Description
Financial accounting can be complex. An integral part of a senior associate’s job responsibilities is to perform effective and efficient research using the FASB’s Accounting Standards Codification (ASC). In this session, participants will be introduced to the ASC, including how it is structured, organized, and updated. They will also learn about other information that can be accessed from the ASC. Next, the session will cover best practices for effective research using the ASC, including the ASC’s search functionality and other tools that will make accounting research easier to perform. (Please Note: This module is part of Surgent’s Audit Skills Training: Level 4.)
Designed For
Accountants with several years in the auditing profession
Objectives
Determine the sources of authoritative U.S. GAAP Recall FASB Research and information sources Identify the structure of the Accounting Standards Codification Recall how to perform research with the ASC
Major Subjects
Structure of the ASC codification Content included and not included in the ASC Other information contained in the codification Best practices for performing effective and efficient accounting research
Instructions
None

(SSTX470/26) Surgent's Individual and Financial-Planning Tax Camp
2026-06-30 12:00
Event Description
Each year brings its own set of tax planning challenges, and this year is no exception. This course aims to arm tax planners with planning strategies and ideas that all clients, but in particular, wealthy clients, middle-income clients, and closely held business owners need to consider right now to take advantage of present opportunities and plan for future tax advantages. Learn strategies that can really have an impact on client lives, while also bringing value to you and your firm. This material is continuously updated for recent legislation impacting individual taxpayers.
Designed For
Those involved in tax planning for individuals, including those who may be partners or shareholders
Objectives
Mine a tax return for tax planning with a client Understand the planning implications of the current environment Determine the best tax strategies for retirement Understand tax planning for the middle-income client
Major Subjects
Comprehensive coverage of the SECURE Act 2.0 Understanding the environment: what’s new, what’s expired or expiring, and what’s likely to change Reading a tax return for developing client-specific tax strategies Changes to the lifetime estate tax exemption in light of proposed regulations The net investment income tax: planning for compliance Family income-splitting strategies that need to be considered Income tax issues: impact on timing of other income Selling a principal residence Two principal residences at the same time Use of life insurance to protect families: Whole Life Insurance, Term Life Insurance, Universal Life Insurance, and Variable Life Insurance Using Roth IRAs and Roth contribution programs to best advantage Conversions: do they still make sense? Taking distributions: matching timing to client requirements Qualified plan contributions to reduce current income and Social Security tax: implications for business owners and self-employed Social Security solvency issues Incentive Stock Options and Employee Stock Purchase Plan considerations What to do about itemized deductions Trans-generational planning: conversions, income, and gain-splitting Tax benefits of HSAs and other tax-advantaged accounts Identifying tax opportunities: reviewing the prior-year return to develop a plan for the future Planning for middle-income taxpayers: financial planning for the young, the working, and those approaching or in retirement Best financial planning ideas for young people
Instructions
None

(SSTX492/26) Surgent's Multistate Income Tax Issues
2026-06-30 12:00
Event Description
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 the area of nexus. Learn how nexus requirements have changed and where the state laws may be heading in the future.
Designed For
Accountants who want an update on current multistate tax issues to minimize clients’ potential state and local tax liability
Objectives
Identify changes in state statutes, regulations and case law Determine how the states will treat changes under the Tax Cuts and Jobs Act Recognize areas that may require additional attention for state tax planning purposes Recall areas that may be costly for employers or clients Recognize the who, what, when, and where of nexus for income and sales tax
Major Subjects
Emerging sales tax topics: Elimination of the physical presence standard in determining nexus (Wayfair case); economic nexus for remote sellers; assisting remote sellers in determining a plan of action in states that enforce economic nexus Emerging compliance issues in the new sales tax economy Income Tax (and other forms of tax): Economic nexus (taxation without physical presence) Will states shift away from income tax and increase reliance on sales tax after Wayfair? Treatment of Tax Cuts and Jobs Act by the states: presence of intangible property; is P.L. 86-272 still valid? When to consider voluntary compliance even though the laws do not dictate a sales tax responsibility
Instructions
None

(SSTE446/26) Surgent's Power Query Series: More Transformations and Load Options
2026-06-30 12:00
Event Description
Power Query (Excel version) offers a wide range of transformation options. This course uses hands-on exercises to explore the data transformation process, focusing on data cleaning and data enrichment. In addition, this course explains query loading options and processes. Power Query is an “ETL” tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the sixth in a twelve-part series, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query.
Designed For
Excel users who want to develop data analytics skills
Objectives
Understand loading options in Power Query Apply the data transformation process in Power Query
Major Subjects
Workflow of the data transformation for a general ledger with sub-accounts Loading a query Loading options for a query Changing the load destination of a query Hands-on examples: flattening a general ledger with sub-accounts; making a connection to the data source; reviewing and documenting the steps created by Power Query
Instructions
Save all data sets provided to a central location on your computer

(SSTX424/26) Surgent's Federal Tax Update
2026-06-30 12:00
Event Description
Both businesses and individual clients face major changes as a result of new legislation, and tax professionals face the considerable challenge of delivering effective planning advice and services to address this myriad of recent developments. This course addresses this challenge and also encompasses the latest cases and rulings applicable to individual and business clients. Continually updated to reflect enacted legislation. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BIT4.
Designed For
Accounting and Finance Professionals who need to know the latest tax law changes in all areas of practice
Objectives
Understand strategies and techniques to use in light of new legislation Understand the latest enacted tax law changes Understand current cases and rulings affecting your clients
Major Subjects
Digital assets and tax implications – understand the new Form 1099-DA for reporting digital asset transactions, along with updated IRS guidance on cryptocurrencies, NFTs, and broker responsibilities Artificial intelligence – discover how AI and generative tools are transforming tax practices, as well as how the IRS is leveraging AI to enhance audit selection Form 1099-K reporting requirements – understand the evolving IRS thresholds and rules for third-party payment platforms The Gig Economy – examine key tax implications for gig workers, including Independent Contractor vs. Employee classification challenges, reporting responsibilities, and the impact of the 2024 Department of Labor Final Rule on worker status Timely coverage of breaking tax legislation Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas
Instructions
None

(SSOT443/26) Surgent's Controller/CFO Update: Hot Topics Facing Today's Financial Professional
2026-06-30 12:00
Event Description
In today’s rapidly changing world, finance professionals are required to wear many hats and are often the keys to the success of the organization. On one hand, they need to be abreast of the latest proven financial skills for making the best decisions, and on the other hand they need the best skills to motivate, manage, and lead people. Being pigeon-holed into one area or another is neither good for career building nor good for the organization. We’ll cover the latest issues that all CFOs and controllers need to know about and provide how-to guidance to allow for immediate use in their organizations.
Designed For
CFOs, controllers, and finance professionals
Objectives
Understand the current issues and latest trends impacting CFOs, controllers, and finance professionals Understand how domestic and global economic conditions could impact an organization Apply what we have learned from recent economic and political changes to have a positive impact on an organization Be familiar with the results of the case studies and exercises that reinforce key learning points throughout the course
Major Subjects
Economic update Leadership and management changes as a result of the pandemic Managing for productivity Metrics and benchmarking Social media’s place in our organizations
Instructions
None

(SSAA449/26) Surgent's Going Concern Accounting and Reporting Considerations
2026-06-30 12:00
Event Description
This course will review the relevant considerations related to going concern, including assessing when substantial doubt concerning an entity’s ability to continue as a going concern exists, management mitigation efforts, and required disclosures both when management, and the accountant, feel such efforts will be effective in mitigating the risk, as well as when they do not. Lastly, we’ll consider the accountant’s reporting responsibilities under various scopes of services in various scenarios and how to audit this often-contentious topic.
Designed For
Accounting and auditing practitioners assisting in the preparation of financial statements
Objectives
Differentiate between the external accountant’s and management’s responsibility related to identifying, evaluating, presenting, and disclosing going concern uncertainty Discuss how to obtain sufficient appropriate evidence to evaluate management’s assertions about an entity’s ability to continue as a going concern for a reasonable period of time Describe the independent accountant’s reporting options under applicable auditing and other professional services standards when uncertainty associated with going concern exists
Major Subjects
Current FASB accounting standards related to going concern, including the new requirements of ASU 2014-15 Evaluating risk of material misstatement in financial reports related to improper presentation and disclosure of going concern uncertainty The responsibility of an independent accountant for evaluating going concern uncertainty under various levels of engagement to perform attest and nonattest services New requirements of SAS No. 132 and SSARS No. 24 related to an auditor’s responsibility for considering going concern uncertainty?
Instructions
None

(SSAA425/26) Surgent's SAS 134 and Other Reporting Considerations
2026-06-30 12:00
Event Description
For all the work performed on the audit, the one thing that the public sees is the auditor’s report. So we need to make sure that the opinion is correct. With the effective date of SAS 134, the auditor’s report underwent significant changes. This session will cover the format of the revised auditor’s report and discuss the responsibilities of both management and the auditors which are now explicitly identified in the revised report. The session will also cover other conforming changes made to the auditor’s report with the effective date of SAS 137-140.Lastly, the session will address both when, and how, the auditor would issue qualified and adverse opinions and when the auditor would disclaim an opinion. The session will also address when the auditor is required to add either an Emphasis of Matter or Other Matter paragraph and its contents. (Please Note: This module is part of Surgent’s Audit Skills Training: Level 4.)
Designed For
Accountants with several years in the auditing profession
Objectives
Identify key changes to auditor’s reporting with the effective dates of SASs 134-140 Identify circumstances when the auditor would issue an other than unqualified report Recall when an auditor would issue a qualified auditor’s opinion and its wording Recall the appropriate wording and location of emphasis of matter and Other Matter paragraphs
Major Subjects
Revised format of audit opinion under SAS 134 Additional responsibilities of both management and the auditors under SAS 134 Additional requirements related to SASs 135-140 Qualified auditor reports, their wording, and when the auditor would issue one of them Circumstances requiring the addition of Emphasis of Matter and Other Matter paragraphs to the standard unqualified audit report
Instructions
None

(SSAA421/26) Surgent's Accounting for and Auditing Complex Investments
2026-06-30 12:00
Event Description
As companies look for greater investment returns in the current low interest rate environment, they are often investing in more risky types of investments, such as cryptocurrency. Further, as they look to hedge business risks, companies are frequently entering into derivative transactions, which both can contain unexpected risk and accounting complexity.As you advance in your audit careers, you will be faced with both understanding the accounting for and auditing these complex financial statement areas. In this course, we’ll review the accounting models of several types of complex investments and review common audit procedures in these areas. (Please Note: This module is part of Surgent’s Audit Skills Training: Level 3.)
Designed For
Accountants who account for or audit more complex financial instruments
Objectives
Recall fair value accounting guidance under ASC 820 Recall the accounting guidance related to hedging transactions and other complex investments Identify common audit procedures related to complex investments
Major Subjects
The fair value measurement process Derivative and hedge accounting under ASC 815 Accounting and auditing considerations related to the use of the equity method of accounting under ASC 323 Accounting and auditing considerations related to investments in cryptocurrency and digital assets
Instructions
None

(SSOT448/26) Surgent's Workplace Etiquette for Young Professionals
2026-06-30 12:00
Event Description
Understanding the nuances of workplace protocol facilitates effective interactions within the office as well as at external business functions. In this class you will learn how to cultivate your executive presence as well as how to conduct yourself in a variety of business settings. The work environment extends beyond the walls of the office into client sites, business events, and conferences. You will be provided with the tools to navigate every situation with confidence and grace. Although the workplace is an evolving structure, the general rules of etiquette such as kindness, respect, cooperation, and effective communication have not shifted.
Designed For
Young professionals in the accounting or financial service professions who are interested in elevating and fine tuning a workplace presence to enhance career opportunities.
Objectives
Understand how to cultivate and project an executive presence Integrate perception management through appearance, behavior, and communication in the workplace Effectively navigate business dining settings and client events
Major Subjects
Projecting a professional presence Verbal communication skills to elevate your message Mastering non-verbal communication Protocol for office settings Building trust within the organization and with clients Running an impactful meeting Adding value as a meeting attendee Executive dining etiquette strategies and tips
Instructions
None

(SSMG427/26) Surgent's Implementing Subscription Pricing to Your Practice
2026-06-30 12:00
Event Description
This course is designed to provide accountants with a comprehensive understanding of the subscription pricing model. As the business world increasingly shifts toward subscription-based models, it’s crucial for accountants to understand the financial implications and strategies associated with this pricing approach. This course will cover the basics of subscription pricing, how to set prices, and how to analyze the financial impacts of these decisions, as well as the specific impacts to your business.By the end of this course, participants will be equipped with the knowledge and skills to effectively manage the implementation of subscription pricing to their practice.
Designed For
All finance and accounting professionals who want to improve billing practices for their business
Objectives
Understand what subscription pricing is and the need for a shift from traditional pricing to subscription pricing Set subscription prices based on costs, customer value perception, and competitive analysis Transition to a subscription pricing model and communicate these changes to stakeholders Understand the need to regularly review and adjust subscription pricing based on business needs and client changes Manage customer retention and churn in a subscription pricing model Develop skills to analyze the financial impact of subscription pricing on a business’s revenue and profitability
Major Subjects
The basics of subscription pricing Pricing strategies, with an eye toward a modern model for your business How to implement subscription pricing The need to look back and assess the financial impact of the implementation How to manage customer retention The optimum subscription pricing for your business
Instructions
None

(SSTX552/26) Surgent's Social Security and Medicare: Planning for You and Your Clients
2026-06-30 12:00
