CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting
-
Online
2.00 Credits
Let us ask you a question. What function do you use most? Is it the SUM function? It shouldn't be - well, at least if efficiency is your goal. This session covers the function that sums better than the SUM function for accounting professionals. In addition, we review the data validation feature, which enables us to control what a user enters into a cell. We'll discuss the conditional formatting feature, which enables us to format a cell based on its value. Lastly, we'll conclude by reviewing a technique that addresses a major pitfall of Excel. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel, since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the session, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook, and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.
Reviewing Partnership Tax Returns: What Are You Missing?
-
Online
4.00 Credits
The partnership section of the Internal Revenue Code is arguably one of the most complicated. That complexity, and the reliability of tax software to properly handle it, can create many issues for you and your staff when processing your client's LLC and partnership tax returns. Join us as we discuss the common errors practitioners make on partnership tax returns that are often missed by review staff. The intent is to sharpen skills for reviewers by examining case studies and discussing issues where additional information from the client may be warranted and areas of tax law where proper treatment requires additional analysis and information. Multiple issues will be discussed, including income, deductions, K-1 reporting, and K-2 and K-3 reporting. This course follows a highly illustrative case study format to increase participant comprehension and retention.
Leases: Mastering the New FASB Requirements
-
Online
8.00 Credits
FASB ASC 842, *Leases*, standards decoded By learning essential information about lease accounting requirements, you'll understand the core principles of the standards and how to apply them. You'll explore topics, such as: Identification Recognition Measurement Presentation and disclosure requirements Deliberate application of lessee accounting model You'll also learn about classifying leases, the amortization of the right-of-use asset, and the interest on a lease liability. Additional topics include: Short-term leases Purchase options Variable lease payments Sale and leaseback transactions Leveraged leases
Reviewing S Corporation Tax Returns: What Are You Missing?
-
Online
4.00 Credits
The complexity of S corporation tax law creates a formidable challenge to the tax practitioner for accurate compliance and reporting of their client's S corporation activities. Join us as we discuss the common errors practitioners make on S corporation tax returns that are often missed by review staff. The intent is to sharpen skills for reviewers by examining case studies and discussing issues where additional information from the client may be warranted and areas of tax law where proper treatment requires additional analysis and information. Multiple issues will be discussed including income, deductions, K-1 reporting, and K-2 and K-3 reporting. This course follows a highly illustrative case study format to increase participant comprehension and retention.
Conducting a Remote Audit
-
Online
4.00 Credits
Understand the basics of remote auditing and how it can be used in your engagements Remote auditing has become increasingly popular in recent years. Learn how to apply auditing standards to real-life examples of remote auditing in this all-new webcast. Join us to explore ways to overcome the challenges of remote auditing and conduct efficient engagements for your clients.
2024 Summer Tax Rewind
-
Online
2.00 Credits
Impacts of federal tax (bold) Tune in to this informative webcast for the latest tax compliance and planning strategies for your clients. In this webcast, we'll discuss: -Tax planning -Legislative changes -The latest IRS tax practice and procedures to implement various tax policies Join Art Auerbach, CPA, CGMA, to discover how U.S. federal tax affects you and your clients.
Excel for Accounting Professionals Session 3: Workbook Design Principles and Organization
-
Online
2.00 Credits
Are you familiar with the five workbook design principles that help us build reliable recurring-use workbooks? This session covers them, as well as workbook and worksheet organization ideas. We also discuss how, why and when to hide administrative worksheets. The importance of highlighting input cells, using selection groups and building formulas with nested functions are also explored. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the webcast, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook, and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.
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).
Finance Business Partnering: Influence to Impact
-
Online
8.00 Credits
Drive business success forward This webcast offers finance professionals an advanced application-based approach to finance business partnering. You will: Acquire essential problem-solving skills that can positively affect all areas of the business Learn how to leverage analytics tools and techniques to aid in decision-making Become accomplished in presenting and influencing key business decision-makers You also will enhance your interpersonal, communication, and leadership skills, so you are more proficient in executing strategic visions.
Excel for Accounting Professionals Session 4: Conditional Summing and Lookups
-
Online
2.00 Credits
This session opens with conditional summing. If you have not explored conditional summing yet, you are in for a surprise. Conditional summing is a game changer and will absolutely improve efficiency in your reporting workbooks. We then move to removing duplicates to create a list of unique report labels. We conclude with lookup basics. We discuss why we prefer lookups to direct cell references and explore the details of the most popular lookup function, VLOOKUP. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel, since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the session, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.
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, informing you of the latest developments and pertinent issues relevant to these engagements. Gain insights into the U.S. business economy, peer review practices, FASB updates, and various aspects that influence preparation, compilation, and review engagements.
Reviewing Individual Tax Returns: What Are You Missing?
-
Online
4.00 Credits
The sheer mass of Internal Revenue Code provisions affecting individual taxpayers presents a considerable challenge for CPAs and tax professionals. These provisions combined with the potential for input error when utilizing the array of income tax software available, create the potential for a multitude of errors that can occur when preparing your client's tax return. Join us as we discuss the common errors practitioners make on individual tax returns that are often missed by review staff. Sharpen your reviewing skills by examining case studies discussing issues for which additional information from the client may be warranted, and areas of tax law that require additional analysis and information.
AICPA Town Hall Series
-
Online
1.00 Credits
Up-to-the-minute guidance Hear the latest updates on the CARES Act and progress of the Paycheck Protection Program (PPP) from AICPA executive leads Susan Coffey, EVP - Public Practice, and Erik Asgeirsson, President and CEO, CPA.com in these weekly town hall webcasts. Topics will be updated weekly. *** Free for AICPA members
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
Interpreting the New Revenue Recognition Standard: What All CPAs Need to Know
-
Online
4.00 Credits
The effective date of FASB ASC 606, Revenue from Contracts with Customers is upon us (bold) Do you know which contracts are within the scope of the standard and when revenue should be recognized? This webcast addresses the requirements of FASB ASC 606's five-step process for recognizing revenue: 1) Identifying a contract with a customer 2) Determining the performance obligations 3) Determining a transaction price 4) Allocating a transaction price 5) Recognizing revenue
New Quality Management Standards: A Practical Approach to Risk Assessment and Response
-
Online
2.00 Credits
Create a robust QM system based upon your firm's needs (bold) Statement on Quality Management Standards (SQMS) No. 1, A Firm's System of Quality Management (ital), changes how quality management is approached, with emphasis on creating processes and policies tailored to your firm's circumstances. The new risk assessment process is a key component to identifying and evaluating the likelihood and potential impact of various risks to your firm. This webcast will offer a practical approach to risk assessment, and to determining the responses - policies and procedures - to the quality risks facing the firm.
Excel - Building Powerful Lookup & Reference Formulas
-
Online
2.00 Credits
Improve efficiency with these powerful functions (bold) Excel has over 500 functions that are built-in and ready to use. You just have to figure out which one to use and when. In this webcast, we will focus on the Logical, Information and Lookup and Reference functions. -In the Logical function section, you will learn to perform logical tests using the IF function along with AND, OR and NOT. -In the Information function section, you will learn various ERROR checking functions that can be combined with the Logical functions. -In the Lookup and Reference section, you will learn to use the various LOOKUP functions and the INDIRECT function. Integrating functions into each and every one of your spreadsheets not only improves efficiency, it also makes your task easier to execute. Regardless of the version you are using, ALL concepts covered in this webcast apply to ALL versions of Excel.
PCAOB Updates
-
Online
1.00 Credits
Understand the complexities of PCAOB updates. Understand the new requirements of recently approved PCAOB amendments to the auditing standards and the auditor's key responsibilities in response to the amendments. Learn to sort through the complexities to identify and apply them to the audit of a public company.
Excel - Advanced Financial and Statistical Calculations
-
Online
2.00 Credits
Improve efficiency with these powerful functions (bold) Excel has over 500 functions that are built-in and ready to use. You just have to figure out which one to use and when. In this webcast, we will focus on Financial, Statistical and Math functions. -In the Financial functions section, you will learn how to use the financial functions to build better amortization schedules. -In the Statistical and Math functions sections, you will learn how to use various statistical functions to analyze your data. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel.