CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Taking Advantage of Array Formulas in Excel
-
Online
2.00 Credits
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's IRS Tax Examinations and Hot Issues
-
Online
4.00 Credits
The Inflation Reduction Act increased the IRS budget. As a result, the IRS continues to replenish its audit workforce. The IRS trains its audit workforce by examining the tax returns of individuals and small businesses. Now, more than ever, Accounting, Tax and Financial Professionals need clients to understand the need for documentation and procedures to substantiate what IRS examiners are pursuing. Learn the high audit risk areas and ways to help clients survive an IRS audit with little or no change. It is critical for Accounting, Tax, and Financial Professionals in public accounting to understand the risk to clients and to themselves in tax return preparation and planning since the IRS continues to increase its audit coverage and is examining more taxpayers than it has in the recent past.This course qualifies for IRS credit.
Surgent's Performing an Effective Audit Risk Assessment
-
Online
4.00 Credits
Recent feedback from the AICPA has emphasized the importance of performing an effective risk assessment to identify and evaluate the risk of material misstatement in a financial statement audit. SAS 145, the 2023 amendment to AU-C 315, makes significant changes to the extant risk assessment standard and certain changes to other standards as well. The amendments clarify confusion that the AICPA believes auditors experienced under the existing standard and also conforms, for the most part, to the IAASB standard on the same topic. SAS 145 has been effective for two years now starting with December 31, 2023 audits. This course will focus on how to perform the risk assessment process under the new standard, providing participants with a summary of the changes to existing guidance. It will discuss linking the results of the risk assessment to further testing (internal control and substantive testing) and procedures performed in concluding on the evidence obtained. In addition, it will also discuss documentation and audit communications.
CAF Cluster: Unlocking AI - Fundamentals and Generative AI for Accountants
-
Online
4.00 Credits
Save a minimum of $50 when you purchase any 4 or more of MOCPA's Cluster Events. USE CODE "CLUSTER25" AT CHECKOUT. This course covers the foundational concepts of artificial intelligence (AI) and its relevance to accounting. Participants will explore various AI applications, including generative AI and prompt engineering, and understand the benefits, challenges, and future trends associated with AI integration in accounting.
Getting SASsy - A Look at Recent Auditing Standards
-
Online
1.00 Credits
This session provides an overview regarding recent standards that should be top-of-mind for auditors in addition to providing insight regarding auditing standards that will soon be effective.
H.R. 1's Hidden Gems: Planning Essentials Beyond the Headlines
-
Online
1.00 Credits
This hidden gems session will spotlight lesser-known provisions of H.R. 1, also known as OBBBA, that advisers may overlook but that carry important planning implications for clients. It will cover changes to: Health savings accounts 529 education savings accounts Student loans Dependent care assistance plans Revised 1099 reporting thresholds This session will also cover other key updates that may get missed.
Mental Illness & Depression: Understanding & Supporting Employees Under the ADA
-
Online
1.00 Credits
This webinar aims to provide HR professionals with a comprehensive understanding of mental illness and depression under the Americans with Disabilities Act (ADA). It will cover key aspects of the law, provide practical advice, and address common challenges.
HR Investigations - Episode 1 - Introduction-Assessing-Planning
-
Online
1.00 Credits
Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session is an introduction to these differences and provides best practices for assessing allegations of employee misconduct and planning the investigation. Attendees will end the session with takeaways to immediately implement in future HR investigations. Episodes 2 and 3 complete the series.
Will Your Ethics Be Burned by Burnout?
-
Online
2.00 Credits
Ethical behavior is not a destination it is a journey with twists, turns, and bumps in the road. We are faced with ethical dilemmas every day. Do I speed to make it to a meeting? Do I call in sick because I need a break? When does "helping my child with their homework" become "doing it for them"? CPAs are ethical most of the time, but staying ethical is hard. It gets harder when we are under stress. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Tax Loss Limitations Imposed on Individuals and Pass-through Entities
-
Online
3.00 Credits
Tax practitioners advising their business clients must be fully informed regarding the multiple loss limitation provisions that apply to individuals conducting businesses and pass-through entities. This program covers the loss limitation rules that tax practitioners must know in order to advise their individual and pass-through entity clients fully and adequately as to when and if a loss limitation applies. The loss limitations discussed in this program start with an introductory discussion of hobby loss rules and graduate to a more substantive discussion of the remaining loss limitations: basis limits, at-risk rules, passive loss limits, excess business loss limits, net operating losses, and the Section 163(j) interest limitation. Knowing when loss limits apply is essential for any tax practitioner. This program will put you in a position to advise clients fully and intelligently regarding each of the loss limits.This course qualifies for IRS credit.
SAS No. 122, AU 315, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstate
-
Online
3.00 Credits
If you do not understand the entity that you are auditing, you won’t know what type of transactions they should be entering into. As a result, you won’t recognize those transactions they should not be there. In other words, you will be performing the audit without having any idea of what you should be looking at. This statement requires that the auditor document their understanding of the entity and its environment that it operates in as well as assessing the risks of material misstatement. Prior to this statement, auditors often assessed risk at maximum and did not evaluate internal controls. A big change made by this statement is that, while it allowed the auditor to continue to assess risk at maximum, they now must first evaluate internal controls in order to have a basis for making such an assumption. As a result, auditors are now required to document their evaluation of internal controls on every financial statement audit. This presentation is an overview of the many procedures auditors are now required to perform and document on every audit related to their understanding of the entity and its environment and the basis for assessing the risk of material misstatement.
Estate & Trust Primer - Tax Staff Essentials
-
Online
4.00 Credits
A comprehensive guide to estate planning and the taxation of trusts.
Forensic Accounting: When The Office Is A Crime Scene
-
Online
4.00 Credits
Embezzlement happens often to many small businesses. Unfortunately, the lack of internal controls allow the embezzlement to remain undetected for years. But when it is discovered, the small business owner will most likely contact their CPA for advice. What should you do when your client contacts you about their employee embezzling money from their business? What options should you present to your client? How can your client protect themselves, while investigating the embezzlement? What steps need to be taken about preserving any documents, emails, texts, or phone calls? This course teaches how to engage the client, properly identify the evidence needed to prove the crime, how to write the report for civil and criminal trial, and best practices in preserving electronic and paper evidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Business Tax Update: Recent Developments
-
Online
2.00 Credits
A discussion of the latest 2021/222 tax developments impacting business taxpayers, with a focus on important provisions, rules and concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Grading Your Auditors - Are You Getting the Most Value?
-
Online
2.00 Credits
An audit is an investment in reliable financial reporting and compliance, and an increased return on those dollars can be achieved by hiring the right auditors. This course will provide key factors for you to consider when evaluating whether you are getting the most quality and insight from your auditors, to enable them to perform the most value-added audit possible in the given circumstances - while retaining the trust of a CPA. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Controllers Role in Data Analytics and Big Data
-
Online
1.50 Credits
Today’s economy and all of the digital enhancements have impacted the way companies engage with their customers as well as how the company manages their internal practices. The business control function needs to keep pace. The rising importance of analytical capability is critical when defining the role of the modern controller. Execution of analytics can vary but there are still key questions that must be asked. What are the options and what we need to understand to decide the best way forward? This course focuses on the value that can be brought by the Controller when becoming involved with data analytics powered by technology and also Big Data. The digitized world we live in has made it important for the Controller function to evolve and take on this advanced task.
Roadmap to Ethical Decision Making
-
Online
2.00 Credits
Practitioners need to exercise caution to ensure they maintain independence as they assist their clients with reviews, audits, and compilation engagements. This course provides a roadmap to best practices and guidance provided by the AICPA's Code of Professional Conduct and analyzes and applies it to actual scenario-based case studies, providing accounting professionals with ethical standards to integrate into their practices.
How to Build a Custom AI Chatbot and GPT in Plain English
-
Online
2.00 Credits
Participants will learn to create customized AI chatbots that can enhance client interaction and internal operations-all without coding experience. This course provides a concise overview of specialized, task-oriented AI chatbots and GPT builders, focusing on how these technologies are revolutionizing professional workflows. Through hands-on exploration of platforms like AgentGPT, Claude Projects, Gemini Gems, and NotebookLM, participants will learn to design, deploy, and manage custom AI assistants tailored to their specific needs. The course emphasizes creating advanced AI apps that can understand context and solve complex problems autonomously. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Taxation of Judgements and Settlements
-
Online
2.40 Credits
In the course of legal actions, payments may be made pursuant to a final disposition of a court case or a mutually agreed-upon settlement. This course will cover the tax implications for payments made for personal injury, emotional distress, lost wages, punitive awards, pre- and post-judgement interest, contract claims, among other damages. **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.
SECURE Act 2.0 and Updates (2025)
-
Online
2.00 Credits
After a false start in 2022 when it failed to pass through Congress, the Secure Act 2.0 was passed in a flurry of year-end legislation. This two hour program will cover the important changes in savings and distributions of retirement plans that impact individuals. Employers will also need to consider how Secure Act 2.0 will the administration of existing plans or the creation of new ones. This course will provide a concise look at these hot topics. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.