CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
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.
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
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
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.
Current and Upcoming FASB Issues
-
Online
1.50 Credits
Keep up with FASB changes Learn about changes in accounting, including relevant pronouncements, exposure drafts, and projects. Identify recently issued FASB standards and guidance that cover broad and narrow issues and understand how to apply them. Learn about upcoming standards that will be effective in the near future.
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.
Revenue Recognition, Financial Instruments, and Leases
-
Online
1.00 Credits
Understand FASB's important accounting and reporting areas: financial instruments and leases. Learn to assess and implement the new standards and guidance that are applicable to your practice.
Individual Income and Tax Compliance Annual Update
-
Online
4.00 Credits
Save time and keep current on the latest tax developments. This course covers all legislative, judicial, and IRS developments of the past year with a focus on implementation and compliance. Discover how to effectively and confidently complete tax planning and compliance engagements. Cover current developments affecting individuals, estates, and trusts (including those regarding income, deductions and losses, tax calculations, individual credits, filing matters). Gift tax matters are also covered.
Taxation of Property Transactions - Tax Staff Essentials
-
Online
4.00 Credits
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, including like-kind exchanges and involuntary conversions. It also covers important property-related timing issues and planning opportunities that can lead to significant tax savings.
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.
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.
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.
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.
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).
Current Audit Environment and ASB Activity
-
Online
2.00 Credits
Explore the current audit environment, and recognize audit challenges triggered by the current environment. Provide a comprehensive review of recent audit pronouncement and exposure drafts. Understand topics critical to success in today's rapidly changing regulatory environment. This course provides 4 hours of CPE credit in the Auditing field of study.
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
AICPA's Annual Federal Tax Update
-
Online
8.00 Credits
Save time and keep current on the latest tax developments. This comprehensive course covers all legislative, judicial, and IRS developments of the past year with a focus on implementation and compliance. Discover how to effectively and confidently complete tax planning and compliance engagements. Cover current developments affecting individuals (including those regarding income, deductions and losses, tax calculations, individual credits, filing matters), business entities (including those regarding S corporations and their shareholders, C corporations, partnerships), estates and trusts, retirement plans, and more.
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.
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.
Pass-Through and Corporate Annual Tax Update
-
Online
5.00 Credits
Corporations and pass-through entities are subject to new regulations and IRS pronouncements every year. This course provides an in-depth analysis of all the most salient pass-through and C corporation matters that have come up in the past year. A perfect primer for the tax season, this course is designed to help tax professionals effectively communicate tax changes and planning opportunities with clients.