CPE Catalog & Events

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.

This program reviews the statutory and regulatory guidance as they relate to fringe benefits. There will be an emphasis on entertainment, meals and business transportation expenses, including qualified employer-provided parking, with a focus on planning opportunities. Recent federal tax legislation, cases and rulings will also be addressed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The audit profession stands at a critical inflection point, facing unprecedented challenges from technological disruption, evolving regulatory landscapes, and workforce transformation. This comprehensive course, based on the Pennsylvania Institute of CPAs' groundbreaking research report "The Future of the Audit: Building Relevance and Sustaining Quality," provides auditors with essential insights and actionable strategies to navigate these seismic shifts. Through expert perspectives from industry leaders including PCAOB board members, Big Four executives, and audit committee chairs, participants will explore how artificial intelligence, blockchain, and data analytics are fundamentally reshaping audit practices while creating new opportunities for value creation and risk assessment. Beyond technology adoption, this course addresses the pressing talent crisis facing the profession and offers practical solutions for building a future-ready workforce. Participants will learn how to leverage emerging technologies to enhance audit quality, understand the implications of regulatory modernization including the concept of "regulatory sandboxes," and develop strategies for attracting and retaining top talent in an increasingly competitive market. Whether you're a partner in a small firm, a manager in a large organization, or an audit professional seeking to future-proof your career, this course provides the roadmap for maintaining relevance, ensuring quality, and thriving in the evolving audit landscape. You'll leave with concrete action steps for immediate implementation and a clear vision for transforming your audit practice to meet the demands of tomorrow's financial ecosystem. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Volume to Value: A New Era of Precision Hiring in Accounting examines how accounting firms are shifting from high-volume recruiting models to "precision hiring" as AI adoption accelerates and talent scarcity continues. Participants will explore why traditional hiring processes often overemphasize technical accounting knowledge while under-assessing the competencies that most impact performance-critical thinking, professional communication, and AI ethics awareness. The course explains how AI-enabled recruiting tools can support candidate screening, assessment, and retention forecasting, and why firms that do not modernize their hiring approach may struggle to compete for top talent. Participants will leave with practical approaches to competency-based assessment, ethical guardrails for AI use in hiring, and a high-level implementation roadmap with metrics to evaluate quality of hire, performance, and retention. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program covers three topics: the Department of Labor's changes in overtime rules, the Federal Trade Commission's ban on most non-compete agreements, and the Department of Labor's new rules relating to differentiating between employees and independent contractors under the Fair Labor Standards Act (FLSA). Any suspensions due to court challenges will be discussed. Understanding these new changes will allow accounting and finance professionals to discuss these important business law changes with their clients.

This session revisits useful, but potentially underutilized, managerial accounting techniques. You will appreciate a fresh look at concepts you may not have considered since your college days. We will illustrate practical ways you can immediately implement managerial accounting analysis in your professional endeavors. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Clients believe that estate planning is only for the wealthy who will owe Federal estate tax. This isn't the case. Perhaps as a result of the 2020 pandemic, estate planning has a renewed focus. All practitioners should be familiar with the vernacular, acronyms and techniques. Estate planning involves personal issues that affect everyone, whether or not the estate tax will apply. Learn strategies to pass assets to future generations; provide education benefits; distribute retirement benefits, and provide a charitable legacy.

Designed as an all-you-need-to-know update for accounting, auditing, and attestation practitioners at all levels in public accounting and industry, this course provides a comprehensive review of recent standard-setting and rulemaking activities of the Financial Accounting Standards Board (FASB), American Institute of Certified Public Accountants (AICPA), Public Company Accounting Oversight Board (PCAOB), and Securities and Exchange Commission (SEC). On the financial accounting front, we will cover the FASB's Post-Implementation Review (PIR) report released in late 2025 for lease accounting under ASC 842 and discuss the best practices in applying the standard and identifying any ongoing issues practitioners are experiencing with applying the standard. We will also discuss the more than a dozen ASUs the FASB has issued since the beginning of 2024 and into 2026 covering government grants, derivatives and financial instruments, practical expedients for credit losses under ASC 326, and expense disaggregation on the income statement. Our focus on AICPA standards includes a detailed discussion of revamped AICPA quality management standards. The AICPA updated and modernized the standards by issuing Statement on Quality Management Standards 1, 2, and 3 (SQMS 1, SQMS 2, and SQMS 3, respectively), SSARS No. 26, and SAS 146, Quality Management for an Engagement Conducted in Accordance with Generally Accepted Auditing Standards (SAS 146). These standards, now effective as of December 15, 2025, modernize quality management standards to reflect an increased focus on risk assessment, technology use, and the presence of outside experts on engagements. We will also discuss AICPA's proposed SAS, The Auditor's Responsibilities Relating to Fraud in an Audit of Financial Statements, intended to supersede AU-C section 240. We will also cover new rules impacting public company audits and present case studies on recent fraudulent accounting stories and best practices for detecting and preventing such frauds. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.

This course covers basic legal principles that every accountant should be familiar with to avoid common legal disputes and costly litigation. By analyzing business law issues from the standpoint and background of accountants and auditors, this course will help you develop an approach to client and practice issues with a sensitivity and appreciation for potential legal ramifications.

The objective of this course is to train new, rusty, or returning-to-practice staff with a hands-on, pencil-pushing gold standard for preparing Form 1065. Common to advanced issues of partnerships are explored in the current course that can double as a quick and practical reference guide for tax treatment and tax preparation guidelines. Within each chapter, we illustrate various parts and areas of interest when preparing a 1065, including examples and corresponding tax forms. We bring it all together in the final two chapters with a comprehensive example that integrates and links all previous chapters. The course and instruction delivery are geared toward a basic understanding and progress to more complex issues via Surgent's "Step-by-Step" preparation guide.

Single auditing can seem so complex! With literally thousands of pages of potential AICPA, GAO and OMB guidance converging for the audit of one client, auditors can easily lose focus and confidence in what they are supposed to do. It does not have to be that way! This course is designed to sharpen your skills and knowledge in performing single audits. Through more than 30 focused exercises, the course provides a highly practical, hands-on approach to mastering today's most critical single audit challenges.

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.

Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

For the past two decades the trend has been to move away from brick and mortar offices and have a greater number of people work or telecommute from home. Because of the upheaval caused by recent events, the rate of this move has been accelerated. This has and will continue to create control challenges and organizations must work to address these. Such things as moving from time based employee value to task completion based measurement and the ability to drive needed inter-company communication are just a sample of the issues with which entities must contend. This session looks at the benefits and pitfalls of workers that telecommute. It then discusses important risks and controls to consider as this trend continues and evolves in the business world. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program presents a detailed analysis of the self-rental passive activity rules, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

With over 50% of marriages ending in divorce, forensic accountants are frequently used in uncovering hidden income and assets. It is not uncommon for one spouse to hide money from another, sometimes for nefarious reasons. As a CPA, your services are valued by high-net-worth individuals who hire attorneys in their divorce proceedings. In this course, you will learn the art of financial investigations and how to uncover the truth in divorce cases, whether from offshore accounts to lifestyle analysis. Step by step, the course will teach you the valuable skills necessary in finding, analyzing, evaluating, and presenting your findings to your client and if needed, ultimately in divorce court. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

*** Save 15% on this event when you use the code SAVE15 at checkout *** This course can act as an introduction to sales and use tax for those wishing to learn but also be sophisticated enough to act as a refresher for even the most seasoned sales and use tax veteran. The course will discuss general transactions subject to sales and use tax. An update concerning statutory changes are a must to properly guide clients. It is critical for practitioners to understand the criminal and civil penalties at risk when a business collects (or does not collect) sales tax, not just for the business owner but also against the practitioner.This course also provides attendees with a timeline of what happens during (and after) a Florida sales and use tax audit. The course will cover significant milestones to ensure the client's rights are adequately protected. The attendee will learn when (and how) to formally disagree with the audit findings, as doing so at the wrong time can cause the client to lose any chance at an appeal. Furthermore, the course discusses what occurs during an informal audit protest as well as a formal audit protest.

If you or your clients are facing that stage of life where careers are passing into the background, and a new "to be determined" life is emerging, then you are entering what is called "retirement". Some people are excited, some are scared, and most are both. There are many issues and questions people face at this time - what to do with time, financial, relationships, health, identity and more. This program summarizes the key research studies, provides stories from those who have made this work, and offers thoughtful, practical exercises from my award winning book NEXT STAGE. It will help you (or your clients) address key issues and develop a Master Plan for the transition. If not now, when? This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course uses the lives of the rich and famous as a template to better understand the realm of estate planning. With stories ripped from the headlines, we will examine pitfalls and best practices. Did you know that Prince died without a will, opening the door for 45 people claiming to be his beneficiaries? Or that Michael Jackson was not careful in properly funding his trust, leading to delays and legal battles in the administration of his estate? Even Abraham Lincoln, it turns out, did not have a will. In discussing an array of celebrities, from Jackie Kennedy, Joan Rivers, Jimi Hendrix, and Whitney Houston to Aretha Franklin, Barry White, Leona Helmsley, and Florence Griffith Joyner, the course is designed as an enjoyable learning experience with tips for all levels of expertise. We may not have their fame or fortune, but we can certainly walk the red carpet when it comes to estate planning.