CPE Catalog & Events

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.

CPAs spend most of their working lives reviewing bank statements and books and records of businesses. They are experts in understanding how to prepare financial statements according to GAAP. But would a CPA know a possible money laundering transaction if they saw it? Would they know about a money laundering business? Money laundering is a subject of many action and thriller movies, but rarely understood. This presentation will educate the CPA in understanding the basics of money laundering and how to identify money laundering. This presentation will help the CPA know the truth about money laundering, how to identify it, the statutes that define it, and the court cases that interpret it. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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).

Microsoft Teams is one of the most popular tools for communication, collaboration, and knowledge sharing. If you use Microsoft Teams in your practice or business, this is a "must attend" course. You will learn everything you need to know to optimize the features of Teams and maximize your productivity. We will cover everything from how to effectively design your teams and channels configuration. How to utilize all the Teams features for posting conversations and working with your Office documents, PDF files and more. You will leave this course with the skills to master all the features of Teams! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

You'll learn about current and upcoming requirements in accounting standards (except financial instruments and leases) and understand how to apply the guidance in practice.

Guidance on how to account for digital assets (bold): Accounting for stablecoins may not be stable: Though the use of digital assets is rapidly expanding, accounting guidance has not kept pace. As a result, accounting for digital assets can feel shaky. The AICPA can help: The AICPA practice aid on accounting and auditing for digital assets and this webcast can help you answer the question of what to do when you or your client accounts for stablecoins. You'll be helped to understand how to account for other transactions and investments involving crypto and digital assets under U.S. GAAP. You'll also learn more about what the AICPA is doing to lend clarity and guidance to this murky but increasingly important field. Learn how you can add more value: Whether you're a CPA with attest clients or an industry accountant responsible for corporate accounting policy, this guidance will give you a clear path to help your clients or firm by applying the most up-to-date accounting policy. Detailed examples and use cases will demonstrate real-world application of this guidance. Note: FASB issued ASU No. 2023-08, Intangibles-Goodwill and Other-Crypto Assets (Subtopic 350-60): Accounting for and Disclosure of Crypto Assets, which is effective for all entities for fiscal years beginning after December 15, 2024. This ASU is not yet reflected in this webcast.

Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in SAS Nos. 134-145. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

As financial leaders, CPAs are often tasked with managing organizational risk. In this respect, the supplier relationship can be a tricky one. It is often one of the more familiar and comfortable business relationships we have, yet it may also be the one that presents the most significant risk to our company. In this course, we will explore how to manage the supplier relationship from onboarding to termination. Through case studies and best practices, we will discuss how to continue being a good partner to our suppliers while also understanding where potential risks exist. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize, and structure data, apply calculations to derive key metrics, and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful, and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Comply With All Standards As You Prepare, Compile and Review Engagements This webcast is a go-to reference for staying in compliance with all professional standards surrounding engagements performed in accordance with Statements on Standards for Accounting and Review Services (SSARSs).

In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.

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.

According to a recent study, over 70% of accounting professionals suffer from burnout, leading to feelings of exhaustion, inefficiency, and dissatisfaction with their careers. Recurring challenges for accounting and finance professionals include long hours, repetitive work, pressing client demands, and changing rules and regulations. Together, these conditions contribute to chronic workplace stress. Burnout is real, and firms that ignore this common problem pay a high price. Nearly three out of five employees in accounting and finance professions report psychological harm from work-related stress, including an overall feeling of lack of interest, motivation, or energy. Fortunately, individuals and organizations are beginning to take career burnout more seriously, especially in the post-pandemic era. This course looks at the causes of accounting burnout and examines strategies organizations are implementing to address and reduce a well-known but often overlooked problem.

To many clients, CPA firms all look the same. While services and specialties may vary significantly from one firm to another, it is hard for the average person to see this by simply looking at the sign outside our office door. Is there any way to make us stand out more to the outside world? Through surveys, statistics, and examples, this course looks at how CPA firms can develop a marketing plan beyond just relying on referrals. We look at the pluses and minuses of various marketing channels, regulatory constraints, and how to measure success in the competitive financial services space.

Discover the communication edge that will take your CPA career to the next level. This comprehensive course empowers CPAs with the tools to enhance clarity, build trust, and drive decisions. Learn to transform complex jargon into actionable insights and develop powerful persuasion techniques that resonate with clients and stakeholders. Join me to sharpen your communication skills and elevate your professional impact. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Organizations of all sizes often fail to successfully install needed foundational components of an internal control system. Whether large or small, entities must view policies, procedures, and all controls in a wholistic manner in order to develop a system of controls that will keep the entity on its intended course. Moreover, those that design policies and procedures benefit by knowing why control measures are necessary. This session sets forth internal control concepts and explains the importance of strong internal control policies. It provides an understanding of the interrelated nature of all controls created by any organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Providing a practical overview of the IRS Power of Attorney, Form 2848, and IRS Tax Information Authorization, Form 8821. Participants will explore the differences between these forms, understand when each is required, and how to comply with IRS requirements for representing clients and accessing their tax information. The course will cover practical issues, ethical considerations, and best practices for managing client authorizations through the IRS Centralized Authorization File (CAF) system. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The webcast explores the challenges of the current economic trends and analyzes their impact on you as the financial executive in areas of human resource management; credit markets and banking; risk management and pandemic style disruptions; cash flow planning strategies; debt and equity mix impacts in uncertain markets; globalization of the market in times of uncertainty; retirement planning and social security funding; and acquiring distressed companies and assets. Specific recommendations and insights will be offered to you to deal with the challenges.

What you need to know about the lessee and lessor accounting models This course explains the lessee accounting model, including Lease and non-lease components Lease classification Amortization of the right-of-use asset Interest on the lease liability This course also explains the lessor accounting model, including Transfer of risk Profit recognition Collectibility Included in this course are detailed and illustrated examples with amortization tables and journal entries.