CPE + Events Catalog

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.

Artificial Intelligence (AI) and automation tools offer incredible opportunities for all business professionals to improve productivity and accuracy. For example, generative AI tools such as ChatGPT and Bard can be beneficial when conducting research or drafting reports and correspondence. Likewise, Microsoft's Power Automate platform and similar tools such as Zapier can help you elevate efficiency to levels you may have thought unattainable. If this sounds appealing, plan to participate in this session to modernize your workflows and take advantage of these tools.This session will teach you practical applications of today's AI and automation tools. Moving beyond fundamental discussions, you will learn how to use AI and automation to streamline workflows, improve internal control, maximize productivity, and even improve team member morale. In addition, you will learn about some potential pitfalls associated with these technologies and how to avoid making mistakes when using these tools. In sum, this session is "must-see CPE," and you should plan to participate in this class today.

With the increasing complexity and ever-changing nature of tax laws and issues, today's accountant needs a one-day update course focusing on business income tax issues with an emphasis of newly enacted income tax legislation. This comprehensive class will not only review the current Federal business 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 business income tax filing season.

With the increasing complexity and ever-changing nature of tax laws and issues, today's accountant needs a one-day update course focusing on business income tax issues with an emphasis of newly enacted income tax legislation. This comprehensive class will not only review the current Federal business 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 business income tax filing season.

46 million Americans now own bitcoin. Yet, few tax professionals understand how to help individuals and businesses dealing with digital assets like cryptocurrency & NFTs. This session walks you through the tax implications of common cryptocurrency-related transactions and how to successfully service clients dealing in digital assets. We will also cover current developments surrounding this topic, such as the updated version of the digital assets question on Form 1040, funds locked in insolvent exchanges, the tax treatment for digital assets which have substantially impaired in value (Luna), tax notices (CP2000, Letter 6173, Letter 6174 & Letter 6174-A), and tax planning opportunities. OSCPA has partnered with the Washington Society of CPAs for this event.

With the explosion of technology over the past thirty years, one fair question is, "what are the ethical considerations and impacts related to this technology?" Of course, practical technology issues such as data privacy and security undoubtedly carry ethical considerations. However, technology also affects the ethics associated with work-life balance, the digital divide, training needs, copyrights, and fraud, to name a few. This course will teach you about "technoethics" and its implications for individuals and organizations. To that end, you will explore many current and emerging issues associated with ethics and technology, such as copyrights, cybercrimes, privacy versus security, and geo-tracking technologies. Given the profound implications of ethics and technology, this could be the most impactful session you will ever attend.

Charts and graphs are nothing new. However, many professionals struggle with building compelling visualizations. If that statement describes you, participate in this session to improve your skills in creating Excel charts and other visualizations. As a result, you will create visualizations to enhance your communication skills. This session is much more than just a seminar on fundamental charts. Instead, in this session, you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing - three qualities that will help to ensure that your readers and audience will understand the data you are presenting. This seminar is a must if you want to improve your communication skills.

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel's more advanced features - some new and some legacy - to elevate your productivity to higher levels.In this session, you will learn about many of Excel's newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel's FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment. Isn't it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365.

Clients want help with present and future business services. Which tax planning strategies will you provide for your corporate and small business clients? Updated for the latest legislation and IRS guidance on tax reform, this course answers the tough questions and shows you what strategies are best for your clients. We use a case-study approach to explore opportunities for businesses and how the tax practitioner can continue to add value for their clients. Discussions will include traditional and new planning opportunities as a result of the latest tax legislation, including the SECURE 2.0 Act, and IRS guidance.

New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel's "legacy" features, and you have significant new opportunities to improve your Excel-based reporting environments.In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to format your spreadsheets quickly and efficiently to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.

This session will start with a quick look at how Artificial intelligence, Blockchain, Cybersecurity, and Data governance are impacting the accounting ecosystem supporting transaction recordation and financial reporting. Then we'll dive deeper into how to identify opportunities for automation, whether with traditional programming, robotic process automation (RPA), or machine learning. We'll close out with a look at how the role of the finance team leader will change and the skills needed to be successful in the near future. OSCPA has partnered with the Washington Society of CPAs for this event.

Headlines abound saying that Robotic Process Automation (RPA) and artificial intelligence (AI) is going to eliminate the need for accountants. In reality, RPA and AI provide a great opportunity for accountants to automate more routine procedures and focus on delivering more value-added insights to help improve an organization's performance or risk mitigation. Conversely, the use of AI within organizations can also have some perverse results if not managed properly. Accountants must be aware of these risks and work to ensure that the proper controls are in place to manage an organization's operational and financial risks associated with automation and AI. Attend this session to learn more about these technologies and their implications to the skills and knowledge needed to be an effective management accountant. OSCPA has partnered with the Washington Society of CPAs for this event.

The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare a moderately complex federal individual income tax return (Form 1040). Over the years, thousands of new staff have received practical, hands-on experience to become familiar with tax forms. This course covers the latest tax law changes, making it essential for your new staff. NOTE: This course qualifies for IRS CE (PTIN) credit. To receive IRS CE credit, please email your PTIN to profdev@orcpa.org at the end of the course. Surgent will report credit at the end of each quarter.If you have questions, you can contact Professional Development at 503-641-7200, ext. 3 or email profdev@orcpa.org.

Ensure your clients are prepared for complex sales tax challenges in this essential session of the SALT Mastery Series. Gain a deep understanding of sales tax nexus considerations and the key factors that determine when and where tax obligations arise. Learn how to accurately assign sales to the correct jurisdictions and navigate existing exposure with strategies for voluntary disclosure. With expert guidance, you’ll leave equipped to confidently advise your clients on minimizing risks and staying compliant in the ever-evolving world of sales tax.

Fraud continues to plague businesses at epidemic levels, and technology control failures are a significant reason fraud occurs. Using a case study approach, in this session, you will learn about the pervasiveness of fraud, the control failures contributing to fraud, and what you can do to mitigate fraud risk.A specific focus of this course is applying information technology general controls and information technology application controls. In this course, you will examine numerous reported fraud cases and identify the general and application control failures that contributed to each fraud. By learning through these real-world case studies, you will be positioned better to reduce fraud risk.

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.

QuickBooks Online's (QBO) market share continues to expand, and the Cloud-based accounting platform now dominates the small business market. Yet, most accounting and financial professionals have not participated in any formal training on the Cloud-based accounting service. Thus, they are unaware of many of the tool's available features and do not work with QuickBooks Online as efficiently and effectively as they should.This course teaches you how to set up QBO and convert QuickBooks Desktop files into a QBO instance. You will learn how to process all types of transactions, including accounts payable, accounts receivable, bank feeds, inventory, and payroll. Further, you will learn how to implement appropriate internal controls and how to capitalize on advanced features such as workflow management and management reports. Join us in this session to learn how to set up QBO properly and take full advantage of all it offers while avoiding common errors and mistakes.

As tax laws continue to evolve, CPAs need to stay informed and proactive. The OSCPA's State & Local Tax Conference delivers the latest on legislative updates, case law, and compliance strategies for accounting professionals. Gain actionable insights from leading tax experts and build a network of peers facing similar challenges. Ensure your clients’ success by mastering the complexities of state and local taxes. CLE-OR: Pending ApprovalCFP: Pending Approval A special thanks to the members of the State & Local Taxation Project Committee for developing the 2024 State & Local Tax Conference. Thank you to our 2024 Gold Sponsors Live Oak Bank, NW Financial Network, Paychex, and Private Practice Transitions.                             

As tax laws continue to evolve, CPAs need to stay informed and proactive. The OSCPA's State & Local Tax Conference delivers the latest on legislative updates, case law, and compliance strategies for accounting professionals. Gain actionable insights from leading tax experts and build a network of peers facing similar challenges. Ensure your clients’ success by mastering the complexities of state and local taxes. CLE-OR: Pending ApprovalCFP: Pending Approval A special thanks to the members of the State & Local Taxation Project Committee for developing the 2024 State & Local Tax Conference. Thank you to our 2024 Gold Sponsors Live Oak Bank, NW Financial Network, Paychex, and Private Practice Transitions.