CPE Catalog & Events

Leaders set the tone for workplace well-being. This program will equip leaders with the tools to build resilient teams. Creating a culture of mental wellness allows employees to feel safe, valued and heard. This will improve productivity, reduce burnout and absenteeism and ultimately, create a workplace where employees can thrive. Leaders will also learn the importance of nurturing their own self-care to prevent burnout for themselves in order to be the best leader possible.

Passive Activity Loss (PAL) rules have never been more critical in Federal tax reporting. This course provides a comprehensive and complete review of the laws and regulations impacting PALs, including the rules governing rental real estate, grouping and the 3.8% net investment income tax. Learn what qualifies as a passive activity and the rules governing its application by exploring several recent court cases and the existing regulations to know how the IRS views this critical area of the tax law. The IRS is actively auditing the failure to report passive losses properly. You and your clients can't afford to be left behind.

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.

Since 1919, the Internal Revenue Service had a civil and criminal function in the United States tax system. Little do people know, the IRS has an elite criminal function that started with five United States Postal Inspectors. From its early days in taking down Al Capone to now solving cybercrimes, the IRS special agents are tasked with investigating tax fraud, money laundering, and other white collar crimes. This presentation will show you the importance of this law enforcement function, the training, techniques, expertise, and actions that cause them to be known as the "world's finest financial investigators." This presentation has been prepared by a 20 year veteran with the IRS-Criminal Investigation. The presenter investigated crimes, and trained and mentored other special agents. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Do you understand the root cause for many professional and personal goals not being achieved? The SMART acronym is valuable in setting goals but insufficient for achieving them. You need two types of goals to boost your chances of success. Outcome goals focus on the results you want to attain. Process goals identify the action steps required to accomplish those desired outcomes. This session explores the essence of both types of goals, and practical examples and tips for the execution of your goals.

This program addresses the many issues impacting investment scams. The unique challenges facing practitioners in finding deductions for the horrendous losses many clients experience due to these scams are related to actual practice situations – and then analyzed for their deduction implications. The situations are based on real life experiences of practitioner clients.

Finance technology decisions (ERP, FP&A, AP/expense automation, close/consolidation, bank integrations, and AI-enabled tools) can dramatically improve close speed, forecasting, and control execution-but vendor demos and "AI" marketing often hide integration complexity, data readiness gaps, governance risk, and long-term total cost. This course provides a practical, vendor-neutral approach for CPAs and finance leaders to evaluate and implement corporate finance technology with an audit-ready mindset. Participants learn how to cut through AI claims using an AI capability framework, apply a weighted vendor evaluation scorecard focused on controls and assurance, build a five-year total cost model that captures hidden and ongoing costs, and follow an implementation roadmap with checkpoints and red flags to reduce failure risk and improve ROI realization. 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 focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables.

The updated revenue recognition standard outlines five steps for proper compliance. At the surface, these steps seem simplistic. However, there are many considerations that should be considered within each step based on your process and industry.  

Companies reporting under International Financial Reporting Standards (IFRS) continue to face a steady flow of new standards and interpretations. The resulting changes range from significant amendments of fundamental principles to some minor changes from the annual improvements process. The changes will affect different areas of accounting, such as recognition, measurement, presentation and disclosure.  It can be time-consuming and confusing to keep up-to-date on the resulting impact on financial statements and disclosures. This course will provide an executive summary of recent IFRS updates with current and upcoming effective dates.  

Unlock the full potential of Excel with our comprehensive training on shortcuts and formulas. This course is designed for CPAs and financial professionals who want to enhance their efficiency and accuracy in Excel. Learn how to navigate and utilize different versions of Excel, discover powerful new functions, and master the art of creating effective tables and automations. With practical examples and hands-on exercises, you'll transform your Excel skills, making your daily tasks quicker and more precise. Plus, benefit from insider tips and tricks drawn from the instructor's extensive real-world experience. Whether it's mastering keyboard shortcuts that save you time or applying formulas that simplify complex calculations, you'll gain practical knowledge that you can immediately apply in your work. This course isn't just about learning Excel; it's about learning to excel at Excel.

Governmental accounting differs significantly from other forms of accounting and requires a distinct approach to financial reporting. This course introduces the foundational principles of governmental accounting, including fund accounting concepts and the modified accrual basis of accounting. Participants will explore the structure and purpose of governmental fund financial statements and government-wide financial statements, gaining clarity on their objectives, layouts, and key elements. The course also addresses essential topics such as component units, the role and structure of Management's Discussion and Analysis (MD&A), and the preparation and significance of the Annual Comprehensive Financial Report (ACFR). Designed for those new to governmental accounting—or those seeking a refresher-this course provides a solid foundation for understanding and applying governmental financial reporting principles. The course has been updated to reflect recent guidance issued by the Governmental Accounting Standards Board, including GASB Statements 101-105.  

What does fraud look like? It depends. What may appear to be an indicator of fraud in one client’s operation could be normal in another, making it critical to understand your client and the transactions you expect to see. Look for what should be present but isn’t—and for what is present but shouldn’t be. This course emphasizes the importance of professional skepticism, which has no on/off switch—it must be applied continuously. As auditors, our role is to independently verify, yet too often we rely on client representations without sufficient validation, increasing the risk of missing fraud. Many auditors recognize, in hindsight, that they have encountered fraud indicators but failed to identify them at the time. This session will provide you with the tools to recognize those indicators and strengthen your ability to detect fraud—so you are better prepared for what you may find.

Enter the complex world of elder planning with this comprehensive course tailored for financial professionals. Gain invaluable insights into estate and financial strategies designed specifically for older clients, equipping you with the knowledge and skills to address their unique needs and challenges. Throughout the course, participants will explore a wide range of topics, from understanding the complexities of Medicare and various life insurance types to navigating Social Security considerations and exploring Medicaid planning details. With a focus on practical application, attendees will learn to customize estate planning strategies, explore housing and care alternatives, and address gifting complexities relevant to older clients. By the end of the program, you'll develop expertise in executing specialized planning requirements for mature clients, ensuring you're well-prepared to provide informed counsel and support in this important aspect of financial practice. Join us and enhance your knowledge in estate and financial planning for the older client today. *Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Handouts Tab and submit to kori.herrera@acpen.com

In today's rapidly evolving business landscape, accounting professionals are expected to be more than just number crunchers, they are expected to be insightful interpreters of data. In an era where data is king, this course is your gateway to becoming a savvy data analyst, giving you a competitive edge in your field. We will guide you through the intricacies of making complex data analysis approachable and engaging. You will learn the all important Data Analysis Process Flow that will take you from collecting data all the way to making insightful decisions based upon your data. We will explore the basics of data modeling that will allow you to access data from multiple sources and use sophisticated calculations to create our data metrics. You will learn how to create interactive dashboards, perform sophisticated reporting, and uncover deep insights from your data. Whether you're looking to streamline your reporting process, enhance your data visualization skills, or make more data-driven decisions, this course is tailored to meet those needs. It's not just about learning a tool; it's about enhancing your professional identity as a forward-thinking accounting professional. 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 *** In 2026, cash forecasting has evolved from a backward-looking "gut feel" exercise to a forward-looking predictive science. This session explores how AI-driven tools are reshaping treasury management by identifying hidden patterns in historical data and real-time transactional flows. We will discuss the transition from static spreadsheet models to dynamic, intelligent forecasts that incorporate macroeconomic indicators and customer payment behaviors. Participants will evaluate various AI forecasting methodologies—including the rise of "Agentic AI" for autonomous scenario planning—and learn how to perform automated variance analysis to understand the "why" behind cash fluctuations. The session provides a roadmap for implementing AI-enhanced liquidity strategies that improve forecast accuracy, reduce idle cash, and support more confident strategic decision-making.

Tax credit and incentive programs offer significant but rarely utilized savings. This presentation will introduce the most important federal and California tax credits and incentives available to business taxpayers. Attendees will hear an overview of these benefits and learn how to identify these opportunities for their clients.

While many financial services professionals advise their clients on tax, investment, and life insurance issues, far fewer venture to help in the area of property and casualty insurance. Auto and homeowners policies are mandatory products that everyone generally needs - yet they are also complex products. This complexity raises questions in clients' minds: Are all my belongings covered under my policy? Do I have to adjust my policy if I want to let my neighbor borrow my car? Do I need an additional policy if I want to work as a rideshare driver? And will my premium go up when I move? In this course, we will cover the fundamentals of auto and homeowners' policies. We will touch on these questions, explore basic coverages, and offer some guidance on what practitioners should cover with their clients in this area, so you can offer guidance and give them the peace of mind they need. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Sarbanes Oxley Act (SOX) continues to pose challenges with compliance. Companies must continue to evaluate whether they have designed and implemented an adequate system of internal controls over financial reporting (ICFR). This course will address the best practices that ensure an effective and efficient approach to SOX compliance. 

Discover the power of Office Scripts, the game-changing feature that lets you automate tasks in Excel and other Office applications effortlessly. Unlike VBA, which is limited to Windows, Office Scripts run on any platform and device that supports Office on the web. With its modern and intuitive interface, you can easily create, edit, and share your scripts, all stored securely in the Cloud. Office Scripts seamlessly integrate with Office Online apps and Power Automate, enabling you to streamline processes and boost productivity like never before. Say goodbye to repetitive tasks and hello to efficiency with Office Scripts in Excel and beyond!