CPE Catalog & Events

*** Save 15% on this event when you use the code SAVE15 at checkout *** The traditional manual cycle of exporting, cleaning, and formatting reports is a significant drain on professional productivity. This session demonstrates how to transform this process by integrating Excel's Power Query with the analytical power of ChatGPT. We will explore the "Extract, Transform, Load" (ETL) lifecycle, showing how to create repeatable, one-click reporting workflows that handle messy data with ease. Participants will learn advanced techniques for using AI to write complex M code and DAX formulas, automate variance analysis narratives, and bridge the gap between disparate data sources. Attendees will leave with a practical framework for building "self-healing" reports that scale with their firm's needs, turning hours of manual labor into seconds of automated processing.

As financial leaders, CPAs are often tasked with managing organizational risk. In this respect, the supplier relationship can be a tricky one. It is often one of the more familiar and comfortable business relationships we have, yet it may also be the one that presents the most significant risk to our company. In this course, we will explore how to manage the supplier relationship from onboarding to termination. Through case studies and best practices, we will discuss how to continue being a good partner to our suppliers while also understanding where potential risks exist. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Discover how artificial intelligence is transforming the accounting profession in this dynamic, intermediate-level CPE session. Microsoft Copilot for Accounting and Financial Professionals explores how AI-powered tools in Microsoft 365-like Excel, Outlook, and Teams-can streamline workflows, enhance data analysis, and improve client service. Learn how to harness Copilot to automate tasks, generate financial insights, and collaborate more effectively, while maintaining compliance and data integrity. Whether you're in public accounting, corporate finance, or advisory services, this course will equip you with practical strategies to integrate Copilot into your daily work and prepare for the future of intelligent accounting.

Technology has given us many new writing tools, but they may just allow an inexperienced novice to turn out poor communications more quickly.  Whatever your expertise level, this webinar will help you take your writing skills to another level, saving your time and making it far more likely your reader will read and understand your message.  

Until recently, a percentage of organizations discounted the risk related to external fraud attempts. Most were only concerned with protecting physical assets such as inventory or fixed assets. However, because of the many highly publicized corporate hacking events, such as the ones that affected the Colonial Pipeline and JBS Meats, more attention is being paid to external fraud risk of all types. In this session, we look at what is included in a definition of external fraud and then delve into specific control issues that can give rise to increased risk. We then discuss measures that organizations can employ to help reduce exposure to external attacks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Specifically designed for preparation, compilation, and review practitioners, this course provides a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-27 by the AICPA's Accounting and Review Services Committee (ARSC). The course also reviews recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARSs requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform compilation, preparation, and review engagements.

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.

Many small to medium sized companies do not properly address the risk that arises related to fraud because these organizations do not have the resources needed to mitigate this risk or because owners or those in top level management underestimate the scope of the issue. All organizations, regardless of size, must be aware of the risks associated with intentional fraudulent acts and know that a significant and effective fraud scheme could even create going concern issues for some entities. In this session, we delve into the reasons that fraud takes place. The material discusses the types of defalcations that are often executed against smaller entities and then explores measures that organizations can implement to help stop fraud activities and add security. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

This course provides a high-level overview of the most important accounting, financial reporting, compliance and audit issues facing nonprofit entities and their accountants. The focus is on explaining the basis behind major issues and trends in executive summary (yet practical) form, enabling professionals to understand the most important aspects of relevant standards, and the basis for any potential changes on the horizon. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Accurate and effective financial reporting is essential for every not-for-profit organization, and it requires a solid understanding of today's reporting requirements. This course equips professionals with the knowledge and tools to confidently navigate not-for-profit accounting standards. You'll learn how requirements are applied in financial statements, explore available reporting options, and gain clarity on key areas such as net assets, contributions, and functional expense reporting. Through a highly illustrative format and over 30 targeted exercises, this course provides a practical, hands-on approach to building expertise in not-for-profit accounting and reporting.

This program reviews the statutory and regulatory guidance as they relate to fringe benefits. There will be an emphasis on entertainment, meals and business transportation expenses, including qualified employer-provided parking, with a focus on planning opportunities. Recent federal tax legislation, cases and rulings will also be addressed. 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 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.

Sometimes the vernacular of accounting seems more challenging than technical aspects. This session offers suggestions for translating the foreign language of taxation into tangible terms for non-accountants. We explore techniques for simplifying the complexity of taxation terminology. This course will equip you with tools for demystifying tax technicalities so you can help clients and other non-tax professionals grasp fundamental concepts.

Here's a more detailed look at the controller's role in AI: 1. Data Integrity and Quality: •    Controllers are responsible for ensuring the quality and integrity of data used to train and inform AI models.  •    They work to establish data governance frameworks, implement data quality initiatives, and ensure data lineage (tracking data from source to downstream systems).  2. Risk Management: •    Controllers assess potential risks associated with AI implementation, including inaccuracies, vulnerabilities, and ethical considerations.  •    They help define and implement risk management frameworks for AI, ensuring that AI systems are used responsibly and ethically.  3. Compliance:  •    Controllers stay informed about relevant regulations and ensure AI systems are compliant with those regulations. •    They monitor AI systems to ensure they are not violating any laws or policies. 4. Transparency and Auditability:  •    Controllers work to ensure that AI decisions are transparent and auditable. •    They establish processes to review AI decisions and identify potential biases or errors. 5. Collaboration and Training:  •    Controllers work with IT and business teams to understand AI's capabilities and limitations. •    They provide training to teams on how to use and manage AI tools effectively. 6. Value Creation: •    Controllers can leverage AI to identify areas for automation, improve efficiency, and gain real-time insights into financial operations.  •    They can use AI to make more informed decisions and create more strategic recommendations for action.  7. Emerging Role: •    The role of the controller is evolving with the rise of AI, with controllers becoming more hands-on throughout the implementation process.  •    They are increasingly seen as catalysts for AI-enabled transformation, helping to identify potential use cases and build confidence in the technology This course will explore many of these topics.

This course will examine certain qualities a leader must exhibit to set an ethical tone from the top.

Most leadership development focuses on a single direction within the organizational hierarchy: downstream to subordinates. While it is important to be a good boss, leadership is much more than that. The best leaders learn to lead well in all directions. They lead upward to superiors and across among peers throughout the organization. And it all starts with self-leadership. This often overlooked or misunderstood leadership principle is essential to build a thriving and productive culture. This topic is based on Jon’s book, Mission-Critical Leadership: How Smart Managers Lead Well in All Directions. 

This program presents a detailed analysis of the self-rental passive activity rules, 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 terri.storer@acpen.com  

Quality management represents a significant shift in how CPA firms design, implement, and evaluate audit and attestation quality. This course provides a focused, practical deep dive into the quality management standards and related engagement-level requirements that firms are now operating under. The course covers SQMS 1 and SQMS 2, along with related engagement-level standards, including SAS 146, SAS 145, SSARS 26, and SSAE 23. Emphasis is placed on post-implementation responsibilities, including evaluating the effectiveness of quality management systems and addressing monitoring and remediation requirements. Participants will also examine engagement-level quality management responsibilities, including the auditor’s responsibilities under SAS 146 and the engagement partner's responsibilities in SSARS engagements. The course is designed to help firms navigate the second phase of implementation, moving beyond design and rollout to ongoing evaluation, monitoring, and continuous improvement.