CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Inflation Reduction Act of 2022: Explanation and Planning
-
Online
2.00 Credits
This program provides an explanation of the recently enacted inflation Reduction Act of 2022. 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 Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Online
2.00 Credits
Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.
Ask Me No Questions and I Will Tell You No Lies - The Art of Interviewing & Interrogation
-
Online
3.00 Credits
When we verbally communicate with an individual, we must make a conscious decision as to whether we believe what we have heard. Little do we realize that we are not making a decision based on what we have heard; rather we make a subconscious decision based primarily on what we have seen, or how the body was behaving when the subject was speaking. We often walk away from a conversation with a gut feeling that the person was not telling the truth. That gut feeling is your subconscious. Yet we often have no idea as to why we have that feeling. This presentation is designed to provide the participant with the tools to identify those both verbal and nonverbal indicators that we all give off when we are under stress. Normally, telling the truth does not create stress. When we lie, we know that we are not supposed to and that creates stress, and it will manifest itself in some manner, and that is what a trained interviewer is looking to observe. When we observe indicators of deception, how do we deal with it? How do we get the subject to admit to a wrong-doing when it is not in their best interest to do so? That is one of the many things that will be addressed in this presentation. Whether you are a parent dealing with you kids; an employer dealing with employees or and investigation interviewing a suspect, this presentation will provide you with the tools to assist you in finding the truth.
Achieving Balance in Work and Life - Part 2
-
Online
4.00 Credits
In trying to achieve life balance, various internal and external obstacles arise. In this course we will look at these obstacles and provide specific ways to overcome them. In addition, we will look at how to excel in every area of your life including your relationships, finances, sense of purpose, level of happiness, and your physical health and leisure time pursuits. You will leave this course with powerful methods and a specific plan to move forward in your life in a balanced, healthy, and productive manner. Don't forget to take Part 1 of this amazing course.
Data & Predictive Analytics & Business Intelligence for Controllers/CFOs
-
Online
4.00 Credits
The Accountant role is evolving from data aggregation to knowledge extraction, with a significant emphasis on understanding and leveraging technological advancements. In this era of rapid digital transformation, it is crucial for accountants to grasp the shift towards more analytical roles, learn the tools, and integrate Business Intelligence (BI) and Data Analytics (DA) in their organization and daily practices. This course will focus on raising the accountant's awareness of BI and DA practices, the impact of AI technologies like ChatGPT, and how these can benefit their organization. By embracing these technologies, accountants can enhance their value proposition by transitioning from traditional accounting roles to becoming strategic advisors and decision-makers.
Ethics - A Line in the Sand; Implications for Daily Business
-
Online
4.20 Credits
Ethical behavior continues to be a problem in society and even in the CPA ranks. "Ethics - A Line in the Sand" looks at the behavioral issues that influence how CPA's act. The course will address why individuals make ethical blunders, the state of ethical conduct in business organizations, the relationship between strong cultures, policy and procedures and successful ethical work environments. In addition, the course will highlight the one behavior to watch for as an indicator of potential ethical violations.
Prevention & Detection of Fraud In Small Businesses
-
Online
4.00 Credits
As reported in the Association of Certified Fraud Examiners Occupational Fraud 2022: A Report to the Nations, on average, small businesses lose 5% of their revenue due to fraud. Can the average small business owner afford to lose 5% of their revenue due to fraud? I think not. This presentation is designed to illustrate the numerous ways employees commit fraud in small businesses, how to detect it, and most importantly, how to prevent it. Both auditors and small business owners would both benefit from this presentation.
2024 A Practitioner's Guide to IRAs and Qualified Retirement Plans
-
Online
8.00 Credits
Are you ready to expand your practice and offer comprehensive retirement planning services? Look no further! Delve deeper into the realm of IRAs and qualified retirement plans with this comprehensive eight-hour course tailored for financial practitioners. Understanding the intricate tax implications, design options, and strategic considerations of these plans is essential for meeting your clients' diverse retirement needs effectively. By the end of the program, practitioners will emerge equipped to confidently advise clients on a myriad of retirement planning strategies, enhancing their expertise and credibility in the field. Explore the intricacies of different IRAs, ranging from traditional to Roth, and gain valuable insights into SEPs, qualified plans, and contribution plans. Navigate through the complexities of 401(k) plans, including Roth 401(k)s, and master the art of seamlessly navigating minimum distribution rules. Through practical highlights, case studies, and real-world scenarios, this course empowers practitioners to not only select the optimal retirement plans for their clients' unique financial goals but also to provide personalized retirement solutions tailored to individual needs. Don't miss out on this opportunity to elevate your practice and establish yourself as a trusted advisor in retirement planning. Enroll today and embark on a journey towards maximizing your clients' financial future! **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.
Coaching the Next Generation of CPAs
-
Online
2.00 Credits
Attracting and retaining staff is critical to an organization's success, especially in the age of the millennial worker who will change jobs multiple times in the course of a career. This course will focus on best practices for nurturing the human element of your organization, especially millennial workers who comprise a growing percentage or the workforce. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Monthly Federal Tax Updates - April 2025
-
Online
2.00 Credits
Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. 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 Purchase and Sale of a Residence: Critical Tax Issues
-
Online
2.00 Credits
Many clients end up selling one or more residences during their lifetimes. Tax practitioners must be aware of the tax rules that relate to such sales in order to assist their clients regarding these sales. This program provides general tax practitioners with the tax rules they need to know to help their clients when they sell a personal residence. This program is a comprehensive survey of the various tax issues associated with the sale of a residence.This course qualifies for IRS credit.
Surgent's Ethical Considerations for the CPA
-
Online
4.00 Credits
CPAs today face greater challenges than ever to maintain the high ethical standards of their profession. It is vitally important that all CPAs understand their professional responsibilities related to all aspects of their job. This course, which focuses on key components of the AICPA Code of Professional Conduct, reviews a history of the CPA profession and focuses on ethical requirements that CPAs must adhere to in their everyday practice, including practical examples of potential ethical dilemmas that practitioners may encounter, particularly those related to objectivity and independence. PLEASE NOTE: THIS COURSE COVERS GENERAL ETHICS AND IS APPLICABLE IN STATES IN WHICH STATE-SPECIFIC ETHICS IS NOT REQUIRED. This course does not qualify for IRS credit.
Communication Miracles At Work and In Life - Part 1
-
Online
4.00 Credits
Communication is the glue that connects people, but it doesn’t come easy for many of us. If you want to quickly and effectively handle problems with co-workers or clients, and you want people to do what you want without a lot of hassle, this seminar is for you. The bottom line will be better client and co-worker relationships, leading to increased enjoyment and productivity at work.
Coping With the Growth of Online Fraud
-
Online
4.00 Credits
Just about every company, no matter its size or the types of activities it undertakes, is at greater risk because of all the types of fraud that can be be carried out electronically. Potential perpetrators can be operating internally or externally and the scope of the damage that occurs is almost never limited to cyber-assets. While threat awareness is improving, there are still too many owners or top level executives that underestimate the scale of the issue. In this session, we delve into the types and the nature of many electronic defalcation schemes. The material then explores measures that organizations can implement to help stop these activities and add additional layers of security. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
CPA to CFO
-
Online
1.00 Credits
This Masterclass is a one-hour training exclusively for CPAs and accountants. Rely less on tax season and use your expertise to help business owners have a better future! Designed for CPAs, but also applicable to enrolled agents and accountants, this webinar covers the steps necessary to effectively transform a tax or accounting practice into an advisory service. We explore what it means to be a CFO/advisor to small-to-medium sizes businesses and what qualifications are necessary to offer such a service. We will also cover how to find and convert leads and how to price and package services, including combining advisory services with the firm's current offerings. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Synchronize Your Files to the Cloud with SharePoint -Updated
-
Online
2.00 Credits
One of the most cost effective methods for storing your files safely and economically in the cloud is with Microsoft 365 OneDrive and SharePoint apps. If you use either or both of these cloud storage apps, this course is a "must take." There are often times when you want or need cloud based files to be stored on your local laptop or desktop PC. With the OneDrive Sync app, you can have the best of both worlds. You can have copies of a file stored locally and in the cloud simultaneously. The Synch app will update both copies of the file in real time for any changes that are made in the local or cloud copy of the file. A classic example is if you have a QuickBooks Desktop data file that you need to store locally to work with the files in QuickBooks. However, you also want the file stored in the cloud for anytime, anywhere access and enhanced security. The Sync app facilitates this scenario effortlessly. Nationally recognized accounting technology advisor and thought leader, John Higgins, will take you through the step-by-step process of setting up and using the Sync app. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Rewards & Recognition Strategies for Leaders
-
Online
1.00 Credits
Whether you are responsible for managing 1 employee or 20, your leadership can make or break your team. Learn practical leadership strategies that you can implement when you return to your office. In today’s competitive market, it’s more imperative than ever that as leaders we are inspiring and motivating our teams to success.
2024 Independence Requirements for Auditors
-
Online
2.00 Credits
CPAs in public practice are required to maintain independence. In this course, we will discuss concepts associated with independence and review the rules from the AICPA Code of Professional Conduct with a focus on their practical application. We will also review the recently issued ethics interpretations from the Professional Ethics Executive Committee (PEEC), which impact independence, and discuss practical methods of implementation.
Implementing System Changes: Success Planning & Leadership
-
Online
2.00 Credits
What actions can financial professionals take to increase the odds of a successful system implementation? This session will show you how to be a key player on the team by focusing on specific areas in the project planning and delivery process that improve results. Learn how to use components of a project plan to transparently manage a project from the planning phase through embedment. These actions can be applied to small system changes, system upgrades, or large ERP systems. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Measuring Audit Risks
-
Online
3.00 Credits
In order not to perform an excessive number of audit procedures (over audit) auditors must perform procedures in order to determine in what areas are there weak internal controls that could result in a risk that the financial statements would be materially misstated and not be detected. SAS No. 122, AU 300 – 499, Measuring Audit Risk provides guidance as well as required procedures that must be performed in every audit in order to determine the risk of material misstatement. No longer can the auditor state that they assess the risk of material misstatement at maximum without having a basis for making such assessment. As a result, the standards now require that the auditor make such an assessment of a material misstatement of the financial statement on every audit in order to have a basis for such assessment. This program is an overview of the statement documentation requirements in assessing such a risk.