CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Governmental and Not-for-Profit Annual Update
-
Online
8.00 Credits
The latest GASB developments and federal audit changes affecting governments and not-for-profits (NFPs) are explored in this update overview.
Controller Series: Technology - Must Have Excel Competencies
-
Online
1.00 Credits
Excel has long been included in the accountant's toolbox. Even though Microsoft Power BI and other big data tools such as Qlik and Tableau are becoming more important, Excel is still a "must have" tool. We cover what the accountants of today should know about Excel to improve their efficiency, access data, and gain insights into the company, industry, and economy.
Streamlined Excel Reporting Series Session 3: PivotTables Displays and Alternatives
-
Online
2.00 Credits
Essential techniques for displaying data in alternative ways You'll work alongside an expert instructor as you practice using PivotTables and exploring creative alternatives for insightful data presentation. You'll learn techniques for effective data presentation, including: Filtering and sorting data Cleaning and organizing data through text manipulation Using dynamic features to summarize and analyze large datasets Using slicers and filters for visual filtering Highlighting key Excel features through guided practice You'll walk through realistic scenarios that show alternative functions for greater data management, such as: GROUPBY PIVOTB PERCENTOF In addition, various text functions such as TEXTJOIN and TEXTSPLIT will be explained, highlighting how to concatenate and split text strings efficiently. *Session 3 is one of four individual sessions. Each session builds on the previous one, so consider watching [Streamlined Excel Reporting Series Session 4: External Data and PivotCharts](https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series-session-4-external-data-and-pivotcharts) to tackle real-world issues and create powerful workbooks.*
Reviewing Partnership Tax Returns: What Are You Missing?
-
Online
4.00 Credits
Strategies to help reviewers catch errors in partnership and LLC tax returns before they are submitted.
Streamlined Excel Reporting Series Session 4: External Data and PivotCharts
-
Online
2.00 Credits
Extracting data for richer insights You'll gain meaningful analysis techniques while working alongside an industry expert and knowledgeable instructor. This session begins with the GETPIVOTDATA function to enable report customization. It's a great starting point before moving on to more advanced techniques. Power Query introduction With its user-friendly interface, Power Query empowers Excel users to take the next step by enabling seamless data import and transformation. With Power Query, you will explore features, including: Getting and transforming data Loading data Managing columns Data source settings Layouts and parameters Visualizing with PivotCharts A well-designed chart can effectively illustrate data trends and comparisons. You'll learn how to create and customize PivotCharts to elevate your reports and make the data more accessible to others. *Session 4 is one of four individual sessions. Each session builds on the previous one, so consider watching all the sessions [Streamlined Excel Reporting Series](https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series) to tackle real-world issues and create powerful workbooks.*
Cybersecurity Frontlines: Protecting Financial Data in an Evolving Threat Landscape
-
Online
1.00 Credits
Securing Your Practice: Essential Cybersecurity Strategies for Modern Accounting Is your accounting practice equipped to handle today's sophisticated cyber threats? This fireside chat brings together leading cybersecurity experts to help you navigate the increasingly complex world of digital security in accounting. In an era where financial data breaches make headlines daily, accounting professionals face unprecedented security challenges. Our expert panel will address critical questions such as: How are threat actors specifically targeting accounting firms and financial data? What cybersecurity frameworks and controls should accounting firms implement today? How can firms balance security requirements with operational efficiency? This isn't just theoretical discussion - it's a practical exploration of real-world threats and solutions. Our unique approach combines technical expertise with accounting-specific applications, giving you actionable insights you can implement immediately. Why is this relevant? Because cybersecurity is no longer just an IT concern - it's a business imperative affecting client trust, regulatory compliance, and your firm's survival. Firms with robust security postures are winning client confidence and avoiding costly breaches. We will demonstrate practical security measures that accounting professionals can implement, showcase real-world case studies of breach responses, and provide a roadmap for developing a security-conscious culture within your organization.
Forensic Accounting: Fraud Investigations
-
Online
8.00 Credits
In high demand - forensic accounting knowledge and skills (bold) Forensic accounting has been a rapidly growing part of the accounting profession for some time. The rapid expansion in technology and growth in various sectors of business and industry, and the increase in complexity of white-collar crimes, all contribute to this growth. A diverse range of clients, as well as cases involving all types of fraud, make this an attractive profession, and one that is always in high demand. Enhance your knowledge and skills with our Forensic Accounting: Fraud Investigations webcast. Whether you're a forensic accountant, or an aspiring one, this webcast will provide you with the foundational knowledge to successfully identify, investigate, and communicate your findings. You will also receive a copy of the AICPA's Forensic & Litigation Service's Forensic Accounting - Fraud Investigations practice aid for future reference.
Accounting for Digital Assets under US GAAP: Classification, Measurement, and Recognition
-
Online
1.00 Credits
What is a digital asset and how does US GAAP apply? This webcast will provide you with an understanding of how to account for investments in, or transactions involving, crypto assets (for example, bitcoin) and other digital assets under US GA Note: FASB issued ASU No. 2023-08, Intangibles-Goodwill and Other-Crypto Assets (Subtopic 350-60): Accounting for and Disclosure of Crypto Assets, which is effective for all entities for fiscal years beginning after December 15, 2024. This ASU is not yet reflected in this webcast.
Turning Sustainability Challenges into Business Opportunities
-
Online
1.00 Credits
Of the world's largest companies, 66% have committed to net zero, but only 4% meet key criteria. Businesses need practical solutions to turn their goals into results. This webcast will cover the biggest sustainability challenges that organisations face today, with: Expert advice Practical strategies A clear path to progress. Use this chance to build your skills and create change in your organisation. This webcast is part of the Oxford Sustainable Business Programme, hosted by Sa‹d Business School, the Smith School of Enterprise and the Environment, and Oxford Net Zero. It is delivered as one of a series of quarterly webinars reflecting the partnership between Oxford Sa‹d, AICPA (American Institute of Certified Public Accountants), and CIMA (Chartered Institute of Management Accountants). The Executive Management Program in Sustainability includes the ESG and Sustainable Financial Strategy Course and the Oxford Sustainability Reporting and ESG Data Management Programme, jointly created and delivered by Oxford Sa‹d, AICPA and CIMA.
Ethics in the World of AI: An Accountant's Guide to Managing the Risks
-
Online
2.00 Credits
Discover "Ethics in the World of AI: A CPAs Guide to Managing Risks" - a concise 2-hour training session for certified public accountants. Karl Ahlrichs and Jennifer Elder discuss the current uses of AI in business, nine risk areas, and provide practical suggestions to address these risks effectively. Equip yourself with the tools to navigate the ethical challenges of AI, upholding professional standards while embracing transformative technology. Join us now for a journey towards ethical excellence in AI.
Construction Contractors: Non-Revenue and Non-Lease Accounting Considerations
-
Online
4.00 Credits
The construction industry stands out in its need to adhere to a diverse range of accounting standards. This course explores the essential knowledge required for success in construction accounting, as well as the key issues influencing this field. Discover the implications of recent developments for yourself, your business, or your clients. In addition, we will examine the relationship between contractors and sureties. Given the construction industry's significant and ever-expanding share of the economy, staying up to date with the latest accounting updates in this sector is critical. Note: This course does not address FASB ASC 606, Revenue from Contracts with Customers, or FASB ASC 842, Leases. The AICPA offers a companion course which focuses on revenue and lease accounting for construction contractors. See Contract Accounting and Lease Accounting and Their Impact on Construction Contractors (CCREVL).
Current Audit Environment and ASB Activity
-
Online
2.00 Credits
New pronouncements from ASB are covered so you can be up to date on ASB activities and understand how to apply the guidance.
Current and Upcoming FASB Issues
-
Online
2.00 Credits
You'll learn about current and upcoming requirements in accounting standards (except financial instruments and leases) and understand how to apply the guidance in practice.
Accounting for digital assets under US GAAP: Specialized accounting, fair value, and stablecoins
-
Online
1.50 Credits
Guidance on how to account for digital assets (bold): Accounting for stablecoins may not be stable: Though the use of digital assets is rapidly expanding, accounting guidance has not kept pace. As a result, accounting for digital assets can feel shaky. The AICPA can help: The AICPA practice aid on accounting and auditing for digital assets and this webcast can help you answer the question of what to do when you or your client accounts for stablecoins. You'll be helped to understand how to account for other transactions and investments involving crypto and digital assets under U.S. GAAP. You'll also learn more about what the AICPA is doing to lend clarity and guidance to this murky but increasingly important field. Learn how you can add more value: Whether you're a CPA with attest clients or an industry accountant responsible for corporate accounting policy, this guidance will give you a clear path to help your clients or firm by applying the most up-to-date accounting policy. Detailed examples and use cases will demonstrate real-world application of this guidance. Note: FASB issued ASU No. 2023-08, Intangibles-Goodwill and Other-Crypto Assets (Subtopic 350-60): Accounting for and Disclosure of Crypto Assets, which is effective for all entities for fiscal years beginning after December 15, 2024. This ASU is not yet reflected in this webcast.
Performing Preparation, Compilation and Review Engagements
-
Online
2.00 Credits
Comply With All Standards As You Prepare, Compile and Review Engagements This webcast is a go-to reference for staying in compliance with all professional standards surrounding engagements performed in accordance with Statements on Standards for Accounting and Review Services (SSARSs).
Key Financial and Economic Issues Facing the Financial Executive
-
Online
1.00 Credits
The webcast explores the challenges of the current economic trends and analyzes their impact on you as the financial executive in areas of human resource management; credit markets and banking; risk management and pandemic style disruptions; cash flow planning strategies; debt and equity mix impacts in uncertain markets; globalization of the market in times of uncertainty; retirement planning and social security funding; and acquiring distressed companies and assets. Specific recommendations and insights will be offered to you to deal with the challenges.
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.
The Bottom Line on the New Lease Accounting Requirements
-
Online
4.00 Credits
FASB ASC 842, *Leases* explained Understanding lease fundamentals is essential to applying FASB lease requirements appropriately. As such, you'll delve into key concepts that define what a lease is, as well as basic lease accounting topics, such as: Contracts containing leases Lease classification Amortization of the right-of-use asset Impairment considerations Lease presentation and disclosure requirements Comprehensive examples and case studies will guide you through approaches to help you adopt accounting guidance for FASB ASU 2023-01. You'll also review the presentation and disclosure requirements, and other topics, including: Lease versus non-lease components Sales-type lease Direct financing lease Operating lease Lease terminations
Yellow Book: Staying Compliant With Government Auditing Standards
-
Online
8.00 Credits
Government Auditing Standards and application guidance are examined for auditors who work with state and local governments or not-for-profits.
Preparation, Compilation, and Review Engagements: Update and Review
-
Online
4.00 Credits
By reviewing the latest developments and issues relevant to preparation, compilation and review engagements, you'll be able to adhere to professional standards while performing these types of engagements.