CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
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.
Yellow Book Ethics
-
Online
2.00 Credits
Government Auditing Standards (or Yellow Book) has a unique perspective on ethics and transparency due to accountability owed to taxpayers, oversight bodies, and others. This course will discuss the foundational principles in the Yellow Book relevant to professional conduct on related engagements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course qualifies for yellow book credit.
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.
Walter Haig's Business Financial Health Checkup
-
Online
8.00 Credits
This course fills an important need for both financial managers and accountants in the practice of public accounting by offering the tools to help ensure the future success of a business. Practical guidance for the effective use of benchmarking and analytical procedure is also provided. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
QuickBooks DESKTOP- Monthly Closeouts and Year-End Cleanups
-
Online
2.00 Credits
The process of closing out the books every month can make year-end accounting a breeze! But isn't this time consuming? Not when you know the steps to take monthly. We'll show you what to do in your QuickBooks Pro, Premier, or Enterprise as well as learn what you can do monthly to ensure a tax return that will stand up again an IRS audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Fraud Busters: Controls to Prevent & Detect Fraud
-
Online
2.00 Credits
This course investigates actual real-world fraud schemes and discusses what controls could have prevented the fraud from occurring, and what controls could detect and curtail the fraud scheme. The instructor speaks from experience, finding multiple frauds very early in her career leading to a career-long focus on fraud prevention and detection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Data Analytics: Practical Insights for Today's Accountant
-
Online
2.00 Credits
This session explores tools and techniques that can enhance the efficiency and effectiveness of client engagements and business processes using data analysis tools. We will introduce some of today's popular and software tools and examine the AICPA's Five-step approach to incorporating data analytics into public accounting engagements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 403: Fraud Trends - Applying Real-Life Lessons
-
Online
2.00 Credits
Fraud Trends - Applying Real-life Lessons to Small- and Mid-Size Entities will focus on real-life and practical examples of fraud in smaller- and mid-size environments, including nonprofits. Fraud involves an intentional act to deceive, which may result in material misstatement in the financial statements due to fraudulent financial reporting or misappropriation of assets. Management's responsibility is to design, implement, maintain and monitor a system of internal control to prevent, or detect and correct, fraud. Note: This is a part of the suggested 16-hour Audit Skills Level 4 curriculum for experienced in-charges or seniors. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
CFO Series: Proven Methods to Detect and Prevent Fraud
-
Online
2.00 Credits
Fraud impacts over 80% of all organizations, costing over $10 billion annually. Do you aim to fortify your organization, or your client's, against fraud risks? This seminar will address how to instill a robust anti-fraud culture and give you the tools needed to proactively prevent, detect, and manage fraudulent activities. Prevention is vital for success. Do not wait to protect the organization
Start a Forensic Accounting Practice with Confidence
-
Online
4.00 Credits
The need for a forensic accountant has grown in the last two decades, with more expected in the future. From oil well spills to divorces - from stealing trust funds to partnership disputes - forensic accountants are needed to find and calculate losses. They are financial detectives that are needed to explain the money story to attorneys, judges, and juries. If you are interested in starting a forensic accounting practice or adding on this service to your existing firm, this course is for you. In this presentation, you will know what service to provide possible clients, how to find those clients, and the cost-effective ways to start the forensic accounting practice. Your instructor has over 20 years of experience as a special agent with IRS-Criminal Investigation where he conducted investigations into tax and money laundering crimes across the globe. After his successful investigative career, he started a CPA firm from scratch that focused on forensic accounting. He shares the successes and failures in starting a forensic accounting practice, including getting the right credentials, various ways of marketing to potential clients, closing the deal with engagement letters, and delivering the service to the client. 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.