CPE Catalog & Events

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.

Many organizations have a process documented for their employment life cycle but do not look at it wholistically. Having a longer view of the employee life cycle can provide more value to your company that you might think. Join us for an interactive discussion around the entire life cycle of employees with best practices discussed on continuous improvement for your organization. This session will provide an overview of each of the steps in the timeline from multiple perspectives, to provide keen insights on actionable ideas to take back to your workplace and implement today.

The audit standards state that one of the reasons auditors fail to detect fraud is that they don’t know what it looks like.  Prior to the original SAS No. 82, Consideration of Fraud In A Financial Statement Audit, nowhere in any SAS was there a description of what fraud looked like.  So, as they say, if you don’t know what you are looking for, you can often look right at it and not recognize it! This presentation illustrates some of the more common indicators of fraud they most individuals would overlook unless they 1) knew what they were looking for and were 2) actually looking for it.  Contrary to what the standards say about fraud being concealed, I have found that fraud is often laying on the table right in front of you; but no one has discovered it because they have no idea what the indicators of fraud are.

Discover critical insights from the latest Department of Labor studies on employee benefit plan audits and tackle the pressing issue of audit deficiencies head-on. This course dives deep into the most common errors undermining audit quality and explores the underlying causes of these issues. Through practical strategies, engaging case studies, and regulatory guidance, participants will learn how to close gaps in compliance, enhance audit execution, and protect plan participants and beneficiaries. Whether you're an experienced auditor or new to benefit plan audits, this course will equip you with the tools needed to elevate audit quality and ensure regulatory compliance.  

This course highlights when to use Form 433-A or 433-B, along with documents needed to effectively submit an Offer in Compromise (OIC) or Installments Agreement. Settling tax debts is an important part of the IRS collection process, this course helps guide taxpayer representatives through the process so they may efficiently complete these necessary forms. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Discover the communication edge that will take your CPA career to the next level. This comprehensive course empowers CPAs with the tools to enhance clarity, build trust, and drive decisions. Learn to transform complex jargon into actionable insights and develop powerful persuasion techniques that resonate with clients and stakeholders. Join me to sharpen your communication skills and elevate your professional impact. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Estate planning continues to evolve, and staying informed about the latest trends and strategies is crucial for professionals in the field. This forward-looking course delves into the intricacies of estate planning, with a specific focus on current issues. Participants will explore cutting-edge techniques, emerging legal considerations, and industry developments to ensure they are equipped with the knowledge and skills to create effective estate plans that withstand the test of time and safeguard their clients' legacies. *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  

Financial statements prepared for stockholders and external users follow Generally Accepted Accounting Principles (GAAP), while tax returns adhere to the Internal Revenue Code (IRC). These frameworks differ in recognizing profitability, influencing reported income significantly. Companies often aim to minimize taxable income within legal bounds, while maintaining compliance with both financial reporting and tax regulations. - Timing Differences: Variations in income recognition and deductible expenses between GAAP and IRC create timing differences, impacting reported profitability and tax liabilities. - Deferred Tax Assets: Companies accrue deferred tax assets from overpaid taxes or carried-forward credits, which can offset future taxable income, reducing tax liabilities. - Deferred Tax Liabilities: When taxable income is less than reported income, deferred tax liabilities arise, necessitating future tax payments when temporary differences reverse. Join us to delve into these concepts, exploring how financial reporting choices and tax strategies shape a company's financial performance and compliance obligations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Each event is a rebroadcast of the live Town Hall webcast from the previous week. The AICPA Town Hall Series delivers: Timely & Critical Information Interpretation & Analysis Firm and Business Strategies Practitioner Capabilities **Free for AICPA members Not an AICPA or CIMA member? Become one today.

*** Save 15% on this event when you use the code SAVE15 at checkout ***Demystify the complex world of passive activity rules. Build a rock-solid foundation by learning how to distinguish passive income from nonpassive income and understand the reasoning behind Congress’s creation of these rules — a key to making smart grouping decisions. We’ll take a deep dive into how to group activities in the most tax-efficient way, plus cover clever strategies like creating passive income generators and avoiding the permanent loss of passive activity carryovers. If passive activity rules have ever felt overwhelming, this engaging, practical session will help you turn confusion into confidence.This course is part of a four-seminar series. Take it as a stand-alone seminar or sign up for the entire series for a comprehensive passive activity training.

Generative AI is seemingly everywhere, and business professionals are embracing the technology. And for a good reason - generative AI provides opportunities for enormous gains in efficiency and productivity. However, those gains can be even greater if you understand best practices for issuing AI prompts. In this session, you will learn the best ways to ask questions of your AI platforms so that you get the information you seek quickly and easily. Stop wasting time with inefficient and ineffective prompts! Learn the best ways to get the information you seek!

Part 2 of a 2-part series is an overview of GAAP requirements for nonprofit organizations and will help you become proficient in nonprofit financial reporting. This session focuses on revenue recognition. Be sure to register for part 1 in the series: Nonprofit A&A Series Part 1: Financial Statement Presentation & Disclosure

Power BI - Bringing It All Together for Data Analysis is an advanced-level course designed for professionals looking to integrate and optimize their use of Microsoft Power Pivot and Power BI. Building on the foundational knowledge from previous courses, this session focuses on the crucial next steps after creating data models and measures, guiding participants on how to fully utilize the potential of these tools to uncover insights and create impactful, actionable visualizations. This course takes a deep dive into the critical aspects of using Power BI to its fullest potential, emphasizing a holistic approach to data analytics. You'll learn how to build a streamlined workflow, ensuring every step in your data journey contributes to actionable insights. The course also focuses on optimizing performance for data models, utilizing advanced features of Power BI Services, and moving beyond basic data models to create advanced solutions tailored to real-world business needs. By the end of the course, you'll be able to synthesize all your Power BI skills to design and deliver powerful analytics solutions tailored to any audience. Whether you're presenting to stakeholders, sharing insights across teams, or managing enterprise-level reporting, this course will equip you with the tools and strategies to succeed. Perfect for Power BI users looking to tie all the pieces together into a comprehensive, efficient workflow. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Even though they have been around for several years, the tax laws pertaining to S corporations remain some of the more difficult areas of the Internal Revenue Code. Given the rising popularity of S corporations, understanding how shareholder basis and the equity section of the balance sheet work together for tax purposes is imperative for nearly any tax practitioner. In this course, we will discuss this relationship. Using examples and illustrations, we will show how contributions, operating transactions, and distributions affect shareholder basis as well as equity.

This course provides a comprehensive analysis of the SECURE 2.0 Act. The principal focus of the Act is to expand retirement coverage and increase retirement savings. As such, the Act has many important changes relating to IRAs and qualified plans. This legislation alters the landscape of retirement planning for taxpayers of all ages. Make sure you are up to date with the latest information available in order to effectively advise your clients on these important changes.

The new Standards emphasize that quality performance requires conformance to the Standards. Each standard within Domain III specifically identifies the responsibilities of the CAE and the board, as well as joint responsibilities. The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service

This course provides a comprehensive update on the key developments impacting not-for-profit (NFP) accounting and auditing in 2025. While the FASB hasn't recently issued NFP-specific standards, several Accounting Standard Updates (ASUs) will significantly affect nonprofit organizations. We'll review these changes and their implications. We also explore the growing relevance of programmatic investments and their interplay with the Current Expected Credit Losses (CECL) standard, and examine the IFR4NPO initiative, a global project aimed at establishing universal financial reporting standards for nonprofits. On the auditing side, we'll delve into the impact of the new quality management standards, impacting firms that provide attestation services, including compilations and reviews for nonprofits. This session will equip you with the insights needed to navigate these changes and stay compliant.

There is simply no denying that a sufficiently designed and effectively operating system of internal controls over reliable financial reporting is more important than ever. The primary objective of this course is to give participants "hands-on" practice in designing, evaluating, and communicating conclusions related to design and operating effectiveness of internal controls over reliable financial reporting and other risks for nonprofit environments. 

This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction. A detailed analysis of the self-rental passive activity rules will be given, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. *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

Tax professionals can get caught up on all the latest developments in the areas of individual, estate, trust and gift tax in this comprehensive course.