CPE + Events Catalog
Effective Oct. 1, 2025: Washington residents will be charged state & local sales tax on OSCPA live webcast events. For more information, visit the CPE FAQs. If your residence is no longer in Washington, please update your member profile here.
K2's Advanced Excel - Webcast
-
Online
8.0 Credits
Member Price: $315
If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2's Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information. The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer.
Exploring Internal Controls That Could Have Prevented Frauds (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course examines actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters' ability to accomplish their nefarious acts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Partnership Property Distributions and the New Form 7217 (1 hour)
-
Online
1.0 Credits
Member Price: $29
See more dates
This program will address the complex rules for partnership distribution of property with a focus on liquidating of a partner's interest, Section 751 and how to complete the new Form 7217.
More Dates
Navigating IRS Correspondence: Responding to IRS Letters (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Participants will learn how to interpret the most common IRS correspondence, adhere to response deadlines, and effectively communicate with the IRS to resolve issues and minimize risks. It provides professionals with knowledge and strategies needed to handle the most common notices including audit requests, collections & return inquiries as well as error notices. Focusing on best practices to ensure compliance and avoiding penalties or escalation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
25-26 FASB and AICPA Update (ASU, SAS, Ethics) (4 hours)
-
Online
4.0 Credits
Member Price: $175
See more dates
This 4-hour program addresses the latest promulgations of FASB ASU impacting privately-held entities, AICPA SAS and selected AICPA ethics interpretations.
More Dates
Lease Implementation for Private Entities 25-26 (4 hours)
-
Online
4.0 Credits
Member Price: $175
See more dates
The Financial Accounting Standards Board (FASB) has issued a new accounting standard for leases. This new standard?ASC Topic 842?replaces the existing ASC Topic 840, changes the accounting for operating leases (requiring capitalization in the financial statements), and upgrades many other lease accounting and reporting aspects.
More Dates
Forensic Accounting: When The Office Is A Crime Scene (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
Embezzlement happens often to many small businesses. Unfortunately, the lack of internal controls allow the embezzlement to remain undetected for years. But when it is discovered, the small business owner will most likely contact their CPA for advice. What should you do when your client contacts you about their employee embezzling money from their business? What options should you present to your client? How can your client protect themselves, while investigating the embezzlement? What steps need to be taken about preserving any documents, emails, texts, or phone calls? This course teaches how to engage the client, properly identify the evidence needed to prove the crime, how to write the report for civil and criminal trial, and best practices in preserving electronic and paper evidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Comprehensive Passive Activity Losses (PAL) 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
Passive Activity Loss (PAL) rules have never been more critical in Federal tax reporting. This course provides a comprehensive and complete review of the laws and regulations impacting PALs, including the rules governing rental real estate, grouping and the 3.8% net investment income tax. Learn what qualifies as a passive activity and the rules governing its application by exploring several recent court cases and the existing regulations to know how the IRS views this critical area of the tax law. The IRS is actively auditing the failure to report passive losses properly. You and your clients can?t afford to be left behind.
More Dates
Everything You Need to Know About Trusts 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
An overview of trust laws and a review of general concepts. Common structures and review of some more advanced trust planning issues. Extensive coverage planning issues through a discussion of trust administration. The discussion covers special needs planning, asset protection, gift and estate tax planning, use of most common trusts, and portability versus A-B and A-B-C trusts.
More Dates
Everything You Need to Know About Trusts 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
An overview of trust laws and a review of general concepts. Common structures and review of some more advanced trust planning issues. Extensive coverage planning issues through a discussion of trust administration. The discussion covers special needs planning, asset protection, gift and estate tax planning, use of most common trusts, and portability versus A-B and A-B-C trusts.
More Dates
Not-for-Profit Organizations: Accounting Principles and Risk Management 2024
-
Online
8.0 Credits
Member Price: $329
See more dates
Not-for-profit organizations are one of the fastest-growing sectors of our economy, making it increasingly important that auditors, attorneys, CFOs and other advisers understand the unique accounting principles and challenges that apply. Examine the core principles and practices of not-for-profit accounting; review the general characteristics and operational environment of not-for-profit organizations; and discuss how to apply generally accepted standards and principles. Also, learn risk management best practices and common accounting errors.
More Dates
Preparation, Compilations and Reviews?A Practical Workshop 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
Participants will go over the changes on preparation, compilation and review engagements using SSARS rules, followed by a general overview of how to perform these services. This interactive workshop is designed for practitioners in small and medium-sized CPA firms and will include a lecture with generous time for questions and case studies.
More Dates
Top 10 Things to Know About Estate Taxation & Planning 25-26
-
Online
8.0 Credits
Member Price: $329
See more dates
Clients believe that estate planning is only for the wealthy who will owe Federal estate tax. This isn't the case. Perhaps as a result of the 2020 pandemic, estate planning has a renewed focus. All practitioners should be familiar with the vernacular, acronyms and techniques. Estate planning involves personal issues that affect everyone, whether or not the estate tax will apply. Learn strategies to pass assets to future generations; provide education benefits; distribute retirement benefits, and provide a charitable legacy.
More Dates
Risk Assessment Under SAS No. 145: The Key to Audit Quality? (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
The AICPA has identified risk assessment as an area of focus for its Enhancing Audit Quality Initiative as deficiencies in auditor's risk assessment procedures continue to be a common issue identified in peer review. SAS No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was written to improve the quality of risk-based audits. While key concepts do not fundamentally change, the standard works to clarify and enhance certain aspects of the identification and assessment of the risks of material misstatement to drive better risk assessments and hopefully overall enhance audit quality. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Todd and Julie Chrisley Go to Prison (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
The course provides general information on proceedings that led to a grand jury indictment of television reality stars, Todd and Julie Chrisley. Participants learn how business decisions can lead to federal charges for conspiracy, bank fraud, wire fraud, and tax evasion. The grand jury also indicted the Chrisley's accountant, Peter Tarantino, on tax-related offenses. Participants learn how to develop resources and tools for effective detection and deterrence of federal crimes, and the learn the consequences that follow white-collar crime, including how responses can influence lengthy prison terms. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Understanding the New Forms K-2 and K-3 (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Schedules K-2 and K-3 are promulgated by the IRS in order to standardize the reporting of foreign-related tax information for pass-through entities. Even pass-through entities that have no foreign activities, investments, or partners may have a reporting requirement. Schedules K-2 and K-3 for reporting partners' income, deductions, and credits from foreign activity are now required for passthrough returns (Form 1065, 1120-S and 8858). This requirement starts with returns with a tax year that ends in 2021. This course discusses each part of these schedules and explain these new reporting obligations in detail. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Tax Power Ethics for Tax Professionals (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
Award winning discussion leader, former state accountancy board chair, and lifelong tax practitioner Mark Hugh will review ethics for tax professionals: the AICPA Code of Professional Conduct and interpretations; the Statements on Standards for Tax Services; tax preparer standards in the Internal Revenue Code; the rules for practice with and before the IRS, including IRS Circular 230; new developments; and discuss examples of best practices and case studies.
More Dates
Everyday Ethics at Work: Don't be the Next News Story! (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
When asked, most people would say they are an ethical person. So why is it that every month there are reports of ethical breaches at major companies? The concept of ethics is easy to understand, easy to talk about, but incredibly hard to implement on a consistent basis. In this course, we will discuss current ethical issues, and walk-through a nine-step ethical decision-making model. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Foundational Carbon Accounting (1 hour)
-
Online
1.0 Credits
Member Price: $75
Understand what carbon accounting is and how it's applied, so you can implement it in your own role. Carbon accounting quantifies the number of greenhouse gasses produced by a company or organization to provide a better understanding of their carbon footprint. Carbon accounting also measures which part of a company's operation is responsible for the emissions. This final output is known as the organization's greenhouse gas inventory - or carbon footprint. With carbon accounting, organizations can make accurate assessments of where to concentrate their efforts at decarbonization. Carbon accounting is the essential language through which investors, businesses, finance and accounting professionals can speak to one another about climate change. Measuring the carbon footprint of an organization means it can be managed and reduced, which helps achieve some of the goals of tackling climate change at an organizational level. This webcast will be useful to a number of accounting and finance professionals who want to implement it internally within their organization or within an accounting firm looking to provide assurance or advisory services.
Power BI - Bringing It All Together for Data Analysis (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Power BI - Bringing It All Together for Data Analysis is an advanced-level course designed for professionals looking to integrate and optimize their use of Microsoft Power Pivot and Power BI. Building on the foundational knowledge from previous courses, this session focuses on the crucial next steps after creating data models and measures, guiding participants on how to fully utilize the potential of these tools to uncover insights and create impactful, actionable visualizations. This course takes a deep dive into the critical aspects of using Power BI to its fullest potential, emphasizing a holistic approach to data analytics. You'll learn how to build a streamlined workflow, ensuring every step in your data journey contributes to actionable insights. The course also focuses on optimizing performance for data models, utilizing advanced features of Power BI Services, and moving beyond basic data models to create advanced solutions tailored to real-world business needs. By the end of the course, you'll be able to synthesize all your Power BI skills to design and deliver powerful analytics solutions tailored to any audience. Whether you're presenting to stakeholders, sharing insights across teams, or managing enterprise-level reporting, this course will equip you with the tools and strategies to succeed. Perfect for Power BI users looking to tie all the pieces together into a comprehensive, efficient workflow. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.