CPE Catalog & Events

The Secure Act 2.0 was passed in a flurry of year-end legislation. This one hour program will cover the important changes that employers need to know about company retirement plans. Employers will also need to consider how Secure Act 2.0 will the administration of existing plans or the creation of new ones.  This course will provide a concise look at these hot topics.   **Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.

The accounting profession faces unprecedented workforce challenges that demand a fundamental rethinking of traditional firm structures. This course examines why the century-old pyramid practice model is becoming obsolete and presents the inverted pentagon framework as a sustainable alternative. Based on comprehensive research showing that 52% of firms expect to shrink by 20% or more in the next five years, participants will learn how to restructure their firms to thrive with fewer entry-level staff while expanding specialized expertise. The course explores the "6 Ps of Business Model Transformation" - Precision Hiring, Proactive Retention, Practical Technology Implementation, Pricing Expertise, Practice Area Expansion/Focus, and People Acceleration. Drawing from success stories in manufacturing, healthcare, and technology industries, attendees will discover proven strategies for accelerating staff development, implementing effective knowledge transfer programs, and building sustainable talent pipelines in an era of technological disruption and demographic shifts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In today’s environment of constant volatility and complexity, organizations are inundated with data yet often lack meaningful insights. The finance and accounting function has a unique opportunity to harness Big Data and the full spectrum of analytics—descriptive, diagnostic, predictive, and prescriptive—to enhance decision-making. However, collecting and reporting data is not the same as analyzing it to extract actionable intelligence. Compared to fields like marketing, sales, and supply chain management, finance has been slower to adopt advanced analytics. This course explores how CFOs and finance leaders can close that gap and transform their function into a true driver of strategic insight.

This course focuses on the individual taking ownership for their career.  It provides tools and methods to assist and guide the individual to develop the collateral necessary in navigating their career.  It provides a Personal Marketing Plan that can be customized to fit the career objectives and goals of the individual. It also focuses on character self-awareness, crucial for long-tern career success.

Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session provides best practices for interviewing to gather accurate information, such as creating and asking open ended questions, effective listening, and understanding verbal and non-verbal communication. Attendees will end the session with takeaways to immediately implement in future HR investigations. Two of three Episodes in the series.

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.

This course explores the increasingly complex features of Excel that facilitate efficient data analysis.  We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information and dive into the powerful, but potentially under-utilized, capabilities of Microsoft Excel.  Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level.

Excel is the go-to tool for accountants when it comes to analyzing and reporting financial data. However, many professionals still rely on time-consuming and error-prone methods for everyday tasks. Whether you're a beginner or an experienced user, our course is designed to help you master Excel and transform your workflows. In this course, you'll discover a trove of tips, tricks, and techniques to boost your productivity and streamline your tasks. Say goodbye to mundane formatting and hello to customized Excel solutions that enhance accuracy and efficiency. You'll also learn how to build powerful formulas, link Excel data from various sources, and simplify report generation and printing processes. Our expert K2 instructors will guide you through the program with practical, real-world examples, ensuring you grasp the key concepts and apply them effectively. With over twenty-five years of experience in delivering top-notch spreadsheet training to accounting and financial professionals, we guarantee that the insights and guidance you receive will be both relevant and invaluable. Join us and elevate your Excel skills to new levels. Don't miss out on this opportunity to work smarter, not harder!

Participants will learn to create customized AI chatbots that can enhance client interaction and internal operations-all without coding experience. This course provides a concise overview of specialized, task-oriented AI chatbots and GPT builders, focusing on how these technologies are revolutionizing professional workflows. Through hands-on exploration of platforms like AgentGPT, Claude Projects, Gemini Gems, and NotebookLM, participants will learn to design, deploy, and manage custom AI assistants tailored to their specific needs. The course emphasizes creating advanced AI apps that can understand context and solve complex problems autonomously. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Building a remote team is no longer just a perk- it's a strategic advantage for CPA firms that want to attract top talent, improve retention, and scale sustainably. This session will explore how to intentionally design a remote work environment that balances flexibility with accountability. Attendees will learn how to structure communication, meetings, and leadership touchpoints so remote staff stay engaged, aligned, and productive. This session will provide practical systems CPAs can implement immediately.

Stay current on the latest accounting developments affecting not-for-profit organizations with this timely GAAP update. This course reviews recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline. The course also introduces the International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025. Participants will gain perspective on the purpose and structure of INPAS and how it compares conceptually to U.S. GAAP requirements for NFPs. This course is designed to help practitioners, financial leaders, and auditors of not-for-profit organizations understand both current GAAP requirements and emerging global developments shaping the future of nonprofit financial reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Stay current on significant developments affecting Single Audits with this focused update on recent regulatory and professional guidance. This course reviews the 2024 Uniform Guidance overhaul, including the increase in the Single Audit threshold to $1 million and other changes impacting audit planning and execution. The course also examines Appendix B of the 2025 GAS/Single Audit Guide issued by the AICPA, highlighting updates that affect audit efficiency and compliance considerations. In addition, participants will receive updates on recent guidance issued through Office of Management and Budget (OMB) memoranda, as well as reporting-related changes, including the transition from the Federal Audit Clearinghouse's prior systems to SAM.gov-based reporting. This course is designed to help auditors understand how these developments affect Single Audit requirements and what to watch for as expectations continue to evolve.  

You don’t need an accounting degree to harness the power of Microsoft Excel. This course shows how Excel makes sense beyond dollars and cents. We will focus on fundamental concepts for creating, editing, and utilizing Excel content. Participants will learn how to use Excel’s menus and other functions to craft Excel workbooks. Because this course is designed for newer users, we intentionally offer a broad overview of Excel’s numerous capabilities with in-depth coverage of selected resources tailored for non-accounting applications.

Many self-employed or sole proprietors find themselves having to navigate Schedule C in reporting business income.  While this attachment to Form 1040 seems straightforward on the surface, there are many traps for the unwary. This course is ideal for CPAs, EAs, or other tax professionals. **Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.

Many of our clients are moving to one of the seven states with no personal income tax, particularly Florida and Texas. Others may maintain multiple homes with an eye toward eventually establishing residency in a state with no income tax. This course will give you practical tips for your clients seeking to establish residency in a new jurisdiction. Cash-strapped states are increasingly attempting to assess taxpayers who have declared domicile and residency elsewhere, for example in Florida, to maintain their diminishing tax base. Arm your clients with the tools needed to save money by successfully establishing domicile and residency. As a practitioner, you can't afford to be unaware of the latest issues affecting so many relocating baby boomers and others. Avoid that state audit with the information provided in this entertaining webinar.

Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.

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 2025 tax year, this course is an essential guide for tax preparers on how to tackle the preparation of these forms. Understanding and preparing these forms requires a basic knowledge of various international tax topics, including sourcing of income, foreign tax credit income categories, effectively connected income, and fixed, determinable, annual, or periodical (FDAP) income. The course includes a brief discussion of key international tax concepts, a detailed walk-through of what information is required to be reported in different parts of the schedules, and practical advice from the field. The course also includes three comprehensive case studies on how the form should be completed for operating, real estate rental, and investment partnerships. Please note: Surgent also offers a companion course, "Schedules K-2 and K-3: Filing Requirements" (KFR2).

As litigation becomes more complex, attorneys are relying more on accountants to serve as consulting experts or expert witnesses at trial. Serving as an expert witness is not as difficult as you might expect. Accounting experts educate lawyers and jurors on issues such as valuation, tax liability, and forensics. Learn how accountants become expert witnesses, the role they play during pre-litigation through to trial, and the techniques experts employ to avoid challenges from opposing counsel.

Calculating partnership basis is one of the most important things that we do as practitioners. However, it is also one of the most confusing. When we use the term "basis," we really could be referring to one of three different things. This course will explore the differences between inside basis, outside basis, and 704(b) basis. Through several examples and practice problems, we will show you how to easily distinguish among these terms. We will also explore the tax implications of initial contributions of property to a partnership as well as the different types of partnership distributions.

Unlock the full potential of Excel and transform your operational and financial reports like never before. With cutting-edge tools such as Data Models, Power Query, Data Analysis Expressions, and Power Pivot, you can create powerful summaries and schedules in record time. Combine these with Excel's legacy features, and you have a game-changing opportunity to elevate your reporting environment. Join our fast-paced seminar to discover the magic of Power Query and how it seamlessly links data into Excel data models, enabling more efficient and insightful reporting. Learn to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance data analytics and understandability. Plus, master best practices for quickly and efficiently formatting your spreadsheets, giving them a polished and professional appearance. This course is a must for anyone using Excel for reporting processes. Elevate your skills and stay ahead of the curve with our expert guidance. You will truly learn how you can revolutionize your Excel-based reporting practices by participating in this session.