WICPA CPE & Special Event Catalog
Building Security & Efficiency With Internal Control
-
Online
8.00 Credits
Member Price: $239
A well-designed internal controls system can and will drive all entity objectives. Too many times control creators focus too much on security. It is important to properly balance protection-based measures with those designed to enhance efficiency. This session works to illustrate the power of a strong and well supported control system. It also discusses steps to take in order to establish such a system. This material is becoming more and more beneficial as companies strive to address many new business challenges such as evolving markets, the rapid rate of change in the business world and the notable increase in governmental and industry-based regulation. Those that desire a balanced and workplace enhancing control system should strongly consider this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excelling at Excel: The Magic of Power Query
-
Online
2.00 Credits
Member Price: $89
Elevate your data analysis capabilities with our focused course on Power Query. Tailored for financial professionals, this training will show you how to get started using Power Query & teach you some of the ways to take advantage of its ability to handle messy data & automate repetitive tasks. Harness the efficiency of Power Query to revolutionize the way you work with data. Learn how to "program" your tasks once & set them on repeat, eliminating the need for repetitive, robotic work. This automation not only saves time but also ensures consistency & accuracy in your data processes. Whether you're dealing with complex datasets or simply looking to streamline your reporting processes, this course will equip you with the tools & knowledge to make Excel work for you like never before.
The 10 Must Know Excel Features
-
Online
2.00 Credits
Member Price: $89
Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2’s Better Reporting With QuickBooks Online
-
Online
1.00 Credits
Member Price: $39
With over 7 million businesses relying on QuickBooks Online, one thing is clear: excellent financial reporting isn't optional: it's essential. Yet many users struggle to access the insights they need, often limited by subscription tiers or simply unaware of the powerful tools at their fingertips-that's where this session comes in. This session is your fast track to mastering QuickBooks Online's reporting capabilities. Whether you're a small business owner, accountant, or financial manager, you'll discover how to: Build & customize Standard, Custom & Management Reports Leverage the new Spreadsheet Sync tool to create dynamic, multi-company reports in Excel Uncover hidden features that help you make smarter, faster decisions If you're ready to transform your data into actionable insights & finally get the reports you need, this session is your game-changer. Join us & take control of your QuickBooks Online reporting like never before!
AICPA's New SSTS #4: New Ethics Standard for Tax Resolution
-
Online
1.00 Credits
Member Price: $55
This 1-hour course is designed for CPAs and EAs who want to stay ahead in the ever-evolving field of tax resolution. Dive into the latest updates to the AICPA Statements on Standards for Tax Services (SSTS) #4 and explore their practical implications for your practice. Through real-world examples and case studies, you'll gain a deeper understanding of how to navigate ethical challenges while maintaining compliance with professional standards. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Corporate Transparency Act Developments
-
Online
2.00 Credits
Member Price: $89
U.S. Department of Treasury's Financial Crimes Enforcement Network (FinCEN) imposed a new reporting requirement that went into effect on January 1, 2024. Millions of businesses may have to file a Beneficial Ownership Information (BOI) Report. In a surprise turn of events, the Federal District Court from the Northern District of Alabama ruled on March 1, 2024 in National Small Business United v. Yellen ("NSB") that the CTA is unconstitutional. This course will discuss the CTA's provisions and the court's decision in NSB. Also covered will be future implications for business entities and steps to consider given the recent ruling. We will also discuss recent proposed rulemaking by FinCen with respect to nonfinanced purchases of residential real estate and gratuitous transfers so that businesses can prepare for any additional reporting burdens that might arise. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Accounting & Tax Ethics: Standards, Issues, & Case Studies 26-27
-
Online
4.00 Credits
Member Price: $175
In recent history, even the most prestigious CPA firms have had ethical lapses and oversights that have cost them both financially and, at that moment, clouded their brand. This course will review the AICPA code of ethics for both accounting and tax practitioners and encourage you to examine your firm's policies and choices relative to those standards and common sense through thought-provoking and sometimes humorous Q&A and case studies. Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
Firm Ethics -- A Practical Approach 26-27
-
Online
4.00 Credits
Member Price: $175
In this course, you'll review what ethics means for a CPA firm and how to use the rules. The interactive workshop is designed for practitioners in small and medium-sized CPA firms and includes generous time for questions and case studies. Note: This course qualifies to count toward the WICPA membership Ethics CPE requirement.
K2's Mastering Advanced Excel Functions 26-27
-
Online
4.00 Credits
Member Price: $175
Are you ready to move past Excel's simple functions, such as SUM" If so, participate in this session to learn about many of Excel's advanced functions, including XLOOKUP, SUMIFS and SWITCH. You'll also learn about the revolutionary Dynamic Arrays feature.
S Corporation Preparation, Basis Calculations & Distributions: Form 1120S Schedule K & K-1 Analysis
-
Online
8.00 Credits
Member Price: $300
This comprehensive training is designed to get the accountant up to speed quickly with S corporation formation & preparation issues as well as a complete understanding of calculating a shareholder's stock & debt basis. The cornerstone of this course is the in-depth line-by-line analysis of the Form 1120S Schedule K & K-1 & how these items affect the shareholder's Federal individual income tax return. 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 & submit to terri.storer@acpen.com
Cybersecurity: Protecting Your Firm's Data & Reputation
-
Online
2.00 Credits
Member Price: $89
Cybersecurity protection of digital data continues to be a top priority for CPAs. The cyber threats continue to increase and are becoming more sophisticated with the advent of AI technology. The first step is to understand what the primary threats are, the potential damage they can inflict and, most importantly, how to mitigate the risks. This course will prepare you have informed conversations with your IT service providers to ensure you are employing best practices in cybersecurity protection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
A Fox in the Henhouse/Courthouse
-
Online
1.00 Credits
Member Price: $39
The ancient Romans had a saying about using caution when appointing someone to a position of trust, "don't set a wolf to watch the sheep". That saying is in use today & has changed to include "don't put a fox to guard the henhouses";. The thought is similar, but the wolf & fox are vastly different animals. Wolves rely upon their strength to survive while foxes rely on their cunning. Like foxes, fraudsters rely upon their cunning to defeat or circumvent internal controls. This session reviews the investigation of a deputy court clerk who exploited a weakness in internal controls & committed fraud in the courthouse.
The Future of Audit: Technology, Talent & Transformation
-
Online
1.00 Credits
Member Price: $55
The audit profession stands at a critical inflection point, facing unprecedented challenges from technological disruption, evolving regulatory landscapes and workforce transformation. This comprehensive course, based on the Pennsylvania Institute of CPAs' groundbreaking research report "The Future of the Audit: Building Relevance and Sustaining Quality," provides auditors with essential insights and actionable strategies to navigate these seismic shifts. Through expert perspectives from industry leaders including PCAOB board members, Big Four executives and audit committee chairs, participants will explore how artificial intelligence, blockchain and data analytics are fundamentally reshaping audit practices while creating new opportunities for value creation and risk assessment. Beyond technology adoption, this course addresses the pressing talent crisis facing the profession and offers practical solutions for building a future-ready workforce. Participants will learn how to leverage emerging technologies to enhance audit quality, understand the implications of regulatory modernization including the concept of "regulatory sandboxes," and develop strategies for attracting and retaining top talent in an increasingly competitive market. Whether you're a partner in a small firm, a manager in a large organization, or an audit professional seeking to future-proof your career, this course provides the roadmap for maintaining relevance, ensuring quality and thriving in the evolving audit landscape. You'll leave with concrete action steps for immediate implementation and a clear vision for transforming your audit practice to meet the demands of tomorrow's financial ecosystem. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Benford’s Law & Other Digital Analysis Techniques
-
Online
1.80 Credits
Member Price: $79
Numbers & especially the digits within those numbers can conceal a lot of information. Benford's Law & other digital analysis techniques can be the keys to unlocking that information. This session will explain what Benford's Law is, how it works & how it can be used to reveal bogus information & made-up data. Accountants & auditors should understand how to use this valuable audit tool as well as other digital analysis techniques. But, if you attend this session, you must promise not to reveal the secret behind these techniques to any fraud perpetrators.
GASB 96 –SBITA, GASB 94 P3 & GASB 87 Leases (Year 2)
-
Online
2.00 Credits
Member Price: $89
This is a 2 hour webcast that will focus on the similarities between all three of these GASB accounting standards that deal with contractual arrangements such as leases, Subscription-Based Information Technology Arrangements (SBITA) & P3s. Compare & contrast these standards as you prepare for implementation this year of GASB 94 & GASB 96 & review the implementation efforts of Leases in Year 2.
Leveraging ChatGPT for Innovative Business Advisory Services
-
Online
2.00 Credits
Member Price: $89
In this cutting-edge course, participants will gain a deep understanding of how to leverage ChatGPT, OpenAI's powerful language model, to innovate and enhance business advisory services in the accounting sector. The course integrates theory and practice, demonstrating how various enterprise evaluation methodologies can be applied in conjunction with ChatGPT for increased business analysis efficiency, profitability and growth. It also provides hands-on training for implementing these techniques in real-world scenarios. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Key Tax Issues Facing Business & Industry
-
Online
4.00 Credits
Member Price: $149
This course focuses on the key federal tax issues affecting business From the internal accountant's point of view, with a focus on the major ramifications of the TCJA & other recent tax legislation & developments. Planning alternatives & the potential risks associated with those strategies will also be discussed. 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 & submit to terri.storer@acpen.com
Multistate Taxation: Issues & Planning Opportunities
-
Online
8.00 Credits
Member Price: $250
Join our course on Multistate Taxation: Issues & Planning Opportunities designed for financial professionals. Learn about crucial topics like nexus implications, state taxable income calculations & audit defense strategies. Gain practical insights to integrate these considerations into client financial plans effectively. From deciphering complex formulas to understanding state-specific regulations, this course equips you with actionable knowledge to excel in finance. Explore multistate business activities, choice of business entity & interstate commerce clauses. By course completion, you'll be ready to identify common pitfalls, mitigate risks & ensure compliance with multistate taxation. Join us & navigate the complexities of finance confidently. 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 & submit to kori.herrera@acpen.com.
Profiles in Fraud
-
Online
2.00 Credits
Member Price: $89
Nobody is immune to fraud risk. This course opens with stories of real fraud perpetrators then examines the similarities between the fraud perpetrators, discovering that they all have many common traits. It finishes with techniques accountants can use to deter these behaviors. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2026/27 Yellow Book Update
-
Online
1.00 Credits
Member Price: $55
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.
