CPE + Events Catalog

Discover the real-world power of Artificial Intelligence (AI) and equip yourself with the skills to conquer modern challenges in accounting and finance. In this engaging course, we demystify AI and unveil its practical applications, transforming it from theory into a hands-on tool. Learn the essential AI fundamentals and unlock its remarkable potential to boost your productivity and effectiveness alongside your team. Explore the specific problem-solving capabilities of AI, tailored to address the unique challenges faced by accounting and financial professionals. Gain expertise in leveraging AI features integrated into everyday applications, including the ubiquitous Excel. Uncover how these features enable you to effortlessly detect fraud, identify potential transaction errors, and elevate your financial operations to new heights. Witness firsthand how AI is reshaping the present and future of your profession, positioning you at the forefront of this revolutionary wave.

This course provides an in-depth examination of partnership basis concepts, focusing on the distinction and interaction between inside and outside basis. Participants will analyze contributions, allocations, distributions, liabilities, and basis adjustments that commonly lead to reporting errors. Emphasis is placed on reconciling partner capital accounts, K-1 reporting, and tax basis schedules.

Partnership taxation remains one of the most complex and high-risk areas of federal tax compliance. From basis calculations and allocation rules to disguised sales, debt allocations, and partnership audit exposure, even experienced CPAs can encounter technical pitfalls that create significant financial and professional risk. This two-hour program examines the top 10 partnership tax issues most frequently encountered in practice. Designed specifically for CPAs advising partnerships and partners, the course provides practical guidance to identify, analyze, and avoid common compliance errors under Subchapter K. Through real-world examples and application of current tax law, participants will strengthen their technical proficiency and improve the quality of client advisory services.

This intermediate-level course provides a focused review of federal income and transfer tax reporting for trusts, estates, and taxable gifts. Participants will examine key reporting requirements and filing mechanics for Forms 1041 and 709, including income distribution deductions, Schedule K-1 reporting, and taxable gift calculations. The course emphasizes fiduciary accounting considerations, compliance risks, and common preparation errors. Practical examples reinforce accurate reporting and documentation standards in fiduciary and gift tax return preparation.

This webcast is part of a new three-part 2026 Internal Audit Series. You may purchase individually, or save up to $75 when purchasing the bundle (see below). The series is led by Elizabeth McDowell, CPA, CIA, founder of Audit Forward and a seasoned internal audit leader with more than 20 years of experience. She brings real-world insights to every session. Known as an “edutainer,” Elizabeth combines education and entertainment to make auditing concepts engaging, practical and memorable.OSCPA has partnered with the Iowa Society of CPAs for this new series.

Internal controls are more important than ever, and their importance increases daily. However, internal controls present a challenge for many smaller organizations. This program will teach you how to evaluate, develop, and implement an effective internal control structure in a small business environment. You will identify how to assess risk in smaller organizations and implement preventive, detective, deterrent, and compensating controls to mitigate these risks, even without proper segregation of duties. Additionally, participating in this program will teach you technology-focused techniques for preventing and detecting fraud and securing information systems and sensitive data. For small organizations, maintaining an effective system of internal controls presents a significant challenge. Realistically, implementing many theoretical concepts surrounding internal controls may sometimes be impossible. Consequently, many internal control structures foster an environment where too much risk exists. This factor and uncontrolled information systems can often lead to disastrous results. Participate in this program to learn the necessary insights and tools to design, implement, and monitor small organizations' internal controls, security, and anti-fraud measures.

The term "artificial intelligence" (AI) has become mainstream and while most have a layperson understanding of AI, few know the depth and breadth of these technologies' capabilities. AI is affecting just about everything in business and in people's personal lives. The operation of an internal control system is also changing because of this incredible advance. This session explains what AI is and how it works and then goes into detail about how it can be applied to a system of internal control. The material speaks about changes occurring in today's world as well as to what's coming in the not too distant future. OSCPA has partnered with the Washington Society of CPAs for this event.

Are you ready to pass the CPA Exam? Have you studied enough? Are you focusing on the right material? There’s only one way to find out – give it a try!  OSCPA members are invited to participate in Surgent CPA Review's live 4-hour mock CPA Exam workshop. This unique opportunity will allow you to experience what it is like to sit for any CPA Exam section as you immerse yourself in questions pulled from the actual CPA Exam Blueprints. Plus, you will leave the session with your own personalized ReadySCORE™ (an accurate measurement of your actual exam score) plus a detailed report showing your areas of strength and weakness for that section. Can't make this mock exam date? Questions? Please contact Membership; 503-641-7200 / 800-255-1470, ext. 4. Program facilitated by:

More Dates

In today's digital age, databases have become the backbone of every business technology, application, platform, and service. Every system relies on databases to store and organize information, from financial records in Quickbooks and Xero to sales efforts in Salesforce and Hubspot. Popular reporting tools like Power BI and Excel utilize databases to create beautiful, insightful dashboards. Despite the widespread use and importance of databases, many financial professionals lack a basic understanding of how they operate. Traditionally, working with databases has been delegated to an organization's IT department, leaving the accounting team out of scope. However, in today's technology-driven environment, accountants need to have a basic understanding of how databases work and the ability to query data independently. Our database basics course focuses on the knowledge most helpful for financial professionals. Through hands-on learning, participants will develop the skills to query data from a database or cloud provider and use it to create insightful reports in Excel or Power BI. By the end of the course, participants will feel empowered to design their dashboards and work more effectively with cloud data. With our database basics course, gain the knowledge you need to succeed in today's digital age and enhance your value as a financial professional.

More Dates

Are you looking to take your PivotTables to the next level? Many experts consider PivotTables to be Excel's most powerful feature. Yet, most who create and work with them barely scratch the surface of all that PivotTables can do. In this session, you'll learn eight powerful features you may have missed. From user-defined calculations to consolidating reports and adding KPIs, we'll show you how to get the most out of your PivotTables. These are just some examples of the great things you can do with PivotTables, and in this session, you will learn these and other techniques to make your PivotTables even more powerful.

Advance your skills to propel your career. This course is the second in a five-course series, provides the guidance needed to handle small engagements and to complete small audits, reviews and compilations with minimal supervision. Gain knowledge to improve your skills to perform more complex analytical procedures, as well as drafting financial statements and footnotes. Per NASBA's rules effective January 1, 2024, participants are required to be on camera and participate in the full and small group discussions to earn CPE credits for this Group Live - Virtual course. As such, please make sure you are set up properly with reliable internet (hard wired is best), a working camera, and a working microphone.

More Dates

In this session you will learn how to create a synopsis of critical trust terms and provisions, correctly interpret mandatory and discretionary distribution language, understand how the marital deduction functions for trusts, and identify and understand the tax implications of various trust funding formulas. This course is recommended to take first before the others in the series. This event is part of the Trust & Estate Mastery Series Bundle. There are 10 courses included in the bundle designed to equip CPAs, tax preparers, and fiduciary professionals with a complete understanding of trust taxation—from the basics to advanced concepts. Each course is a stand-alone topic. If you miss one in the series, no worries! Purchase individual courses or purchase the Trust & Estate Mastery Series Bundle and save up to $150!

More Dates

As IRS scrutiny of digital assets intensifies, CPAs must stay current on cryptocurrency taxation and reporting requirements. This focused 2-hour course provides a practical update on the federal income tax treatment of cryptocurrency transactions, emerging reporting rules, and current IRS enforcement initiatives. Participants will review the tax implications of common digital asset transactions, including sales, exchanges, mining, staking, hard forks, and airdrops. The program emphasizes reporting requirements, including the Form 1040 digital asset question, Form 8949 reporting, and new broker reporting developments such as Form 1099-DA. Special attention is given to audit risk factors, documentation standards, and practitioner responsibilities in an evolving regulatory environment. This session is designed to equip tax professionals with the tools needed to ensure compliance and confidently advise clients in today’s increasingly regulated digital asset landscape.

Navigate the complex world of Form 990 and discover how its structure, definitions and disclosures shape public perception and regulatory oversight. Gain a clear understanding of the form's core components, the triggers for its schedules and the key terms every preparer must know. Learn how to identify data sources within an organization, manage sensitive disclosures and guide board members in understanding what the completed form communicates. Gain the clarity and confidence needed to complete Form 990 accurately and effectively. OSCPA has partnered with the Minnesota Society of CPAs for this event.

The technology landscape of 2026 is defined by a practical convergence of intelligence and automation. This session begins with a strategic look at the major trends set to reshape the next decade, from the long-term potential of quantum computing to the continued evolution of autonomous systems. We will move past the immediate hype to understand how these looming shifts will eventually bridge the gap between today's workflows and the firm of the future. The core of the discussion focuses on how generative tools have evolved to manage complex tasks and integrate directly with firm information. We will analyze the trio of AI, data intelligence, and digital crypto assets while exploring how these tools help practitioners stay relevant and effective. This course provides the roadmap for maintaining efficiency in an era where the pace of change is only accelerating, ensuring you can turn emerging disruption into a strategic advantage.

Join us for a focused, insightful session on sales and use tax hosted by Charli Harrell and Aldo Rodriguez, sales tax subject matter experts. This event is designed to help tax professionals confidently navigate one of the most misunderstood areas of state and local taxation. With a spotlight on 2026 updates and real-world examples, this webinar will equip you with guidance to protect your clients from sales tax surprises and stay ahead of changing laws. Whether you're advising startups or established businesses, you’ll leave with new knowledge, practical tools, and a stronger foundation in sales tax compliance.

Elevate your expertise, stay ahead of legislative changes, and gain practical insights tailored for tax professionals. Join us for an in-depth exploration of the Washington legislation effective October 1, 2025. Don't miss the opportunity to master the complexities of SALT and transform your tax practice.

With recent Excel updates provided through Microsoft 365/Office 365 subscriptions, Office 2021, and Office 2024 Microsoft continues to pack new features into the popular spreadsheet tool. More recent Excel versions offer enhanced data analysis tools, new functions, and improved collaboration opportunities. For those who know about these new features and apply them, exciting opportunities for improved productivity await. So, take advantage of this opportunity to learn how to use Excel's best new features! Summary Description Microsoft continues to add new features to Excel at a breakneck pace. Dynamic Arrays, XLOOKUP, Power Query, and collaboration and commenting tools can improve productivity and efficiency. Learn about these features - and others - in this session.

This intermediate-level course provides a focused review of federal reporting requirements for tax-exempt organizations and selected international information returns. Participants will examine key compliance components of Form 990, including governance disclosures and unrelated business income considerations, as well as commonly encountered international reporting forms such as Forms 5471, 8865, and 8938. The course emphasizes reporting mechanics, disclosure requirements, penalty exposure, and common filing errors. Practical examples highlight areas of heightened IRS scrutiny and documentation considerations.

The most effective path to success lies in being indispensable to clients. Achieving that indispensability requires a robust understanding of the client. Participants will explore the latest developments affecting not-for-profit entities, including FASB requirements, OMB Uniform Guidance, and Yellow Book developments. Moreover, they will thoroughly review updates to ethics, governmental auditing standards, and accounting for not-for-profit entities. After taking this course, participants will be well-versed in current standards and best practices in not-for-profit accounting and auditing. YELLOW BOOK: Qualifies for Yellow Book CPE based on your unique audited entity. OSCPA has partnered with the Idaho Society of CPAs for this event.