CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Understanding and Creating an Internal Control System
-
Online
8.00 Credits
Successful organizations, both large and small, must understand the importance of effective internal controls and be able to develop a system of controls that will keep the entity on its intended course. Moreover, those that design policies and procedures benefit by knowing why control measures are necessary. This session sets forth internal control concepts and explains the importance of strong internal control policies. The material highlights some of the reasons that measures are needed and it also provides an overview of control creation methods. Finally, it discusses ways to successfully implement the developed policies and procedures. Participants that take this course will gain a well-rounded understanding of internal control procedures of all types. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel - Fundamentals, Data Entry and Basic Formulas
-
Online
2.00 Credits
Are you self-taught on Excel? Have you ever wondered if you really know how to use Excel? Do you want to build a great foundation for using Excel? Are you new to using Excel? If you answered YES to any of these questions, this is for you. This course is designed to start with the basics of using Excel from the interface to the structure to data entry to formula basics. Whether you're a beginner or an intermediate user, you will gain valuable foundational knowledge for using Excel. 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.
Becoming Conflict Competent
-
Online
2.00 Credits
Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles, and build constructive behaviors to manage conflict. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 401: Critical Traits of a Thinking Auditor
-
Online
2.00 Credits
Critical Traits of a Thinking Auditor - Stretching Experienced Auditors Beyond the Basics will provide tips and best practices for stretching experienced auditor past the basics in each of the three pillars of success. Those in charge of the day-to-day supervision of engagements need to consciously embrace and demonstrate characteristics that will enable him/her to transition to a firm leader. This includes a focus on three key pillars: financial success, retaining clients through superior client service, and developing other professionals. Note: This course is recommended as a part of a 16-hour audit skills curriculum for supervisory and managerial auditors, while it is also appropriate for anyone who has responsibilities by finding creative audit solutions. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Seeing Beyond the Numbers: Analysis for CFOs & Controllers
-
Online
4.00 Credits
Financial statements are a window into what is going on in the day-to-day operations of the company. They help us see what the company's strengths and weaknesses are. However, financial statements can often have different messages depending on the user. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethical Considerations in Working with Cannabis
-
Online
1.00 Credits
This session will explore the ethical considerations CPAs and CPA firms should be cognizant of when considering services to the state legal, regulated cannabis industry. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Whistleblowers and the Law
-
Online
2.00 Credits
Honest people face real challenges when working in an unethical environment. Business owners may be at risk if team members feel as though policies and practices within the business violate rules, regulations, or laws. Some of those employees may contact authorities. Perhaps they work in an undercover capacity, exposing the business owner and other people that work with the business, or align with the business, to both government investigations and potentially criminal prosecutions. Participants will learn from a real story which led to criminal prosecution for Medicare Fraud. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
How Much Are Your Ethics Worth?
-
Online
2.00 Credits
Ethics are of central importance to the CPA profession. But what do we mean by ethics? Is it just appropriate behavior, compliance with laws, or is it more than that? In this course, we'll discover what sets ethics apart and, therefore, sets the profession apart as well. We'll explore the tools available, the role of bias, and dive into real life case studies. We'll apply the AICPA's ethical framework and detect where bias was involved in the case studies. We'll even discover that one person set the price tag on their ethics at $53.7 million, only to lose it all in the end. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel for Staff Level 2 - Getting More Out of Excel
-
Online
2.00 Credits
Excel can do so many things but what are some of the features that can really help accountants take their Excel skills to the next level? This course is designed to do just that. To learn ALL the capabilities of Excel would take hundreds of hours of training, so this two-hour course is designed to give you a jump start on the most important features that you can immediately begin implementing in your spreadsheets. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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.
Audit 402: Audit Quality Control - Avoid Peer Review Issues
-
Online
2.00 Credits
Audit Quality Control - Avoiding Peer Review Deficiencies highlights the most important considerations for those at all levels of the engagement team with quality control responsibilities on audit engagements. Upper-level reviewers have significant responsibilities for ensuring high-quality audit engagements. Unfortunately, deficient audits have serious negative consequences for both the CPA firm and the profession as a whole. Note: This course is recommended as a part of a 16-hour audit skills curriculum for supervisory or managerial auditors, while it is also appropriate for anyone who has quality control responsibilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Tax Implications of Cryptocurrency
-
Online
2.00 Credits
This course presents an overview of blockchain and the tax implication of cryptocurrency transactions. The IRS has provided some recent guidance, but potentially conflicting pronouncements by other regulatory agencies have created uncertainty on reporting issues. The practitioner will be helped to understand when a taxable transaction has occurred and what reports to file to satisfy IRS requirements. We will also identify tax traps for the unwary. This information is suitable for Corporate tax and finance executives, directors, managers and staff, CPAs, Enrolled Agents, accountants, attorneys and business/financial advisors who work with and advise individuals or businesses that use or invest in cryptocurrency. All in-house and public practice professionals involved with tax compliance and planning will benefit from this timely and insightful seminar. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethical Performance Management
-
Online
2.00 Credits
Today, more than ever, effective performance management is critical to the well-being of an organization, as well as the engagement and satisfaction of staff. Unfortunately, performance management is also often one of the most dreaded responsibilities managers face. This session will provide insight into what performance management is, how to prepare and conduct performance appraisals, how to coach the marginal employee, legal considerations to be aware of when conducting an appraisal, and ways to engage and motivate staff. In addition to providing tools to conduct effective appraisals, we will also look at the ethical implications of employee reviews. When done well, performance management has the power to improve communication between managers and their staff as well as help foster stronger career paths and routes for growth. It can motivate, re-engage, and energize everyone involved. Ethical values such as fairness, accountability, respect, intellectual honesty, and trust will be incorporated into this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Payroll Essentials: Getting to Know Payroll Taxes
-
Online
2.00 Credits
Payroll is among the most common tasks an employer undertakes in the course of running their business. At its most basic level, payroll consists of an agreement between an employer and employee related to compensation for services. Once you look under the hood, there is so much more to payroll, including various kinds of compensation, payroll taxes and required reporting on government forms. This course will provide a general introduction to the inner workings of payroll and payroll taxes. We will introduce you to the various types of payroll statutory and withholding taxes, under what conditions and which employees these various types of taxes apply, how to calculate, withhold and deposit those taxes and the related due dates requirements that apply to payroll taxes. This course will include real-life examples of how to process payroll, the withholding and payroll tax deposit regime, familiar payroll forms, and tips and tricks for tying it all together. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Google Sheets for Accountants
-
Online
2.00 Credits
This course provides a concise overview of Google Sheets, a cloud-based spreadsheet application by Google. Similar to Excel, the tool allows users to enter numbers, apply formulas, prepare graphs, create charts, use pivot tables and more. While Excel is the default tool and industry standard for most accountants, Sheets has many underrated capabilities which are clearly superior to Excel. These include online collaboration, team communications, mobility, version control, revision history, cloud storage, translation, Google integration, and scores of third-party add-ons. You'll walk away knowing how to use a whole new array of spreadsheet features not found in Excel that can boost your analytical powers and accelerate your financial workflow. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Payroll Essentials: Fringe Benefits: Taxable or Not?
-
Online
2.00 Credits
Fringe benefits are just another way of paying your employees. Do you know how to correctly track fringe benefits, as well as apply and report the various withholding tax rules for those fringe benefits? The IRS says fringe benefits must be included in and reported as a part of employee pay, but with any good tax law, there are always exclusions to that rule. Knowing how to handle fringe benefits can be complicated, especially in an area that changes on an annual basis. Attendees will leave with an understanding of what the requirements are around fringe benefits, what constitutes a fringe benefit, and whether it is taxable or not. We will also explore the evergreen areas of reporting S-Corp Shareholder Health, HSA, and when cash is not taxable compensation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Teaching CPAs to be Better Thinkers
-
Online
1.00 Credits
Designed especially for CPAs, this class is a practical call to action that provides CPAs with the tools and inspiration they need to be better thinkers. You'll learn habits and strategies you can use every day to dramatically improve judgment and decision-making. You'll learn how to break down mental barriers and alleviate mental fatigue. You'll achieve new levels of mental clarity, flexibility, and resilience. You will also benefit from better overall mental well-being and be more resistant to stress and burnout. Attendees leave as more powerful and confident thinkers and better communicators and problem-solvers. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Critical Thinking for Financial Professionals
-
Online
1.00 Credits
What were they thinking? Why do business leaders sometimes make horrible decisions that severely damage themselves and their organizations? It is tempting to assume that poor choices must be due to someone's incompetence, inexperience, bad character, or low intelligence. Yet, when we make a mistake ourselves, we someone rationalize it as a choice other people would make under the same circumstances. This session will discuss the common decision-making errors people make and to help you avoid making these blunders yourself. 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.
2024 Accounting & Auditing Update for Small Businesses
-
Online
4.00 Credits
For many small businesses, the standards issued by the FASB may have little to no effect as they impact topics that do not reflect the type of transactions that these entities most frequently experience. This class will focus on the Accounting Standards Updates (ASUs) that are most likely to impact small businesses with a focus on ASUs initiated by the Private Company Council (PCC). We'll then look at alternative reporting options to GAAP including FRF for SMEs and IFRS for SMEs for entities who don't necessarily need to prepare GAAP financial statements but want to use accrual accounting. Finally, we will transition to audit standards that small business auditors will need to implement. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.