CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Excel for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check
-
Online
3.50 Credits
Relevant Excel methods for accounting experts In Excel, there are several opportunities to apply features, functions and methods to build a dynamic workbook. In this hands-on demonstration of several Excel skills, you'll review the following topics through engaging expert-led instruction: Dynamic headers Horizontal reports Mapping Tables Data Validation Excel error checking skill development Designed with time for you to work along with the facilitator, this webcast examines the importance of automating reporting workbooks in Excel. You will review various topics, including: Horizontal or crosstab reports Mapping tables and how they are the key to unlocking major efficiency gains. Data validation in digital reports Error Check *Session 8 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching other parts of the bundle. [Excel for Accounting Professionals Webcast Series] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-webcast-series-bundle) to further prepare to tackle real-world issues and build powerful workbooks.*
Internal Controls for Small and Medium-Sized Entities
-
Online
1.00 Credits
This session explores the importance of internal controls with an emphasis on best practices for small- and medium-sized entities. We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed.
Strategic Foresight
-
Online
1.00 Credits
In this FutureReady course, Tom Hood explains how Strategic Foresight is crucial to preparing your organization for a future of exponential change. First, he defines Strategic Foresight and shares different ways of applying it. Then, he demonstrates how to prepare for a future that you can't yet see. And finally, Tom covers different types of innovation and how to apply them to your career and organization.
The Controller Function - Elevating the Role
-
Online
1.50 Credits
This is the beginning of a series that will cover major aspects of the Controllership function. Controllers are essential to the day-to-day accounting for organizations. Yet, the role is not often readily understood. In today’s world of acronyms such as CFO, CEO, COO, CAO, etc., the Controller function may get lost in the shuffle. However, they are a critical group of professionals who ensure the adequacy and transparency of accounting and financial reporting information. A Controller is an individual who has responsibility for all accounting-related activities including high-level accounting, managerial counting, and finance activities within a company. The duties of a Controller include assisting with the preparation of the operating budgets, overseeing financial reporting, and performing essential duties relating to payroll. However, in today’s evolving world, the Controller function can provide much more in-depth value to their organizations. This series is dedicated to exploring the traditional Controller role and stepping out of the box to identify areas where the Controller can add strategic value to their organizations. In this first course we focus on the typical Controller function and begin to identify ways to elevate the function.
The Controller Function - Inventory Part 1
-
Online
1.80 Credits
This course is one of the courses dedicated to our Controllership series. This series of courses is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we will discuss the area of inventory. This specific segment in the first part of a two-part series on inventory. We explore how the controller can move these responsibilities into more of a strategic role. This course takes a look at some of the typical concepts and duties involved in the inventory function that is sometimes viewed as operational roles. We explore how these areas are strongly tied to the importance of the controllership role and how the controller can add value in each area.
K2'S Top Tech Productivity Tips And Tricks
-
Online
2.00 Credits
The world of work changed radically and became much more virtual after the pandemic’s onset in 2020. Over two years into the “new normal,” our team has compiled a list of the top technology productivity tips, tricks, and traps. In this session, you will learn about shortcuts and hacks to help you accomplish more in Excel, Teams, Outlook, virtual meetings, and many other applications you use every day. Attend this session and learn the best tips to help you and your team accomplish more in less time.
Are You Qualified? The Ethics of Practice Development and Skill Enhancement
-
Online
2.00 Credits
For an accounting practice or career to thrive, it must grow and develop. But what about the "Catch-22" of practice development: expertise at anything new requires experience, and experience cannot be attained while you are a non-expert! Or can it? This workshop looks at some of the more popular pathways to practice development (e.g., cybersecurity, client advisory services and cannabis) and considers the drawbacks of reaching too far, too fast.
IRS Cybersecurity Checklist
-
Online
2.00 Credits
This course is designed to provide learners with an understanding of the Internal Revenue Service (IRS) Cybersecurity Checklist and how it can be used to protect taxpayer data. The course will cover the basics of cybersecurity, including threats, risks, and vulnerabilities. Learners will be introduced to the IRS Cybersecurity Checklist, which provides a framework for organizations to assess and enhance their cybersecurity practices. The course will cover the various elements of the IRS Cybersecurity Checklist, including access control, data protection, and employee training. Learners will gain an understanding of the importance of each element and how it contributes to the overall security of taxpayer data. The course will also cover best practices for implementing each element of the IRS Cybersecurity Checklist. Throughout the course, learners will be presented with real-world examples of cybersecurity threats and breaches, highlighting the importance of effective cybersecurity practices. Learners will also be given practical exercises and assessments to reinforce their understanding of the IRS Cybersecurity Checklist. *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.
ChatGPT and Advanced Accounting Research
-
Online
2.00 Credits
This course provides a concise overview of how artificial intelligence, particularly ChatGPT and other AI tools, is transforming accounting research methodologies and practices. Students will explore the shift from traditional search engine-based research to AI-driven insights, learning how to leverage various AI platforms for enhanced financial analysis, regulatory compliance, and strategic decision-making. The course emphasizes practical applications of AI in accounting contexts while addressing critical considerations such as data verification, ethical usage, and professional judgment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Independence Requirements for CAAS Engagements
-
Online
2.00 Credits
Understanding independence is essential for CPAs providing Client Advisory and Accounting Services (CAAS) to attest clients. This course provides a comprehensive overview of the AICPA Code of Professional Conduct, focusing on the guidelines for maintaining independence while delivering CAAS. We'll review the overall independence process and its application to CAAS engagements, followed by an in-depth exploration of specific services, including reconciliations, accounting standard implementation, information system services, bookkeeping, hosting, and payroll services. Attendees will gain clarity on what services are permissible and how to navigate potential independence issues to remain compliant and uphold professional standards.
Navigating IRS Authorizations: Understanding Power of Attorney, Form 2848, and Form 8821 - 2 hrs
-
Online
2.00 Credits
This two-hour course provides a comprehensive overview of the IRS collection process, guiding tax professionals through each stage, from the initial notice to enforced collection actions. Participants will gain insights into taxpayer expectations during the collection process, as well as strategies for resolving tax debts. The course highlights when to use Form 433-A or 433-B, the documentation needed, and the criteria for submitting an Offer in Compromise (OIC) to settle tax debts for less than the full amount owed. Attendees will also learn about the various payment options available and practical approaches to advising clients. *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
Surgent's Working Remotely: Best Practices, Challenges, and Opportunities
-
Online
2.00 Credits
Working from home presents both benefits and challenges for professionals. For employees, working from home provides opportunities to be more productive and gain time that would otherwise be spent commuting to and from the office. Employers who utilize remote work enjoy fewer fixed costs, more efficiency, and greater employee satisfaction. Without proper planning, professionals who work remotely may experience increased anxiety and disorganization. They may also jeopardize data privacy. However, when executed properly, working remotely can help organizations become more efficient and profitable, while at the same time improving employee morale. This course looks at how firms and companies have successfully implemented work from home programs and discusses mistakes that can be avoided through proper planning.
Lessons on Fraud Prevention from Sam Bankman-Fried's Crypto
-
Online
2.00 Credits
This course chronicles the decisions that led to the arrest of Sam Bankman-Fried (SBF), and helps participants understand the consequences that will follow for people charged with business-related crimes. Authorities arrested SBF pursuant to a grand jury indictment that charged him with wire fraud, securities fraud, money laundering, and related conspiracy charges. This lesson chronicles how the former billionaire's business decisions exposed him to criminal charges that include potential penalties of more than 100 years in federal prison for his alleged role in defrauding investors who trusted in his ability to make ethical decisions. Participants will learn about the criminal justice process, including indictments, arrest, extradition, judicial proceedings, mitigation, sentencing, prison, and collateral consequences. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Employment Law 101
-
Online
1.00 Credits
Review of the major employment laws governing the workplace, when they are triggered, and key compliance aspects under each law. This presentation is designed to give viewers enough information to issue spot when matters arise in the workplace.
Preparing for & Conducting Discharge Meetings
-
Online
1.00 Credits
Over 80% of all employment-related lawsuits relate to termination. Every termination should be treated as a potential lawsuit. The facts supporting a leader's recommendation of discharge must be fully investigated. The discharge of an employee requires prior review and approval. Narrow self-interest, spite, or personal animosity must not play a part in making termination decisions. This course provides practical knowledge and scripts for handling discharges with good judgment such that personal and employer liability is avoided.
2025 AICPA Regulatory Ethics Update (VBOA Approved)
-
Online
2.00 Credits
Stay ahead of the curve with this VBOA-approved ethics course designed to meet Virginia's ethics requirements while keeping you informed on the latest developments at the AICPA. The Professional Ethics Executive Committee (PEEC) has been active recently, issuing new guidance and updating existing rules. In this session, we'll explore the most impactful changes, including updates on fees, recruiting, CPE, and NOCLAR (noncompliance with laws and regulations). CPAs in both industry and public accounting will gain the insights needed to stay compliant in an evolving regulatory environment. We'll also provide a sneak peek at key projects PEEC is expected to finalize soon, ensuring you're prepared for what's next.
Self-Rental Real Estate: Passive Activity & Section 199A
-
Online
2.00 Credits
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. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Effective Governance for Nonprofit Success
-
Online
1.00 Credits
Effective governance is the cornerstone of any nonprofit organization. This course delves into the foundational elements of nonprofit governance, emphasizing fiduciary duties, board responsibilities, and best practices for board operations. Participants will explore key compliance requirements, risk management strategies, policy development, and regulatory obligations. By the end of the session, you'll be equipped with practical tools and insights to confidently navigate the complexities of nonprofit governance.
Tech It to the Next Level: Slim Your Team for Max Efficiency
-
Online
1.00 Credits
Ready to slim down your team and maximize efficiency without sacrificing quality? This session breaks down how to leverage tech and automation to fill workflow gaps, build a strong tech stack, and connect tools seamlessly. Learn how one proven tech stack replaced more than half a traditional team while improving client satisfaction and reducing overhead. Walk away with practical steps to streamline operations, automate repetitive tasks, and focus your resources on what really matters. Attendees will gain practical insights into streamlining operations, automating repetitive tasks, and focusing resources on high-value activities. The session also includes an exclusive look at a proven tech stack used to replace over half a traditional team, offering actionable steps to create a leaner, tech-driven, scalable firm. Perfect for firm owners ready to rethink staffing, reduce overhead, and embrace the future of accounting efficiency. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Controller Function - Strategic and Annual Planning
-
Online
1.20 Credits
This course corresponds to our Controllership series. Within this course, we specifically address the Controllers role and pro-active potentials in organization Strategic and Annual Planning. This series of courses is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the Controller can add strategic value to their organizations. Controllers are essential to the day-to-day accounting for organizations. Yet, the role is not often readily understood. In today’s world of acronyms such as CFO, CEO, COO, CAO, etc. the Controller function may get lost in the shuffle. However, they are a critical group of professionals who ensure the adequacy and transparency of accounting and financial reporting information. When it comes to the task of strategic planning, many feel this role is primarily the responsibility of the executive team and board. However, in this course, we delve into the various steps of the strategic plan and explore where the Controller can add strategic value through providing functional input and insight. Strategic planning is a process used to identify goals, the strategies necessary to accomplish those goals, and the internal performance management system that will be used to monitor and evaluate progress.