CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Surgent's Excel Budgeting Ideas
-
Online
2.00 Credits
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.
Surgent's Understanding Non-Compete Agreements
-
Online
2.00 Credits
The enforceability of non-compete agreements in the U.S. is in flux. While the FTC's proposed ban is on hold pending legal proceedings, existing state laws continue to govern the validity of non-compete clauses. Some states, like California, Oklahoma, and North Dakota, prohibit non-compete agreements, while others enforce them under certain conditions. Although state laws vary, non-competes are often used to protect the creation and development of corporate goodwill, customer relationships, and specialized training, among others. Today, employees are more likely to be asked to sign non-compete agreements as a condition of employment. Non-compete agreements are also a common component of a business sale agreement. This program surveys non-compete agreements from all angles, including the current state of play regarding the usefulness and enforceability of agreements going forward. Whether you advise individual clients or work for an employer, this course provides an understanding of common issues that arise in the negotiation and enforcement of non-competes.
ACPEN: Expand Your Analytical Toolbox More Tools for Success
-
Online
4.00 Credits
Valuation techniques and cash management activities are two other tool categories that can round out your analytical toolbox. In this course we will initially discuss how to turn your financial plan into a powerful valuation engine. We then will discuss the formation of an efficient cash management program based on solid banker relationships. Finally, we will review Ten Steps for keeping your financial toolbox full. Presented by: William O’BrienType: Live Webcast Replay
ACPEN: The Essential SSARS Update with Renee Rampulla
-
Online
4.00 Credits
This update is essential and designed to assist you in the application of Statements on Standards for Accounting and Review Services (SSARSs) issued by the American Institute of Certified Public Accountants (AICPA). Learn about recently issued SSARS Nos. 26 and 27, identify common accounting and reporting issues, and hear about other recent developments. Presented by: Renee RampullaType: Live Webcast Replay
2026/27 Annual Update for Not-for-Profit Accountants & Audit
-
Online
4.00 Credits
This comprehensive annual update brings together key accounting, auditing, and compliance developments affecting not-for-profit organizations. The course integrates recent standard-setting activity, audit and attestation updates, and Single Audit developments to provide a practical view of changes impacting nonprofit financial reporting and oversight. Participants will begin with an overview of accounting developments affecting not-for-profit organizations, including recently issued Accounting Standards Updates (ASUs) from the Financial Accounting Standards Board and an introduction to the International Non-Profit Accounting Standard (INPAS). Emphasis is placed on understanding the purpose and structure of INPAS and how it compares conceptually to U.S. GAAP requirements for NFPs. The course then shifts to auditing and attestation developments from the AICPA, including the next phase of quality management with a focus on monitoring and remediation responsibilities. Participants will also review recent and upcoming standards affecting audit, attestation, and consulting engagements, including updates related to SSAEs, SSARSs, exposure drafts on confirmations and fraud, and changes affecting group audits. Finally, the course addresses recent developments impacting Single Audits for not-for-profit organizations receiving federal funding. Topics include the 2024 Uniform Guidance overhaul, updates to Appendix B of the AICPA GAS/Single Audit Guide, recent guidance issued through the Office of Management and Budget (OMB), and reporting changes related to SAM.gov. Designed for nonprofit preparers, auditors, and financial leaders, this course helps participants understand how recent accounting and auditing changes intersect-and what to monitor as requirements continue to evolve. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Business Ethics: Cases from the Real World
-
Online
4.00 Credits
Being consistently ethical is a challenge. Most of us have had to make tough choices. This session will discuss real world cases involving thorny ethical dilemmas and how to resolve them. Being ethical is not the same as complying with the law and ethical issues are not always black and white. This session will review different professional ethical standards. What does integrity mean in the office? If you want to learn lessons from the best in a short time, this session is for you. Participate in engaging dialogue about how to prepare for the inevitable ethical situations. These lessons are valuable for every business leader. Presented by: Don MingesType: Live Webcast Replay
ACPEN: Mary Jane Hourani’s Federal Tax Update: Business
-
Online
4.00 Credits
This course provides a practical review of recent federal tax law changes affecting businesses. It covers enacted and proposed tax legislation, IRS regulations and rulings, recent tax-related court cases, and updates to IRS procedures. The course focuses on how these developments impact business entities and common tax positions. Participants will work through real-world scenarios and examples to apply current law to business tax situations, including the use of deductions, credits, and other available tax benefits. Emphasis is placed on applying new guidance in practice while maintaining compliance with current IRS rules and procedures. 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 terri.storer@acpen.com Presented by: Mary Jane HouraniType: Live Webcast Replay
ACPEN: Creative Strategies for Buying, Selling, or Gifting a Business
-
Online
8.00 Credits
Navigating the complexities of business transactions requires a deep understanding of tax and estate planning strategies. In this comprehensive course tailored for financial professionals, participants will explore the intricacies of creative approaches to buying, selling, or gifting a business. Through real-world scenarios and practical insights, attendees will gain invaluable expertise in identifying tax risks, minimizing liabilities, and safeguarding assets. From evaluating valuation methods to exploring the details of stock versus asset purchases, this course equips you with the essential tools to provide informed counsel to clients. Discover the potential for strategic success as you master topics including estate transfer and tax implications, gifting strategies, and the utilization of various trusts and partnerships. Whether you're a CPA, EA, attorney, or financial planner, this course offers indispensable knowledge to elevate your practice. With a recommended 8 credit hours of Continuing Professional Education (CPE), this intermediate-level course is designed for professionals with a foundational understanding of business tax and estate planning. Join us and immerse yourself in a journey towards mastery in the vibrant landscape of business transactions. **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. Presented by: Arthur WernerType: Live Webcast Replay
ACPEN: K2’s Excel Tips, Tricks, And Techniques For Accountants
-
Online
8.00 Credits
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! Presented by: Thomas StephensType: Live Webcast Replay
Multi Year Failure to File: Getting into Compliance
-
Online
8.00 Credits
This comprehensive program equips CPAs with the knowledge and practical tools to handle clients who have failed to file tax returns for multiple years. The course covers every stage of the process-from client onboarding and transcript analysis to risk assessment, ethical considerations, and resolution strategies. Participants will learn how to manage cases involving individuals, married couples, businesses, payroll taxes, and S corporations, including situations with missing records and potential criminal exposure. Real-world examples, IRS references, and best practices are integrated throughout to ensure confidence and compliance. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Get started with Power BI
-
Online
2.00 Credits
Embark on a journey to master Power BI, a powerful tool for data analysis and business intelligence, in our comprehensive course, "Get Started with Power BI." This course is meticulously designed for professionals who seek to understand the full spectrum of Power BI capabilities, including its integration with Excel's Power BI features like Power Pivot and Power Query, and its comparison with standalone Power BI tools such as Power BI Desktop, Power BI Service, and Power BI Report Server. In the first part of the course, participants will be introduced to the fundamentals of Power BI. This includes an overview of Power BI's interface, key features, and its seamless integration with Excel. The course will cover Excel's Power BI tools - Power Pivot, for advanced data modeling, and Power Query, for efficient data transformation and preparation. This segment is essential for understanding how Power BI extends and enhances the data processing and analytical capabilities of Excel. The second section of the course delves into the standalone Power BI tools. Here, participants will explore Power BI Desktop for creating complex data models and sophisticated reports, Power BI Service for cloud-based collaboration and sharing, and Power BI Report Server for on-premises report deployment. This part of the course will focus on the unique features and strengths of these standalone tools, providing attendees with the skills to leverage Power BI in a variety of business contexts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: An Exceptional Leader C.A.R.E.S.
-
Online
1.00 Credits
This session will teach leadership principles to transform a workplace into a healthy & supportive environment. By improving organizational culture, mental health conditions will improve, & burnout potential is minimized. An unhealthy workplace results in failure to attract and retain top talent. Leaders can be instruments of change. The C.A.R.E.S. approach offers leadership principles that will improve your workplace. Symptoms are hidden at work. Your employees are hurting, and you can help. If you care for your people from the bottom of your heart, you will be amazed at what it does to your bottom line. Presented by: Micheal TowersType: Live Webcast Replay
ACPEN: Introduction to Forensic Accounting
-
Online
1.80 Credits
This course provides a high-level overview and introduction into the world of the forensic accountant. Most accountants have an understanding of the concept of fraud and how it impacts companies, but many individuals do not have a full comprehension of the variance in the work performed by a forensic accountant versus a typical management accountant. This course is meant for those individuals interested in understanding the variances in the job tasks and responsibilities of forensic accountants versus typical financial or management accountants. Forensic accountants or auditors take a unique focus on performing their work. Typically, when a person with forensic experience is called in to examine financial records, it is due to suspicion of fraud, evaluation of assets, or even to track down fundamentally incorrect accounting – intentional or not. As fraud continues to raise its head in business processes, forensic accountants are discovering new and unique ways to identify, examine, and support their hypotheses and investigative techniques. The work performed by a forensic specialist can be interesting and full of potential potholes if evidence isn’t examined according to proper protocols and standards. Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Awesome Business Lessons from the Past: Learn from the Best!
-
Online
2.00 Credits
Why not learn, or re-learn, some amazing business lessons from the past that are still effective today? What did Henry Ford do when annual employee turnover was 370% and workers demanded more pay? Sound familiar to today’s world? Ford’s solution worked! We see today’s problems and believe that these problems have never occurred before. Not true. We will discuss timeless business lessons that are as practical today as when they were written decades ago. We will review; ‘How to Win Friends and Influence People,’ ‘Today and Tomorrow,’ and ‘The Art of War.’ Let's learn from the very best, as these lessons have been battle-tested and proven over time. Presented by: Don MingesType: Live Webcast Replay
ACPEN: How to Choose the Right Business Entity for Your Client
-
Online
2.00 Credits
Tax rates, personal liability, operations - these are all factors to be weighed when advising clients about their choice of entity decision. This session provides a comparison of the multiple entity choices to start the discussion with clients and selecting the best tax efficient option for them. *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 Presented by: Steven DilleyType: Live Webcast Replay
ACPEN: The Controllership Series - The Treasury Function Part 1 - Cash and Investing
-
Online
2.00 Credits
This course corresponds to our Controllership series. This course is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we discuss the area of cash and investments and explore how the controller can move these responsibilities into more of a strategic role. In today’s world, the role of cash management is often a pivotal role in the organization. In economically difficult times, controllers may find that they spend a great deal of their time on understanding and managing the organizations' cash position. This is certainly important and, in some areas, can be seen as a staple of the lifeblood of the organization’s ongoing viability. This course takes a look at some of the typical objectives involved in Cash management and then evaluates how those objectives can be further stretched into strategic pillars of the organization. Presented by: Lynn FountainType: Live Webcast Replay
Microsoft Copilot Deep Dive Hands-on Bootcamp for CPAs
-
Online
2.00 Credits
Microsoft 365 is one of the most widely used business applications software suites used in business today. Microsoft Copilot is the generative AI application that is integrated directly into the Microsoft 365 ecosystem. If your firm or business is a Microsoft 365 user, this course will teach you how to use Copilot AI to optimize the use of your Microsoft 365 apps. This course will provide a comprehensive review and demonstration of how to put Microsoft Copilot AI to work for you and your clients. It is designed as a "hands-on" course that facilitates following along with the presenter to apply the features of Microsoft Copilot on your computer. Practice files will be provided so that you don't have to expose your confidential data. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Guide to Preparing Form 1041 for Estates and Trusts
-
Online
4.00 Credits
This program examines the critical issues, rules, and special opportunities when preparing your clients' Form 1041 US Income Tax Return for Estates and Trusts. Learn what is considered taxable income; filing requirements and deadlines; impact of the 3.8 percent Medicare surtax on net investment income; and the 10 principles of tax accounting for trust income. *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 terri.storer@acpen.com Presented by: Doug Van Der AaType: Live Webcast Replay
ACPEN: Passive Activities & Rental Real Estate Income Tax Issues
-
Online
8.00 Credits
This comprehensive training is designed to get the accountant up to speed quickly with the complex passive activity loss (PAL) rules that apply to certain investments in trades or businesses and rental activities. The cornerstone of the course is the in-depth coverage of the detailed tax law and regulations applicable to passive activities under IRC §469 and how and when the 3.8% net investment income tax under §1411 applies. *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 terri.storer@acpen.com Presented by: J. Patrick GarverickType: Live Webcast Replay
ACPEN: Qualified Business Income (QBI) Deduction (§199A) – The Ins & Outs
-
Online
8.00 Credits
The Tax Cuts and Jobs Act (TCJA) was a major overhaul of our tax system that lowered the income tax rates for individual and corporate taxpayers and introduced the new 20% qualified business income (QBI) deduction for sole proprietors and pass-through entities. The cornerstone of this course is the comprehensive discussion of the 20% QBI deduction final regulations under IRC §199A. *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 terri.storer@acpen.com Presented by: J. Patrick GarverickType: Live Webcast Replay