CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
AI-Powered Excel: Leveraging AI and ChatGPT for Supercharged Productivity
-
Online
1.00 Credits
Learn how to enhance your Excel workflows with AI in this course, "AI-Powered Excel: Leveraging AI and ChatGPT for Supercharged Productivity." Discover the various AI features built into Excel and how to use ChatGPT to create, understand and troubleshoot Excel functions and formulas. Imagine turning two-hour Excel tasks into two minutes of effort! This course will help you streamline your Excel work, research and documentation, saving you time and effort in your day-to-day tasks.
Construction Contractors: Auditing Considerations
-
Online
4.00 Credits
Overcoming the challenges of auditing contracts Construction makes up a large portion of the economy. As such, a growing number of accounting and finance professionals may need to be aware of the accounting and auditing guidance for the construction industry. You'll delve into the audit considerations related to construction contracts, covering various topics, including: Audit planning and substantive auditing procedures The core knowledge necessary to succeed Key issues affecting construction auditing, including auditing under the new revenue recognition and leases guidance Audit risks and risk assessment
Lessee and Lessor Accounting
-
Online
2.00 Credits
What you need to know about the lessee and lessor accounting models This course explains the lessee accounting model, including Lease and non-lease components Lease classification Amortization of the right-of-use asset Interest on the lease liability This course also explains the lessor accounting model, including Transfer of risk Profit recognition Collectibility Included in this course are detailed and illustrated examples with amortization tables and journal entries.
Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting
-
Online
2.00 Credits
Which Excel function is your go-to? This session invites you to actively engage and practice with the instructor, exploring exercises demonstrated. In doing so, you'll gain a firmer grasp of common Excel functionalities, including: Data validation Conditional formatting Enhanced summing options Skinny rows Achieving proficiency in Excel features Gaining proficiency in Excel means learning to design workbooks that are both functional and streamlined. The facilitator will lead you through an array of formatting skills, formula functions, and beyond as we expand upon foundational Excel knowledge with topics such as: Managing data input for individual cells Using conditional formatting to prevent errors Enhancing productivity via the Subtotal feature Ensuring total formulas refresh automatically *Session 2 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 3: Workbook Design Principles and Organization] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-3--workbook-design-principles-and-organization) to further prepare to tackle real-world issues and build powerful workbooks.*
Risk Assessment Under SAS No. 145
-
Online
2.00 Credits
Get familiar with SAS No. 145 (bold) In October 2021, the AICPA Auditing Standards Board issued Statement on Auditing Standards (SAS) No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement. SAS No. 145 does not fundamentally change the key concepts underpinning audit risk. Rather, it clarifies and enhances certain aspects of the identification and assessment of the risks of material misstatement to drive better risk assessments and, therefore, enhance your audit quality. Hear from members of the Auditing Standards Board's risk assessment task force as they help you learn to navigate SAS No. 145 and examine new and updated concepts including: A new definition of significant risk New guidance on maintaining professional skepticism Revised requirements to evaluate the design of certain controls Separately assessing inherent risk and control risk Revised requirements regarding audit documentation New guidance on scalability
The Crucial Connection - Why You Should Care About Your Client's System of Internal Control
-
Online
1.50 Credits
Conduct risk assessment the right way Regardless of the size of your client or audit budget, there are specific requirements in accounting standards and generally accepted auditing principles (GAAP) related to auditing internal control for risk assessment purposes. Take a deep dive into understanding your audit client's system of internal control to perform a more effective and efficient audit.
Current and Upcoming FASB Issues
-
Online
2.00 Credits
Keeping up with FASB changes You'll explore changes in accounting, including: Relevant pronouncements Exposure drafts Projects Additionally, you'll be able to identify recently issued FASB standards and guidance that cover broad and narrow issues, as well as understanding how to apply them. You'll also learn about upcoming standards that will be effective in the near future.
Current Audit Environment and ASB Activity
-
Online
2.50 Credits
Understanding the current audit environment You'll explore the current audit environment, including the audit challenges triggered by the current environment. Additionally, you'll do a comprehensive review of recent audit pronouncement and exposure drafts. Topics you'll cover include those critical to success in today's rapidly changing regulatory environment, such as: Recently issued audit and attest interpretations Technical questions and answers The ASB workplan
Documenting Your EBP Audit: What You Need to Know
-
Online
8.00 Credits
What you document matters Understanding different parts of the employee benefit plan (EBP) audit process can help you think holistically about your level of audit documentation. You'll learn the appropriate level of documentation when performing EBP audit procedures, which involves testing items that are not typically tested in audits of other types of entities. Real-life examples You'll also gain insights from real-life examples and solutions as you are guided by a former employee benefit plan expert panel member and peer reviewer. Additionally, reviewing these examples will help you truly understand documentation in an EBP audit and learn best practices for documentation to incorporate into your audits.
Taxation of Property Transactions - Tax Staff Essentials
-
Online
4.00 Credits
A practical guide to business property transactions A fundamental understanding of the taxation of business property transactions is essential to any tax practice. This course prepares tax professionals to handle the tax effects of common property transactions. Topics include: Depreciation recapture Exchange transactions Dispositions of business property Updated for the effects of H.R. 1, commonly referred to as OBBBA, this learning provides a current view of these essential topics. Tips for achieving an optimal tax result on property transactions Professionals are exposed to important business property-related timing issues and planning opportunities that can lower a client's tax liability. Strategies laid out in the course empower practitioners to consider the timing of recognizing gain and loss to achieve tax savings. Part of Tax Staff Essentials Level 2 This self-study online course is part of Tax Staff Essentials Level 2, a comprehensive learning program that provides experienced tax staff with the technical training required to gain independence.
SOC 2® Report Walkthrough
-
Online
2.00 Credits
This webcast will walk you through a SOC 2 report, giving you enhanced knowledge of essential information for preparing or reviewing SOC 2 reports. Get comfortable with SOC 2 reports. Avoid potential pitfalls. For service auditors and user entities new to SOC 2 reporting, not understanding the report contents can result in reporting deficiencies or inappropriate identification of key information. How will this course benefit you? This webcast presents the contents of each section of a SOC 2 report, highlighting key items of interest. As a user or user auditor, you will be better able to identify pertinent information that affects your organization or audit work. And as a service provider or service auditor, you will be better able to recognize what users are looking for and meet the requirements of SSAE No. 18. Why take this course? Take this course as an introduction to SOC 2 reporting, to strengthen your foundational knowledge as you perform SOC 2 examinations as a service auditor or as you review SOC 2 reports as a user entity or user auditor.
Ethics: Avoiding the Slippery Slope of Ethical Pressures
-
Online
4.00 Credits
Maintaining an ethical climate (bold) Being on prime-time news might seem exciting, but not when the story is an ethics breach you committed. You may say, "that will never happen to me". And those were the words spoken by Wells Fargo, United Airlines, Senator Al Franken, and Steve Wynn. A claim of an ethical failure can stay in the news for almost five years. That's long enough to damage your reputation and lower your profitability. Upholding high ethical standards for yourself and your team requires constant care and feeding.
Quality Management: Performing a Root Cause Analysis
-
Online
2.00 Credits
Root cause analysis is a powerful tool for understanding why quality issues arise, and for preventing them from recurring. This webcast examines the principles and objectives of a root cause analysis and how it aligns with SQMS No. 1's focus on continual improvement. Learn practical approaches for: Identifying underlying causes of findings and deficiencies Evaluating contributing factors Implementing meaningful corrective actions We'll also explore how this process can help firms of all sizes to: Enhance audit quality Strengthen remediation activities Foster a culture of proactive problem-solving
Conducting a Remote Audit
-
Online
4.00 Credits
Auditing for today's world Remoting auditing is happening everywhere you turn. Understanding the considerations for a remote audit and the specific techniques for performing the engagement will help you integrate remote auditing into your practice. You will learn how to: Leverage the benefits of remote auditing Manage the team, client, and audit process remotely Identify engagement-wide procedures from client acceptance through report issuance when remote auditing Identify and obtain audit evidence for generally material accounts
Preparation, Compilation, and Review Engagements: Update and Review
-
Online
4.00 Credits
If you supervise preparation, compilation, and review engagements, this course is designed to assist you in adhering to professional standards. It will inform you of the latest developments and pertinent issues relevant to these engagements as you gain insights into: The U.S. business economy Peer review practices FASB updates Various other aspects that influence preparation, compilation, and review engagements
Performing Preparation, Compilation and Review Engagements
-
Online
2.00 Credits
Compliance with standards Do you perform preparation, compilation, or review engagements? Staying in compliance with all professional standards surrounding engagements performed in accordance with Statements on Standards for Accounting and Review Services (SSARSs) is essential to your engagements. You'll gain insight into how to perform these engagements in accordance with the relevant guidance. Building a foundation for successful engagements You'll cover several key topics to help you complete preparation, compilation, or review engagements successfully and compliantly. Topics covered include: Frameworks, objectives, and general principles Standards and guidance Documentation
Yellow Book: Application of GAGAS Principles
-
Online
6.00 Credits
Building a strong foundation by knowing the essentials By reviewing chapters 1-5 of *Government Auditing Standards*, 2024 Revision, you'll learn the fundamentals of performing engagements in accordance with generally accepted government auditing standards (GAGAS). Your new knowledge will help you build an excellent foundation of the principles of GAGAS as you work to understand Yellow Book requirements and application guidance. Topics covered include: Foundational principles General requirements Standards for financial audits
Excel for Accounting Professionals Session 3: Workbook Design Principles and Organization
-
Online
2.00 Credits
Enhancing Excel workbook productivity This workshop covers organizing and managing worksheet information, offering hands-on participation alongside the instructor. Through the practical tasks, you will gain a comprehensive grasp of commonly utilized Excel functions such as: Hiding worksheets Inputting cells styles for users Organizing workbooks Mastering Excel capabilities Becoming proficient in Excel entails developing workbooks that are efficient and well-organized. The facilitator will guide you through mastering complex functions, selecting cells and objects, and organizing principles of workbook design. You'll enhance your basic understanding of Excel with topics including: Creating complex formulas with nested functions Applying techniques for group selection *Session 3 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 4: Conditional Summing and Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-4--conditional-summing-and-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*
Interpreting the FASB Revenue Recognition Standard: What All CPAs Need to Know
-
Online
4.00 Credits
Mastering revenue recognition It's crucial to know the key principles of revenue recognition to recognize revenue effectively. You'll gain an understanding of these key principles by exploring the five-step revenue recognition process. You'll learn more about: Identifying a customer contract Determining performance obligations Establishing a transaction price Allocating the transaction price Recognizing revenue Fulfilling performance obligations Enhancing financial acumen through practical management strategies and real-world examples can significantly improve your organization's ability to excel in revenue recognition practices. You'll cover several aspects of performance obligations, including: Identifying distinct goods and services Implications of promised goods Complexities associated with shipping and handling activities
Excel for Accounting Professionals Session 4: Conditional Summing and Lookups
-
Online
2.00 Credits
Boosting productivity with Excel For those unfamiliar with conditional summing, you're in for a revelation —it's an impactful technique that improves productivity in creating reports. You'll learn how to optimize Excel efficiency by managing duplicates, selecting appropriate shortcuts, and performing lookups. Practical hands-on Excel learning exercises taught by highly engaging expert in the field You'll also deepen your skills and tackle real-world Excel workbooks that address the following: Benefits of using lookup functions over direct cell referencing A comprehensive exploration of the popular VLOOKUP function Techniques for removing duplicates to create a distinct set of report labels *Session 4 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 5: Error Trapping and Improving Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-5--error-trapping-and-improving-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*