CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Mastering the Excel Lookup Functions
-
Online
2.00 Credits
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
SAS No. 122, AU 240, Consideration of Fraud in a Financial Statement Audit
-
Online
3.00 Credits
When performing a financial statement audit, auditors have always been responsible for the detection of anything that would cause a material misstatement of the financial statements whether caused by error of fraud. However, in the past the audit profession focused on material misstatements due to errors and more or less ignored the possibility of misstatements due to fraud. Now, SAS No. 122, AU 240 requires significant documentation as to what the auditor did in order to determine if there any material risk of a misstatement of the financial statements. This presentation is an overview of what the auditor is to document in there working papers on every financial audit as to the procedures they performed in order to determine the risk of a material misstatement. If a material risk is discovered, they are then required to document what they did in order to determine if the financial statements were misstated.
Not Just Your Everyday FASB Update
-
Online
4.00 Credits
This course highlights significant updates that affect financial reporting and related attestation services. We will explore novel FASB pronouncements while examining the enduring impact of lease accounting and revenue recognition standards. This course will provide reminders regarding both GAAP and non-GAAP financial reporting alternatives for closely held entities. We will also explore selected guidance regarding audit, review, and compilation engagements.
Common Financial Statement Disclosures
-
Online
2.00 Credits
Financial statement disclosures are important to provide the information necessary for financial statement users to make economic decisions. Disclosures further explain and clarify information provided in the basic financial statements, but also provide critical information about subsequent events, litigation risk, and other concerns. This course focuses on the most common financial statement disclosures for small- or medium-sized nonpublic entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Ethics Hour: Accounting Scandals: What Happened and Why? Can We Prevent Them?, featuring Tracy Cooper and
-
Online
1.00 Credits
The staggering volume of accounting scandals is a scandal. What has happened and what were the root causes? Why do many financial professionals choose to do the wrong thing? What has been the cumulative impact on the profession? What can we do to enhance our professional reputation? We will discuss the many "fixes" imposed to address previous accounting scandals, including COSO; were they effective? We must understand that accounting fraud is prevalent and what should we look out for? Be aware. We do not want history to repeat itself.
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.
Addressing Misconduct
-
Online
1.00 Credits
The objective of corrective action is to change conduct through teaching. Corrective action may be sequential, out of order, repetitive, or not appropriate to take at all. The action selected should reflect the type, frequency, and severity of the misconduct. Changing conduct through teaching requires effective employee relations skills. This course provides practical knowledge and scripts for handling a wide array of sensitive misconduct situations with good judgment, such that personal and employer liability is avoided.
Predictive Accounting: Driver-Based Budgeting & Rolling Financial Forecasts
-
Online
2.00 Credits
The annual budgeting process is often criticized as an accounting exercise that is obsolete soon after it is published, prone to gamesmanship, cumbersome, not volume sensitive, and disconnected from the organization's strategy and risk management processes. You can resolve these deficiencies using capacity-sensitive driver-based projections. Driver-based budgeting allows for quick scenario planning and far easier analysis of a growing organization whose future may look nothing like today. The driver-based budgets can be periodically refreshed to create rolling financial forecasts extending well beyond the fiscal year end. Learn how managerial accounting can become managerial economics.
Ethics: What a CPA in Business & Industry Needs to Know
-
Online
2.00 Credits
Accountants in business and industry face ethical conflicts almost daily. This workshop (re-)introduces the revised AICPA Code of Professional Conduct and walks through the five basic rules of conduct and the related professional ethical principles applicable to accountants in business and industry. 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 Eight Awesome PivotTable Features
-
Online
2.00 Credits
Are you looking to take your PivotTables to the next level? Many experts consider PivotTables to be Excel’s most powerful feature. Yet, most who create and work with them barely scratch the surface of all that PivotTables can do. In this session, you’ll learn eight powerful features you may have missed. From user-defined calculations to consolidating reports and adding KPIs, we’ll show you how to get the most out of your PivotTables. These are just some examples of the great things you can do with PivotTables, and in this session, you will learn these and other techniques to make your PivotTables even more powerful.
Fraud Case Studies: Professional Misbehavior in the 21st Century
-
Online
4.00 Credits
Savvy accountants pay attention to fraud trends so they can implement preventive and/or detective controls. This course examines novel frauds to explore potential mitigation measures. Participants will see how selected frauds were accomplished so they can consider internal controls that could have foiled the fraudsters' nefarious efforts. We examine broad ethical considerations and specific provisions of the AICPA Code of Professional Conduct. Along the way, we consider dramatic details of several fraud cases to illustrate practical applications that accountants can apply in their professional endeavors.
Tax Implications of Retirement Plan Distributions
-
Online
1.00 Credits
This session will address the complex rules of retirement distributions, review key provisions of the SECURE Act 2.0, and provide practical strategies of maximizing tax benefits for your client. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Preparing to be a Forensic Accountant - Focus on Network Forensics
-
Online
1.50 Credits
Network forensics - defined as the investigation of network traffic patterns and data captured in transit between computing devices - can provide insight into the source and extent of an attack. It is used in forensic accounting and with the expansion of information technology it has become a growing field. Network forensics is a relatively new field of forensic science. Computing has become network centric. Data is now available outside of disk-based digital evidence. Network forensics can be performed as a standalone investigation or alongside a computer forensics analysis. When used alongside a computer forensic analysis it is used to reveal links between digital devices or reconstruct how a crime was committed. Network investigations deal with volatile and dynamic information and is a sub-branch of digital forensics. It relates to the monitoring and analysis of computer network traffic for information gathering, legal evidence, or intrusion detection. This course is a complement to our other courses in the series on becoming a forensic accountant.
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.
Nonprofit Taxation Rules and Form 990
-
Online
2.00 Credits
This course explores the latest tax provisions impacting non-profit entities, including charities, hospitals, and universities, with a focus on common issues CPAs may face when completing their clients Form 990. *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
Self-Rental Real Estate Passive Activity Rules
-
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. *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
Leveraging ChatGPT for Innovative Business Advisory Services
-
Online
2.00 Credits
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.
Surgent's Excel Budgeting Ideas
-
Online
2.00 Credits
Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.
Avoiding Peer Review Deficiencies and Professional Liability in Public Accounting
-
Online
8.00 Credits
Peer review deficiencies and professional liability claims result from both audit and nonaudit services. This course will provide best practices for avoiding legal liability and quality control concerns for a wide variety of professional services offered by public accountants.
Current Nonprofit Fraud Trends
-
Online
4.00 Credits
Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.