CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Controller Series: Technology - Must Have Excel Competencies
-
Online
1.00 Credits
Excel has long been included in the accountant's toolbox. Even though Microsoft Power BI and other big data tools such as Qlik and Tableau are becoming more important, Excel is still a "must have" tool. We cover what the accountants of today should know about Excel to improve their efficiency, access data, and gain insights into the company, industry, and economy.
Before You Let Them Go: A Whole Brain Approach to Helping Team Members with ADHD Thrive in Your Organization
-
Online
1.00 Credits
Many employees with ADHD struggle with productivity. It’s heart-breaking to feel you have to let a team member go due to lack of performance. This course is for HR Professionals and Team Leaders who want more tools in their tool belt to help improve retention with ADHD team members. You will learn whole brain strategies to help your team members with ADHD improve performance, so they can not only survive but thrive. This innovative science-based approach is designed to help people with ADHD get more done in less time with a process designed with their creative brain in mind.
Leveraging Analytical Procedures to the Fullest on Audits - Case Studies in Strengthening Audit Evidence
-
Online
2.00 Credits
Peer review deficiencies commonly relate to the design, documentation, and evaluation of the results of analytical procedures. This course will provide examples of how to strengthen evidence resulting from preliminary, substantive, and final analytics. It will reinforce the elements of strong analytical procedures that may enhance the quality of audits.
FASB Update and Review
-
Online
2.00 Credits
Periodic FASB checkups are critical for accountants who deal with financial statements prepared in accordance with U.S. GAAP. This course introduces recent FASB pronouncements and revisits selected existing standards that are likely to be salient for private entities. This session also offers a preview of coming attractions by examining significant elements of the FASB's technical agenda.
Ethics, Tax Practice & The Cannabis Industry
-
Online
2.00 Credits
This course provides an in-depth discussion of the ethical considerations and compliance requirements when working with taxpayers in the cannabis industry. Attendees will review the implications of Circular 230, preparer due diligence, and the specific challenges posed by conflicting federal and state laws. Federal case law, standards set by Boards of Accountancy, and guidance from the IRS Office of Professional Responsibility will also be covered to help practitioners navigate this complex area with confidence.
Form 1120S - Preparation and Analysis
-
Online
2.00 Credits
This course is designed for financial professionals looking to understand Form 1120S. It covers the essential aspects of S corporation taxation, including the preparation of Form 1120S, determining taxable income, and accurately reporting and allocating income, deductions, and credits. Participants will also learn how to calculate shareholder basis and understand the strategic advantages and limitations of an S corporation.
Surgent's Introduction to Required Minimum Distributions
-
Online
2.00 Credits
Required minimum distributions (RMDs) must be taken from certain tax-deferred retirement accounts, starting when the account owner reaches their applicable age. The RMD rules are complex and must be simplified to help ensure clients understand them. Accounting and finance professionals must understand the basics of RMDs for IRAs and employer plan accounts so as to help IRA owners, plan participants, and beneficiaries meet their RMD obligations and avoid penalties that apply to RMDs not taken by their applicable deadline. Accounting and finance professionals should also be able to demonstrate tax-efficient solutions for RMDs. This course will walk accounting and finance professionals through the fundamental concepts and rules that apply to RMDs, demonstrate how to calculate RMDs, and explain how to correct RMD errors. It can be taken by anyone, including those without any experience working with RMDs. The course will include cases to promote understanding of the rules.This course qualifies for IRS credit.
2025 Accounting & Auditing Update
-
Online
3.00 Credits
Stay informed and prepared with this comprehensive annual update on the latest developments in accounting and auditing. We'll begin with a deep dive into the Accounting Standards Updates (ASUs) effective in 2025, followed by insights from the FAF's 2024 PCC Review and an overview of FASB's Invitation to Comment - Agenda Consultation, which will shape the future of accounting standards. On the auditing side, we'll tackle the essential changes in quality management standards that firms must implement by the end of 2025. The session will also highlight common deficiencies identified by the DOL in EBP (Employee Benefit Plan) engagements and provide a peek at upcoming projects from the Auditing Standards Board (ASB). Join us to gain practical insights and actionable takeaways to navigate these updates with confidence.
Gamed: Why Performance Targets and Incentives Fail and How to Fix Them
-
Online
4.00 Credits
Targets can be a powerful catalyst for remarkable achievements - from landing humans on the moon to eradicating smallpox and repairing the ozone layer. However, poorly designed targets can have severe consequences, potentially leading to executive imprisonment, corporate collapse, or even loss of life. This course uses real-world examples and case studies to guide you through a practical, step-by-step process for crafting robust, effective, and credible targets for your organization. You'll learn how to harness the positive potential of targets whilst avoiding the pitfalls that can derail even the most well-intentioned performance initiatives.
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.
Build a Data Model for Analysis in Power BI
-
Online
4.00 Credits
This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Conducting a Remote Audit
-
Online
4.00 Credits
Understand the basics of remote auditing and how it can be used in your engagements Remote auditing has become increasingly popular in recent years. Learn how to apply auditing standards to real-life examples of remote auditing in this all-new webcast. Join us to explore ways to overcome the challenges of remote auditing and conduct efficient engagements for your clients.
Tax Season Update for Business with Steve Dilley
-
Online
4.00 Credits
This program provides an update to the latest tax developments, rules and regulations affecting business taxpayers, including a review and integration of 2024-25 legislation. **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.
Was It Fraud or Just Poor Audit Quality?
-
Online
1.60 Credits
This session describes a state agency's quality review of a not-for-profit organization's A-133 Single Audit. The case study describes the organization audited, its federally- and state-funded programs, and the CPA firm retained to do the audit. Various anomalies in the financial statements alerted state officials to potential problems, and a detailed quality review followed. Find out how the entity turned hundreds of thousands of dollars in bank overdrafts into hundreds of thousands of dollars of cash on its balance sheet. Explore other “creative” ways to deal with fixed assets, accounts receivable, and related-party transactions. Were the auditors just sloppy, ignorant, negligent? Or were they active participants in producing fraudulent financial statements? You be the judge.
Leadershift Ethics: Things Must Change!
-
Online
2.00 Credits
With the rapid pace of change, change now happens daily in business and our personal lives. It can be difficult to navigate change when right and wrong get a bit fuzzy. New processes, new technology, new circumstances and new impacts to people must be measured and decisions made as the change evolves. Change always becomes something different than what was originally planned or imagined. In this session, learn how to measure your ethics through change. You will learn how to filter everything you do during change through a simple litmus test. Through the power of story, you will learn from the lessons of other organizations and their ethical mistakes. Lastly, you will take away what is required to manage yourself so that when ethical decisions arise, you have the mental capacity to manage through it well. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Just Ask Why - Searching for Answers: Generating Solutions
-
Online
4.00 Credits
Breaking the Wall of blind acceptance; avoiding habitual complacency and Yoking the dots between cause and effect.
Surgent's Data Security: Best Practices to Protect Your Business and Yourself
-
Online
1.00 Credits
Data security is a front-of-mind topic for most businesses because the risk and cost statistics are sobering. Each of us is in the crosshairs because a typical internet-connected computer faces a cyberattack every 39 seconds. Businesses of all sizes should be cognizant of the ethical issues that must be considered when planning their approach to privacy and data security. In this webinar, we will explore both the risks we have traditionally faced in the workplace personally, as well as the novel set of data privacy threats and compliance challenge issues employers face with a remote and mobile workforce.
Introduction to Forensic Accounting
-
Online
1.80 Credits
This course provides a high-level overview and introduction into the world of the forensic accountant. Most accountants have an understanding of the concept of fraud and how it impacts companies, but many individuals do not have a full comprehension of the variance in the work performed by a forensic accountant versus a typical management accountant. This course is meant for those individuals interested in understanding the variances in the job tasks and responsibilities of forensic accountants versus typical financial or management accountants. Forensic accountants or auditors take a unique focus on performing their work. Typically, when a person with forensic experience is called in to examine financial records, it is due to suspicion of fraud, evaluation of assets, or even to track down fundamentally incorrect accounting – intentional or not. As fraud continues to raise its head in business processes, forensic accountants are discovering new and unique ways to identify, examine, and support their hypotheses and investigative techniques. The work performed by a forensic specialist can be interesting and full of potential potholes if evidence isn’t examined according to proper protocols and standards.
Benford's Law and Other Digital Analysis Techniques
-
Online
1.80 Credits
Numbers and especially the digits within those numbers can conceal a lot of information. Benford's Law and other digital analysis techniques can be the keys to unlocking that information. This session will explain what Benford's Law is, how it works, and how it can be used to reveal bogus information and made-up data. Accountants and 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.
Power Skills: Your Guide to Professionalism and Client Interactions
-
Online
2.00 Credits
Client interactions and professionalism are at the core of what we do as accountants. However, communication with clients is not always as straightforward as it may seem. Sometimes there will be difficult conversations and disagreements that can be tough to navigate. During this course, we will discuss best practices when communicating with the client, and also walk through complicated scenarios to practice what we learn.