CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Starting a Fraud Investigation
-
Online
2.00 Credits
In this session we focus on the early stages of a fraud investigation, including: who should be on the team, how to create an investigation plan, and the evidence that should be acquired and evaluated. Investigative techniques involving a variety of different sources will be covered, including financial document analysis, background checks, data analysis, and interviewing. This is the most practical fraud investigation course you will ever take. Rather than learning only the theory of fraud, you will learn how a forensic accountant actually investigates fraud from the beginning to the end. We focus on forensic accounting techniques used in the field to prove what happened, who was involved, how much money was stolen, and where the money went. Starting a Fraud Investigation is Part 2 of a series of four courses on fraud investigations. Each course is a stand-alone class that may be taken individually. For comprehensive instruction on completing a fraud investigation from start to finish, take all four. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Creating a Culture of Trust in a Fraud-filled World
-
Online
2.00 Credits
This session will highlight recent cases of ethical failures and fraud and will highlight concepts of trust, personal accountability, responding to fraud, and the conduct expected of CPAs outlined in the Code of Professional Conduct. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 207: Sampling - Avoiding Common Mistakes on Audits
-
Online
2.00 Credits
Sampling - Avoiding Common Mistakes on Financial Statement and Compliance Audits will describe the proper process for both attribute testing and variable sampling in financial statement and compliance audits. Sampling is an important method for determining the extent of testing controls, testing compliance, and tests of substantive details. It allows the auditor to apply procedures to less than 100% of the population yet extend results to project likely conclusions about the entire population. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has sampling responsibilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Yellow Book Independence and Single Audit Fundamentals
-
Online
4.00 Credits
This CPE course explains Yellow Book independence including the general requirements, requirements for auditors providing non-audit services and documentation requirements. This course also explains the basic elements of a Uniform Guidance compliance audit, including an overview of requirements, major program determination with examples, an understanding of compliance requirements and related internal control over compliance, sampling, and single audit reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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.
ChatGPT and Complex Financial and HR Conversations
-
Online
2.00 Credits
The course provides a concise overview of how accountants can use ChatGPT to assist with communications involving intricate and often sensitive topics that require a deep understanding of both financial principles and human resource policies. These conversations can range from budgeting and compensation to ethical considerations and regulatory compliance. The course also explores the use of ChatGPT in crafting clear, accurate, and empathetic responses to complex queries related to financial audits, tax planning, and employee benefits. It emphasizes the importance of balancing technical financial knowledge with effective communication skills to address diverse stakeholders' needs in various scenarios, from internal team discussions to client consultations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Finding Errors in Excel Spreadsheets
-
Online
2.00 Credits
This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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.
Audit 208: Audit Reporting Basics - Report Issuance Process
-
Online
2.00 Credits
Audit Reporting Fundamentals - Introducing Core Concepts in the Audited Financial Statement Drafting and Issuance Process will provide tips and techniques necessary for issuing and reporting on high-quality financial statements prepared under any applicable financial reporting framework. The ultimate objective of a financial statement audit is to issue an auditor's report. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for drafting and issuing audit reports. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethics: Get Rich, Lose Weight, and Enjoy True Love
-
Online
2.00 Credits
The title of this webinar is NOT a joke. If you consistently apply the five principles of ethical intelligence that Forbes Contributor Bruce Weinstein, The Ethics Guy, presents, your business will prosper, you will take better care of yourself and lose that weight, and either find or keep the love of your life. However, you are the one that will have to do the work, day in and day out. All Bruce can do is show you the way. If you are willing to commit (or renew your commitment) to leading your business and your personal life with ethical intelligence, this is the perfect webinar for you. The work you put in during and after the webinar will help to make you a better CPA and a better person. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
QuickBooks - Know the Right Version for Your Client
-
Online
2.00 Credits
QuickBooks Desktop has been the go-to solution for companies since 1984 (Intuit originally created Quicken for bank reconciliations) and has grown into a powerful tool to track business finances. QuickBooks Online is one of the fastest growing applications in the accounting market today. With its ability to be an "on-the-go" solution, many service providers, entrepreneurs, and other industries prefer to keep it simple and use QuickBooks Online. Understanding the pros and cons of QuickBooks Desktop and QuickBooks Online will help you advise your client on the best solution for their business. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel - Feature Review in 100 minutes
-
Online
2.00 Credits
Over the years, Excel has added MANY new features and functionality, yet most people still use it the same way they first learned it. Many of the features were added to Excel to enhance your ability to create spreadsheets more efficiently and with more accuracy. However, if you aren't aware of these new features, how can you use them? This class will focus on walking through each ribbon (menu) to explain the capability of various features in Excel. It is a great overview for both new and advanced Excel users to make sure you know all the capabilities of Excel. You may have seen many of the features but had no idea what they could do for you. This class will help you to understand these features and determine how you might take advantage of their capabilities. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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.
Section 199A Deduction: Rules & Forms Reporting
-
Online
2.00 Credits
This program addresses the Section 199A deduction for flow-through entity income, including a review of the major provisions, forms reporting, and recent developments. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Dark Web & Cybersecurity for Tax and Accounting Pros
-
Online
2.00 Credits
This course provides a concise overview of the Dark Web, a part of the internet that isn't indexed by search engines, and is often associated with anonymous transactions and nefarious activities. Discover the leading threats and risks that the Dark Web poses to accounting firms. Explore how practitioners can effectively mitigate the risk of data breaches, ransomware attacks, financial fraud and other risks connected to the Dark Web. You'll walk away with a foundational understanding of leading cybersecurity strategies that can help you maintain client trust and protect your firm's sensitive data in this complex and ever-changing threat landscape. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Introduction to the Property & Casualty Insurance Industry
-
Online
1.00 Credits
The insurance industry has unique accounting and regulatory requirements. This course provides an introduction to those unique requirements, including the multiple layers of regulation, statutory vs. GAAP accounting, non-admitted assets, special treatment of taxes, and more! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Everything There is to Know About Summonsing
-
Online
1.00 Credits
You are likely familiar with and/or have experience with IRS summonses. BUT - Did you know there's a lot of procedure and decorum that goes into issuing a summons that you can leverage to help your client? This program will focus on the basics of an administrative summons, what the IRS can summons for, how you should comply with a summons, summons referral criteria, and common errors and misnomers the IRS can make in generating/serving a summons. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Power BI - Analyze Your Data With Excel Pivot Tables
-
Online
4.00 Credits
* This course is #3 in the Microsoft Power BI series of webinars. Click button in Program Content section below to see suggested viewing order. * Excel is a popular tool for data analysis, yet most users have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. This session is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make data analyzation an easy task for all accountants. Participants will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Power BI - Advanced Data Analytics with Power Pivot
-
Online
8.00 Credits
This fast-paced course focuses on using Excel Power Pivot features to enhance data analysis. One of the strengths of Power Pivot is the formula language DAX (Data Analysis eXpressions). We will spend considerable time using the power of DAX to create meaningful calculations that add new dimensions to our data. We will also review the use of a date or calendar table that allows us to perform date analysis that was never possible before. This will allow us to use the new time-intelligent functions to perform complex calculations on our data such as: month-to-date, quarter-to-date, year-to-date, last year same period, last year-to-date, etc. We will also demonstrate the hottest tips and tricks that will take your data analysis to the next level. Although our focus will be on using Power Pivot, we will review some of the other Power BI Tools including: Power Query (Get & Transform), Power BI Desktop and Power BI Services (PowerBI.com). NOTE: If you want to apply the concepts presented, you will need Excel 2013, 2016 or 2019/Office 365 AND the Power Pivot add-in pre-installed. To see our full prerequisite recommendations, see PROGRAM CONTENT section below. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Financial Accounting for Related Party Transactions
-
Online
2.00 Credits
This course explores the FASB codification provisions and AICPA financial reporting framework for transaction with related parties, including business owners and special purpose entities. Real-life examples are used to illustrate the various authoritative standards and discuss the consequences of failing to comply. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.