CPE Catalog & Events

How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.

Required minimum distributions (RMDs) must be taken from certain tax-deferred retirement accounts, starting when the account owner reaches their applicable age. The RMD rules are complex and must be simplified to help ensure clients understand them. Accounting and finance professionals must understand the basics of RMDs for IRAs and employer plan accounts so as to help IRA owners, plan participants, and beneficiaries meet their RMD obligations and avoid penalties that apply to RMDs not taken by their applicable deadline. Accounting and finance professionals should also be able to demonstrate tax-efficient solutions for RMDs. This course will walk accounting and finance professionals through the fundamental concepts and rules that apply to RMDs, demonstrate how to calculate RMDs, and explain how to correct RMD errors. It can be taken by anyone, including those without any experience working with RMDs. The course will include cases to promote understanding of the rules.

It is important for accounting and finance practitioners to help their clients understand and apply the many new provisions of OBBBA. Many of these changes are effective for the 2025 tax year and beyond. This program is an introduction to and review of some of these critical changes and their impact on taxpayers. This program is a two-hour review and analysis of what we consider some of the most current and important changes from the OBBBA. If you want the latest OBBBA information to relay to your clients, this course is for you.

Business strategies for 2026 are based on important tax changes made in the One Big Beautiful Bill Act (OBBBA). There are a number of important business tax changes that can be used to develop tax planning strategies that have great advantages for businesses and their owners. This program covers many important business tax changes and the implications for tax planning founded on them.

This course will review common deficiencies identified by the AICPA and state boards of accountancy. It features discussion on a variety of topics, including analytical procedures, sampling, group audits, and risk assessment. We will review the areas of concern and how you can overcome them by employing best practices.

Workpapers are the primary support for findings, conclusions and opinions on any audit or other attest engagement.  This course will provide the essential tips and techniques for ensuring workpaper documentation is of a high quality, yet efficient, nature.

Tax developments have been in the forefront of the news, and tax practitioner can find it challenging to remain up-to-date with these changes. This 8 hour program will cover tax issues relating to individuals, including new court decisions, recent IRS publications, and the latest tax legislation. The remaining time will be spent on IRS procedure and other issues. This course will provide 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.

This course will serve as an introduction to conducting effective walkthroughs to gain an understanding of the client's transaction processes as well as identifying internal controls within each process. This course will review the procedures, questions to ask, and documentation requirements of walkthroughs. It will also include real-world examples of the red flags that may arise while executing a walkthrough. 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 key developments affecting governmental audits with this focused update on the 2024 revision of the Yellow Book. This course highlights significant changes related to quality management and updates affecting key audit roles, with an emphasis on how these revisions impact audit planning and execution. The course also addresses the GAO's implementation delay and its implications for 2026 audit planning. Participants will gain context around recent leadership changes at the U.S. Government Accountability Office and what those transitions may signal for future guidance and oversight priorities. In addition, the course includes an overview of recent updates to the Green Book, helping auditors understand changes to internal control guidance that may affect governmental entities and Single Audit engagements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Managerial accounting provides economic and financial information for managers and other internal users. Managerial and Financial Accounting have similarities and differences. Each field of accounting deals with the economic events of a business. Both managerial and financial accounting require that a company’s economic events be quantified and communicated to interested parties. This another course in our series on the controller’s role. The controller’s role encompasses many traditional functions. Within this segment of our controllership series, we discuss the area of managerial accounting and the basic concepts that surround this discipline as it primarily relates to cost accounting issues.  

Many finance departments spend considerable time managing cash, particularly if the organization is highly leveraged or cash rich.  Many opportunities exist to reduce your financing costs or increase short-term cash returns if you manage cash effectively.  This session will cover a wide variety of day-to-day cash management tools.  

This course provides a focused and practical overview of the Generation Skipping Transfer (GST) Tax, designed specifically for professionals involved in estate and gift tax planning. As Part 4 of the Form 706 and 709 series, this session zeroes in on the rules, definitions, and application of GST tax, including the mechanics of calculating the inclusion ratio and how the GST exemption operates in real-world planning scenarios. Participants will gain clarity on how to identify skip persons, the types of transfers subject to the GST tax, and the proper treatment of direct skips, taxable terminations, and taxable distributions. Through clear examples and practical instruction, this course walks participants through voluntary, timely, late, and retroactive GST exemption allocations. With increasing regulatory complexity and heightened exemption limits, understanding the GST tax is critical for practitioners assisting clients in multigenerational wealth transfers. This course supports more accurate return preparation and strategic allocation of exemptions to minimize tax exposure. *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

Over the next decade, the area of “Advisory Services” has the greatest potential for growth in your practice.  Complexities within your clients’ financial, estate, and asset protection plans coupled with the ever-changing Internal Revenue Code has created an opportunity for the CPA, the EA, and other advisors to expand their client offerings. This course provides the practitioner with the framework for practice expansion as well as an understanding of a variety of necessary issues and techniques.  

This course offers a comprehensive exploration of the cannabis industry, delving into essential topics such as cannabis regulations, business models, financial management, and ethical considerations. A key focus is on distinguishing between Marijuana and Industrial Hemp, including their respective tax treatments. Participants will gain a thorough understanding of the unique challenges and opportunities within the cannabis sector, covering federal and state tax implications, licensing requirements, and market trends. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Consolidations have always been a complex topic in accounting. This course will discuss the requirements to consolidate and private company options. It will cover which entities need to consolidate and include an in-depth discussion on variable interest entities (VIEs). It will also cover the FASB's recent revisions to the Financial Accounting Concepts (FACs) chapter on entities.

Yellow Book and Single Audit engagements are considered must-select engagements for peer review. This course will review the common deficiencies noted by peer reviewers and federal agencies. We'll focus on the requirements of Yellow Book independence, CPE, and reporting. We will also review deficiencies related to internal controls over compliance, compliance testing, and major program determination for Single Audits. We'll close the course with a look at the deficiencies often identified in COVID-related funds.

The budgeting process can be a time consuming and frustrating process for accountants.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This series will offer solutions to the budgeting woes from both the big picture and in the details.    Budget Mastery: Process, Problems, and Solutions The budgeting process can be a mundane one for accountants. Let’s be realistic and agree that even the word “budget” does not bring excitement to you and your departmental colleagues.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This session is the first part of a four part series and will cover the big picture of keeping the process fresh, pragmatic and useful. We discuss these keys in an engaging manner by discussing both our flaws and strengths, including how to build on these characteristics towards an enjoyable solutions-based method that should deliver effective results for your organization.  Budget Mastery: Walkthroughs and Real World Calculations Towards Tying Budgets to Value This session takes a unique review of the fundamental budget issues faced by all and walks through a detailed modeling process intended to generate discussion and best practices to improve your organization’s financial modeling.  From the beginning of the accounting process – ‘the chart of accounts’ to the end of the process – ‘the valuation of the company’, the budgeting cycle via a live case model to learn best practices common to successful companies.   This course stands on its own but is part two of a four part budget mastery series. Budget Mastery: The Human Side of Budgeting-Navigating People's issues with 360 Insight You have a fantastic budget, but certain players are not pleased. Financial plans have a technical component and human component.  We can resolve some of our budget issues by exploring the process’ human aspect.  Understanding what makes you and others operate can enhance your understanding of the entire organization and build upon the respect and influence needed to navigate and lead the budgeting cycle. This session includes a case study that measures an individual’s personality type and then explores how to use our strengths and weaknesses to create a better budget process and quite frankly maybe a better you.  This is a great and fun course on its own, but is also part three of a four part series on budget mastery. Budget Mastery: From Numbers to Narrative: Effectively Presenting Your Budget and Reporting  Perhaps the most important element of the budget process is its communication.  If management does not understand the budget – there is an issue. Knowing the right ways to communicate at all levels is essential to stakeholders laying an ownership claim to successful budgets.  This session reveals several key guidelines in successful budget presentations and will identify key problems in how people often communicate financial plans. Presenting your budget and reporting is the final part of a four part series, but can easily stand on its own course that is intended to be fun, enjoyable and educational.

Almost every business and individual has to file tax returns, which can be a great treasure trove of information for forensic accountants. Whether in a divorce, partnership dispute, recreating books and records, or bankruptcy proceeding, analyzing tax return information should be an initial step in uncovering income and assets. The IRS retains a large amount of information, both from taxpayers and 3rd parties who report financial transactions. This course will be your guide in gathering, analyzing, and evaluating tax return information, so that you have a full picture of the financial investigation. Your presenter is a 20 year veteran with IRS-Criminal Investigation, who used this information as a basis for his federal criminal investigations. 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 dynamic economic landscape, staying ahead with effective fringe benefit planning is more critical than ever for both businesses and individual clients. With evolving tax laws and shifting market dynamics, understanding the intricacies of fringe benefit planning is essential to ensure financial well-being and compliance. This course offers a comprehensive overview of essential tools and techniques tailored for financial professionals, allowing them to navigate the complexities of fringe benefit planning with confidence and precision. By attending this course, practitioners will gain invaluable insights into various planning tools and techniques essential for meeting fringe benefit planning objectives. From mastering the subtleties of employee benefit planning, including ERISA reporting and disclosure requirements, to unraveling the complexities of IRC §132 fringe benefit options, attendees will enhance their expertise to deliver superior advisory services. The curriculum also delves into the practical aspects of cafeteria plans, flexible spending accounts, group term life insurance plans, and strategies for financing retiree medical benefits, among others. With a focus on practical application and real-world scenarios, this course equips participants to tackle fringe benefit planning challenges head-on, providing them with the tools and knowledge needed to optimize benefits for both business and personal needs, now and in the future. **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.

In today's workplace, employees are faced almost daily with customers or teammates that may have needs or concerns that we are forced to handle. Though many of these situations are easily dealt with through simple communication skills, others may become heated and, in some instances, violent. Today we will discuss healthy ways to de-escalate a wide variety of potential issues.