CPE + Events Catalog

A Deep Dive into State and Local Tax TopicsUnlock the secrets of effective state and local tax strategies with our comprehensive SALT Mastery Series! Elevate your expertise, stay ahead of legislative changes, and gain practical insights tailored for tax professionals. Join us for an in-depth exploration of advanced techniques, guided by industry-leading experts. Don’t miss this opportunity to master the complexities of SALT and transform your tax practices. Sign up today and take the first step towards becoming a SALT expert! There are 10 courses in the bundle. Each course is a stand-alone topic. If you miss one in the series, no worries! Purchase individual courses or purchase the SALT Mastery Series bundle and save up to $140!

OSCPA Members: Add this Not-for-Profit CPE Webcast Bundle for FREE! The OSCPA Not-for-Profit Knowledge Networks offer a great opportunity to explore important not-for-profit topics in one-hour informal discussions with experts and peers - and to obtain valuable CPE.

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.

This course will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We'll then switch our attention to the items coming down the pike, including a look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation. We'll also review year 2 considerations for leases including modification accounting. Then we will switch gears, moving to the audit side of the house. We'll review the impact of the changes to auditing group audits as well as the status of the AICPA's quality management project management. This course will keep auditors up to date on the work of the ASB.

Do you desire to not be tripped up and held back by the passive activity loss, at-risk, basis, new excess business loss rule and newly revamped NOL limitation rules? This course will get you through the woods as unscathed as possible. And, how does the new 163(j) limit on business interest expense play in?

The QuickBooks platform is robust with features and capabilities that many users are unaware of or do not know how to utilize effectively. This course helps you get more out of QuickBooks Desktop and QuickBooks Online and resolve the issues even experienced QuickBooks users struggle with, such as locking down prior periods. This program starts fast with a chapter covering the top issues accountants face with QuickBooks. Then, the day continues with practical guidance and solutions designed to help accountants get the most out of QuickBooks for themselves or their clients. You will learn about issues like setting up a new company, configuring and customizing QuickBooks preferences, and enabling system security and password protection features. Also, you will learn how to lock down transactions in prior periods, use the audit trail, customize reports, export reports to Excel, and extend QuickBooks' usefulness with tools such as the Fixed Asset Manager and Loan Manager.

Award winning discussion leader Mark Hugh will review the AICPA Code of Professional Conduct and key Oregon differences; discuss new developments at the national and state level in ethics in the last two years; best practices for CPAs in public accounting and industry; highlight emerging issues; and discuss Oregon administration and enforcement, including case studies.NOTE: This course meets the Oregon Board of Accountancy's biennial four-hour general ethics requirement.For the most current Oregon Administrative Rules (OARs), refer to the BOA website: https://tinyurl.com/OR-BOA-Rules.

Win the next tax season by optimizing workflow in your practice using tactics from the project management and Lean Six Sigma worlds. Experience hands-on lessons from "The Relentless CPA" to create your ideal workflow and optimize your capacity to delight clients with better service. OSCPA has partnered with the Washington Society of CPAs for this event.

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.

Get the latest updates on trends and issues impacting you and the accounting profession. Join your colleagues at the OSCPA 2024 Professional Issues Update. Fees: OSCPA Members: $69 per person / Nonmembers: $119 per person Nonmember Full-Time Accounting Faculty: $69* Students: Complimentary** *Nonmember Full-Time Accounting Faculty: Email OSCPA to register and receive discount or call us at 503-641-7200 / 800-255-1470, ext. 3. **Students: Email OSCPA to process your complimentary registration or call us at 503-641-7200 / 800-255-1470, ext. 3.

Get the latest updates on trends and issues impacting you and the accounting profession. Join your colleagues at the OSCPA 2024 Professional Issues Update. Fees: OSCPA Members: $69 per person / Nonmembers: $119 per person Nonmember Full-Time Accounting Faculty: $69* Students: Complimentary** *Nonmember Full-Time Accounting Faculty: Email OSCPA to register and receive discount or call us at 503-641-7200 / 800-255-1470, ext. 3. **Students: Email OSCPA to process your complimentary registration or call us at 503-641-7200 / 800-255-1470, ext. 3.

Maximize deductions and minimize confusion with the Oregon Pass-Through Entity Elective Tax (PTE-E). This essential session of the SALT Mastery Series provides an overview to properly reporting on PTE-E forms and delivering accurate information to PTE owners. Dive into the interaction between PTE-E and individual returns, as well as key Federal considerations, ensuring your clients don’t miss out on valuable tax savings. Led by seasoned tax experts, this session will equip you with the knowledge and strategies to optimize PTE-E reporting and compliance.

Designed to provide you with the knowledge to be more efficient and effective at planning and performing audits in accordance with the requirements of the Uniform Guidance and the Single Audit Act, this course examines how the Single Audit Act relates to OMB Uniform Guidance, as well as the different types of guidance and requirements found in the Uniform Guidance. The course also covers responsibilities and requirements of the auditor and the auditee, how to identify federal assistance and how to determine a nonfederal entity's major programs. Make sure your skills are up to date with the latest information in this challenging audit area.YELLOW BOOK: May qualify for Yellow Book CPE based on your unique audited entity. OSCPA has partnered with the Washington Society of CPAs for this event.

Staff accountants have specific needs when working with Excel. Unfortunately, their existing Excel knowledge often does not meet these needs. Chief among these are summarizing data quickly and accurately, generating accurate and aesthetically pleasing reports, and creating accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills to maximize efficiency and accuracy when working with Excel.This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a "laptop-friendly" environment, and participants will have access to all the demonstration files. In sum, this seminar is a "must" for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.

How good are you with the technology you use daily? Are new technology tools available to save time and make you more effective? Technology continues to accelerate rapidly, and keeping pace is essential. This course is for you if you are not an information technology (IT) expert but need a technology update to maintain and improve your skills to serve your companies or clients more efficiently and effectively!In this fast-paced, update-style course, you will survey today's IT environment, learning about computer hardware, software (including Microsoft Office), operating systems (including Windows 11), peripheral devices, and what they mean for you. You will also learn about significant trends in information technology and how to take advantage of the opportunities presented by these trends. Examples include the latest Excel features, best practices for working with PDF files, and security and privacy issues. Additionally, you will learn how to improve the overall performance of your IT investment, thereby increasing your return on investment.Throughout this program, you will learn from real-time demonstrations of practical applications of the latest tools, which can provide you with the knowledge you need to harness the power of technology, both now and in the future. So register now for this "don't miss" opportunity to get the skills required to enhance the value of your IT investment.

Award winning discussion leader Mark Hugh helps you meet the ethics requirements of two states, while learning about recent changes at the national and state level. This four-hour class satisfies the Oregon general ethics requirement and is approved by the Washington Board of Accountancy as meeting its four-hour ethics requirement.

Stay ahead of the evolving landscape of income tax nexus and apportionment in this must-attend session of the SALT Mastery Series. Learn how to assess your client’s business activities in relation to differing state nexus and apportionment rules and uncover key distinctions between economic and physical presence nexus—especially in today’s world of technology and remote work. Explore the implications of factor presence nexus and when it becomes critical for tax compliance. Join industry-leading experts as they help you master these essential concepts to effectively guide your clients through complex multistate tax environments.

There have been several changes in Oregon law, as well as changes in the federal law that impact estate planning in Oregon. The speakers will unwind the complicated changes in the law and address the nuances that affect proper planning for Oregon clients and their families.

As spreadsheets evolve, so must your creating, editing, and auditing practices. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel.Today's best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this "must-see" CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel fully.

With the increasing complexity and ever-changing nature of tax laws and issues, today's accountant needs a one-day update course focusing on individual income tax issues with an emphasis of newly enacted income tax legislation. This comprehensive class will not only review the current Federal individual income tax laws but will also update tax return preparers of new tax forms, changes to existing tax forms, as well as tax planning opportunities and pitfalls. This is a "must-attend" course for all tax practitioners who want to be up to speed quickly and have a successful Federal individual income tax filing season.