CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Excel - Advanced Spreadsheet Troubleshooting Techniques
-
Online
2.00 Credits
Do you dread that annoying ERROR! message popping up on your spreadsheets? Tired of using the same long, elaborate formulas when you could be using the ones that are already built into Excel? Then this class is for you! In this webinar, we will focus on Debugging and Troubleshooting complex formulas. You will learn various techniques that will assist you in creating complex compound formulas. You will also learn techniques to resolve issues when you receive errors. This session will also discuss the 9 built-in error checking options and demonstrate resolution techniques. We will also review techniques to resolve rounding errors. This session is presented using Excel 2013. Regardless of the version you are using, ALL 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.
Tax Season Update for Individuals with Steve Dilley
-
Online
4.00 Credits
This program provides an update to the latest tax developments, rules and regulations impacting individual taxpayers, with a review and integration of the numerous 2021/22 legislation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 204: Auditing Basic Inventory - Focus on Observations
-
Online
2.00 Credits
Auditing Inventory - Performing Required Observations and Other Common Procedures will primarily focus on performing the inventory observation, while introducing other risk concepts related to inventory. Assets classified as inventory varies widely with the nature of the entity and industry. Depending on the complexity of the inventory and the related pricing model, risk of material misstatement will vary widely as well. 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 auditing inventory. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Understanding the Form 990 and its Preparation Prerequisites
-
Online
2.00 Credits
Introductory Session of Borenstein's Form 990 Foundational Series: This "initiation and introduction to" the Form 990's mechanics and importance will prevent you from drowning in the Form 990's force-field! More than 80% of the Form's inputs and relevant definitions are NOT found in the statutes and Regulations that apply to the exempt sector, a reality that can be overwhelming for both novices and more advanced preparers. This session provides an easy-to-digest synopsis of the entirety of the Form's key definitions as well as the mechanics that preparers need embrace from the moment they first approach preparing a 990. Packed with practical tips and perspectives on data gathering, this class is a "must" gateway for beginning (and even more experienced) preparers to learn "how to befriend Form 990 preparation." This webinar will vault preparers past all the initially confounding problems of the Form 990, providing baseline info on the critical nuances the form uses. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Illicit to Essential: Marijuana & Hemp/CBD Evolving Issues
-
Online
2.00 Credits
The webinar will provide an overview of the regulated, legal side of the industry which now includes 19 states with recreational/adult use access and 38 states with medical access. This session will lay a foundation focusing on the modern historical background of the cannabis plant and the evolution of laws and regulations related to marijuana and agricultural hemp. The segment is designed to be useful for CPA practitioners desiring to provide or enhance their services within the cannabis and hemp niches. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Tax Depreciation: Review and Update
-
Online
2.00 Credits
A discussion of recent law changes that impact capitalization, depreciation, and disposition of assets. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Corporate Transparency Act Developments
-
Online
2.00 Credits
U.S. Department of Treasury's Financial Crimes Enforcement Network (FinCEN) imposed a new reporting requirement that went into effect on January 1, 2024. Millions of businesses may have to file a Beneficial Ownership Information (BOI) Report. In a surprise turn of events, the Federal District Court from the Northern District of Alabama ruled on March 1, 2024 in National Small Business United v. Yellen ("NSB") that the CTA is unconstitutional. This course will discuss the CTA's provisions and the court's decision in NSB. Also covered will be future implications for business entities and steps to consider given the recent ruling. We will also discuss recent proposed rulemaking by FinCen with respect to nonfinanced purchases of residential real estate and gratuitous transfers so that businesses can prepare for any additional reporting burdens that might arise. 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.
Risk Assessment for Small Business Audits
-
Online
2.00 Credits
Auditing standards require auditors to assess risk-including controls-and use that assessment as a foundation for performing the audit. Risk assessment is not just a technical GAAS requirement, it has a direct impact on realization. Audit teams that perform a thorough risk assessment are more likely to have high realization engagements than those who go through the motions. This course is designed for small business audit teams. It addresses the risk assessment procedures and responsibilities for each team member and how they fit together to create more effective and efficient audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
What If Your Client Didn't Take Reasonable Compensation
-
Online
1.00 Credits
Are you a new advisor handling S Corp clients, or perhaps a seasoned professional facing this common scenario: "My S Corp client didn't take reasonable compensation last year. Now what?" Knowing that reasonable compensation isn't just a tax obligation, but a strategic financial decision, you need to be armed with expert knowledge to help your client navigate this situation. Join us to discuss IRS regulations, understand preventive measures, and address challenges within the year. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Communicating Financial Data to Non-Financial Audiences
-
Online
1.00 Credits
Communicating financial data to those who aren't used to hearing it can be a challenge; however, there are some actions you can take to make the information easier to understand and relatable. This course provides you the necessary tools to communicate financial information to non-financial audiences. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Building Security and Efficiency With Internal Control
-
Online
8.00 Credits
A well-designed internal controls system can and will drive all entity objectives. Too many times control creators focus too much on security. It is important to properly balance protection-based measures with those designed to enhance efficiency. This session works to illustrate the power of a strong and well supported control system. It also discusses steps to take in order to establish such a system. This material is becoming more and more beneficial as companies strive to address many new business challenges such as evolving markets, the rapid rate of change in the business world and the notable increase in governmental and industry-based regulation. Those that desire a balanced and workplace enhancing control system should strongly consider 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.
Practical Insights Gleaned from the AICPA's Code of Conduct
-
Online
2.00 Credits
Reading the AICPA Code of Professional Conduct can be a daunting experience. This course unpacks the AICPA Code of Professional Conduct by exploring practical considerations for accounting professionals. We will examine selected provisions that are relevant to CPAs in both public accounting 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.
Partnerships: How to Calculate Partner Basis
-
Online
2.00 Credits
A detailed analysis of the calculations related to determining a partner's tax basis for a partnership interest. How to use the Form 1065 and Schedule K-1 information for basis determination will be reviewed. An illustrated example with filled in forms will demonstrate how the process works, including its many potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 205: Auditing Liabilities and Long-Term Debt Risks
-
Online
2.00 Credits
Auditing Liabilities, Including Long-Term Debt - Addressing the Risks of Completeness, Classification, and Disclosure will discuss tips and techniques for auditing accounts payable, accrued expenses, and common long-term financing arrangements and related debt covenants. The completeness and proper classification of liabilities are the typical higher audit risks. The complexity of the debt financing arrangements may create a significant risk requiring more persuasive audit evidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Create Visuals in Power BI to Successfully Analyze Data
-
Online
4.00 Credits
Unlock the full potential of your data with our cutting-edge course, "Create Visuals in Power BI to Successfully Analyze Data." Designed to span a focused, four-hour session, this course is your gateway to mastering the art of data visualization using the powerful tools of Microsoft Power BI Desktop and PowerBI.com. Whether you're a business professional, a budding data analyst, or simply someone interested in the world of data science, this course is tailored to enhance your skills in transforming raw data into visually stunning and insightful reports. Dive into the intuitive interfaces of Power BI Desktop and PowerBI.com, and learn to navigate these platforms with ease and confidence. The course is meticulously structured to provide you with demonstrations and practical knowledge. Starting with a comprehensive tour of the Power BI Desktop and PowerBI.com interfaces, you'll quickly move to the core of creating impactful visuals. Explore a wide array of available visuals and learn how to select the most effective ones for your data stories. Through detailed sessions on building interactivity into your visuals, you will discover how to create dynamic reports that not only captivate but also communicate effectively. This course will also guide you through the process of publishing your reports on PowerBI.com, ensuring that your insights reach their intended audience with the right impact. By the end of this transformative journey, you will be adept at leveraging the full capabilities of Power BI. Your newfound ability to create interactive, engaging, and informative visual reports will make you an indispensable asset in any data-driven decision-making process. Embrace this opportunity to elevate your professional profile, enhance your analytical capabilities, and become a sought-after expert in the field of data visualization. Join us for "Create Visuals in Power BI to Successfully Analyze Data" and step into the future of data analysis with confidence and skill. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
IRS Penalties and Abatements
-
Online
2.00 Credits
Penalty abatement is a technique that tax practitioners can utilize to help their clients reduce penalties and interest they owe to the IRS if the taxpayer can prove "reasonable cause". This informative and insightful webinar will provide you with some insider tips, practical steps and effective strategies to help your client manage IRS tax penalties and interest. Learn about various types of penalties that you may face, and the various forms and procedures used for requesting penalty and interest abatement, including First Time and Reasonable Cause abatement. Plus, learn about the procedure to follow when requesting refund of paid penalties. 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 Masterclass
-
Online
2.00 Credits
Ready to make radical leaps in your critical thinking? In a world of rapid change and unreliable information, we need the ability to separate fact from fiction, recognize flawed assumptions, and have clarity under pressure. This course will teach you how to audit your thinking and build effective reasoning strategies for all types of situations. You will achieve dramatic improvements in judgement, problem solving, memory, and learning. This course will make you more flexible, adaptable, creative and resilient, and provide a cognitive toolkit you can carry for life. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Implementing System Changes: Success Planning & Leadership
-
Online
2.00 Credits
What actions can financial professionals take to increase the odds of a successful system implementation? This session will show you how to be a key player on the team by focusing on specific areas in the project planning and delivery process that improve results. Learn how to use components of a project plan to transparently manage a project from the planning phase through embedment. These actions can be applied to small system changes, system upgrades, or large ERP systems. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 206: Analytical Procedures - Audit Fundamentals
-
Online
2.00 Credits
Analytical Procedures - Comprehending Financial Statement Audit Fundamentals will provide the tips and techniques necessary to gather sufficient appropriate audit evidence to support conclusions using analytic procedures common to financial statement audits. Properly designing, documenting and evaluating results of analytic review procedures is critical for performing an effective and efficient audit engagement. 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 performing financial statement audit analytics. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.